Search Results update_actmetricfact

Overview

APPS.AMS_ACTMETRICFACT_PVT is a private PL/SQL package in the Oracle E-Business Suite Marketing (AMS) module that defines the constants, records, types, and procedures comprising the activity metric facts API. Activity metric facts represent the measured or forecasted values associated with marketing activities, tracking quantitative outcomes across defined metrics, geographic areas, products, currencies, and time periods. The package header declares the package with AUTHID CURRENT_USER, and its documented record type, act_metric_fact_rec_type, maps the columns of AMS_ACT_METRIC_FACTS_ALL, including identifiers, audit columns, object version number, activity metric and formula attributes (value_type, activity_metric_id), dimensional keys (geographic area, product, and organizational identifiers), currency and quantity measures, and twenty-five time_id columns supporting a multi-period fact structure.

Because the package is classified as PVT, it is intended for internal use by the AMS product and is not a supported public end-user API. Its procedures underpin the maintenance of activity metric fact data that drives marketing analytics, campaign measurement, and performance reporting.

Key Procedures and Functions

• INIT_ACTMETRICFACT_REC — Initializes the activity metric fact record structure, establishing default values for the record type used by the other API procedures.
• CREATE_ACTMETRICFACT — Inserts a new activity metric fact row into the underlying fact table.
• UPDATE_ACTMETRICFACT — Modifies an existing activity metric fact row.
• DELETE_ACTMETRICFACT — Removes an activity metric fact row from the fact table.
• LOCK_ACTMETRICFACT — Obtains a row-level lock on an activity metric fact, typically prior to an update or delete.
• VALIDATE_ACTMETFACT — Performs validation of an activity metric fact, applying the overall business rules for the record.
• VALIDATE_ACTMETFACT_ITEMS — Validates the individual attribute or item values of an activity metric fact. This is the routine most closely associated with the search term "validate_actmetfact_items" and is the item-level counterpart to the record-level validation.
• VALIDATE_ACTMETFACT_REC — Validates the complete activity metric fact record as a unit.
• COMPLETE_ACTMETFACT_REC — Derives or populates remaining values on the record, completing any required defaults or calculated attributes.
• VALIDATE_FUND_FACTS — Validates fund-related facts associated with the metric fact processing, supporting the funding dimension of activity metrics.

Tables Accessed

• AMS_ACT_METRIC_FACTS_ALL — The primary fact table storing activity metric fact rows; the target of create, update, and delete operations.
• AMS_ACT_METRIC_FACTS_ALL_S — The sequence used to generate surrogate primary keys for new fact rows.
• AMS_ACT_METRICS_ALL — The activity metrics definition table, referenced during validation to confirm that the metric referenced by a fact exists and is valid.
• AMS_ACT_METRIC_FORMULAS — Stores metric formula definitions, consulted during validation and record completion to resolve calculated metric values.
• DUAL — Used for simple scalar evaluations within the PL/SQL logic.

Usage Notes

As a private package, AMS_ACTMETRICFACT_PVT is not invoked directly from customer forms or concurrent programs; it is called by the AMS forms and public APIs that maintain activity metric facts, and it is referenced by one other package according to the documented metadata. Customizations should treat this package as internal and use the supported public API instead. In Oracle EBS 12.1.1 and 12.2.2 environments, the header revision string indicates the package lineage dates to early releases, and its behavior is consistent across the two versions. The record type supplies the canonical field list for integration work: any custom code that builds activity metric fact interfaces should align its column mapping with the fields declared in act_metric_fact_rec_type, including the time_id1 through time_id25 period keys and the trans_forecasted_value and func_forecasted_value measures.