Search Results submit_fsg_report

Overview

JA_CN_PS_FSG_XML_SUBMIT_PROG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports Chinese localizations for Financial Statement Generator (FSG) reporting. The package header defines it with AUTHID CURRENT_USER, meaning execution privileges are evaluated against the calling user rather than the package owner. Its stated purpose is to submit an FSG report and, upon submission, invoke the XML Report Publisher or the equivalent conversion routine that transforms FSG output into a structured format suitable for statutory financial statement delivery.

The source header (JACNPFXS.pls, version 120.0, dated 2010) records the original creation by Chaoqun Wu on 6 August 2010. The naming convention reflects its role in the JA (Asia/China) product family and the CN (China) localization, targeted at the cash flow statement, balance sheet, and profit statement reports required by PRC accounting regulations.

Key Procedures and Functions

ETRM documents a single public procedure within this package:

• Submit_FSG_Report — The procedural entry point used to submit an FSG report and then trigger the Report Item Data Convert program that converts the FSG output. Its signature accepts, among other inputs, a data access set identifier and chart of accounts identifier; an ad hoc prefix, industry, and flex code; the default ledger short name, period name, output option, exception flag, and accounting date; a page length and subrequest identifier; an application default name; and report identifiers and numbers for the cash flow statement, balance sheet, and profit statement. The procedure reconciles these parameters against the FSG report definitions and dispatches the report and its downstream conversion as concurrent requests.

Tables Accessed

ETRM records nine base tables accessed through APPS synonyms. They fall into three functional groups:

• FSG definition tables — RG_REPORTS, RG_REPORT_AXIS_SETS, RG_REPORT_CONTENT_SETS, RG_REPORT_DISPLAY_SETS, and RG_ROW_ORDERS provide the report definition, axis, content set, display set, and row ordering metadata required to construct and submit the FSG request.
• Ledger and security tables — GL_LEDGERS and GL_ACCESS_SETS resolve the ledger associated with the request and validate that the submitting user has data access to the specified access set.
• Localization control tables — JA_CN_SYSTEM_PARAMETERS_ALL supplies China-specific system parameters, while FND_LOOKUP_VALUES supplies lookup codes used for validation and decoding of report options and flags.

Usage Notes

The package is typically invoked from the Chinese localization FSG report submission flow, either through the associated Oracle Forms interface or by a concurrent program that calls Submit_FSG_Report with the report and ledger context. It is not intended for direct ad hoc invocation by end users; the parameter set is populated programmatically from the current form or request context. Because the package uses AUTHID CURRENT_USER, callers must hold privileges on the underlying RG_*, GL_*, FND_LOOKUP_VALUES, and JA_CN_SYSTEM_PARAMETERS_ALL objects. ETRM also records that one other package references this package, indicating it participates as a component in a larger localization submission chain rather than as a standalone utility. When diagnosing missing FSG output or failed XML conversion, the subrequest identifier and report number parameters passed to Submit_FSG_Report are the primary values to trace in the concurrent request log.