Search Results create_fund_adjustment

Overview

OZF_FUND_UTILIZED_PUB is a public PL/SQL API package owned by the APPS schema within the Oracle E-Business Suite. It belongs to the Oracle Trade Management (formerly Oracle Funds Management) product family, identified by the OZF application prefix, and is classified as a PUB (public) API, denoting that it is intended for external invocation by other application modules or customer extensions rather than being an internal-only implementation unit. The package governs the creation and processing of fund utilization adjustments — transactions that record how accrued marketing or trade promotion funds are consumed, reallocated, or reconciled against specific deliverables and customer obligations.

Fielded within Release 12.1.1 and 12.2.2, the package is documented with a VALID status in the ETRM repository and adheres to the standard EBS API architecture, relying on FND_API for message handling, error stacking, and return-status conventions. Its role is central to maintaining accurate fund balances in OZF_FUNDS_ALL_B while simultaneously preserving the transactional linkage between funds, customers, and the orders or activities that consumed them.

Key Procedures and Functions

The ETRM metadata documents a single public procedure for this package:

• CREATE_FUND_ADJUSTMENT — The principal entry point for generating a fund adjustment record. This procedure encapsulates validation of the adjustment request, defaulting logic, and the write to the underlying fund tables. It applies the standard EBS API return contract, returning a status code along with optional error messages, and is designed to be called transactionally so that callers may commit or roll back surrounding work.

The absence of additional documented procedures in the metadata indicates that supporting logic is encapsulated in private package body routines or in sibling packages such as OZF_FUND_UTILIZED_PVT, which this package references.

Tables Accessed

The package performs both direct and indirect table access through APPS synonyms, reflecting the broad integration footprint of fund adjustment processing:

• OZF_FUNDS_ALL_B — The base fund definition table; adjustments update or are validated against the fund header, including currency and balance information.
• AR_PAYMENT_SCHEDULES_ALL — Used to associate fund activity with receivable transactions and payment terms.
• HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL — Provide customer, site, and site-use context required to attribute fund consumption correctly.
• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, OE_SYS_PARAMETERS_ALL — Supply order-level and line-level detail so that fund adjustments can be tied to the sales transactions that generated the obligation.
• AMS_ACT_ACCESS_DENORM, AMS_DELIVERABLES_ALL_B, AMS_DELIVERABLES_ALL_TL — Link adjustments to marketing activities and deliverables, the objects against which trade funds are typically earned and consumed.
• MTL_SYSTEM_ITEMS_KFV, MTL_CATEGORY_SETS_B, MTL_DEFAULT_CATEGORY_SETS — Resolve item and category information for adjustments referencing products.
• FND_CURRENCIES — Validate and convert currency values used in the adjustment.

Usage Notes

OZF_FUND_UTILIZED_PUB is invoked primarily from other server-side PL/SQL rather than from a user-facing form. The ETRM dependency listing shows that OZF_FUND_UTILIZED_PUB is referenced by OZF_FUND_UTILIZED_PUB itself (recursive package body references) and, importantly, by OZF_GL_INTERFACE_PVT — indicating that fund utilization adjustments feed into the General Ledger interface process as part of period-end accounting. Consequently, the package should be called within a properly managed transaction, with callers inspecting the returned status and message list before committing. In 12.1.1 and 12.2.2, changes to the surrounding table structures are governed by patching and the Online Patching (adop) cycle in 12.2.x; any custom code that calls CREATE_FUND_ADJUSTMENT must therefore be validated against the current editioned view of the APPS synonyms after each application of patches.