Search Results claim_date

Overview

DPP_XLA_CP_V is a reporting view owned by the APPS schema within the Oracle Price Protection (DPP) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It is documented as the "Dpp SLA Claim Summary View" and functions as the principal consolidation point between Price Protection transaction headers, Price Protection claim associations, Oracle Claim (OZF) claim records, and subledger accounting (SLA/XLA) event headers. The view surfaces the accounting-relevant attributes of a price protection claim in a single row per claim-and-transaction relationship, exposing the claim date, claim number, claim type, accounted amount, and currency alongside the corresponding Price Protection transaction header identifier.

Because it joins directly to DPP_XLA_HEADERS, the view is oriented toward subledger accounting analysis — it enables reporting on which claims have generated SLA event data and how those claims are described in the SLA repository. For users searching on claim_date, this is the object that carries that column through from OZF_CLAIMS_ALL into a DPP/SLA context.

Underlying Base Objects

The view is defined over five referenced objects, combined in a single SELECT with no aggregation or grouping:

• OZF_CLAIMS_ALL (synonym) — the Oracle Claims base table. Supplies CLAIM_DATE, CLAIM_NUMBER, CURRENCY_CODE, and the ACCTD_AMOUNT aliased as AMOUNT; its ORG_ID is the join driver to the DPP transaction headers.
• DPP_TRANSACTION_HEADERS_ALL (synonym) — the Price Protection transaction header table. Supplies TRANSACTION_HEADER_ID and TRANSACTION_NUMBER (presented in the view as PP_TXN_NUMBER).
• DPP_TRANSACTION_CLAIMS_ALL (synonym) — the association between transaction headers and claims. Supplies CLAIM_ID and CLAIM_TYPE, and links DTH.TRANSACTION_HEADER_ID to DTC.TRANSACTION_HEADER_ID.
• DPP_XLA_HEADERS (synonym) — the Price Protection SLA event header table. The join requires BASE_TRANSACTION_HEADER_ID to be non-null and to equal OCA.CLAIM_ID, filtering the result to claims that have an associated SLA header and correlating the SLA header to the DPP transaction header.
• FND_LOOKUP_VALUES_VL (view) — the dated lookup values view, restricted to LOOKUP_TYPE = 'DPP_CLAIM_TYPES' to translate the claim type code into its MEANING, with the active-date window enforced via SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE).

Key Columns

• TRANSACTION_HEADER_ID — Price Protection transaction header identifier; the primary correlation key to DPP transaction data.
• BASE_TRANSACTION_HEADER_ID — documented as a column of the view, used to relate the SLA header back to the originating claim (OCA.CLAIM_ID) in the view's join condition.
• CLAIM_ID — the Oracle Claims identifier; the hinge between OZF claims and DPP claim associations.
• CLAIM_DATE — the date of the claim, sourced from OZF_CLAIMS_ALL. This is the field most commonly searched for in this view and is the anchor for period-based claim reporting.
• CLAIM_NUMBER — the user-visible claim document number.
• CLAIM_TYPE — the decoded meaning of DTC.CLAIM_TYPE from the DPP_CLAIM_TYPES lookup, providing a human-readable classification (the raw code is held on DTC).
• AMOUNT — OCA.ACCTD_AMOUNT, the accounted amount of the claim in the subledger.
• PP_TXN_NUMBER — the Price Protection transaction number (DTH.TRANSACTION_NUMBER).
• CLAIM_CURRENCY_CODE — the claim currency (OCA.CURRENCY_CODE).

Common Use Cases and Queries

The view is typically queried to reconcile Price Protection claims against their SLA representation, to list claims by date, or to report accounted amounts by claim type and currency. A representative query for a claim-date range follows:

• SELECT claim_number, claim_date, claim_type, pp_txn_number, amount, claim_currency_code FROM dpp_xla_cp_v WHERE claim_date BETWEEN :p_from AND :p_to ORDER BY claim_date;
• Filtering to a single Price Protection transaction: SELECT * FROM dpp_xla_cp_v WHERE transaction_header_id = :p_txn_id;
• Summarizing accounted amounts by claim type for a period: SELECT claim_type, claim_currency_code, SUM(amount) FROM dpp_xla_cp_v WHERE claim_date BETWEEN :p_from AND :p_to GROUP BY claim_type, claim_currency_code;

Two behavioural points should be noted. First, the join to DPP_XLA_HEADERS with BASE_TRANSACTION_HEADER_ID IS NOT NULL means only claims that have generated SLA headers appear; claims without subledger events are excluded. Second, the lookup join is date-sensitive, so a claim whose type code falls outside the active lookup date window will be dropped from the result set. Both characteristics make the view well suited to accounting-focused claim reporting rather than a complete claim inventory.