Search Results ozf_resale_common_pvt




Overview
Explore in AI Chat

Overview

OZF_TP_ACCRUAL_PVT is an Oracle EBS Trade Management (formerly Oracle Trade Management / OZF schema) private PL/SQL package owned by the APPS schema. It belongs to the ETRM (Enterprise Trade Revenue Management) family of seeded application code and carries the standard _PVT suffix, indicating that it is an internal helper package meant to be called only by sibling public packages rather than directly by external code. Its central responsibility is trade promotion (TP) accrual processing: it validates accrual-related transaction records, computes accrual entries, and drives the end-to-end processing of accruals and resale adjustments tied to trade promotion offers, funds, and resale batches.

The package is documented as VALID and is referenced by three other seeded packages — OZF_FUND_UTILIZED_PVT, OZF_RESALE_COMMON_PVT (appearing twice), and OZF_RESALE_PVT — confirming that it is a low-level building block inside the accrual and resale processing chain rather than a top-level entry point.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents five procedures/functions:

  • VALIDATE_ORDER_RECORD — Performs record-level validation on order data before accrual processing proceeds, ensuring that the order information required for a valid accrual is present and consistent.
  • PROCESS_ORDER — Drives order-level accrual processing, taking validated order records through the accrual calculation logic.
  • PROCESS_RESALE — Handles the resale-related portion of accrual processing, operating against the resale batch and resale adjustment structures.
  • PROCESS_TP_ACCRUAL — The core routine that performs trade promotion accrual processing, applying accrual rules to the related offer/fund/order data.
  • START_TP_ACCRUAL — The orchestration entry point that initiates a trade promotion accrual run and sequences the other processing steps.

The order of invocation typically follows START_TP_ACCRUAL → VALIDATE_ORDER_RECORD / PROCESS_ORDER → PROCESS_TP_ACCRUAL → PROCESS_RESALE. Parameter lists are not documented in the metadata and are intentionally omitted here.

Tables Accessed

The package references several application tables via APPS synonyms, notably:

Usage Notes

Because OZF_TP_ACCRUAL_PVT is a private (_PVT) package, it should never be invoked directly from customer forms, concurrent programs, or custom code. It is exercised internally by seeded public packages such as OZF_RESALE_PVT, OZF_RESALE_COMMON_PVT, and OZF_FUND_UTILIZED_PVT. In practice, accrual processing is triggered through the Trade Management accrual concurrent program or via the resale/offer UI actions, and those entry points ultimately call this package. The metadata shows the search term "ozf_resale_common_pvt" is a sibling caller, reinforcing that OZF_TP_ACCRUAL_PVT is a dependency in the resale/common processing path rather than a standalone API. Custom code should target the documented public packages, not this private package.