Results for “gl_acct_key”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_ACCT_KEY is a table owned by the GMF schema (Process Manufacturing Financials) within Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the account key definitions used by Oracle Process Manufacturing's financial accounting engine to associate individual general ledger accounts with company codes, accounting units, and account numbers. The ETRM documentation explicitly annotates the description as "*NOT USED*," indicating that the table is either legacy, no longer actively consumed by shipped functionality, or reserved for internal processing logic that the documentation set does not expose. Despite this annotation, the table remains VALID and continues to carry a defined column set and index structure, so it should be treated as an active physical object for query and integration purposes.

Under heuristic Data Vault classification mined from its foreign key structure, GL_ACCT_KEY is best modeled as a link entity. It sits between master/business entity tables (GL_ACCT_MST, GL_ACCU_MST, GL_PLCY_MST) and a text header table (GL_TEXT_HDR), resolving multiple many-to-many associations through its foreign keys. This classification is a modeling suggestion only; the physical implementation remains a conventional relational table with a composite primary key.

Key Information Stored

The documented physical schema carries 22 columns for the GMF owner. The most significant attributes are summarized below.

• CO_CODE — Company code; part of the composite primary key and a foreign key into GL_ACCT_MST, GL_ACCU_MST, and GL_PLCY_MST. It scopes every account key to a legal/operating company.
• ACCTG_UNIT_NO — Accounting unit number; part of the composite primary key and a foreign key into GL_ACCU_MST. It identifies the accounting unit (cost center equivalent) that owns the account.
• ACCT_NO — Account number; part of the composite primary key and a foreign key into GL_ACCT_MST. It links the key to its master account definition.
• ACCT_KEY_ID — Surrogate identifier for the account key row, distinct from the composite business key.
• ACCT_KEY_DESC — Descriptive text for the account key.
• ACCT_TYPE_CODE — Classifies the account type (for example asset, liability, revenue, expense).
• ACCT_CLASS_CODE — Further categorizes the account class.
• ACCT_USAGE_CODE — Indicates how the account is intended to be used in processing.
• ACCT_BAL_TYPE — Balance type semantics for the account (debit/credit orientation).
• SUMMARY_IND — Flag indicating whether the account is a summary (roll-up) account.
• QTY_IND / QUANTITY_UM — Quantity tracking indicator and its associated unit of measure.
• START_DATE / END_DATE — Effective dating window for the account key.
• TEXT_CODE — Foreign key into GL_TEXT_HDR, providing associated descriptive text.
• TRANS_CNT — Transaction counter, typically used for concurrency or activity tracking.

The documented unique index GL_ACCT_KEY_PK (CO_CODE, ACCTG_UNIT_NO, ACCT_NO) is the business-key candidate; ACCT_KEY_ID serves as the surrogate identifier. Audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) and DELETE_MARK support standard EBS auditing and logical deletion.

Common Use Cases and Queries

Because the table is marked *NOT USED*, its primary practical value lies in data lineage, migration reconciliation, and historical reporting on legacy Process Manufacturing accounting configurations.

• Account key resolution: Reconstructing the relationship between a company code, accounting unit, and GL account for a given transaction.
• Effective-dating filters: Querying rows active at a specific point in time using START_DATE/END_DATE.
• Text enrichment: Joining to GL_TEXT_HDR via TEXT_CODE to retrieve descriptive narratives.

A representative query joins the master tables through the composite key:

SELECT k.CO_CODE, k.ACCTG_UNIT_NO, k.ACCT_NO, k.ACCT_KEY_DESC
FROM GMF.GL_ACCT_KEY k
WHERE k.DELETE_MARK = 0
AND SYSDATE BETWEEN k.START_DATE AND NVL(k.END_DATE, SYSDATE);

Reporting scenarios typically aggregate account keys by ACCT_TYPE_CODE or SUMMARY_IND to compare summary versus detail account configurations.

Related Objects

• GL_ACCT_MST — Master account table; joined on CO_CODE and ACCT_NO.
• GL_ACCU_MST — Accounting unit master; joined on CO_CODE and ACCTG_UNIT_NO.
• GL_PLCY_MST — Policy master; joined on CO_CODE.
• GL_TEXT_HDR — Text header table; joined on TEXT_CODE for descriptive content.
• GL_ACCT_KEY_PK — Composite unique index enforcing the business key.

These relationships confirm the table's role as a linking entity within the GMF financial schema, notwithstanding its "*NOT USED*" documentation status.