Results for “currency_code_pri”
10 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:
- ACCT_HRC_ID — Surrogate primary key (GL_ACCT_HRC_PK), uniquely identifying each priority configuration record.
- CO_CODE — Company code; foreign key to GL_PLCY_MST. Together with ACCT_TTL_TYPE it forms the unique business key (GL_ACCT_HRC_U1).
- ACCT_TTL_TYPE — Account title type; foreign key to GL_ACCT_TTL. Also part of the unique business key.
- ORGN_CODE_PRI — Priority assigned to organization code as an account-selection criterion.
- WHSE_CODE_PRI — Priority for warehouse code.
- ITEM_PRI — Priority for item.
- VENDOR_PRI / CUSTOMER_PRI — Priorities for vendor and customer selection.
- CURRENCY_CODE_PRI — Priority for currency code.
- RESOURCE_PRI and COST_CMPNTCLS_PRI — Priorities for resource and cost component class.
- ICGL_CLASS_PRI, VENDGL_CLASS_PRI, CUSTGL_CLASS_PRI — Priorities for intercompany, vendor, and customer GL classes.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns.
- DELETE_MARK — Soft-delete indicator reflecting EBS multi-org archival conventions.
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.
-
This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In
-
This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In
-
VIEW: GMF.GL_ACCT_HRC# 12.2.2
-
VIEW: GMF.GL_ACCT_HRC# 12.2.2
-
TABLE: GMF.GL_ACCT_HRC 12.1.1
-
TABLE: GMF.GL_ACCT_HRC 12.2.2
-
eTRM - GMF Tables and Views 12.1.1
Defines Third-Party software which has a supported interface to OPM.
-
eTRM - GMF Tables and Views 12.2.2
Defines Third-Party software which has a supported interface to OPM.