Results for “user_attr”

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

Overview

FII_PA_UOM_CONV_F_C is a PL/SQL package body owned by the APPS schema that supports the Oracle E-Business Suite Enterprise Data Warehouse (EDW) / Enterprise Tax and Reporting Management (ETRM) collection layer. Its specific purpose is to extract Projects (PA) unit-of-measure (UOM) conversion data from the EBS transactional schema and stage it for downstream fact loading. The package follows the standard FII (Financial Intelligence Interface) collection pattern, in which a single public procedure named Push drives the interface between the source application and the target EDW fact staging table, identified internally as OPI_EDW_UOM_CONV_FSTG.

The package is designated with an API classification of OTHER, indicating that it is an internal collection utility rather than a public application programming interface. Its header comment references the source control file FIIPA12B.pls, confirming its lineage within the PA collection family.

Key Procedures and Functions

The documented package exposes one public procedure: Push.

• Push — The entry point that performs the UOM conversion fact collection. It accepts a from-date and to-date range, resolves the effective collection window, logs the range for debugging when the FII_DEBUG_MODE profile option is enabled, initializes the EDW collection context through EDW_COLLECTION_UTIL.setup, and writes staged rows into the target fact staging table. Error conditions are surfaced back to the caller through the Errbuf and Retcode parameters, which is the conventional concurrent-program error interface.

Internally the procedure derives the effective date range from the global package variables g_push_date_range1 and g_push_date_range2. When explicit dates are not supplied by the caller, these are populated from EDW_COLLECTION_UTIL.G_local_last_push_start_date minus the configured offset, and EDW_COLLECTION_UTIL.G_local_curr_push_start_date respectively.

Tables Accessed

Per the documented metadata, the package references the following APPS synonym:

• EDW_LOCAL_INSTANCE — Read to obtain the local instance code via the EDW_INSTANCE.get_code function. This value identifies the EBS instance whose data is being collected and is used to scope the collected records to the correct source system.

In addition, the procedure interacts with the staging object OPI_EDW_UOM_CONV_FSTG as the target of the UOM conversion fact load. The global collection context variables and the setup routine reside in EDW_COLLECTION_UTIL, which underpins all FII collection packages and manages push-date bookkeeping across collection runs.

Usage Notes

This package is typically invoked by an Oracle EBS concurrent program registered against the Push procedure, with p_from_date and p_to_date supplied as concurrent program parameters. It is not referenced by any other documented package, confirming that it operates as a standalone collection driver rather than a library consumed by neighboring code.

Because the metadata records the source header as version 120.1 dated 2002/11/22, the package has been stable across the 12.1.1 and 12.2.2 releases and requires no version-specific adaptation for either environment. The FII_DEBUG_MODE profile option controls diagnostic output written via EDW_LOG; enabling it during troubleshooting produces the logged collection range that assists in diagnosing gaps in collected UOM conversion records. The global g_push_date_range1 variable is the internal marker that holds the resolved lower bound of the collection window and is the element users most frequently inspect when reconciling why a particular date range was captured.