Search Results complete_ar_validation

Overview

OZF_AR_VALIDATION_PVT is a private (PVT-class) PL/SQL package owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Trade Management (OZF) application family and provides validation logic that bridges Trade Management claim and settlement processing with Oracle Receivables. As a PVT-class API, it is not intended as a public integration surface; it is an internal implementation package whose procedures are invoked exclusively by other OZF packages and by Trade Management setup flows.

The package's central business responsibility is to determine whether an Accounts Receivable transaction, credit memo, or payment schedule is eligible for claim settlement processing, and to validate the customer and credit-to information required before claims or deductions are settled against open receivables. It enforces data-integrity rules that prevent invalid or duplicate claims from reaching the settlement and workflow stages of the Trade Management deduction lifecycle.

Key Procedures and Functions

• COMPLETE_AR_VALIDATION — Serves as the primary entry point that performs end-to-end validation of Accounts Receivable data associated with a claim, returning or raising an error when the AR records fail the Trade Management settlement criteria. It consolidates the individual AR checks into a single callable routine.
• VALIDATE_CREDITTO_INFORMATION — Validates the "credit to" customer and transaction information used to direct the settlement credit to the correct trading partner or customer account. This ensures the credit target referenced on the claim is a valid, active AR customer relationship.
• CHECK_TO_PROCESS_SETL_WF — Evaluates whether a given claim or settlement is eligible to proceed to the settlement workflow. This acts as a gate, preventing unsettled or invalid claims from being routed into the workflow engine.

These three routines are the documented procedures of the package; no public parameters are exposed through the ETRM metadata, and callers should treat the signatures as internal.

Tables Accessed

• AR_PAYMENT_SCHEDULES / AR_PAYMENT_SCHEDULES_ALL — Read to inspect installments, remaining balances, and open transaction amounts used to determine settlement eligibility.
• AR_SYSTEM_PARAMETERS — Read to obtain Receivables system options that govern transaction and customer behavior during validation.
• RA_CUSTOMER_TRX_LINES — Read to confirm transaction line detail for credit memos and invoices referenced by a claim.
• RA_CUST_TRX_TYPES — Read to validate that the AR transaction type is one that participates in Trade Management settlement.
• MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE — Read to validate the inventory item and its unit of measure when claims contain product-level detail.
• OZF_CLAIM_LINES — Read to retrieve the claim line data being validated against the AR records.
• OZF_REASON_CODES_ALL_TL — Read to resolve the translated reason code associated with the claim or deduction.
• OZF_SYS_PARAMETERS — Read to retrieve Trade Management system parameters that control validation and workflow behavior.

Usage Notes

OZF_AR_VALIDATION_PVT is referenced by three other packages: OZF_AR_PAYMENT_PVT, OZF_CLAIM_SETTLEMENT_PVT, and OZF_CLAIM_SETTLEMENT_VAL_PVT. It also references FND_API, OZF_CLAIM_PVT, and STANDARD. Because it is a private package, it should never be called directly from custom code; the supported approach is to drive Trade Management claim and settlement flows through the Oracle Trade Management user interface or the corresponding public APIs, which transitively invoke this validation logic. Typical invocation occurs during claim settlement, deduction creation, and settlement workflow routing, ensuring that AR data is validated before any financial update is committed.