Results for “ap_flex_segment_mappings_pk”

6 results




Overview
Explore in AI Chat

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

Overview

AP_FLEX_SEGMENT_MAPPINGS_ALL is an Oracle Payables (AP) application table that stores Accounting Flexfield segment sequences and related layout configuration used by the Expense Distribution Detail Report. The table defines how individual Accounting Flexfield segments are mapped into report columns, ranges, and totals, allowing the Payables reporting engine to render expense distribution output in a consistent, user-configured format. Records are defined per ledger (SET_OF_BOOKS_ID), so the table supports multi-organization and multi-ledger reporting requirements across Oracle EBS 12.1.1 and 12.2.2.

From a Data Vault modeling perspective, the mined foreign key structure suggests AP_FLEX_SEGMENT_MAPPINGS_ALL is satellite-leaning. Its dependency on GL_SETS_OF_BOOKS_11I indicates that the ledger acts as the parent hub-like business key, while this table carries descriptive and configuration attributes (segment names, ranges, sequence, totals) that qualify that relationship. This classification is heuristic, based solely on the documented FK pattern, and should be treated as a modeling suggestion rather than a definitive architectural statement.

Key Information Stored

The table's primary key is AP_FLEX_SEGMENT_MAPPINGS_PK, a composite key consisting of SEGMENT_MAPPING_ID and SEQUENCE. SEGMENT_MAPPING_ID acts as the surrogate identifier that groups a set of related segment mapping rows, while SEQUENCE provides ordering and uniqueness within that group.

  • SEGMENT_MAPPING_ID — Surrogate key grouping the mapping definition; part of AP_FLEX_SEGMENT_MAPPINGS_PK.
  • SEQUENCE — Ordinal position within the mapping; part of the composite primary key.
  • SET_OF_BOOKS_ID — Foreign key to GL_SETS_OF_BOOKS_11I, identifying the ledger the mapping belongs to.
  • SEGMENT_NAME — The Accounting Flexfield segment being mapped for display.
  • SEGMENT_NUM — Numeric position of the segment within the Accounting Flexfield structure.
  • RANGE_LOW / RANGE_HIGH — Low and high values bounding the segment range included in the report.
  • REPORT_TOKEN — Identifier associating the mapping with a specific report definition.
  • PAGEBREAK — Controls whether a page break occurs at this mapping position.
  • TOTAL_BY — Indicates whether the segment acts as a totaling/grouping level.
  • ORG_ID — Operating unit identifier supporting Multi-Org access control.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns.

Common Use Cases and Queries

Typical use cases involve configuring and troubleshooting the Expense Distribution Detail Report layout, auditing ledger-specific segment mappings, and reconciling how segments roll up to report totals. Reporting extracts frequently join to GL_SETS_OF_BOOKS_11I to translate SET_OF_BOOKS_ID into a ledger name.

  • Retrieve all mappings for a ledger and report token, ordered by SEQUENCE.
  • Audit which segments are flagged for totaling (TOTAL_BY) or page breaks.
  • Verify segment ranges defined by RANGE_LOW and RANGE_HIGH for a given segment.

A representative query pattern:

SELECT m.SEGMENT_MAPPING_ID, m.SEQUENCE, m.SEGMENT_NAME, m.SEGMENT_NUM, m.RANGE_LOW, m.RANGE_HIGH, m.TOTAL_BY, m.PAGEBREAK FROM AP.AP_FLEX_SEGMENT_MAPPINGS_ALL m WHERE m.SET_OF_BOOKS_ID = :ledger_id AND m.REPORT_TOKEN = :report_token ORDER BY m.SEGMENT_MAPPING_ID, m.SEQUENCE;

Related Objects

The most significant referenced object is the ledger parent, plus the associated Payables and General Ledger structures used in reporting.

  • GL_SETS_OF_BOOKS_11I — Referenced via SET_OF_BOOKS_ID; supplies ledger context.
  • AP_FLEX_SEGMENT_MAPPINGS_PK — Composite primary key constraint (SEGMENT_MAPPING_ID, SEQUENCE).
  • GL_CODE_COMBINATIONS — Accounting Flexfield combinations interpreted by these segment mappings.
  • AP_INVOICE_DISTRIBUTIONS_ALL — Source distributions summarized by the Expense Distribution Detail Report.
  • FND_FLEX_VALUES / FND_FLEX_VALUE_SETS — Define the segment values constrained by RANGE_LOW and RANGE_HIGH.
  • FND_ID_FLEX_SEGMENTS — Metadata for the Accounting Flexfield segments referenced by SEGMENT_NAME and SEGMENT_NUM.