Search Results validate_formula_items

Overview

OZF_ACTMETRICFACT_PVT is a private PL/SQL package in the APPS schema that underpins the Oracle E-Business Suite Trade Management (formerly Oracle Field Sales/TeleSales) activity metric and fund allocation subsystem. Its central business purpose is to create, validate, and maintain "activity metric facts" — the quantified, measurable outcomes associated with marketing activities and promotions — together with the reusable formulas and formula entries that define how those metrics are calculated. These metric facts serve as the quantitative inputs that drive fund allocation, accrual, and settlement logic elsewhere in the OZF (Trade Management) module. As a PVT-classification package, it is not intended for direct customer invocation; it exposes the internal programmatic machinery that public packages and their thin _W wrapper packages call.

The package depends on the standard EBS infrastructure libraries FND_API, JTF_PLSQL_API, and the SYS.STANDARD package, indicating that it uses the Oracle Application Object Library API error-handling and message-stack conventions as well as the JTF (CRM Foundation) PL/SQL utilities. It is documented as VALID and referenced by three other packages: OZF_ACTMETRICFACT_PVT_W, OZF_FUND_ALLOCATIONS_PVT, and OZF_FUND_ALLOCATIONS_PVT_W. This confirms the user's search term — OZF_FUND_ALLOCATIONS_PVT — as a documented consumer of this package.

Key Procedures and Functions

The ETRM metadata documents sixteen procedures and functions, organized around two functional clusters: metric facts and formulas.

• INIT_ACTMETRICFACT_REC — Initializes the activity metric fact record structure prior to processing.
• CREATE_ACTMETRICFACT — Creates a new activity metric fact record.
• UPDATE_ACTMETRICFACT — Modifies an existing activity metric fact.
• VALIDATE_ACTMETFACT, VALIDATE_ACTMETFACT_ITEMS, VALIDATE_ACTMETFACT_REC — Validate the metric fact entity, its line items, and the assembled record respectively.
• COMPLETE_ACTMETFACT_REC — Finalizes completion of the metric fact record.
• CREATE_FORMULA, DELETE_FORMULA — Create and remove metric formula definitions.
• VALIDATE_FORMULA, VALIDATE_FORMULA_ITEMS, VALIDATE_FORMULA_REC — Validate formula headers, items, and full records.
• CREATE_FORMULA_ENTRY — Creates a formula entry (a component row of a metric formula).
• VALIDATE_FORMULA_ENTRY, VALIDATE_FORM_ENT_ITEMS, VALIDATE_FORM_ENT_REC — Validate formula entries, their items, and complete records.

Tables Accessed

The package reads and writes the following tables via APPS synonyms: OZF_ACT_METRIC_FACTS_ALL and its _S sequence (fact header/line data), OZF_ACT_METRIC_FORMULAS and its _S sequence (formula definitions), OZF_ACT_METRIC_FORMULA_ENT_S (formula entries), OZF_ACT_METRIC_FORM_ENT (formula entry detail), and DUAL for scalar/PLSQL expression evaluation.

Usage Notes

OZF_ACTMETRICFACT_PVT is invoked indirectly. Public API layers and the OZF_ACTMETRICFACT_PVT_W wrapper call into it, and OZF_FUND_ALLOCATIONS_PVT consumes its results when computing fund allocations. It is typically reached through the Trade Management setup and activity forms, related concurrent programs, and any custom code that must insert or validate metric facts and formulas. Developers should avoid calling the _PVT layer directly and instead use the supported public API.