Search Results pn_loc_acc_map_all




Overview
Explore in AI Chat

Overview

PN_LOC_ACC_MAP_ALL is a Property Manager (PN) transaction table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the mapping of expense accounts to locations. It is the detail (line-level) counterpart to the mapping header, allowing an organization to associate a range or set of accounting flexfield values with a specific property location so that expenses incurred at that location are charged to the correct accounts. Because it carries ORG_ID and is named with the _ALL suffix, the table is multi-org enabled and partitions data by operating unit, consistent with the MOAC (Multi-Org Access Control) model used throughout EBS 12.x.

From a dimensional modeling perspective, the mined foreign-key structure suggests classifying this table as a link entity. It resolves relationships between operating units (HR_ALL_ORGANIZATION_UNITS), mapping headers (PN_LOC_ACC_MAP_HDR_ALL), and the accounting flexfield segments, rather than acting as a standalone hub or a descriptive satellite. This is a heuristic suggestion based on the documented FK structure, not a declarative statement from Oracle.

Key Information Stored

The table contains 92 documented columns. The most significant are:

No business-key candidate beyond the surrogate key is uniquely documented; the primary key remains the authoritative identifier.

Common Use Cases and Queries

Typical scenarios include validating that every location has an active expense account mapping, identifying gaps before period close, and reporting on account ranges by property. A representative query joins the detail to its header and operating unit:

SELECT m.LOC_ACC_MAP_ID, m.LOCATION_ID, m.ACCOUNT_LOW, m.ACCOUNT_HIGH, h.LOC_ACC_MAP_HDR_ID
FROM PN.PN_LOC_ACC_MAP_ALL m, PN.PN_LOC_ACC_MAP_HDR_ALL h
WHERE m.LOC_ACC_MAP_HDR_ID = h.LOC_ACC_MAP_HDR_ID
AND m.ORG_ID = :p_org_id;

A second pattern filters effective-dated rows using EFFECTIVE_FROM_DATE and EFFECTIVE_TO_DATE to return only mappings active as of the current date. Because the table is org-striped, queries executed through MOAC require the ORG_ID predicate or the client-side org context to return the correct operating unit data.

Related Objects

  • PN_LOC_ACC_MAP_HDR_ALL — Parent header; joined on LOC_ACC_MAP_HDR_ID.
  • HR_ALL_ORGANIZATION_UNITS — Operating unit definition; joined on ORG_ID.
  • PN_PROPERTIES_ALL / PN_LOCATIONS_ALL — Property and location master data referenced by PROPERTY_ID and LOCATION_ID.
  • GL_CODE_COMBINATIONS — Source of valid account combinations that the segment low/high ranges resolve against.
  • FND_FLEX_VALUES — Supplies the flexfield segment values used in the SEGMENTn_LOW/HIGH columns.
  • Property Manager account mapping concurrent programs and the PN_LOC_ACC_MAP public API — Maintain and validate mapping records.