Search Results gl_acct_key




Overview
Explore in AI Chat

Overview

The GL_ACCT_KEY table is a data object within the Oracle E-Business Suite, specifically belonging to the GMF (Process Manufacturing Financials) product module. Its primary role is to serve as a key mapping or reference table that links fundamental financial master data entities. As indicated by the provided metadata, its documented description is marked "*NOT USED*," which typically signifies it is a supporting technical table for internal application logic rather than a primary transactional repository intended for direct user interaction. Its existence is crucial for enforcing referential integrity between core accounting setup tables, ensuring data consistency across the financial configuration within the Process Manufacturing environment.

Key Information Stored

The table's structure is defined by its composite primary key, which consists of three columns: CO_CODE, ACCTG_UNIT_NO, and ACCT_NO. This combination uniquely identifies a record within the table. The CO_CODE column stores the company or legal entity identifier. The ACCTG_UNIT_NO holds the key for an accounting unit, which is an organizational subdivision for financial reporting. The ACCT_NO contains the general ledger account number. A fourth column, TEXT_CODE, is also present and is used as a foreign key to descriptive text held in another table. Collectively, these fields establish a validated relationship between a specific company, its accounting unit, and a general ledger account.

Common Use Cases and Queries

Direct interaction with this table is typically performed by the application's internal processes during the validation and posting of financial transactions originating from Process Manufacturing. Common use cases include validating that an account used in a manufacturing cost transaction is properly assigned to the correct accounting unit and company. A sample query to retrieve the key relationships for a specific company might be:

  • SELECT acctg_unit_no, acct_no FROM gmf.gl_acct_key WHERE co_code = '&COMPANY';

For reporting or data validation purposes, one might join this table to its referenced master tables to list all valid account-unit-company combinations:

  • SELECT k.co_code, k.acctg_unit_no, k.acct_no, m.acct_desc FROM gmf.gl_acct_key k, gmf.gl_acct_mst m WHERE k.co_code = m.co_code AND k.acct_no = m.acct_no;

Related Objects

The GL_ACCT_KEY table is centrally connected to several critical master data tables via foreign key constraints, as detailed in the metadata. Its primary relationships are:

  • GL_ACCT_MST: The general ledger account master table, referenced via CO_CODE and ACCT_NO.
  • GL_ACCU_MST: The accounting unit master table, referenced via CO_CODE and ACCTG_UNIT_NO.
  • GL_PLCY_MST: The accounting policy master table, referenced via CO_CODE.
  • GL_TEXT_HDR: A table storing descriptive text, referenced via the TEXT_CODE column.

These relationships confirm that GL_ACCT_KEY functions as a nexus, ensuring that any account key used in the system points to valid and existing records in these foundational setup tables.