Search Results validate_claim_line_tbl




Overview
Explore in AI Chat

Overview

OZF_OM_VALIDATION_PVT is a private (PVT) PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the Trade Management (formerly Oracle Sales and Marketing / Oracle Trade Management) module's claim processing and order validation framework. The package is declared with AUTHID CURRENT_USER, meaning that it executes with the privileges of the invoking schema rather than the definer's privileges, which is the conventional pattern for EBS private APIs that are called from within other server-side code.

The package's central business purpose is to validate and default claim line information — particularly claim lines associated with customer orders and returns — before those lines are processed into downstream order management and receivables transactions. It provides the procedural logic that ensures claim data supplied by a user or an upstream process is complete, internally consistent, and compatible with the referenced order, return, and receivables records. It also supplies defaulting logic that derives values such as the order type, item, quantity, unit of measure, rate, and currency for claim lines where the caller has not explicitly supplied them.

The package defines the composite datatypes claim_line_item_rec_type (a record mirroring the key columns of OZF_CLAIM_LINES) and claim_line_item_tbl_type (a PL/SQL associative array of that record indexed by BINARY_INTEGER). These types underpin the bulk (table-based) APIs and allow callers to validate or default an entire collection of claim lines in a single call.

Key Procedures and Functions

  • GET_DEFAULT_ORDER_TYPE — Derives the default order transaction type for a claim, based on the reason code, claim type, and set of books supplied by the caller. The resolved order type identifier is returned to the caller for use when creating or validating an order.
  • DEFAULT_CLAIM_LINE — Populates default values for a single claim line record. This is the single-record form of the defaulting logic.
  • DEFAULT_CLAIM_LINE_TBL — The bulk counterpart of DEFAULT_CLAIM_LINE, applying the same defaulting rules across a table (collection) of claim line records. This is the procedure most commonly invoked by set-based internal callers to avoid row-by-row context switching.
  • VALIDATE_CLAIM_LINE — Performs validation on a single claim line record, checking the supplied attributes (source object references, item, quantity/UOM, rate, currency) against the relevant claim, order, and receivables data. Validation messages are returned through the standard FND_API message stack (x_return_status, x_msg_data, x_msg_count).
  • VALIDATE_CLAIM_LINE_TBL — The bulk form of VALIDATE_CLAIM_LINE, validating a collection of claim line records in a single invocation. This is the procedure referenced by the user search term validate_claim_line_tbl.
  • COMPLETE_RMA_VALIDATION — Completes the validation cycle for claim lines tied to Return Merchandise Authorization (RMA) processing, reconciling the claim line against the associated return order.

All procedures follow the Oracle EBS API convention, accepting an API version, init message list, and validation level as standard IN parameters and returning status and message information through standard OUT parameters.

Tables Accessed

The package reads and writes through APPS synonyms for the following base tables:

  • OZF_CLAIM_LINES — the primary claim line table whose columns define the record type and are the subject of defaulting and validation.
  • OZF_CLAIMS — the parent claim header, used to resolve claim type and related attributes.
  • OZF_SYS_PARAMETERS — Trade Management system parameters that drive default values such as default order types.
  • OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, OE_ORDER_LINES_ALL — order management tables consulted to validate the claim line's relationship to a sales order, and to confirm order type and line details.
  • OE_SYS_PARAMETERS_ALL — order management system parameters used during defaulting and validation.
  • RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES, RA_CUSTOMER_TRX_LINES_ALL — receivables transaction and line tables used when the claim is associated with a credit or invoice transaction, ensuring the claim line reconciles to the receivables document.
  • PLITBLM — a standard helper table used for PL/SQL table indexing/parsing utility operations.

Usage Notes

Because OZF_OM_VALIDATION_PVT is classified as a Private API, it is not intended as a public integration point. It is designed to be invoked by other packages within the Trade Management claim processing flow rather than directly by external customizations. The ETRM metadata shows the package is referenced by one other package, confirming that its callers are internal EBS components.

Typical invocation scenarios include the Trade Management claim entry and validation forms, where claim lines must be defaulted and validated before the claim is submitted for processing; internal claim workflow packages that process claims in bulk; and the RMA validation flow, where COMPLETE_RMA_VALIDATION reconciles claim lines against return orders. Customers extending claim processing should call the supported public APIs rather than this private package, and should be aware that the package's interface may change between releases. The package is present in both EBS 12.1.1 and 12.2.2; the 12.2.2 metadata lists six documented procedures, and callers relying on older signatures should verify against the specific patch level of their instance.