Results for “create_snapshot”

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

Overview

FEM_AW_SNAPSHOT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Enterprise Planning and Budgeting (EPB) product family, which relies on the FEM (Financial Enterprise Management) schema objects and the Analytic Workspace (AW) infrastructure. The package name indicates its role in the snapshot mechanism used to capture and preserve the state of analytic workspace metadata — in particular dimension attribute definitions — at a point in time. In EBS 12.1.1 and 12.2.2, this snapshot capability supports EPB deployment, upgrade, and refresh operations, where the current definition of OLAP metadata must be recorded before structural changes are applied, allowing comparison, validation, and rollback of dimension and attribute configurations.

Key Procedures and Functions

The ETRM documentation records a single public procedure in the package specification:

• CREATE_SNAPSHOT — Captures a snapshot of the relevant analytic workspace metadata. The procedure follows the standard EBS error-handling convention, returning an error code and a message count through OUT parameters so that calling programs can detect and report failures. Because the parameter list documented by ETRM consists only of these two OUT parameters, the procedure takes no inbound arguments; the scope of the snapshot is derived from package-level context or the current session state rather than from caller-supplied identifiers.

The package specification contains no other documented procedures or functions, and the package body is not exposed through ETRM. The procedure is a wrapper-style API intended for programmatic invocation rather than interactive use.

Tables Accessed

The only documented table reference for this package is FEM_DIM_ATTRIBUTES_B, accessed through an APPS synonym. This is the base table that stores dimension attribute definitions used by the FEM analytic workspace. CREATE_SNAPSHOT reads from this table to record the current attribute configuration. The choice of a snapshot operation against dimension attributes is consistent with the EPB model, in which dimension members and their attributes define the structure of the analytic workspace; preserving that structure is necessary before deployments that alter dimensions, hierarchies, or attribute mappings.

Usage Notes

FEM_AW_SNAPSHOT_PKG is classified in ETRM as an OTHER API rather than a public, supported interface, and the ETRM metadata records no other packages as referencing it. This indicates that it is invoked internally by EPB deployment and administration components — including concurrent programs and internal setup logic — rather than being called directly from Oracle Forms or external integrations. The header comment in the source, dated 2005, shows that the package has been stable across releases and is carried forward into 12.1.1 and 12.2.2 without signature changes.

Custom code should treat this package as internal. Direct calls are not recommended because the procedure relies on session and application context that is not exposed through its parameter list, and because Oracle does not document the package as a supported extension point. Where snapshot behavior is required, the supported path is to use the EPB administrative flows or concurrent programs that invoke the package on the caller's behalf. The returned error code should always be checked, as silent failures during snapshot creation can leave deployment operations without a valid restore point.