Search Results gl_subr_tst




Overview
Explore in AI Chat

Overview

The GL_SUBR_TST table is a core work table within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. Its primary function is to support the Subledger Update process when executed in test mode. This allows financial users to perform a trial run of the subledger accounting process, verifying the accuracy of journal entry bookings—such as amounts, accounts, and dimensions—before committing them to the live general ledger. By using this table, organizations can mitigate the risk of posting incorrect financial data, ensuring data integrity during period-end closing procedures.

Key Information Stored

The table stores transactional data for a test subledger run. While a full column list is not provided in the metadata, the documented foreign keys reveal the critical dimensions and references captured for each transaction line. Key referenced data points include a unique SUBLEDGER_ID (the table's primary key), the accounting unit (ACCTG_UNIT_ID), ledger (LEDGER_CODE), and company code (CO_CODE). It also holds accounting details like the account (ACCT_ID), transaction source type, and currency information for both base and transaction amounts (CURRENCY_BASE, CURRENCY_TRANS). Furthermore, it stores quantity and unit of measure data, linking to SY_UOMS_MST. A critical column is GL_SUBR_TST_REFERENCE_NO, which links to the GL_SUBR_STA table to associate test lines with a specific test run or status record.

Common Use Cases and Queries

The primary use case is the Subledger Update test run, initiated from the GMF application. A typical workflow involves generating subledger transactions, running the update in test mode to populate GL_SUBR_TST, reviewing the results via standard reports or custom queries, and then proceeding with the live update. Common analytical queries include verifying account distributions and reconciling amounts. A sample query to examine test run details might be:

  • SELECT tst.sublgr_id, tst.acct_id, amst.account_code, tst.currency_trans, tst.amount_trans FROM gl_subr_tst tst, gl_acct_mst amst WHERE tst.acct_id = amst.acct_id AND tst.gl_subr_tst_reference_no = '&TEST_RUN_ID';

Data in this table is typically transient, serving as a staging area for a specific test execution and is often purged or archived after review.

Related Objects

GL_SUBR_TST has extensive relationships with fundamental GMF setup and transaction tables, as defined by its foreign keys. Key related objects include:

  • GL_SUBR_STA: The most direct relationship, linked via GL_SUBR_TST_REFERENCE_NO, likely controlling the status of the test run.
  • Master Data Tables: GL_ACCT_MST (accounts), GL_LDGR_MST (ledgers), GL_PLCY_MST (company policy/company code), GL_CURR_MST (currencies), and SY_UOMS_MST (units of measure).
  • Other GMF Tables: GL_ACCU_MST (accounting unit) and GL_SRCE_MST (transaction source type).

This table is central to the test subledger process but is not typically queried directly for live reporting, as its data is for validation purposes only before posting to permanent ledger tables.

  • Table: GL_SUBR_TST 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST,  object_name:GL_SUBR_TST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Update. ,  implementation_dba_data: GMF.GL_SUBR_TST , 

  • Table: GL_SUBR_TST 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST,  object_name:GL_SUBR_TST,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Update. ,  implementation_dba_data: GMF.GL_SUBR_TST , 

  • Table: GL_SUBR_TST_EFC 12.1.1

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST_EFC,  object_name:GL_SUBR_TST_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_SUBR_TST for EFC migration. Stores the original values of columns of GL_SUBR_TST 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_TST and ,  implementation_dba_data: GMF.GL_SUBR_TST_EFC , 

  • Table: GL_SUBR_TST_EFC 12.2.2

    owner:GMF,  object_type:TABLE,  fnd_design_data:GMF.GL_SUBR_TST_EFC,  object_name:GL_SUBR_TST_EFC,  status:VALID,  product: GMF - Process Manufacturing Financials ,  description: Shadow table of GL_SUBR_TST for EFC migration. Stores the original values of columns of GL_SUBR_TST 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_TST and ,  implementation_dba_data: GMF.GL_SUBR_TST_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_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_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_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_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.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_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_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 , 

  • 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 ,