Search Results arcm_journal_load_xml

Overview

ARP_RECON_REP is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Receivables. It is the reporting and diagnostics engine behind the Receivables to General Ledger reconciliation functionality. Its purpose is to compare receivables subledger activity against the corresponding General Ledger balances and journal entries, identify discrepancies, and emit the results as XML output suitable for rendering as the AR/GL Reconciliation report.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the package owner. It is classified as an OTHER API rather than a supported public interface, so it is invoked by Oracle-delivered report components rather than by customer-facing integrations. Global state is held in a package-level record type (var_t), which captures the reporting level, reporting entity, set of books, chart of accounts, GL date range, period name, posting status, functional currency, out-of-balance flag, and maximum GL date for the current run.

Key Procedures and Functions

The package exposes twenty documented procedures and functions. The XML generation routines form the core of the reporting pipeline:

• ARUNAPP_JOURNAL_LOAD_XML — generates the XML payload covering unapplied and on-account receipt activity for the reconciliation report.
• ARAPP_JOURNAL_LOAD_XML — generates the XML payload for applied receipt activity.
• ARADJ_JOURNAL_LOAD_XML — generates the XML payload for adjustment activity.
• ARCM_JOURNAL_LOAD_XML — generates the XML payload for cash management–related journal activity.
• ARGLRECON_LOAD_XML — assembles the overall AR/GL reconciliation XML document from the individual journal loads.
• INIT — initializes the package globals (reporting level, entity, set of books, GL date range, period) before the report run.
• GET_REPORTING_LEVEL and GET_REPORTING_ENTITY_ID — accessor functions returning the current reporting level and entity identifier.
• GET_DETAIL_ACCOUNTS — flexfield-based routine that resolves the detail accounting flexfield values used for reconciliation comparison.
• GET_DESCRIPTION — retrieves descriptive text, typically for lookup or code meanings shown on the report.
• FORMAT_STRING and WHICH — utility routines supporting string formatting and conditional branching within the report logic.

Tables Accessed

Reconciliation requires reading both subledger and GL data. The package queries AR subledger tables through APPS synonyms, including AR_SYSTEM_PARAMETERS (functional currency and setup), AR_PAYMENT_SCHEDULES_ALL, AR_ADJUSTMENTS_ALL, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, AR_BATCHES_ALL, AR_DISTRIBUTIONS_ALL, AR_MISC_CASH_DISTS_ALL, AR_RATE_ADJUSTMENTS_ALL, AR_RECEIVABLE_APPOSITE_ALL, RA_CUSTOMER_TRX_ALL, RA_BATCHES_ALL, and RA_CUST_TRX_GL_DIST_ALL. On the GL side it reads GL_BALANCES, GL_JE_HEADERS, GL_JE_LINES, GL_JE_SOURCES, and GL_PERIODS.

Setup and flexfield structures are resolved via FND_FLEX_VALUES, FND_ID_FLEX_SEGMENTS, and FND_SEGMENT_ATTRIBUTE_VALUES. Intermediate reconciliation results are staged in AR_GL_RECON_GT, a global temporary table. The package also writes to GL_INTERFACE and uses DBMS_LOB, DBMS_SQL, DBMS_UTILITY, and DBMS_XMLGEN for dynamic SQL, XML generation, and large object handling.

Usage Notes

ARP_RECON_REP is normally invoked by the Oracle Receivables reconciliation concurrent programs and associated report definitions rather than being called directly by end users. The XML payloads produced by the journal load routines are consumed by the XML Publisher template that renders the AR/GL Reconciliation report. Because the package is AUTHID CURRENT_USER and depends on package globals initialized by INIT, custom code should call INIT before any journal load routine and should not assume a persistent session. No other documented packages reference it, so it is best treated as an internal support package; direct external invocation is unsupported and should be avoided in favor of the delivered concurrent programs.