Search Results publish_report

Overview

The IGI_IAC_SUBMIT_RXI_ASSET_BAL package body is a component of the Oracle E-Business Suite Internet Expenses and Assets integration framework, delivered under the APPS schema with the internal short name igiiaxab.pls. Its principal purpose is to serve as a report submission wrapper within the IGI (Oracle Financials Intelligence / iExpenses and Assets) family of PL/SQL utilities. Specifically, the package is designed to accept a single request type and up to eight associated report definitions, then submit them to the Oracle EBS Concurrent Manager as concurrent requests.

The naming convention — submit_rxi_asset_bal — indicates the package was authored to drive asset balance reporting within the Internet Expenses and Assets integration. The package header comment block records its version lineage (120.1.12000000.1, dated August 2007), confirming it is a long-standing, shipped object rather than a customer extension. Oracle's ETRM classifies the object as OTHER rather than a public API, meaning it is intended primarily for internal framework invocation rather than direct third-party calls.

Key Procedures and Functions

A single documented procedure is exposed in the package specification:

• SUBMIT_REPORT — The core worker routine. It accepts the standard concurrent program OUT parameters (errbuf and retcode) together with a request type and a repeating pattern of report descriptors — each consisting of a report name, report identifier, and reporting attribute set — supporting up to eight reports in a single submission. The procedure orchestrates the creation of concurrent requests, allowing a parent process to launch a coordinated batch of asset-related reports.

The package body also contains a forward declaration for a legacy function named publish_report. The source comments explicitly state that this construct is "NO LONGER USED — SEE COMMENTS AT END OF PROGRAM." It must therefore be treated as dead code and should not be referenced by any new development.

Tables Accessed

The ETRM metadata for this package lists no explicitly declared table references. All report submission activity is delegated to Oracle's Concurrent Manager FND APIs, which perform their own inserts into the FND_CONCURRENT_REQUESTS and related run-time tables. Any direct table access within the package would occur through APPS synonyms of standard FND tables rather than through locally declared cursors against asset or expense base tables. No application-level asset, invoice, or expense tables are documented as dependencies.

Usage Notes

Because the package is classified as OTHER and is not exposed as a published API, it should not be called directly from custom forms or ad hoc PL/SQL unless the developer accepts the risk of dependence on an unsupported interface. In practice, SUBMIT_REPORT is invoked from within the IGI integration flow — typically from another wrapper package or from a concurrent program whose logic chains multiple report submissions together. The pattern of accepting eight optional report slots suggests it was written to support a consolidated asset balance submission process, where several related reports must be launched with a shared context.

When embedding this package in Oracle EBS 12.1.1 or 12.2.2, developers should note the ONLINE patching considerations of 12.2.2, which affect editioning of PL/SQL objects, and should confirm that any wrapper concurrently submits reports within the correct operating unit and responsibility context. Because the object carries no callers documented within ETRM, impact analysis prior to recompilation or modification should extend to custom schemas that may reference IGI_IAC_SUBMIT_RXI_ASSET_BAL indirectly.