Search Results oracle vz rx fd




The GL_CONCURRENT_SCHEDULES table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a critical repository for managing scheduled concurrent programs within the General Ledger (GL) module. This table stores metadata and execution parameters for recurring or scheduled concurrent requests, enabling automated processing of financial reporting, data validation, and period-end closing tasks. Below is a detailed analysis of its structure, functionality, and integration within Oracle EBS.

1. Purpose and Functional Role

The GL_CONCURRENT_SCHEDULES table serves as the backbone for scheduling recurring GL processes, such as journal imports, mass allocations, and financial statement generator (FSG) report submissions. It links to Oracle Concurrent Manager via the FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS tables, ensuring seamless execution of batch jobs. Key functionalities include:
  • Scheduling Parameters: Defines recurrence patterns (daily, weekly, monthly) and execution timeframes.
  • Program Associations: Maps scheduled jobs to specific GL concurrent programs (e.g., GLLEZL for Journal Import).
  • Status Tracking: Maintains active/inactive flags and last execution timestamps.

2. Key Columns and Metadata

The table's schema includes columns critical for operational and auditing purposes:
  • SCHEDULE_ID: Primary key, uniquely identifying each schedule.
  • CONCURRENT_PROGRAM_ID: Foreign key referencing FND_CONCURRENT_PROGRAMS.
  • START_DATE/END_DATE: Defines the schedule's validity period.
  • REPEAT_INTERVAL: Stores cron-like syntax for recurrence (e.g., FREQ=DAILY;INTERVAL=1).
  • LAST_RUN_DATE/NEXT_RUN_DATE: Tracks execution lifecycle.
  • CREATED_BY/UPDATED_BY: Audit columns capturing user modifications.

3. Integration with Oracle EBS Modules

GL_CONCURRENT_SCHEDULES interacts with multiple EBS components:
  • Concurrent Processing: Integrates with FND_CONCURRENT_REQUESTS to spawn jobs via Concurrent Manager.
  • GL Data Flow: Triggers programs like GLPPIN (Period Close) or GLPRATIO (Ratio Analysis).
  • Security: Respects FND_USER and FND_RESPONSIBILITY access controls.

4. Technical Considerations

  • Indexing: Typically indexed on SCHEDULE_ID, CONCURRENT_PROGRAM_ID, and NEXT_RUN_DATE for performance.
  • Partitioning: In high-volume environments, partitioning by LAST_RUN_DATE may optimize archival.
  • Dependencies: Relies on GL_INTERFACE for data inputs and GL_JE_BATCHES for output validation.

5. Customization and Extensions

Organizations often extend the table's utility via:
  • PL/SQL Triggers: To enforce business rules (e.g., blocking schedules during fiscal close).
  • API Integrations: Using FND_REQUEST.SUBMIT_REQUEST to dynamically create schedules.
  • Data Pump Exports: For migrating schedules between instances.

6. Common Use Cases

  • Automated Journal Processing: Scheduling GLLEZL to import journals from subledgers hourly.
  • Periodic Reporting: Running FSG reports on the last day of each month.
  • Compliance: Executing reconciliation programs (e.g., GLRECONC) post-close.

7. Limitations and Best Practices

  • Concurrency Limits: Avoid overlapping schedules to prevent resource contention.
  • Error Handling: Monitor FND_CONCURRENT_REQUESTS.STATUS_CODE for failures.
  • Purge Policies: Archive obsolete schedules to prevent table bloating.
In summary, GL_CONCURRENT_SCHEDULES is a pivotal table for automating GL operations in Oracle EBS, combining scheduling flexibility with tight integration to Concurrent Processing. Proper configuration ensures reliable execution of critical financial workflows while adhering to organizational controls.

  • Concurrent Program: RXGLCKJ 12.2.2

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_CHECK ,  product: GL - General Ledger ,  user_name: RX Journals Check Report ,  description: RX Journals Check Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLGNJ 12.2.2

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_GENERAL ,  product: GL - General Ledger ,  user_name: RX Journals Report ,  description: RX Journals Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLGNJ 12.1.1

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_GENERAL ,  product: GL - General Ledger ,  user_name: RX Journals Report ,  description: RX Journals Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLVCJ 12.1.1

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY ,  product: GL - General Ledger ,  user_name: RX Journals Day Report ,  description: RX Journals Day Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLVCJ 12.2.2

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY ,  product: GL - General Ledger ,  user_name: RX Journals Day Report ,  description: RX Journals Day Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLDBJ 12.2.2

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY ,  product: GL - General Ledger ,  user_name: RX Journals Day Report ,  description: RX Journals Day Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLCKJ 12.1.1

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_CHECK ,  product: GL - General Ledger ,  user_name: RX Journals Check Report ,  description: RX Journals Check Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLDBJ 12.1.1

    execution_filename: GLRX_JOURNAL_COVER_PKG.JOURNALS_DAY ,  product: GL - General Ledger ,  user_name: RX Journals Day Report ,  description: RX Journals Day Report ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RXGLTB 12.2.2

    execution_filename: GL_RX_TRIAL_BALANCE_PKG.CREATE_ROWS ,  product: GL - General Ledger ,  user_name: RXGLTB ,  description: RX Trial Balance Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • View: GL_JOURNAL_REPORTS_ITF_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLGL.GL_JOURNAL_REPORTS_ITF_V,  object_name:GL_JOURNAL_REPORTS_ITF_V,  status:VALID,  product: GL - General Ledger ,  implementation_dba_data: APPS.GL_JOURNAL_REPORTS_ITF_V , 

  • View: GL_JOURNAL_REPORTS_ITF_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SQLGL.GL_JOURNAL_REPORTS_ITF_V,  object_name:GL_JOURNAL_REPORTS_ITF_V,  status:VALID,  product: GL - General Ledger ,  implementation_dba_data: APPS.GL_JOURNAL_REPORTS_ITF_V , 

  • Concurrent Program: RXGLTB 12.1.1

    execution_filename: GL_RX_TRIAL_BALANCE_PKG.CREATE_ROWS ,  product: GL - General Ledger ,  user_name: RXGLTB ,  description: RX Trial Balance Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RGUWUR 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Where Used ,  description: Where Used Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGUWUR 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Where Used ,  description: Where Used Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRPTS 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Report Summary Listing ,  description: Report Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRPTD 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Report Detail Listing ,  description: Report Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOLS 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Column Set Summary Listing ,  description: Column Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXROWD 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Row Set Detail Listing ,  description: Row Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRSETD 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Report Set Detail Listing ,  description: Report Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRORDD 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Row Order Detail Listing ,  description: Row Order Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXROWS 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Row Set Summary Listing ,  description: Row Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCONS 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Content Set Summary Listing ,  description: Content Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXROWD 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Row Set Detail Listing ,  description: Row Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOND 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Content Set Detail Listing ,  description: Content Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRORDD 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Row Order Detail Listing ,  description: Row Order Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCONS 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Content Set Summary Listing ,  description: Content Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOLD 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Column Set Detail Listing ,  description: Column Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOND 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Content Set Detail Listing ,  description: Content Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRPTS 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Report Summary Listing ,  description: Report Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRPTD 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Report Detail Listing ,  description: Report Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRSETD 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Report Set Detail Listing ,  description: Report Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRSETS 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Report Set Summary Listing ,  description: Report Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXROWS 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Row Set Summary Listing ,  description: Row Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOLS 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Column Set Summary Listing ,  description: Column Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXCOLD 12.1.1

    product: GL - General Ledger ,  user_name: FSG - Column Set Detail Listing ,  description: Column Set Detail Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RGXRSETS 12.2.2

    product: GL - General Ledger ,  user_name: FSG - Report Set Summary Listing ,  description: Report Set Summary Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Table: GL_CONCURRENT_SCHEDULES 12.2.2

    owner:GL,  object_type:TABLE,  fnd_design_data:SQLGL.GL_CONCURRENT_SCHEDULES,  object_name:GL_CONCURRENT_SCHEDULES,  status:VALID,  product: GL - General Ledger ,  description: Oracle General Ledger concurrent schedule definitions ,  implementation_dba_data: GL.GL_CONCURRENT_SCHEDULES , 

  • Concurrent Program: GLXRCUNR 12.1.1

    execution_filename: GLXRCTRS ,  product: GL - General Ledger ,  user_name: GLXRCTRS ,  description: Reconciled Transaction Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Table: GL_APPLICATION_GROUPS 12.1.1

    owner:GL,  object_type:TABLE,  fnd_design_data:SQLGL.GL_APPLICATION_GROUPS,  object_name:GL_APPLICATION_GROUPS,  status:VALID,  product: GL - General Ledger ,  description: Application product groups that use Oracle General Ledger accounting periods ,  implementation_dba_data: GL.GL_APPLICATION_GROUPS , 

  • Table: GL_APPLICATION_GROUPS 12.2.2

    owner:GL,  object_type:TABLE,  fnd_design_data:SQLGL.GL_APPLICATION_GROUPS,  object_name:GL_APPLICATION_GROUPS,  status:VALID,  product: GL - General Ledger ,  description: Application product groups that use Oracle General Ledger accounting periods ,  implementation_dba_data: GL.GL_APPLICATION_GROUPS , 

  • Table: GL_CONCURRENT_SCHEDULES 12.1.1

    owner:GL,  object_type:TABLE,  fnd_design_data:SQLGL.GL_CONCURRENT_SCHEDULES,  object_name:GL_CONCURRENT_SCHEDULES,  status:VALID,  product: GL - General Ledger ,  description: Oracle General Ledger concurrent schedule definitions ,  implementation_dba_data: GL.GL_CONCURRENT_SCHEDULES , 

  • Concurrent Program: GLXJETAX 12.1.1

    execution_filename: GLXJETAX ,  product: GL - General Ledger ,  user_name: GLXJETAX ,  description: Tax Journals Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLXRLBOL 12.1.1

    execution_filename: GLXRLBOL ,  product: GL - General Ledger ,  user_name: GLXRLBOL ,  description: Budget Organization Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLRXVCJ 12.1.1

    execution_filename: GLWACCTR ,  product: GL - General Ledger ,  user_name: GLWACCTR ,  description: Account Analysis - Contra Account ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLYRLJRE 12.1.1

    execution_filename: GLYRLJRE ,  product: GL - General Ledger ,  user_name: GLYRLJRE ,  description: Journal Batch Summary ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLTRBAL1 12.1.1

    execution_filename: GLRTR1 ,  product: GL - General Ledger ,  user_name: GLRTR1 ,  description: Summary 1 Trial Balance ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLYRLJGE 12.2.2

    execution_filename: GLYRLJGE ,  product: GL - General Ledger ,  user_name: GLYRLJGE ,  description: Journal Line Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLTRBALD 12.2.2

    execution_filename: GLRTBD ,  product: GL - General Ledger ,  user_name: GLRTBD ,  description: Detail Trial Balance ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLCRDR 12.2.2

    execution_filename: GLCRDR ,  product: GL - General Ledger ,  user_name: GLCRDR ,  description: Consolidation Journals Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: GLXRLBOL 12.2.2

    execution_filename: GLXRLBOL ,  product: GL - General Ledger ,  user_name: GLXRLBOL ,  description: Budget Organization Listing ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports ,