Search Results get_coa

Overview

JA_CN_UTILITY is a shared PL/SQL utility package in the Oracle E-Business Suite APPS schema that provides common procedures and functions for the CNAO (China National Accounting Office) family of programs. It belongs to the Oracle Financials for China localization product and is declared with AUTHID CURRENT_USER, meaning its unqualified database references resolve according to the privileges of the calling session rather than those of the APPS owner. The source header (JACNCUYS.pls, version 120.5.12020000.4, last updated December 2012) describes the package as providing "share procedures for CNAO programs." Its primary business purpose is to support the China Accounting Software Data Interface Standard, particularly Version 2, which governs standardized financial data exchange between Oracle EBS and Chinese statutory accounting and tax reporting systems. The package encapsulates reusable logic for profile option checks, chart of accounts and set of books resolution, lookup value translation, natural account validation, accounting period range checking, concurrent program output file naming, and character set conversion. It also provides XML generation helpers such as Add_Sub_Root_Node, Add_Child_Node, Add_Fixed_Child_Node, Get_XML_Tag, Get_XML_Encoding, and Submit_XML_Charset_Conversion, which are used to build the structured XML output required by the Chinese data interface standard. In Oracle EBS 12.1.1 and 12.2.2, this package remains part of the China localization layer and is referenced by 83 other packages, making it a foundational dependency for Chinese financial reporting and interface programs.

Key Procedures and Functions

The package exposes 36 documented procedures and functions. The principal ones include:

• CHECK_PROFILE — verifies the value of a profile option, typically used to confirm that the Chinese localization or a specific CNAO feature is enabled before further processing.
• GET_SOB_AND_COA, GET_SOB, GET_COA — return the Set of Books (in 12.1.1) or ledger equivalent and the Chart of Accounts identifier for the current context.
• GET_LOOKUP_MEANING, GET_LOOKUP_CODE — translate lookup codes to their meanings and vice versa, supporting consistent descriptive output.
• CHECK_NAT_NUMBER, CHECK_ACCOUNT_LEVEL, CHECK_CASH_RELATED_ACCOUNT — validate natural account numbers, account hierarchy levels, and cash-related account designations.
• OUTPUT_CONC, CHANGE_OUTPUT_FILENAME — control concurrent program output, including renaming the output file to meet Chinese interface naming conventions.
• SUBMIT_CHARSET_CONVERSION, SUBMIT_XML_CHARSET_CONVERSION — invoke character set conversion utilities, required for GB2312/GBK or UTF-8 compliant output.
• CHECK_ACCOUNTING_PERIOD_RANGE — validates that a specified accounting period range is valid and open.
• FETCH_ACCOUNT_STRUCTURE, POPULATE_LEDGER_LE_BSV_GT, GET_BALANCING_SEGMENT_VALUE — retrieve accounting structure metadata and balancing segment values for ledger and legal entity processing.
• GET_XML_ENCODING, GET_XML_TAG — return the XML encoding declaration and tag strings used when constructing interface XML documents.
• ADD_SUB_ROOT_NODE, ADD_CHILD_NODE, ADD_FIXED_CHILD_NODE — build and append nodes to the XML document tree used for the China Accounting Software Data Interface Standard V2.

Tables Accessed

The package reads and writes several EBS foundation and financial tables through APPS synonyms. FND_FLEX_VALUES, FND_FLEX_VALUES_TL, FND_FLEX_VALUE_SETS, FND_FLEX_VALIDATION_TABLES, FND_ID_FLEX_SEGMENTS, and FND_ID_FLEX_STRUCTURES are queried for key flexfield validation, segment, and structure metadata. FND_LOOKUP_VALUES supplies lookup code and meaning translations. FND_SEGMENT_ATTRIBUTE_VALUES provides segment attribute flags, including balancing segment designation. GL_CODE_COMBINATIONS, GL_LEDGERS, GL_LEDGER_NORM_SEG_VALS, GL_LEDGER_RELATIONSHIPS, GL_PERIOD_STATUSES, and GL_ACCESS_SETS supply ledger, accounting combination, period status, and access set information. JA_CN_DFF_ASSIGNMENTS stores China-specific descriptive flexfield assignment data used by the localization. These tables are accessed to resolve reporting context, validate account and period data, and produce standardized XML payloads.

Usage Notes

JA_CN_UTILITY is not intended for direct end-user invocation. It is called internally by CNAO concurrent programs, China localization reports, and other packages in the same product family, consistent with its 83 documented referrers. Its XML node and encoding helpers are invoked during generation of data-interface output files that conform to the China Accounting Software Data Interface Standard. Because the package is declared AUTHID CURRENT_USER, callers must possess the necessary privileges on the underlying FND and GL objects through their own schema grants. Implementers customizing Chinese localization reports typically call the shared validation and lookup functions rather than re-implementing that logic. The 12.2.2 metadata documents the same package as 12.1.1, though ledger-related functions align with the Multi-Org Access Control and ledger architecture introduced in Release 12.