Search Results gl_subr_led




Overview
Explore in AI Chat

Overview

The GL_SUBR_LED table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as the subsidiary ledger, serving as the critical liaison between Oracle Process Manufacturing (OPM) subsystems and the General Ledger (GL). Its primary role is to store detailed transactional accounting entries, or "bookings," generated from OPM subsystem documents such as production, inventory, and cost transactions. These entries are populated and updated by the OPM Subsidiary Ledger Update process, which prepares the data for eventual posting and reconciliation with the central GL. This table is essential for maintaining a granular, auditable trail of financial impacts originating from manufacturing operations before their summarization in the general ledger.

Key Information Stored

The table captures the complete accounting attributes for each subsidiary ledger entry. Key columns include SUBLEDGER_ID, the primary key uniquely identifying each booking. It stores fundamental accounting dimensions such as ACCT_ID (the detailed account), LEDGER_CODE, and CO_CODE (company/legal entity). Transaction-specific data is held in columns like REFERENCE_NO (linking to the source OPM document), TRANS_SOURCE_TYPE, and SUB_EVENT_TYPE. Monetary amounts are recorded with CURRENCY_BASE and CURRENCY_TRANS columns, while QUANTITY_UM and related fields capture the unit of measure and quantity for material-based transactions. The table also includes period and date information, status flags, and foreign key references to numerous master tables, ensuring referential integrity across the financial architecture.

Common Use Cases and Queries

The primary use case is tracing the detailed accounting impact of OPM transactions. Analysts query this table to investigate discrepancies between OPM subledger totals and GL balances, audit specific manufacturing events, or generate detailed operational financial reports. Common SQL patterns involve joining to master tables to translate codes into meaningful descriptions. For example, a query to analyze production variance postings might join GL_SUBR_LED to GL_ACCT_MST and GL_SRCE_MST, filtering on relevant SUB_EVENT_TYPE and accounting period. The table is also central to custom reconciliation reports that aggregate amounts by ledger, account, and source document before comparing them to GL journal line summaries.

Related Objects

GL_SUBR_LED maintains extensive foreign key relationships with foundational GMF and GL master tables, as documented in the ETRM. These relationships are critical for data validation and reporting:

These relationships define the table's position as the central junction point between transactional detail and the enterprise's chart of accounts, ledger structure, and currency definitions.

  • Table: GL_SUBR_LED 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_SUBR_LED 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED,  object_name:GL_SUBR_LED,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. ,  implementation_dba_data: GMF.GL_SUBR_LED , 

  • Table: GL_SUBR_LED_EFC 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED_EFC,  object_name:GL_SUBR_LED_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_SUBR_LED for EFC migration. Stores the original values of columns of GL_SUBR_LED that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_SUBR_LED and ,  implementation_dba_data: GMF.GL_SUBR_LED_EFC , 

  • Table: GL_SUBR_LED_EFC 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_LED_EFC,  object_name:GL_SUBR_LED_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_SUBR_LED for EFC migration. Stores the original values of columns of GL_SUBR_LED that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_SUBR_LED and ,  implementation_dba_data: GMF.GL_SUBR_LED_EFC , 

  • Table: GL_CURR_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_CURR_MST,  object_name:GL_CURR_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials. ,  implementation_dba_data: GMF.GL_CURR_MST , 

  • Table: GL_CURR_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_CURR_MST,  object_name:GL_CURR_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials. ,  implementation_dba_data: GMF.GL_CURR_MST , 

  • Table: GL_SUBR_STA 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_STA,  object_name:GL_SUBR_STA,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: OPM Subsidiary Ledger Update process Control table ,  implementation_dba_data: GMF.GL_SUBR_STA , 

  • Table: GL_SRCE_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SRCE_MST,  object_name:GL_SRCE_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsystem master table ,  implementation_dba_data: GMF.GL_SRCE_MST , 

  • Table: GL_LDGR_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_LDGR_MST,  object_name:GL_LDGR_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL ledgers ,  implementation_dba_data: GMF.GL_LDGR_MST , 

  • Table: GL_SEVT_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SEVT_MST,  object_name:GL_SEVT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping subevents. OPM user is not allowed to modify this information. ,  implementation_dba_data: GMF.GL_SEVT_MST , 

  • Table: GL_LDGR_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_LDGR_MST,  object_name:GL_LDGR_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL ledgers ,  implementation_dba_data: GMF.GL_LDGR_MST , 

  • Table: GL_ACCT_TTL 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TTL,  object_name:GL_ACCT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. ,  implementation_dba_data: GMF.GL_ACCT_TTL , 

  • Table: GL_ACCT_TTL 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_TTL,  object_name:GL_ACCT_TTL,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. ,  implementation_dba_data: GMF.GL_ACCT_TTL , 

  • Table: GL_SUBR_STA 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_STA,  object_name:GL_SUBR_STA,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: OPM Subsidiary Ledger Update process Control table ,  implementation_dba_data: GMF.GL_SUBR_STA , 

  • Table: GL_SRCE_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SRCE_MST,  object_name:GL_SRCE_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsystem master table ,  implementation_dba_data: GMF.GL_SRCE_MST , 

  • Table: GL_SEVT_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SEVT_MST,  object_name:GL_SEVT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: GL mapping subevents. OPM user is not allowed to modify this information. ,  implementation_dba_data: GMF.GL_SEVT_MST , 

  • Table: GL_ACCU_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MST,  object_name:GL_ACCU_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key. Note that with Oracle Financial integration, ,  implementation_dba_data: GMF.GL_ACCU_MST , 

  • Table: GL_ACCT_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MST,  object_name:GL_ACCT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information. ,  implementation_dba_data: GMF.GL_ACCT_MST , 

  • Table: GL_ACCU_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCU_MST,  object_name:GL_ACCU_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key. Note that with Oracle Financial integration, ,  implementation_dba_data: GMF.GL_ACCU_MST , 

  • Table: GL_ACCT_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_ACCT_MST,  object_name:GL_ACCT_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information. ,  implementation_dba_data: GMF.GL_ACCT_MST , 

  • Table: GL_PLCY_MST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST , 

  • View: GLEX_VIEW 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GLEX_VIEW,  object_name:GLEX_VIEW,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Glex view ,  implementation_dba_data: APPS.GLEX_VIEW , 

  • View: GLEX_VIEW 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:GMF.GLEX_VIEW,  object_name:GLEX_VIEW,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Glex view ,  implementation_dba_data: APPS.GLEX_VIEW , 

  • Table: GL_PLCY_MST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_PLCY_MST,  object_name:GL_PLCY_MST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. ,  implementation_dba_data: GMF.GL_PLCY_MST ,