Search Results invalidate_rollup

Overview

APPS.AMS_ACTMETRIC_PUB is the public business API for activity metrics within the Oracle Marketing (AMS) module of Oracle E-Business Suite. Activity metrics represent quantitative measurements captured against marketing activities — for example, the number of leads generated, responses received, or revenue influenced by a campaign. The package provides the supported, externally callable interface through which forms, concurrent programs, and custom code create, maintain, validate, and delete these metric definitions in a controlled and consistent manner.

As a public (PUB) API, it follows the standard Oracle EBS API architecture. Each procedure accepts the conventional p_api_version, p_init_msg_list, p_commit, and p_validation_level parameters and returns x_return_status, x_msg_count, and x_msg_data. Internally, the public layer delegates business logic to the private package AMS_ACTMETRIC_PVT, which performs validation and the actual DML against the underlying tables. The public body is therefore a thin wrapper that manages message-list initialization, savepoints, and commit scope. The header of the source file dates to 2005 (version 120.0), confirming this is a long-standing API carried forward into both 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API exposes six procedures:

• CREATE_ACTMETRIC — Creates a new activity metric record. It accepts a metric record structure (AMS_ACTMETRIC_PVT.act_metric_rec_type) and returns the generated activity metric identifier. A savepoint is established and the private create routine is invoked.
• UPDATE_ACTMETRIC — Modifies the attributes of an existing activity metric, such as its name, description, or measurement configuration.
• DELETE_ACTMETRIC — Removes an activity metric definition from the system.
• LOCK_ACTMETRIC — Acquires a lock on a metric record, guarding against concurrent modification during an update or delete operation.
• VALIDATE_ACTMETRIC — Performs validation of a metric record without persisting changes, allowing callers to pre-check data before committing.
• INVALIDATE_ROLLUP — The procedure matching the user's search term. It invalidates rollup (aggregated summary) data associated with activity metrics, forcing rollup processing to be recalculated. This is typically invoked after a metric definition or its underlying measurement data changes, so that stale aggregated figures do not remain visible in reporting and analysis.

Tables Accessed

The primary table underlying this API is AMS_ACT_METRICS_ALL, which stores activity metric definitions. The CREATE_ACTMETRIC procedure inserts into this table, while UPDATE and DELETE operate on existing rows keyed by the activity metric identifier. Validation routines read from the same table to confirm uniqueness and referential integrity. The rollup invalidation procedure interacts with the metric rollup structures that the AMS module uses to maintain summarized activity performance data, marking affected records so that the rollup engine recalculates them. Table access is performed by APPS synonyms in keeping with EBS naming standards. Two other packages reference this API, indicating it participates in a wider marketing data model.

Usage Notes

AMS_ACTMETRIC_PUB is intended to be called rather than modified. Standard EBS PL/SQL API conventions apply: pass FND_API.g_true for p_init_msg_list when the API is the outermost call, set p_commit to false when the caller needs transactional control, and always inspect x_return_status and the message stack before proceeding. The package is typically invoked from the Marketing activity setup forms, from concurrent programs that batch-process metric data, and from custom code integrating marketing metrics with external systems. When metric data changes in a way that affects aggregation, call INVALIDATE_ROLLUP so that downstream rollup summaries are refreshed on the next processing cycle.