Search Results item_mapping_analysis_report

Overview

JA_CN_CFS_IMA_PKG is a China-localized Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its name derives from its functional domain: the Chinese Cash Flow Statement (CFS) feature combined with Item Mapping Analysis (IMA). The package is declared AUTHID CURRENT_USER, meaning its unqualified database object references resolve against the privileges of the invoking schema rather than the package owner.

The header comments describe the package as providing shared procedures for CNAO (China National Accounting Operations) programs. Its documented purpose is to export records saved through the Item Mapping form, allowing users to understand the cash flow of the company and to perform cash forecasting on the basis of that data. In practical terms, the package bridges the Cash Flow Statement Item Mapping setup — where general ledger lines and event types are mapped to cash flow statement line items — and the reporting layer that produces the analysis output.

Key Procedures and Functions

The package exposes a single documented procedure:

• ITEM_MAPPING_ANALYSIS_REPORT — the sole entry point of the package and the object surfaced when users search for "item_mapping_analysis_report". It is designed as a PL/SQL concurrent program entry point and therefore follows the standard concurrent program calling convention, returning errbuf and retcode as mandatory output parameters. Its input parameters identify the scope of the analysis: an application identifier, an event class code, a supporting reference code, and a chart of accounts identifier. These parameters allow the report to be constrained to a specific subledger application (typically Payables, Receivables, or similar), to particular event classes and supporting references defined in the Subledger Accounting model, and to a single chart of accounts. The procedure exports the item mapping records previously saved through the Item Mapping form so that the audience can review cash flows and build cash forecasts from them. No further procedures or functions are documented for this package.

Tables Accessed

The package reads and writes a defined set of tables, all referenced through APPS synonyms:

• JA_CN_CFS_ITEM_MAPPING_HDRS and JA_CN_CFS_ITEM_MAPPING_LINES — the core China cash flow statement item mapping header and line tables, holding the mapping setup that the report exports.
• JA_CN_CASH_VALUESETS_ALL — the China cash valueset definition table, supporting the value sets used in the mapping setup.
• XLA_ANALYTICAL_HDRS_TL, XLA_ANALYTICAL_DTLS_B, XLA_ANALYTICAL_DTLS_TL, XLA_ANALYTICAL_SOURCES, XLA_EVENT_CLASSES_TL, and XLA_SOURCES_TL — Subledger Accounting analytical criteria, sources, and event class definitions. These supply the accounting event and source context that the item mapping relates to cash flow statement lines.
• FND_APPLICATION_TL, FND_FLEX_VALUES, FND_FLEX_VALUES_TL, and FND_FLEX_VALUE_SETS — application names and key flexfield value sets and values used to resolve and display application, segment, and value descriptions.
• HR_ALL_ORGANIZATION_UNITS_TL — organization name translations, likely used to present the organization associated with the mapping or accounting data.
• DUAL — used for single-row PL/SQL and SQL evaluations.

Usage Notes

JA_CN_CFS_IMA_PKG is invoked primarily as an Oracle EBS concurrent program, which is consistent with the errbuf/retcode signature of ITEM_MAPPING_ANALYSIS_REPORT. Users run the Item Mapping Analysis Report from the Submit Requests window or through a form-based request submission, entering the application, event class, supporting reference, and chart of accounts parameters to scope the output. The package is also referenced by one other package, indicating it participates in a wider CNAO module dependency chain rather than standing alone. Because the package is AUTHID CURRENT_USER, any custom integration must grant the invoking schema appropriate privileges on the underlying XLA, JA_CN_CFS, and FND tables. The "item_mapping_analysis_report" search term corresponds directly to the single public procedure, so administrators tracing that name in the concurrent program definition will find JA_CN_CFS_IMA_PKG.ITEM_MAPPING_ANALYSIS_REPORT as the executable. The package was created in April 2007 and carries no later documented change history, and it remains available in both EBS 12.1.1 and 12.2.2.