Results for “id_flex_structure_code”

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

Overview

AR_TA_LINE_OF_BUSINESS_V is a Receivables (AR) module view that exposes the set of Accounting Flexfield segments designated as "Line of Business" attributes for a specific key flexfield structure. In Oracle EBS 12.1.1 and 12.2.2, the Receivables application uses the AR# key flexfield, and this view materializes only the segment columns flagged with the LINE OF BUSINESS segment attribute. Its primary role is to decouple reporting and integration logic from the physical segment numbering (SEGMENT1 through SEGMENT15), allowing consumers to retrieve a single, logical LINE_OF_BUSINESS value regardless of which physical column the attribute is assigned to.

The view is driven by the flexfield structure identified by the ID_FLEX_STRUCTURE_CODE 'ARTA-RECEIPT_PROF_IDENT' under APPLICATION_ID 222 (Receivables). Because of its structure-aware filtering, the view is typically used in localization, tax, and statutory reporting contexts where the "Line of Business" designation is required for receipts-based profiling assignments.

Underlying Base Objects

Although the documented ETRM metadata lists no explicit referenced base objects, the view text is defined over two dictionary tables:

• AR_TA_PROF_ASSGNT_ALL — the Receivables tax profiling assignment table, providing the segment value columns (SEGMENT1 through SEGMENT15) from which the LINE_OF_BUSINESS value is extracted.
• FND_ID_FLEX_SEGMENTS (aliased as ID) — the flexfield segment definition table that supplies APPLICATION_COLUMN_NAME and joins the profiling assignment columns to their logical segment identity.

Two correlated subqueries against FND_ID_FLEX_STRUCTURES resolve the specific ID_FLEX_NUM for APPLICATION_ID = 222, ID_FLEX_CODE = 'AR#', and the structure code 'ARTA-RECEIPT_PROF_IDENT'. A further subquery against FND_SEGMENT_ATTRIBUTE_VALUES restricts the returned segments to those whose SEGMENT_ATTRIBUTE_TYPE is 'LINE OF BUSINESS' with ATTRIBUTE_VALUE = 'Y'. Only enabled segments (ID.ENABLED_FLAG = 'Y') are included.

Key Columns

• APPLICATION_COLUMN_NAME — the physical column name (for example SEGMENT1, SEGMENT2, etc.) that carries the designated Line of Business attribute within the AR# flexfield structure.
• LINE_OF_BUSINESS — the actual segment value, produced by a DECODE that maps APPLICATION_COLUMN_NAME to the corresponding SEGMENTn column of AR_TA_PROF_ASSGNT_ALL. If no segment matches, NULL is returned. The GROUP BY clause removes duplicates so each attribute/value combination appears once.

Common Use Cases and Queries

The view is most often consulted to determine which flexfield segment stores Line of Business information for receipts profiling, without hardcoding a segment position. A representative query returning the populated values is:

SELECT APPLICATION_COLUMN_NAME, LINE_OF_BUSINESS FROM AR_TA_LINE_OF_BUSINESS_V WHERE LINE_OF_BUSINESS IS NOT NULL;

To discover the physical column name dynamically for use in downstream reporting or mapping logic:

SELECT APPLICATION_COLUMN_NAME FROM AR_TA_LINE_OF_BUSINESS_V GROUP BY APPLICATION_COLUMN_NAME;

Typical scenarios include statutory receipts reporting, tax profiling reconciliation, and integration extracts that must map the Line of Business designation into a normalized output format independent of the underlying key flexfield configuration. Because the view resolves its structure by code, its behavior is stable across Receivables environments but depends on the presence of the ARTA-RECEIPT_PROF_IDENT structure and the correct segment attribute configuration.