Results for “gl_acct_hrc”

36 results




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

Overview

GL_ACCT_HRC is a GMF (Process Manufacturing Financials) table in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. Its name reflects its role as an "account hierarchy" or "account selection priority" table. It stores the account selection priority for companies (represented by CO_CODE) and account titles (represented by ACCT_TTL_TYPE). The GL Mapping program consumes these priorities to retrieve the appropriate accounts for sub-ledger posting, resolving accounts in the exact order of account selection priority defined in this table. This makes GL_ACCT_HRC a critical control-point object for account derivation rules used by Process Manufacturing sub-ledger transactions.

From a Data Vault modeling perspective, the mined FK structure classifies GL_ACCT_HRC as a link table. Its surrogate primary key (ACCT_HRC_ID) is generated per configuration record, while the foreign keys to GL_ACCT_TTL and GL_PLCY_MST anchor this link to two hub-like reference tables. The many "…_PRI" columns behave like link attributes encoding positional priority values.

Key Information Stored

The table contains 33 documented columns. The most significant include:

The surrogate key (ACCT_HRC_ID) differs from the business-key candidates (CO_CODE + ACCT_TTL_TYPE) that appear in the alternate unique index GL_ACCT_HRC_U1.

Common Use Cases and Queries

Typical scenarios include diagnosing why a particular sub-ledger transaction picked a specific account, auditing priority configurations across companies, and reporting on unconfigured title types. A representative query to inspect priorities for one company and title type is:

SELECT co_code, acct_ttl_type, orgn_code_pri, item_pri, vendor_pri
  FROM gl_acct_hrc
 WHERE co_code = :company
   AND acct_ttl_type = :title_type
   AND delete_mark = 0;

To identify title types lacking any priority configuration, an outer join against GL_ACCT_TTL is useful. To trace priority assignment by company versus policy master, join through GL_PLCY_MST on CO_CODE. These queries support monthly close reconciliation and integration troubleshooting for the GL Mapping program.

Related Objects

The most significant related objects referenced by or referencing GL_ACCT_HRC are:

  • GL_ACCT_TTL — Referenced via GL_ACCT_HRC.ACCT_TTL_TYPE; supplies account-title definitions.
  • GL_PLCY_MST — Referenced via GL_ACCT_HRC.CO_CODE; supplies company policy master data.
  • GL_ACCT_HRC_PK — Primary-key constraint/index on ACCT_HRC_ID.
  • GL_ACCT_HRC_U1 — Unique index on (CO_CODE, ACCT_TTL_TYPE).
  • GL Mapping Program — The consuming process that reads these priorities to derive sub-ledger posting accounts.
  • GMF sub-ledger account derivation components — Downstream consumers that rely on the priority values encoded in this table.

Together, these objects form the account-resolution chain within Process Manufacturing Financials.