Search Results qp_sourcesystem_fnarea_map_pk

Overview

The QP_SOURCESYSTEM_FNAREA_MAP table resides in the QP schema and belongs to the Advanced Pricing module (QP) of Oracle E-Business Suite, as documented in ETRM 12.1.1 and 12.2.2. It stores the mapping between source system code combinations and the functional areas (business flows) in which those source systems participate within Oracle Pricing. This mapping is central to the Pricing Transaction Entity (PTE) architecture, which allows pricing data originating from external or adjacent applications to be routed to the correct pricing functional area.

The heuristic Data Vault classification mined from the foreign-key structure is standalone. In Data Vault modeling terms, this suggests the table functions primarily as a reference or cross-reference construct rather than a conventional hub, link, or satellite. It holds no outbound foreign keys to other hubs in the documented relationship data, so it can be treated as an independent mapping reference in analytical models.

Key Information Stored

The table comprises 31 documented columns. The most significant are:

PTE_SOURCESYSTEM_FNAREA_ID — the surrogate primary key, uniquely identifying each mapping row. It is the sole column of the QP_SOURCESYSTEM_FNAREA_MAP_PK index (paired with ZD_EDITION_NAME in the unique index definition).
PTE_SOURCE_SYSTEM_ID — the identifier of the source system participating in the pricing transaction entity flow. Together with FUNCTIONAL_AREA_ID it forms the business-key candidate QP_SOURCESYSTEM_FNAREA_MAP_U1.
FUNCTIONAL_AREA_ID — the functional area (pricing business flow) to which the source system is mapped.
ENABLED_FLAG — indicates whether the mapping row is active and usable by the pricing engine.
SEEDED_FLAG — distinguishes Oracle-delivered seed data from customer-created rows.
CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns for extending the table with customer-defined attributes.
CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard who-columns used for audit and concurrency control.
PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, REQUEST_ID — the standard concurrent-program context columns, identifying the program and request that created or updated each row.
ZD_EDITION_NAME — the editioning column present in 12.2.2, supporting the Edition-Based Redefinition (EBR) architecture.

Common Use Cases and Queries

Typical usage scenarios include verifying which functional areas a given source system feeds, and diagnosing pricing failures where the source system is not enabled for the intended flow. A representative query for enabled, seeded mappings is:

SELECT pte_source_system_id, functional_area_id, enabled_flag, seeded_flag FROM qp.qp_sourcesystem_fnarea_map WHERE enabled_flag = 'Y' ORDER BY pte_source_system_id;
Joining the two unique-index columns (PTE_SOURCE_SYSTEM_ID, FUNCTIONAL_AREA_ID) as the natural lookup key rather than the surrogate PTE_SOURCESYSTEM_FNAREA_ID.
Reporting the count of mappings per functional area, or auditing rows where SEEDED_FLAG = 'N' to detect customer customizations.
Filtering by ZD_EDITION_NAME in 12.2.2 environments to isolate the active edition of the reference data.

Related Objects

Because the documented FK structure classifies this object as standalone, no direct foreign-key dependencies are recorded. Conceptually, the mapping links source-system definitions and pricing functional areas, and is consumed by the Advanced Pricing transaction engine and related QP views and APIs that resolve PTE routing. The unique indexes QP_SOURCESYSTEM_FNAREA_MAP_PK and QP_SOURCESYSTEM_FNAREA_MAP_U1 are the primary relational anchors, while FUNCTIONAL_AREA_ID and PTE_SOURCE_SYSTEM_ID connect logically to the functional-area and source-system reference data used throughout QP pricing setup.

Table: QP_SOURCESYSTEM_FNAREA_MAP 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_SOURCESYSTEM_FNAREA_MAP, object_name:QP_SOURCESYSTEM_FNAREA_MAP, status:VALID, product: QP - Advanced Pricing , description: Stores the functional areas for PTE/Source System Code combinations , implementation_dba_data: QP.QP_SOURCESYSTEM_FNAREA_MAP ,
Table: QP_SOURCESYSTEM_FNAREA_MAP 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_SOURCESYSTEM_FNAREA_MAP, object_name:QP_SOURCESYSTEM_FNAREA_MAP, status:VALID, product: QP - Advanced Pricing , description: Stores the functional areas for PTE/Source System Code combinations , implementation_dba_data: QP.QP_SOURCESYSTEM_FNAREA_MAP ,
INDEX: QP.QP_SOURCESYSTEM_FNAREA_MAP_PK 12.2.2
owner:QP, object_type:INDEX, object_name:QP_SOURCESYSTEM_FNAREA_MAP_PK, status:VALID,
INDEX: QP.QP_SOURCESYSTEM_FNAREA_MAP_PK 12.1.1
owner:QP, object_type:INDEX, object_name:QP_SOURCESYSTEM_FNAREA_MAP_PK, status:VALID,
TABLE: QP.QP_SOURCESYSTEM_FNAREA_MAP 12.1.1
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_SOURCESYSTEM_FNAREA_MAP, object_name:QP_SOURCESYSTEM_FNAREA_MAP, status:VALID,
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
TABLE: QP.QP_SOURCESYSTEM_FNAREA_MAP 12.2.2
owner:QP, object_type:TABLE, fnd_design_data:QP.QP_SOURCESYSTEM_FNAREA_MAP, object_name:QP_SOURCESYSTEM_FNAREA_MAP, status:VALID,
eTRM - QP Tables and Views 12.2.2
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,
eTRM - QP Tables and Views 12.1.1
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,
eTRM - QP Tables and Views 12.2.2
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,
eTRM - QP Tables and Views 12.1.1
description: This table stores information about which workers handle which list_lines, headers, formulas or price adjustments at the time of upgrade. ,