Search Results gl_acct_hrc




Overview
Explore in AI Chat

Overview

The GL_ACCT_HRC table is a core data object within the Process Manufacturing Financials (GMF) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a configuration table that defines the account selection priority for companies and account titles. Its primary role is to provide the GL Mapping program with an ordered hierarchy for retrieving the correct general ledger accounts during sub-ledger posting. This ensures that financial transactions from manufacturing processes are mapped to the appropriate accounting flexfields in the correct sequence, which is critical for accurate financial reporting and compliance.

Key Information Stored

The table's structure is designed to establish a prioritized relationship between a company and an account title type. Its primary key is the unique identifier ACCT_HRC_ID. The table also enforces a unique constraint (GL_ACCT_HRC_U1) on the combination of CO_CODE (Company Code) and ACCT_TTL_TYPE (Account Title Type), which forms the basis of the priority rule. The CO_CODE column is a foreign key to the GL_PLCY_MST table, linking to the company policy master. The ACCT_TTL_TYPE column is a foreign key to the GL_ACCT_TTL table, which holds the master list of account titles used within the GMF module.

Common Use Cases and Queries

The primary use case is the execution of the GL Mapping program, which queries this table to determine the order in which to search for a valid accounting flexfield combination when posting a transaction from the sub-ledger. A common reporting or validation query would involve joining to related master tables to review the configured priorities for all companies. A typical SQL pattern is:

  • SELECT gah.CO_CODE, gah.ACCT_TTL_TYPE, gat.ACCT_TTL_DESC FROM GMF.GL_ACCT_HRC gah JOIN GMF.GL_ACCT_TTL gat ON gah.ACCT_TTL_TYPE = gat.ACCT_TTL_TYPE ORDER BY gah.CO_CODE, gah.ACCT_HRC_ID;

This query helps administrators verify the account selection hierarchy. Troubleshooting often involves checking this table when sub-ledger journal entries fail to generate or post to an unexpected account, indicating a potential misconfiguration in the selection priority.

Related Objects

GL_ACCT_HRC has direct dependencies on two key master tables via foreign key constraints. The ACCT_TTL_TYPE column references GL_ACCT_TTL, the table defining valid account titles. The CO_CODE column references GL_PLCY_MST, which contains company policy information. The table is centrally referenced by the GL Mapping program (likely a concurrent program or package within GMF) that performs the account derivation logic. While not explicitly listed in the metadata, it is intrinsically linked to the overall account derivation and sub-ledger accounting setup within the GMF module.