Results for “ams_actmetrics_engine_pvt”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AMS_ACTMETRICS_ENGINE_PVT is a private PL/SQL package body in the APPS schema that implements the computational engine behind Oracle Marketing's activity metrics subsystem. In Oracle E-Business Suite 12.1.1 and 12.2.2, activity metrics quantify the performance of marketing activities, campaigns, events, deliverables, and offers by evaluating user-defined formulas against transactional and denormalized data. The package is classified as PVT, indicating that its procedures are intended for internal invocation by the public AMS_ACTMETRIC_PVT API and by related marketing engine components rather than by external callers. Its core responsibility is to resolve metric formulas, evaluate their associated functions and variables, persist computed results, and maintain the historical record of metric values as source data evolves.

Key Procedures and Functions

The documented public surface of this package contains eight procedures. REFRESH_ACT_METRICS_ENGINE serves as the primary entry point, orchestrating a full recalculation cycle for activity metrics. RUN_FUNCTIONS and EXEC_FUNCTION handle the evaluation of metric formulas: RUN_FUNCTIONS iterates over the set of metrics requiring computation, while EXEC_FUNCTION resolves and executes an individual formula expression against the underlying data. UPDATE_FORMULAS and UPDATE_VARIABLE manage changes to metric formula definitions and their variable bindings, ensuring the engine operates against the current calculation logic. POPULATE_METRICS_DENORM writes results into the denormalized metrics table used for efficient reporting and retrieval. UPDATE_HISTORY records metric values into the history table, preserving point-in-time snapshots for trend analysis and audit purposes. All procedures follow the FND_API error-handling convention, raising and propagating messages through FND_MSG_PUB where appropriate.

Tables Accessed

The package reads and writes the core activity metrics tables AMS_ACT_METRICS_ALL and its denormalized counterpart AMS_ACT_METRICS_ALL_DENORM. History is maintained in AMS_ACT_METRIC_HST, with sequences AMS_ACT_METRICS_ALL_DENORM_S and AMS_ACT_METRIC_HST_S supplying surrogate keys. Metric definitions and calculation logic are drawn from AMS_METRICS_ALL_B, AMS_METRIC_FORMULAS, and AMS_METRIC_ACCRUALS. Activity context is resolved through AMS_ACT_LISTS, AMS_CAMPAIGNS_ALL_B, AMS_CAMPAIGN_SCHEDULES_B, AMS_DELIVERABLES_ALL_B, AMS_EVENT_HEADERS_ALL_B, and AMS_EVENT_OFFERS_ALL_B. AMS_OBJECT_ASSOCIATIONS links metrics to their parent marketing objects, while AMS_LOOKUPS supplies lookup code values. Currency conversion during metric evaluation is performed via INV_CONVERT.

Usage Notes

AMS_ACTMETRICS_ENGINE_PVT is invoked indirectly through the public AMS_ACTMETRIC_PVT interface and through the activity metrics refresh concurrent program, which is scheduled to recalculate activity metrics on a periodic basis or after significant transactional updates. It may also be triggered from Oracle Marketing forms when a user requests a metric refresh for a specific campaign, event, or deliverable. The package is not referenced by any database object, confirming its role as an implementation detail rather than a dependency target for external customizations. Custom code should call the supported public API rather than this private package body, since its signatures and internal behavior are not guaranteed across patch levels.