Results for “gl_acct_ttl”

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

Overview

GL_ACCT_TTL is a reference table owned by the GMF schema in Oracle E-Business Suite, residing within the Process Manufacturing Financials module (GMF). The table stores the system-defined Account Titles used throughout Oracle Process Manufacturing, functioning as a controlled, read-only lookup of account title definitions. Because the user is not permitted to change these titles in OPM, the table acts as a stable authoritative source for account title classification across multiple dependent GMF subledgers and setup tables.

Within the supplied metadata, the object carries a heuristic Data Vault classification of "hub-leaning," derived from its foreign-key structure. This suggests that GL_ACCT_TTL is best modeled as a hub: a low-volatility, business-key-driven reference entity whose primary key value (ACCT_TTL_TYPE) is referenced by many surrounding tables. It is not a transactional or attribute-history satellite; rather, it is the anchor point from which account title relationships radiate.

Key Information Stored

The table comprises eleven documented columns, of which the following are the most significant:

• ACCT_TTL_TYPE — The primary key column and the sole business-key candidate (unique index GL_ACCT_TTL_PK). It is the code that external tables join against to associate a row with a specific account title type.
• ACCT_TTL_CODE — The descriptive code identifying the account title.
• ACCT_TTL_DESC — The human-readable description of the account title, used in reporting and user-facing displays.
• TEXT_CODE — A code reference used to resolve associated text or labeling for the title.
• TRANS_CNT — A transaction count or usage counter maintained for the title record.
• DELETE_MARK — The standard Oracle soft-delete flag indicating whether the title record is logically inactive.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Oracle EBS audit columns tracking who created and last modified each row and when.

There is no separate surrogate key defined beyond the single-column primary key; ACCT_TTL_TYPE serves simultaneously as the surrogate and business key. This compact, code-driven design reinforces the hub interpretation.

Common Use Cases and Queries

The most common use case is resolving an account title type to its description when reporting on subledger balances, distributions, or setup error records. Because ACCT_TTL_TYPE is a foreign key in several child tables, joins are the dominant query pattern.

• Joining a child table such as GL_SUBR_LED or PO_DIST_DTL to GL_ACCT_TTL on ACCT_TTL_TYPE to translate the type code into a readable ACCT_TTL_DESC.
• Listing all valid, non-deleted account titles for a reconciliation or setup validation report:
  SELECT ACCT_TTL_TYPE, ACCT_TTL_CODE, ACCT_TTL_DESC FROM GMF.GL_ACCT_TTL WHERE DELETE_MARK = 0;
• Auditing recent changes or additions by filtering on LAST_UPDATE_DATE using the audit columns.
• Cross-checking account title definitions referenced by GL_SETU_ERR to diagnose setup errors during period close or subledger configuration.

Related Objects

GL_ACCT_TTL is referenced by six documented child tables, each joining on ACCT_TTL_TYPE:

• GL_ACCT_HRC — via GL_ACCT_HRC.ACCT_TTL_TYPE.
• GL_ACCT_MAP — via GL_ACCT_MAP.ACCT_TTL_TYPE; the core mapping between account titles and accounts.
• GL_SETU_ERR — via GL_SETU_ERR.ACCT_TTL_TYPE; setup error tracking.
• GL_SEVT_TTL — via GL_SEVT_TTL.ACCT_TTL_TYPE; event title associations.
• GL_SUBR_LED — via GL_SUBR_LED.ACCT_TTL_TYPE; subledger balances and entries.
• PO_DIST_DTL — via PO_DIST_DTL.ACCT_TTL_TYPE; purchase order distribution detail.

These relationships confirm GL_ACCT_TTL as a central reference hub whose ACCT_TTL_TYPE value flows into financial mapping, subledger, and purchasing distributions.