Search Results ozf_sd_batch_line_disputes_s

Overview

OZF_SD_BATCH_FEED_PVT is a private PL/SQL package body in the APPS schema that supports the Oracle E-Business Suite Trade Management (formerly Oracle Trade Management / OZF) supplier-deduction and claim batch-feed processing flow. Its role is to receive inbound claim and deduction data from external sources—most notably supplier-distributed (SD) chargeback and claim feeds—populate the interface tables, validate and process the records against approved funds and batch headers, and drive the records to their final processed, disputed, or pending-claim status.

The package is fundamental to the integration between the supplier deduction workflow and the Oracle Trade Management funds and claims infrastructure. The approved_amount value that users search for is carried on the interface and batch-line records that this package processes, and it directly influences how fund utilization is written to OZF_FUNDS_UTILIZED_ALL_B and how batch headers are updated.

Key Procedures and Functions

• UPDATE_STALE_DATA_BATCH_LINE — Marks interface batch lines as processed (processed_flag = 'S') when the source system identifies them as stale, ensuring they are not re-processed by the batch feed. It updates last_update_date and last_updated_by for audit purposes.
• POPULATE_INTERFACE — Loads and populates the interface tables (OZF_SD_BATCH_LINES_INT_ALL) from the inbound feed, including the approved_amount, vendor authorization quantity, and currency attributes required for downstream claim processing.
• UPDATE_DATA — Performs validation and enrichment of interface rows, reconciling feed values against existing batch lines and header data before final processing.
• PROCESS_CHILD_BATCH — Handles the processing of subordinate/child batches that roll up into a parent batch header, ensuring correct aggregation and status propagation.
• PROCESS_COMP_APPR_BATCH — Processes completed or approved batch records, finalizing the claim and updating header/line statuses and fund utilization amounts.
• PROCESS_CLAIM — Core claim-processing routine. On failure it updates the batch header status to PENDING_CLAIM; it also applies the dispute code OZF_SD_NO_RESPONSE for invalid or missing responses.
• UPDATE_DISPUTE_DATA — Records dispute information against batch lines in OZF_SD_BATCH_LINE_DISPUTES, reflecting adjustments and rejection reasons.

Tables Accessed

• OZF_SD_BATCH_HEADERS_ALL — Master batch header records; status (including PENDING_CLAIM) is updated here.
• OZF_SD_BATCH_LINES_ALL / _S — Batch line details, including approved_amount and vendor authorization quantity.
• OZF_SD_BATCH_LINES_INT_ALL / _S — Interface staging tables for inbound batch lines; populated by POPULATE_INTERFACE and updated by UPDATE_STALE_DATA_BATCH_LINE.
• OZF_SD_BATCH_LINE_DISPUTES / _S — Dispute records written by UPDATE_DISPUTE_DATA.
• OZF_FUNDS_UTILIZED_ALL_B — Fund utilization balances updated based on approved_amount processing.
• OZF_SYS_PARAMETERS_ALL — System parameter lookups controlling processing behavior.
• DUAL and PLITBLM — Utility usage for single-row logic and PL/SQL index-by-table handling.

Usage Notes

As a PVT (private) API classification, OZF_SD_BATCH_FEED_PVT is invoked internally by the supplier-deduction batch-feed concurrent programs and by the parent public packages that orchestrate claim and chargeback processing. It is referenced by one other package. It is typically triggered when a batch feed is submitted or when claim processing runs against staged interface records. Custom code should not call this package directly; instead, extensions should target the public orchestration APIs.