Search Results pn_loc_acc_map_hdr_all




Overview
Explore in AI Chat

Overview

PN_LOC_ACC_MAP_HDR_ALL is a Property Manager (PN) table that stores mapping account header information for locations. Its role in Oracle EBS is to define the header-level container for account mapping rules that associate general ledger accounts with specific property locations. Each header row represents a named mapping definition, and the associated detail rows (held in PN_LOC_ACC_MAP_ALL) carry the individual account-to-location line assignments. The table is organization-partitioned through the ORG_ID column and is registered with the PN schema.

The documented primary key is PN_LOC_ACC_MAP_HDR_PK, defined on LOC_ACC_MAP_HDR_ID, with a unique index PN_LOC_ACC_MAP_HDR_U1 also on LOC_ACC_MAP_HDR_ID. Both indexes carry the same single column, so the surrogate key and the business-key candidate are aligned in this release; the descriptive mapping name is not enforced as unique.

The provided metadata classifies this table heuristically as satellite-leaning under a Data Vault model. The designation reflects that the table primarily stores descriptive, attribute-bearing context (mapping name, audit columns, descriptive attributes) around a governing key, rather than serving purely as a conceptual hub or a many-to-many link. This classification is a modeling suggestion only and does not reflect an Oracle implementation construct.

Key Information Stored

The most significant columns in PN_LOC_ACC_MAP_HDR_ALL are:

  • LOC_ACC_MAP_HDR_ID — the surrogate primary key, sourced from a sequence and used as the join key to detail rows.
  • MAPPING_NAME — the descriptive identifier for the account mapping definition.
  • ORG_ID — the operating unit or organization context; foreign key to HR_ALL_ORGANIZATION_UNITS. This column drives multi-org security and is typically the leading predicate in queries.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO-column audit fields used for traceability and incremental extraction.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard EBS descriptive flexfield (DFF) columns, supporting client-specific extensions.

The table carries 24 documented columns in total. The surrogate key (LOC_ACC_MAP_HDR_ID) should be treated as the technical identifier, while MAPPING_NAME functions as the user-facing label.

Common Use Cases and Queries

Typical scenarios include validating mapping definitions before posting property accounting transactions, reporting on configured mappings by operating unit, and joining header details to the line-level mapping rows for account derivation analysis.

A representative query joining the header to its detail rows:

  • SELECT h.LOC_ACC_MAP_HDR_ID, h.MAPPING_NAME, d.LOC_ACC_MAP_ID FROM PN_LOC_ACC_MAP_HDR_ALL h, PN_LOC_ACC_MAP_ALL d WHERE h.LOC_ACC_MAP_HDR_ID = d.LOC_ACC_MAP_HDR_ID
  • Filter by operating unit for reporting: WHERE h.ORG_ID = :p_org_id
  • Incremental extraction for a data warehouse: filter on LAST_UPDATE_DATE >= :last_run.

Related Objects

  • PN_LOC_ACC_MAP_ALL — the detail table; joined via PN_LOC_ACC_MAP_ALL.LOC_ACC_MAP_HDR_ID = PN_LOC_ACC_MAP_HDR_ALL.LOC_ACC_MAP_HDR_ID. This is the primary child relationship.
  • HR_ALL_ORGANIZATION_UNITS — parent of ORG_ID, providing operating unit validation and descriptive organization attributes.
  • PN_LOC_ACC_MAP_HDR_PK / PN_LOC_ACC_MAP_HDR_U1 — the primary key constraint and unique index enforcing key integrity on LOC_ACC_MAP_HDR_ID.
  • PN Property Manager account mapping setup forms and concurrent programs — the application-level interfaces that create and maintain header and detail rows through this table.