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.