Results for “chargeback_line_id”

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

Overview

OZF_CHARGEBACK_PRICE_ADJ_ALL is a Trade Management (OZF) table in Oracle E-Business Suite that stores chargeback price adjustment records. Chargebacks in Oracle Trade Management represent supplier reimbursements issued to customers when they resell products at prices below agreed contract or promotion terms. This table captures the individual line-level price adjustment calculations that quantify the difference between the chargeback amount claimed and the amount authorized under the governing price list.

The object resides in the OZF schema and is documented as VALID in both EBS 12.1.1 and 12.2.2. Under the heuristic Data Vault classification mined from its foreign key structure, the table is characterized as satellite-leaning. This classification suggests the table behaves as a descriptive satellite attached to a transactional hub: its foreign key to OZF_CHARGEBACK_INT_ALL positions the chargeback line as the parent driving entity, while columns such as ADJUSTED_UNIT_AMOUNT and ACCRUAL_FLAG carry the descriptive, changeable attributes associated with that parent rather than defining independent business keys.

Key Information Stored

The table contains 26 documented columns. The most operationally significant are listed below.

• CHARGEBACK_PRICE_ADJ_ID — Surrogate primary key, enforced by OZF_CHARGEBACK_PRICE_ADJ_ALL_P and mirrored by unique index OZF_CHARGEBACK_PRICE_ADJ_U1. This is the sole documented business-key candidate, indicating that no natural composite key is enforced in the data model.
• CHARGEBACK_LINE_ID — Foreign key to OZF_CHARGEBACK_INT_ALL, linking the adjustment to its parent chargeback line.
• LIST_HEADER_ID and LIST_LINE_ID — References to the qualifying price list and its line; LIST_LINE_ID is a foreign key to QP_LIST_LINES. These identify the authorized pricing source used to compute the adjustment.
• ADJUSTED_UNIT_AMOUNT and ADJUSTED_AMOUNT — The per-unit and extended adjustment values calculated for the line.
• PRICED_QUANTITY and PRICED_UOM — The quantity and unit of measure against which the adjustment is priced.
• OPERAND and OPERAND_CALCULATION_CODE — The operand value and the calculation method applied to derive the adjustment.
• ACCRUAL_FLAG — Indicates whether the adjustment accrues for accounting purposes.
• BATCH_ID and BATCH_TYPE — Identify the processing batch and its category, supporting volume calculation runs.
• ORG_ID and SECURITY_GROUP_ID — Multi-org operating unit context; SECURITY_GROUP_ID is a foreign key to FND_SECURITY_GROUPS for access control in a multi-tenant environment.

Standard OAF concurrency columns are present, including OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, CREATED_BY, and the PROGRAM_/REQUEST_ID audit triad.

Common Use Cases and Queries

Primary usage centers on chargeback reconciliation and accrual reporting. Analysts join this table upward to the chargeback line to reconstruct the full claim, and downward to QP_LIST_LINES to confirm the authorized price basis. A typical pattern retrieves all adjustments for a chargeback:

• Join OZF_CHARGEBACK_PRICE_ADJ_ALL.CHARGEBACK_LINE_ID to OZF_CHARGEBACK_INT_ALL.CHARGEBACK_LINE_ID to reconcile computed adjustments against claimed amounts.
• Filter on ORG_ID to scope results to a single operating unit, and on CREATION_DATE or LAST_UPDATE_DATE for period-based reporting.
• Group by BATCH_ID to audit the output of a specific batch calculation run.
• Aggregate ADJUSTED_AMOUNT by LIST_HEADER_ID to report adjustment exposure by price list.
• Filter on ACCRUAL_FLAG to isolate adjustments requiring accrual entries.

Because the primary key is a surrogate, queries should always constrain by CHARGEBACK_LINE_ID or ORG_ID rather than relying on composite natural keys, and should use the OZF_CHARGEBACK_PRICE_ADJ_U1 index where single-record lookups are required.

Related Objects

• OZF_CHARGEBACK_INT_ALL — Parent chargeback line table; joined via CHARGEBACK_LINE_ID.
• QP_LIST_LINES — Qualifying price list line definition; joined via LIST_LINE_ID.
• FND_SECURITY_GROUPS — Application security group; joined via SECURITY_GROUP_ID.
• OZF_CHARGEBACK_PRICE_ADJ_ALL_P — Primary key constraint on CHARGEBACK_PRICE_ADJ_ID.
• OZF_CHARGEBACK_PRICE_ADJ_U1 — Unique index on CHARGEBACK_PRICE_ADJ_ID.
• QP_LIST_HEADERS — Associated price list header referenced by LIST_HEADER_ID.
• FND_CONCURRENT_PROGRAMS — Links via PROGRAM_ID and PROGRAM_APPLICATION_ID for batch audit.