Results for “orig_system_line_reference”

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

Overview

OZF_CHARGEBACK_INT_ALL is the chargeback interface table in the Oracle Trade Management (OZF) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It serves as the staging and processing repository for chargeback transactions imported from external sources — typically order management, order fulfillment, or third-party systems — before they are validated, priced, and converted into finalized chargeback records. Chargebacks in Trade Management represent vendor reimbursement claims raised when a customer purchases at a promotional or negotiated price and the supplier credits the difference. This table is the inbound landing zone where raw claim lines, customer references, order attributes, and pricing details are collected for downstream processing by the Chargeback Engine.

From a Data Vault modeling perspective, the heuristic classification of this object is satellite-leaning. Its structure consists of a single surrogate primary key (CHARGEBACK_INT_ID), extensive descriptive payload columns, and multiple foreign key references to surrounding master and transaction entities — a pattern characteristic of a satellite attached to the core chargeback hub rather than a standalone hub or a pure link table.

Key Information Stored

The table contains 106 documented columns. The most operationally significant are summarized below.

• CHARGEBACK_INT_ID — the surrogate primary key, enforced by CHARGEBACK_INT_ID_PK and uniquely indexed by OZF_CHARGEBACK_INT_ALL_U1. This is the business-key candidate for the interface record.
• BATCH_ID — foreign key to OZF_BATCHES_ALL, grouping imported interface rows into a processing batch.
• ORIG_SYSTEM_REFERENCE, ORIG_SYSTEM_LINE_REFERENCE — source-system identifiers used for traceability back to the originating document and line.
• ORDER_NUMBER, ORDER_TYPE, ORDER_CATEGORY, ORDER_TYPE_ID, DATE_ORDERED, DATE_SHIPPED — order context for the claim.
• BILL_TO_CUST_ACCOUNT_ID, BILL_TO_SITE_USE_ID, SHIP_TO_CUST_ACCOUNT_ID, SHIP_TO_SITE_USE_ID — customer and site references validated against HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL.
• INVENTORY_ITEM_ID and the INVENTORY_ITEM_SEGMENT1 through SEGMENT20 columns — the flexible product key.
• ORIG_SYSTEM_QUANTITY, ORIG_SYSTEM_UOM, ORIG_SYSTEM_SELLING_PRICE, ORIG_SYSTEM_CURRENCY_CODE — the as-received values before normalization into QUANTITY, UOM, SELLING_PRICE, and CURRENCY_CODE.
• STATUS_CODE — the processing state of the interface row.
• ORG_ID, SECURITY_GROUP_ID — multi-org and security-group partitioning.
• EXCHANGE_RATE, EXCHANGE_RATE_TYPE, EXCHANGE_DATE — currency conversion metadata.
• HEADER_ATTRIBUTE1–15 and LINE_ATTRIBUTE1–15 — DFF extensibility at header and line level.

Standard audit columns (LAST_UPDATE_DATE, CREATED_BY, REQUEST_ID, PROGRAM_ID, etc.) support concurrent-program traceability.

Common Use Cases and Queries

Typical usage centers on reconciling inbound claims, monitoring interface processing status, and diagnosing failures. A frequent pattern filters rows by batch and status:

• SELECT chargeback_int_id, order_number, orig_system_reference, status_code FROM ozf_chargeback_int_all WHERE batch_id = :p_batch_id;
• Joining to OZF_CHARGEBACK_INT_LOG on CHARGEBACK_INT_ID to retrieve error or processing messages for rejected rows.
• Aggregating ORIG_SYSTEM_QUANTITY and SELLING_PRICE by ORG_ID or customer for interface-to-final chargeback reconciliation.
• Identifying unprocessed rows by filtering STATUS_CODE to isolate rows that have not reached a terminal state.

Reporting commonly compares interface quantities and prices against converted records in OZF_CHARGEBACK_PRICE_ADJ_ALL.

Related Objects

• OZF_BATCHES_ALL — joined on BATCH_ID; defines the batch governing a set of interface rows.
• OZF_CHARGEBACK_INT_LOG — references this table via CHARGEBACK_INT_ID, holding log and error entries.
• OZF_CHARGEBACK_PRICE_ADJ_ALL — references CHARGEBACK_INT_ID as CHARGEBACK_LINE_ID, holding downstream price adjustments.
• HZ_CUST_ACCOUNTS — joined on BILL_TO_CUST_ACCOUNT_ID and SHIP_TO_CUST_ACCOUNT_ID.
• HZ_CUST_SITE_USES_ALL — joined on BILL_TO_SITE_USE_ID and SHIP_TO_SITE_USE_ID.
• SO_ORDER_TYPES_115_ALL — joined on ORDER_TYPE_ID for order type classification.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for security partitioning.