Search Results ja_cn_cfs_data_clt_pkg




Overview
Explore in AI Chat

Overview

JA_CN_CFS_DATA_CLT_PKG is an Oracle EBS PL/SQL package owned by the APPS schema that supports the China Cash Flow Statement (CFS) localization feature within the Oracle Financials for China (JA_CN) product family. Its principal business role is to collect, transform, and stage financial transaction data required to generate the statutory Cash Flow Statement mandated by Chinese accounting regulations. The package acts as a data collection and preprocessing layer, bridging subledger transaction data held in Oracle Payables, Oracle General Ledger, and related modules into a structure suitable for CFS reporting. Its status is recorded as VALID in the ETRM repository for both 12.1.1 and 12.2.2.

The object is classified as OTHER in the ETRM metadata, indicating it is not a formally published public API but an internal, package-body-driven utility invoked by concurrent processing logic. It depends only on SYS.STANDARD at the direct dependency level and is itself referenced by JA_CN_CFS_CONC_PROG and by eighteen other packages, confirming its position as a shared back-end utility within the CFS localization subsystem.

Key Procedures and Functions

Three documented program units are exposed by this package:

  • CFS_DATA_CLT — The primary data collection routine. It gathers and consolidates the source financial data needed for Cash Flow Statement generation, drawing from the subledger and general ledger tables listed below.
  • GET_BALANCING_SEGMENT — A helper that resolves the balancing segment value (typically the company or legal entity segment) used to identify and separate accounting data by reporting entity. This is essential where CFS output must be produced per balancing segment.
  • GET_PERIOD_NAME — A utility that determines the accounting period name associated with the data being processed, ensuring that CFS collection is scoped to the correct GL period.

Because the object is classified as OTHER and its source is not published, parameter lists are not documented here; consumers should treat these as internal entry points driven by the concurrent program layer.

Tables Accessed

The package references a broad set of APPS synonyms reflecting both setup metadata and transactional data:

Usage Notes

JA_CN_CFS_DATA_CLT_PKG is not intended for direct interactive invocation by end users. It is typically called as part of the China Cash Flow Statement concurrent program flow, most directly via JA_CN_CFS_CONC_PROG, and is shared by eighteen downstream packages. Customizations should avoid modifying the package directly; instead, extensions should be layered at the concurrent program or reporting level. Because the package handles localization-specific statutory reporting, changes carry compliance risk and should be validated against Oracle's localized patches for the installed EBS release.