Search Results gl_subr_sta




Overview
Explore in AI Chat

Overview

The GL_SUBR_STA table is a critical control table within the Oracle Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central control point for the OPM (Oracle Process Manufacturing) Subsidiary Ledger Update process. This process is responsible for transferring detailed cost accounting transactions from the OPM subsidiary ledgers into the General Ledger (GL) module. The table tracks the status and execution parameters of each run of this integration process, ensuring data integrity and providing an audit trail for the financial consolidation between manufacturing and corporate finance systems.

Key Information Stored

While the provided metadata does not list specific columns, the structure and purpose of a control table like GL_SUBR_STA imply it contains key process execution parameters. Based on its role and primary/foreign key relationships, the table almost certainly stores the following types of information for each process run: a unique REFERENCE_NO (the primary key) identifying the specific execution; status flags (e.g., 'PENDING', 'RUNNING', 'COMPLETE', 'ERROR'); timestamps for process start and completion; and parameters defining the accounting period, ledger, and data selection criteria for the update. It acts as a master record that child process tables reference to log detailed messages, ledger entries, and test results.

Common Use Cases and Queries

The primary use case is monitoring and troubleshooting the Subsidiary Ledger Update process. Database administrators and functional consultants query this table to check the status of current or recent jobs, identify failed runs, and analyze process history. Common SQL patterns include checking for incomplete processes or joining with related tables to get a full picture of a specific run.

  • To find recent process runs and their status: SELECT reference_no, process_status, start_date, end_date FROM gmf.gl_subr_sta WHERE start_date > SYSDATE - 7 ORDER BY start_date DESC;
  • To investigate a failed run by linking to error messages: SELECT s.*, m.message_text FROM gmf.gl_subr_sta s, gmf.gl_mesg_tbl m WHERE s.reference_no = m.reference_no AND s.process_status = 'ERROR';

Related Objects

As defined by its foreign key relationships, GL_SUBR_STA is the central parent table for several key process tables. The GL_MESG_TBL table logs detailed messages (including errors) generated during the update process, linked via REFERENCE_NO. The GL_SUBR_LED table likely holds the detailed subsidiary ledger transaction data prepared for the GL transfer. The GL_SUBR_TST table (linked via GL_SUBR_TST_REFERENCE_NO) appears to store test or validation results for the process run. These relationships form a cohesive data model where GL_SUBR_STA provides the controlling header record for all subsidiary ledger update activities.