Search Results fii_ap_op_ind_summary_temp1




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.FII_AP_OP_INDICATOR_SUM_C belongs to the Oracle E-Business Suite Financial Intelligence (FII) product family, which supplies the extract, transform, and load logic underpinning Oracle Daily Business Intelligence for Payables. Its principal business function is to aggregate Accounts Payable invoice activity into an Operating Unit indicator summary. The package reconstructs a set of temporary staging tables, populates them with summarized Payables metrics such as invoice counts, invoice line counts, and invoice amounts, and organizes those metrics by operating unit and trading partner. Downstream reporting and dashboard components consume the resulting summary to present Payables operating indicators at the operating unit level.

The header comment ($Header: FIIAP12B.pls 120.2 2005/06/13) identifies the source file and indicates the package was shipped as a non-shippable (noship) internal component, meaning it is intended for internal FII processing rather than direct customer invocation. The package is specific to EBS 12.1.1 and 12.2.2 environments and is owned by APPS.

Key Procedures and Functions

The package body documents one exposed entry point, LOAD. This is the driver routine that orchestrates the summary build: it performs session-level setup (resolving the FII schema and tablespace, and evaluating the debug profile), invokes table maintenance and population logic, and returns the standard concurrent program error buffer and return code (g_errbuf, g_retcode).

Internally, the body implements supporting procedures that are not separately classified in the metadata but are visible in the source excerpt:

  • DROP_TABLE — issues a dynamic DROP TABLE against a fully qualified g_fii_schema object. It traps Oracle error -942 (table does not exist) via the G_TABLE_NOT_EXIST exception and suppresses it, allowing repeatable rebuilds, while re-raising all other errors.
  • CREATE_FII_AP_OP_IND_SUM_TEMP — drops and recreates the two staging tables FII_AP_OP_IND_SUMMARY_TEMP1 and FII_AP_OP_IND_SUMMARY_TEMP2, defining columns such as operating_unit_pk_key, operating_unit_name, trading_partner_pk_key, trading_partner_name, inv_lines_count, inv_count, and inv_amount, with explicit tablespace, PCTFREE 5, and storage clauses.

A package-level variable, g_debug_flag, governs diagnostic output. It is initialized from the profile option EDW_DEBUG (defaulting to N) and, when set to Y, causes the EDW_LOG utility to emit statements and trace messages during DDL and summary construction.

Tables Accessed

The metadata records a single referenced table: ALL_TABLES, accessed through an APPS synonym. This data dictionary view is used for existence checks, allowing the package to determine whether the temporary summary tables are already present before dropping or creating them. The package also creates and manipulates its own temporary structures, FII_AP_OP_IND_SUMMARY_TEMP1 and FII_AP_OP_IND_SUMMARY_TEMP2, in the resolved FII schema, and reads the underlying Payables invoice data that supplies the inv_count, inv_lines_count, and inv_amount figures.

Usage Notes

Because the LOAD procedure returns g_errbuf and g_retcode, this package is designed to be executed as a concurrent program within Oracle EBS, most likely scheduled as part of the FII Payables operating indicator refresh cycle. It is a dynamic-SQL based utility: DDL is executed with EXECUTE IMMEDIATE, and the CREATE statement is truncated in the excerpt, indicating further construction details are embedded in the full source. It is not referenced by any other documented packages, so it functions as a top-level load routine rather than a shared library. The EDW_DEBUG profile option controls verbosity for troubleshooting. When invoked manually—for example, to validate the summary build—it is best run under the APPS schema with database session privileges appropriate for creating and dropping tables.