Results for “ar_ta_prom_prods_all”

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

Overview

AR_TA_PROM_PRODS_ALL is a Receivables module table within Oracle E-Business Suite (applicable to releases 12.1.1 and 12.2.2) that stores product details associated with trade promotions. The table functions as a child of the promotions model, capturing the specific products that participate in a given promotion and product group, scoped by operating unit. In the Oracle Advanced Pricing and Receivables promotions architecture, this table links promotional activity to inventory items or product hierarchies that are eligible for the promotion.

The metadata classifies this object using a heuristic Data Vault model as standalone. In Data Vault terms, this classification suggests the table behaves as a link-style association entity rather than a hub or satellite in isolation — it carries the relationship between promotions, product groups, and products, keyed by operating unit. Because the FK structure yielded no upstream references in the mined metadata, the standalone designation should be treated as a modeling suggestion rather than a definitive architectural statement. The table is documented as not implemented in the reference database, meaning it exists in the schema definition but was empty or inactive in the source instance.

Key Information Stored

The documented metadata exposes a compact set of columns. The primary key AR_TA_PROM_PRODS_PK is composed of four columns, all of which are also the principal business-key candidates for this table:

• PROMOTION_ID — Identifier of the parent promotion to which the product record belongs. This is the primary foreign-key anchor to the promotions header entity.
• PROMOTION_PRODUCT_GROUP_ID — Identifier of the product group within the promotion. A single promotion may target multiple product groups, and this column distinguishes them.
• PRODUCT_ID — Identifier of the specific product (typically an inventory item or item master reference) included in the promotion/product group.
• ORG_ID — Operating unit identifier enforcing multi-org partitioning, ensuring product promotion records are visible only within the appropriate organization context.

Because the primary key comprises business identifiers directly (no separate surrogate sequence column is documented), there is no distinction between a system-generated surrogate key and a business key — the natural composite of the four columns serves as the row identifier. This is a notable design characteristic that affects how the table should be joined and de-duplicated.

Common Use Cases and Queries

Typical usage centers on promotion eligibility reporting — determining which products are covered by an active promotion, or reconciling promotional discounts against specific items. A representative query joins to the promotion header and lists products per group and operating unit:

• SELECT promotion_id, promotion_product_group_id, product_id, org_id FROM ar_ta_prom_prods_all WHERE org_id = :org_id AND promotion_id = :promotion_id;
• Aggregation for promotion scope: SELECT promotion_id, COUNT(DISTINCT product_id) FROM ar_ta_prom_prods_all GROUP BY promotion_id;
• Cross-check between promotions and items by joining PRODUCT_ID to inventory item master views.

Because the table is documented as not implemented in the reference database, analysts should confirm population before relying on it for reporting, and fall back to related pricing or promotion tables where the table is empty in a given instance.

Related Objects

The mined metadata did not enumerate explicit foreign-key parents, so related-object guidance below is inferred from the column semantics and the Oracle Receivables / Advanced Pricing promotions model:

• Promotions header table (join on PROMOTION_ID) — defines the promotion itself.
• Promotion product group table (join on PROMOTION_ID, PROMOTION_PRODUCT_GROUP_ID) — defines the group to which products belong.
• Item master / MTL_SYSTEM_ITEMS_B (join PRODUCT_ID to INVENTORY_ITEM_ID) — resolves product identity.
• Operating unit / ORG tables (join ORG_ID) — organizational context.
• Related AR_TA_PROM_* tables — sibling promotion entities sharing the AR_TA_PROM prefix and promotion ID namespace.

Because no FK structure was mined, all join relationships above should be validated against the actual data dictionary in the target instance before being used in production queries.