Search Results pending_claim

Overview

APPS.OZF_SD_BATCH_PVT is the private (PVT) PL/SQL package body that implements the batch processing engine for Oracle E-Business Suite's Trade Management (formerly Oracle Field Sales / DFF-based Offer and Claim) module within the OZF schema. Its primary responsibility is to create, populate, and finalize "batch" records — logical groupings of supplier-side accruals and claims — that are staged in the OZF_SD_BATCH_HEADERS_ALL and OZF_SD_BATCH_LINES_ALL tables before they are pushed forward into the claim and accrual flow through OZF_CLAIM_ACCRUAL_PVT, OZF_CLAIM_PVT, and OZF_CLAIM_DEF_RULE_PVT.

The package handles the multi-source nature of batch data. Batches may originate from Oracle Order Management (OM), from an external/IDSM feed, or be created manually, and the package normalizes currency, rounds amounts to extended precision, resolves vendor and vendor-site identifiers, and invokes automatic claiming per the configured claim definition rules. Because it is a private package, it is not intended as a public integration API; it is called from the corresponding public package and from concurrent programs.

Key Procedures and Functions

• CREATE_BATCH_MAIN — Top-level entry point that orchestrates batch creation from the appropriate source.
• CREATE_BATCH_SUB — Helper for the subordinate/child portions of batch construction.
• CREATE_BATCH — Core routine that builds a batch record and its associated header data.
• CREATE_BATCH_HEADER — Inserts and populates the batch header row in OZF_SD_BATCH_HEADERS_ALL.
• CREATE_OM_BATCH_LINES — Creates batch lines sourced from Oracle Order Management transactions.
• CREATE_IDSM_BATCH_LINES — Creates batch lines sourced from the external/IDSM data feed.
• UPDATE_AMOUNTS — Recalculates and persists batch amount fields after line processing.
• GET_BATCH_CURRENCY_AMOUNT — Returns a batch amount converted to the appropriate batch/functional currency.
• GET_VENDOR_ITEM_ID — Resolves the vendor item identifier used to tie batch lines to offers.
• CONV_DISC_TO_OFFER_CURR_AMOUNT — Converts a discount amount into the offer currency amount.
• CONV_AMT_TO_OFFER_CURR_AMOUNT — Converts an arbitrary amount into the offer currency amount.
• CURR_ROUND_EXT_PREC — Rounds a currency value to the extended precision required for offer/claim amounts.
• INVOKE_BATCH_AUTO_CLAIM — Drives automatic claim creation for a completed batch.
• INVOKE_CLAIM — Calls the claim processing logic (OZF_CLAIM_PVT / OZF_CLAIM_ACCRUAL_PVT) for a specific batch.
• PROCESS_SD_PENDING_CLM_BATCHES — Processes all pending supplier-deals claim batches; typically driven by a concurrent program.
• PROCESS_SUPPLIER_SITES — Resolves and processes supplier site records (AP_SUPPLIER_SITES_ALL / PO_VENDOR_CONTACTS) needed for batch and claim creation.

Tables Accessed

• OZF_SD_BATCH_HEADERS_ALL and OZF_SD_BATCH_HEADERS_ALL_S — Header records and their MLS translations; the package inserts and updates headers, and the "S" table provides translated descriptions.
• OZF_SD_BATCH_LINES_ALL — Individual line records staged for each batch.
• OZF_FUNDS_UTILIZED_ALL_B — Fund utilization balances consumed when batches are converted to claims.
• OZF_SUPP_CODE_CONVERSIONS_ALL, OZF_SUPP_TRD_PRFLS_ALL, OZF_SYS_PARAMETERS_ALL — Supplier code conversions, supplier trade profiles, and system parameters that drive conversion and defaulting logic.
• AP_SUPPLIERS, AP_SUPPLIER_SITES_ALL, and PO_VENDOR_CONTACTS — Supplier, site, and contact validation.
• GL_PERIODS, GL_SETS_OF_BOOKS, HR_OPERATING_UNITS — Set-of-Books and period context for currency and accounting-period derivation.
• FND_CURRENCY, FND_GLOBAL, FND_PROFILE, FND_MSG_PUB, FND_FILE, FND_API, MO_GLOBAL, FND_DSQL, DBMS_SQL — Standard EBS infrastructure used for messaging, profile lookup, currency conversion, logging, and dynamic SQL.

Usage Notes

OZF_SD_BATCH_PVT is invoked indirectly rather than directly. In the standard EBS Trade Management flow it is called from the equivalent public package and from concurrent programs that process pending supplier-deal batches, including those corresponding to PROCESS_SD_PENDING_CLM_BATCHES and PROCESS_SUPPLIER_SITES. It may also be reached from the Trade Management forms when batch records are created or updated interactively, and from OM/IDSM integration points where batches are generated from order or external feed data. The package follows the standard EBS API conventions — bulMSg message stack, FND_GLOBAL context, and ML-supported tables — and it is not referenced by any other database object directly, confirming its role as an internal implementation layer beneath the public OZF_SD_BATCH public API. Because it is a private package, customizations should be made to the public API or to the calling concurrent program, not to OZF_SD_BATCH_PVT itself.