Results for “gl_accu_map”

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

Overview

GL_ACCU_MAP 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 GL Account Unit Mapping information, which governs how accounting units are associated with a Company, Organization, and Warehouse combination for the purposes of the GL Mapping program. The account unit mapping is a foundational configuration element in Process Manufacturing Financials: it determines which accounting unit is applied when financial transactions are mapped into the General Ledger based on their organizational and warehousing context. Organization and Warehouse are optional dimensions; a blank value in either column signifies "all values," meaning the mapping applies broadly to every organization or warehouse under the given company.

From a Data Vault modeling perspective, the heuristic classification derived from the foreign key structure identifies this object as a link. This reflects its role as an associative structure connecting an accounting unit, a company, an organization, and a warehouse rather than a pure descriptive entity. Analysts should treat this classification as a modeling suggestion rather than a prescribed design.

Key Information Stored

The table's central identity is the surrogate primary key ACCU_MAP_ID, enforced by the GL_ACCU_MAP_PK constraint. A second unique index, GL_ACCU_MAP_U1, defines the business-key candidate across CO_CODE, ORGN_CODE, and WHSE_CODE, guaranteeing that a given company/organization/warehouse combination maps to exactly one accounting unit. The most significant columns include:

• ACCU_MAP_ID — surrogate primary key uniquely identifying each mapping row.
• ACCTG_UNIT_ID — foreign key to GL_ACCU_MST, identifying the accounting unit assigned to the mapping.
• CO_CODE — company code; also a foreign key to GL_PLCY_MST.
• ORGN_CODE — organization code; foreign key to SY_ORGN_MST and SY_ORGN_MST_B. Optional; blank means all organizations.
• WHSE_CODE — warehouse code; foreign key to IC_WHSE_MST. Optional; blank means all warehouses.
• CREATION_DATE / CREATED_BY and LAST_UPDATE_DATE / LAST_UPDATED_BY / LAST_UPDATE_LOGIN — standard audit columns.
• TEXT_CODE — descriptive text/code associated with the mapping record.
• DELETE_MARK — soft-delete indicator commonly used in Process Manufacturing tables.
• TRANS_CNT — transaction counter used for concurrency or synchronization tracking.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE30 — the standard Oracle EBS descriptive flexfield columns for customer-specific extensibility.
• MIGRATED_IND — flag indicating records introduced through data migration.

Common Use Cases and Queries

Typical reporting and diagnostics revolve around resolving which accounting unit applies to a transaction's organizational context. A common query joins the mapping to its master accounting unit:

• SELECT m.CO_CODE, m.ORGN_CODE, m.WHSE_CODE, a.ACCTG_UNIT_NAME FROM GL_ACCU_MAP m, GL_ACCU_MST a WHERE m.ACCTG_UNIT_ID = a.ACCTG_UNIT_ID AND m.DELETE_MARK = 0;
• Verifying uniqueness or detecting duplicates across the business-key columns CO_CODE, ORGN_CODE, and WHSE_CODE.
• Auditing migrations by filtering on MIGRATED_IND to isolate migrated mapping rows.
• Evaluating "all values" defaults by finding rows where ORGN_CODE or WHSE_CODE is null and interpreting them as wildcard mappings.

These queries support GL Mapping reconciliation, subledger-to-GL configuration reviews, and troubleshooting of incorrectly posted accounting entries in Process Manufacturing environments.

Related Objects

GL_ACCU_MAP participates in several documented foreign key relationships:

• GL_ACCU_MST — joined via ACCTG_UNIT_ID; the master accounting unit definition.
• GL_PLCY_MST — joined via CO_CODE; the company/GL policy master.
• IC_WHSE_MST — joined via WHSE_CODE; the warehouse master.
• SY_ORGN_MST and SY_ORGN_MST_B — joined via ORGN_CODE; organization masters supplying organization definitions and their business-group view.

Taken together, these relationships make GL_ACCU_MAP the linking construct between organizational/warehouse configuration and the accounting units that drive General Ledger mapping within Process Manufacturing Financials.