Search Results create_bc_report

Overview

The APPS.PSA_BC_XML_REPORT_PUB package is a public PL/SQL API within the Oracle E-Business Suite (EBS) financials modules. Its primary business function is to generate Budgetary Control (BC) reports and transaction-level BC reports in XML format, supporting the Oracle EBS Budgetary Control and Funds Check infrastructure. The package name prefix "PSA_BC" indicates its association with Public Sector/Projects accounting budgetary control functionality. It is chiefly responsible for querying budgetary control packet data, constructing structured XML output representing the BC results (including funds availability, ledger information, and transaction details), and persisting that XML output either to the database or to a file system. This XML output is consumed by external reporting mechanisms, integration layers, or downstream applications requiring detailed BC transaction reporting.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• CREATE_BC_REPORT — Orchestrates creation of a Budgetary Control report, likely aggregating BC packet data for a given ledger and period and invoking the XML construction logic.
• CREATE_BC_TRANSACTION_REPORT — Produces a transaction-level BC report, focused on individual transactions and their associated funds check results.
• BUILD_REPORT_QUERY — Dynamically constructs the SQL query used to retrieve BC report data, allowing flexible filtering across ledgers, packets, and transaction attributes.
• GET_XML — Returns the generated XML report content, enabling callers to retrieve the report string directly.
• CONSTRUCT_BC_REPORT_OUTPUT — Assembles the report data into the final XML structure, applying formatting and hierarchical organization.
• SAVE_XML — Persists the generated XML report, typically writing to a file or staging area for external access.
• SAVE_XML_TO_DB — Stores the generated XML report into a database table or CLOB column for retrieval and archival.

Tables Accessed

The package reads from and writes to a broad set of financial and budgetary control tables via APPS synonyms. Budgetary control packet data is drawn from GL_BC_PACKETS and GL_BC_PACKETS_HISTS, which hold current and historical BC packet records. Ledger context is obtained from GL_LEDGERS and account hierarchy data from GL_ACCOUNT_HIERARCHIES. Payables transaction detail is sourced from AP_BATCHES, AP_INVOICES, AP_INVOICE_DISTRIBUTIONS, AP_INVOICE_LINES, and AP_PREPAY_APP_DISTS. Treasury/funds information is retrieved from FV_BE_TRX_HDRS, FV_BE_TRX_DTLS, FV_BE_RPR_TRANSACTIONS, FV_FUND_PARAMETERS, and FV_TREASURY_SYMBOLS. Segment definitions are read from FND_ID_FLEX_SEGMENTS. These tables supply the transaction, ledger, fund, and account context required to render comprehensive BC reports.

Usage Notes

PSA_BC_XML_REPORT_PUB is classified as a PUB (public) API, indicating it is intended for supported external invocation. It is referenced by other packages including GL_BC_PACKETS_PKG, XLA_JOURNAL_ENTRIES_PKG, LNS_DISTRIBUTIONS_PUB, and PO_DOCUMENT_FUNDS_PVT, indicating use across subledger accounting, loans, and procurement funds check flows. Typical invocations occur from concurrent programs generating BC reports, from forms performing on-demand BC reporting, and from custom integration code requiring XML BC output. Because it reads from many transactional tables, callers should ensure appropriate privileges and that the relevant BC packets have been created before invoking report generation. In EBS 12.1.1 and 12.2.2, the package resides in the APPS schema and should be called using the APPS database connection or through supported public API conventions.