Search Results chargeback_line_id

Overview

The OZF_CHARGEBACK_LINES_ALL table is a core data object within Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, specifically for the Trade Management (OZF) module. It stores detailed line-level information for chargeback transactions. Chargebacks are a critical trade management process where a supplier (e.g., a manufacturer) issues a financial claim or deduction against a customer (e.g., a distributor or retailer) for various trade activities, such as promotional discounts, volume rebates, or pricing adjustments. This table operates in a multi-org environment, as indicated by the "_ALL" suffix, meaning it contains data for all operating units. Each record in this table represents a single line item on a chargeback document, linked to a parent header, and holds specific details about the claim amount, associated customer, and related transaction data.

Key Information Stored

The table's primary key is CHARGEBACK_LINE_ID, which uniquely identifies each chargeback line. The most critical columns define the line's relationship to other core EBS entities. The CHARGEBACK_HEADER_ID foreign key links the line to its parent document in OZF_CHARGEBACK_HEADERS_ALL. Customer information is stored through foreign keys to the Trading Community Architecture (TCA) tables: BILL_TO_CUST_ACCOUNT_ID and SHIP_TO_CUST_ACCOUNT_ID reference HZ_CUST_ACCOUNTS, while BILL_TO_SITE_USE_ID and SHIP_TO_SITE_USE_ID reference HZ_CUST_SITE_USES_ALL for specific addresses. While the provided metadata does not list all columns, typical data stored includes the chargeback amount, quantity, reason code, associated invoice or sales order references, product identifier, line status, and accrual or payment details.

Common Use Cases and Queries

This table is central to reporting and auditing chargeback transactions. Common operational and analytical queries include summarizing total chargeback amounts by customer or product, reconciling chargeback lines against original trade agreements or invoices, and tracking the status of individual claim lines. A typical query to retrieve chargeback lines for a specific header would join on the CHARGEBACK_HEADER_ID. For customer-centric reporting, a query would join to HZ_CUST_ACCOUNTS on the BILL_TO_CUST_ACCOUNT_ID. Developers often reference this table when building custom interfaces to load chargeback data or when creating extensions to validate chargeback line logic before submission to the approval workflow.

Related Objects

The OZF_CHARGEBACK_LINES_ALL table has defined foreign key relationships with several fundamental EBS tables, as documented in the ETRM metadata:

• OZF_CHARGEBACK_HEADERS_ALL: Linked via OZF_CHARGEBACK_LINES_ALL.CHARGEBACK_HEADER_ID. This is the primary parent-child relationship.
• HZ_CUST_ACCOUNTS (Bill-to): Linked via OZF_CHARGEBACK_LINES_ALL.BILL_TO_CUST_ACCOUNT_ID. Identifies the customer account being charged.
• HZ_CUST_SITE_USES_ALL (Bill-to): Linked via OZF_CHARGEBACK_LINES_ALL.BILL_TO_SITE_USE_ID. Identifies the specific bill-to address site.
• HZ_CUST_ACCOUNTS (Ship-to): Linked via OZF_CHARGEBACK_LINES_ALL.SHIP_TO_CUST_ACCOUNT_ID. Identifies the associated ship-to customer account.
• HZ_CUST_SITE_USES_ALL (Ship-to): Linked via OZF_CHARGEBACK_LINES_ALL.SHIP_TO_SITE_USE_ID. Identifies the specific ship-to address site.

This table is also a likely source for key Trade Management views and is central to the chargeback processing APIs within the OZF module.