Search Results cm_number




Overview
Explore in AI Chat

Overview

ARP_RECON_REP is the report engine body for the Oracle Receivables Receivables-to-General Ledger reconciliation report (the ARGLRECB program, per the package header revision line). It assembles the data set used to reconcile Receivables subledger activity against General Ledger balances for a given set of books, accounting period, and reporting entity, and it emits that data set in XML form for template-based rendering. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is classified as an OTHER API rather than a public application programming interface, meaning it is intended for internal report execution rather than for direct customer extension.

The package also acts as the runtime query surface for the reporting parameters that drive that reconciliation. A family of accessor functions exposes package globals — reporting level, reporting entity, set of books, and chart of accounts — so that other report components can read the context selected at submission time without re-deriving it.

Key Procedures and Functions

The documented entry points fall into three groups.

  • Context and setup: INIT establishes the reporting context and initializes global state for the run. GET_REPORTING_LEVEL, GET_REPORTING_ENTITY_ID, GET_SET_OF_BOOKS_ID, and GET_CHART_OF_ACCOUNTS_ID are accessors returning the corresponding globals held in the VAR_TNAME record structure (documented in the source as ARP_RECON_REP.VAR_TNAME). WHICH is the standard generic dispatcher used to branch execution by requested action or report variant.
  • Data selection: GET_DETAIL_ACCOUNTS resolves the account ranges and natural-account detail that qualify for reconciliation output. GET_DESCRIPTION resolves descriptive text used for code combinations and report labeling.
  • XML generation: ARADJ_JOURNAL_LOAD_XML, ARUNAPP_JOURNAL_LOAD_XML, ARAPP_JOURNAL_LOAD_XML, ARCM_JOURNAL_LOAD_XML, and ARGLRECON_LOAD_XML each build an XML document for a distinct reconciliation component — adjustments, unapplied receipts, applied receipts, credit memos, and the GL reconciliation summary respectively. FORMAT_STRING provides the string normalization used when composing these documents. These procedures are why the search term "cm_number" is relevant: the credit memo component (ARCM_JOURNAL_LOAD_XML) carries the credit memo number into the XML payload, and cm_number is the column/tag by which that document is identified in the reconciliation output.

Tables Accessed

The package reads Receivables and General Ledger data through APPS synonyms. GL_BALANCES supplies the GL-side balances compared against subledger activity. GL_JE_HEADERS, GL_JE_LINES, and GL_JE_SOURCES provide journal detail and source classification for those balances; GL_PERIODS and GL_INTERFACE support period resolution and interface-level comparison; AR_GL_RECON_GT is the global temporary table holding the intermediate reconciliation result set. AR_SYSTEM_PARAMETERS supplies Receivables system options that govern reconciliation behavior. FND_ID_FLEX_SEGMENTS, FND_SEGMENT_ATTRIBUTE_VALUES, and FND_FLEX_VALUES resolve the accounting flexfield structure, segment attributes, and value descriptions used to label accounts. DBMS_LOB, DBMS_SQL, DBMS_UTILITY, and DBMS_XMLGEN are used programmatically for dynamic SQL, utility operations, LOB handling, and XML document construction.

Usage Notes

ARP_RECON_REP is invoked by the Receivables to General Ledger Reconciliation concurrent program and is not referenced by any other package (referenced by 0 other packages in the ETRM record). Because the XML load procedures are tightly coupled to the report's XML template and to the global context established by INIT, direct calls from custom code are not recommended; the supported integration path is to submit the concurrent program with the desired reporting level, reporting entity, set of books, and period, and to consume the resulting output file. Debugging output is available through the FND_PROFILE options AFLOG_ENABLED and AFLOG_LEVEL, which gate the internal LOG procedure; setting AFLOG_ENABLED to 'Y' with AFLOG_LEVEL of '1' writes diagnostic messages to the concurrent request log.