Search Results concurrent




Overview
Explore in AI Chat

Overview

Concurrent Program JACNNAGN belongs to the JA – Asia/Pacific Localizations product family within Oracle E-Business Suite and is delivered under the user-facing name Chart of Accounts Generation I – Natural Account. Its documented purpose is to generate the Chart of Accounts — specifically the natural account segment — into a predefined flat file format. This output is intended for downstream consumption by external systems, localization reporting, or statutory interfaces that require chart of accounts data in a fixed, delimited layout rather than as an online query result.

The program is enabled in the documented ETRM 12.2.2 metadata and is also available in the 12.1.1 and 12.2.2 release lines where the JA localizations are installed. It forms part of the China localization toolset that supports extraction of accounting flexfield structures for regulatory and integration purposes.

Execution Details

The documented execution attributes for JACNNAGN are as follows:

  • Execution Method: PL/SQL Stored Procedure
  • Argument Method: Standard
  • Executable: JACNCOAG
  • Execution Filename: JA_CN_ETC_CONC_PROG.Export_Coa
  • Subroutine Name: (not populated)
  • Enabled: Yes

The executable JACNCOAG is also presented with the user-facing description “Chart of Accounts Generation into format predefined flat file,” confirming that the stored procedure encapsulates the extraction and formatting logic. Because the argument method is Standard, the program exposes its parameters through the standard Oracle Applications concurrent request submission interface rather than through a custom parameter widget.

How to Run

Users submit JACNNAGN through the standard Submit Requests (SRS) window, typically reached via Requests → Run in the Oracle EBS navigation. The request can be submitted once, scheduled to recur, or added to a request set, subject to the standard concurrent manager availability for the JA localization manager queue or the default manager assigned to the program’s request group.

Because the documented argument method is Standard, the parameter list is defined on the concurrent program definition itself. Administrators should review the “Parameters” window of the program definition to confirm which values must be supplied at runtime — commonly a chart of accounts identifier, a ledger or set of books, effective date ranges, and an output file specification. Users should verify the flat file target directory is accessible to the database tier, since the PL/SQL procedure writes the predefined format to a server-side location. Request output and log files should be reviewed after each run to confirm the natural account segment rows were generated without error.

Related Objects

JACNNAGN is one component of a small family of JA localization extraction programs. The related concurrent program JACNNAGN is paired with other generation programs in the same executable package, JA_CN_ETC_CONC_PROG, which also hosts the Export_Coa routine referenced in the execution filename. Related object types typically encountered alongside this program include:

  • The GL accounting flexfield and its natural account segment values, which supply the source data.
  • Interface and staging tables used by the JA localization extract routines to hold formatted rows before write-out.
  • The concurrent program and executable definitions JACNCOAG and JACNNAGN themselves, maintained in the Concurrent Programs and Executables windows.
  • Request sets and request groups defined for JA localizations that bundle this program with companion chart of accounts generators.

Because the provided metadata does not enumerate specific interface table names, implementers should query the concurrent program definition and the JA_CN_ETC_CONC_PROG package specification in their instance to identify the exact staging objects and parameters in use.