Search Results cogs_ccid

Overview

DPP_XLA_CLAIM_LINES_V is a subledger accounting (SLA) supporting view owned by the APPS schema within the Oracle Price Protection (DPP) module. Its stated purpose, per Oracle's ETRM documentation, is to expose the claim line detail used when Price Protection claim events are transformed into Subledger Accounting entries through the Create Accounting process. The view is part of the DPP SLA event model, pairing with its header-level counterpart DPP_XLA_CLAIM_HEADERS_V, and is registered as a valid, compiled object on the E-Business Suite 12.1.1 / 12.2.2 code line.

The object is frequently encountered during investigations of Price Protection claim accounting, particularly when users search for OZF_CLAIM_LINES_ALL, since that table is the principal transactional source joined by this view. DPP_XLA_CLAIM_LINES_V sits between the transactional claim tables populated by the DPP Claim Workbench and the accounting engine, supplying the amounts, quantities, ledger attributes, and descriptive flexfield values that Oracle Subledger Accounting requires to build journal entry lines.

Underlying Base Objects

The view text joins a combination of transactional tables, SLA repository tables, and setup views. The documented referenced base objects are:

• OZF_CLAIMS_ALL and OZF_CLAIM_LINES_ALL — respectively the claim header and claim line tables in the Oracle Trade Management / Price Protection schema (OZF). These supply claim number, claim date, line amount, accounted amount, currency, quantity, and item.
• DPP_XLA_CLAIM_HEADERS_V — the header-level SLA view providing EVENT_ID, transaction type, and claim organization.
• DPP_XLA_LINES — the mapping table linking SLA transaction header and line identifiers to the originating base transaction identifiers.
• DPP_TRANSACTION_LINES_ALL — Price Protection transaction detail that carries change type, prior price, supplier part number, and the Attribute1–Attribute30 flexfield columns surfaced by the view.
• FINANCIALS_SYSTEM_PARAMS_ALL and HR_OPERATING_UNITS — used to derive the ledger and inventory organization context from the operating unit.
• GL_LEDGERS — supplies LEDGER_ID for the accounting event.
• MTL_SYSTEM_ITEMS_B — provides the COGS account (COST_OF_SALES_ACCOUNT) and the item segment (SEGMENT1).
• DPP_XLA_EVENT_PUB — the event public package invoked by the SLA event model surrounding this view.

The join is driven through DPP_XLA_LINES, which ties BASE_TRANSACTION_HEADER_ID and BASE_TRANSACTION_LINE_ID back to the OZF claim and claim line identifiers, and is restricted to Price Protection transaction types SUPP_DSTR_CL and SUPP_DSTR_INC_CL.

Key Columns

• EVENT_ID — SLA event identifier inherited from the header view; the partitioning key for LINE_NUMBER.
• LINE_NUMBER — generated with ROW_NUMBER() OVER(PARTITION BY EVENT_ID ORDER BY EVENT_ID), providing sequential line sequencing per accounting event.
• ENTERED_AMOUNT / ACCOUNTED_AMOUNT / CURRENCY_CODE — mapped from OZF_CLAIM_LINES_ALL.AMOUNT, ACCTD_AMOUNT, and CURRENCY_CODE; these become the SLA amount attributes.
• DISTRIBUTION_IDENTIFIER — aliased from CLAIM_LINE_ID and used to match SLA distributions back to claim lines.
• PRIMARY_QUANTITY — the claim line quantity.
• LEDGER_ID, ORGANIZATION_ID, TRANSACTION_DATE, COGS_CCID, SEGMENT1 — accounting context derived from GL_LEDGERS, the financials system parameters, the claim date, and the item master.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE30, SUPPLIER_PART_NUM, PRIOR_PRICE, CHANGE_TYPE, CHANGE_VALUE — descriptive and price-change attributes sourced from DPP_TRANSACTION_LINES_ALL, available for mapping into accounting rules.

Common Use Cases and Queries

Typical uses include reconciling Price Protection claim lines to accounting events, verifying that amounts and flexfield attributes were passed correctly into SLA, and diagnosing missing or unbalanced claim accounting entries. A representative query is:

• SELECT event_id, line_number, entered_amount, accounted_amount, currency_code, distribution_identifier, primary_quantity, ledger_id, organization_id FROM apps.dpp_xla_claim_lines_v WHERE event_id = :event_id ORDER BY line_number;
• SELECT h.claim_number, l.* FROM apps.dpp_xla_claim_lines_v l, apps.ozf_claims_all h WHERE h.claim_id = l.distribution_identifier ORDER BY l.event_id, l.line_number;

Because the view is a reporting and SLA construct rather than a transactional table, it should be queried read-only; claim data is maintained through the Price Protection claim transaction forms and the accounting engine processes the resulting events.