Search Results fii_ap_op_indicator_sum_c

Overview

The APPS.FII_AP_OP_INDICATOR_SUM_C package is a concurrent-program driver package belonging to the Financial Intelligence (FII) product family in Oracle E-Business Suite. The "AP" segment of its name identifies the Oracle Payables application, while "OP_INDICATOR_SUM" indicates that the package supports the summarization of operational indicator data within Payables. Packages whose names end in the conventional _C suffix in EBS are typically thin wrapper packages bound directly to a concurrent program definition, responsible for accepting the standard concurrent manager entry-point parameters and delegating the actual processing to underlying business logic. In this case, the package exposes a single documented entry point, LOAD, which serves as the executable called by a concurrent program of the same or similar name. Its header comment, $Header: FIIAP12S.pls 120.1 2005/06/13 11:00:35 sgautam noship $, confirms the file was last maintained at version 120.1 in June 2005 and is marked "noship," meaning it is a non-shipped or internal customization rather than a standard seeded artifact. This distinction is important for administrators assessing support implications.

Key Procedures and Functions

The package specification documents exactly one procedure: LOAD. This procedure follows the canonical Oracle concurrent program entry-point signature, accepting two IN OUT NOCOPY VARCHAR2 parameters that in EBS convention represent the error buffer and the return code. The error buffer is used to surface messages back to the concurrent manager log, while the return code communicates success or failure status. The procedure's purpose is to drive the summarization or loading of Payables operational indicator data as a scheduled batch process. No additional procedures, functions, or overloads are exposed in the documented specification, and the metadata does not disclose a parameter list beyond the standard two-argument concurrent interface, so the internal callable surface remains deliberately minimal.

Tables Accessed

According to the documented metadata, the package references ALL_TABLES via an APPS synonym. ALL_TABLES is the Oracle data dictionary view describing every table accessible to the current schema, exposing columns such as table name, owner, tablespace, and statistics. Its presence here suggests that the LOAD procedure performs metadata discovery or validation — likely enumerating expected FII Payables indicator tables before inserting or updating summary rows. Because the metadata lists no direct application tables, the package appears to function as an orchestrator that inspects the dictionary before invoking downstream summarization logic, rather than writing directly to a documented base table. Any target tables are referenced indirectly, which is consistent with the "noship" internal wrapper pattern.

Usage Notes

The package is invoked almost exclusively by an Oracle Payables concurrent program definition, with the concurrent manager supplying values for the error buffer and return code parameters defined on LOAD. It is not referenced by any other documented package, so no PL/SQL caller dependency exists within the ETRM inventory. Typical invocation patterns include scheduled periodic runs that refresh Payables operational indicator summaries for financial intelligence reporting. Because the object is flagged "noship," administrators should confirm its presence through the custom concurrent program registry rather than assuming it is delivered by the standard EBS 12.1.1 or 12.2.2 installation. In the 12.2.x online patching architecture, be aware that the file resides under the APPS schema in a non-editioned or editioned state; any change to this package requires the normal AD_ZD editioning and patch cycle. Direct ad hoc execution is discouraged in favor of submitting the associated concurrent request, ensuring proper logging and retcode propagation.