Search Results psa_bc_xml_report_s

Overview

APPS.GL_BC_PACKETS_PKG is the core PL/SQL package body that implements Balance Control packet processing in the Oracle E-Business Suite General Ledger. Balance Control is the mechanism that captures and reconciles the balance of a ledger, journal source, or category at the close of an accounting period, producing a controlled snapshot that downstream processes and reporting engines—particularly the Public Sector (PSA) Balance Control reporting components—consume. The package maintains the packet header and line records that represent these snapshots, resolving journal activity for the relevant period and staging the results for XML-based reporting.

The package is owned by APPS and carries a VALID status in the ETRM repository. It is classified as OTHER rather than a public open-interface API, which reflects its role as an internal engine driven principally by the Balance Control user interface rather than a supported integration point. It is not referenced by any other database object, though it references one other package, APPS.GL_BC_PACKETS_PKG being the body of the specification in the same schema.

Key Procedures and Functions

• GET_UNIQUE_ID — Returns a unique identifier used when constructing new packet records, ensuring primary key uniqueness without a sequence dependency.
• INSERT_JE_PACKET — Creates the principal packet record that represents a Balance Control snapshot for a given ledger and period.
• EXISTS_PACKET — Determines whether a packet already exists for the supplied criteria, preventing duplicate snapshots.
• GET_LEDGER_ID — Resolves the ledger identifier associated with the packet or the current context.
• INSERT_BUDGET_TRANSFER_ROW — Adds a budget transfer line to the packet, supporting the transfer of budgetary balances between accounts.
• UPDATE_BUDGET_TRANSFER_ROW — Modifies an existing budget transfer row within the packet.
• LOCK_BUDGET_TRANSFER_ROW — Acquires a row-level lock on a budget transfer line to serialize concurrent edits.
• DELETE_BUDGET_TRANSFER_ROW — Removes a budget transfer line from the packet.
• DELETE_PACKET — Deletes an entire packet and its associated rows.
• COPY_PACKET — Duplicates an existing packet, enabling reuse of a prior Balance Control setup.
• VIEW_BC_RESULTS_SETUP — Returns the configuration and setup information required by the Balance Control results view.

Tables Accessed

• GL_BC_PACKETS / GL_BC_PACKETS_S — The base table and its APPS synonym for packet header records; read and written by the insert, delete, copy, and existence-check routines.
• GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES — Journal batch, header, and line tables read to resolve the journal activity summarized in each packet.
• GL_PERIOD_STATUSES — Confirms period open/closed status, which governs whether a packet may be generated or modified.
• PSA_BC_REPORT_EVENTS_GT, PSA_BC_XML_REPORT_S — Public Sector Balance Control reporting structures that stage and store the generated report output.
• DUAL — Used for single-row processing and value derivation.

Usage Notes

GL_BC_PACKETS_PKG is invoked from the Balance Control forms and supporting concurrent programs rather than called directly by external code. Because it is classified as OTHER and is not referenced by any other database object, it should be treated as an internal implementation package; customizations or integrations should avoid direct dependency on its routines. Its external interfaces are mediated through PSA_BC_XML_REPORT_PUB and PSA_BC_XML_REPORT_S, which consume the staged packet data to produce the Balance Control report output. Error handling is routed through FND_MESSAGE, APP_EXCEPTION, and APP_EXCEPTIONS, so failures surface as standard EBS application messages. The same package body is delivered in both 12.1.1 and 12.2.2, with the online patching architecture of 12.2.2 affecting only deployment, not the package's runtime behavior.