Search Results gl_set_of_bks_id




Overview
Explore in AI Chat

Overview

JGZZCSLP is a concurrent program delivered within the JG – Regional Localizations product family of Oracle E-Business Suite. Its user-facing name is Customer Account Balance Maintenance, and the same label appears as the executable description, indicating that the program was designed to consolidate and maintain customer account balance information as part of a regional localization extension rather than a core financials flow.

Within the ETRM 12.2.2 metadata, the concurrent program is recorded with the status Enabled: No. This is a significant operational detail: although the program definition and its associated executable remain in the application dictionary, the program is not currently activated for submission. Administrators reviewing localization objects inherited from 12.1.1 to 12.2.2 should therefore verify whether JGZZCSLP has been superseded by another process or intentionally disabled following localization scope changes.

The program belongs to the broader JG localization layer, which historically supplied country-specific statutory, tax, and reporting utilities on top of standard Oracle Financials functionality.

Execution Details

The documented execution attributes for JGZZCSLP are as follows:

  • Product: JG – Regional Localizations
  • Execution Method: SQL*Plus
  • Argument Method: Standard
  • Executable: JGZZCSLP
  • Execution Filename: JGZZCSLP
  • User Name: Customer Account Balance Maintenance
  • Enabled: No

Because the execution method is SQL*Plus, the program invokes a SQL*Plus script from the application tier rather than an Oracle Forms-based or Java-based executable. This pattern is common among legacy localization utilities that perform set-based data manipulation through PL/SQL and SQL scripts. The Standard argument method confirms that parameters are passed positionally according to the concurrent program's registered argument sequence.

How to Run

Under normal circumstances, an SQL*Plus–based concurrent program is submitted through the Submit Requests (SRS) window or via the Concurrent Programs form in Oracle Applications Manager. The user selects the request name Customer Account Balance Maintenance, supplies the required parameters, and submits the request for processing by the concurrent manager.

The ETRM excerpt documents several parameters mapped to descriptive flexfield segments (ATTRIBUTE2 through ATTRIBUTE9). Notable examples include:

  • sh_per_from / sh_per_to (ATTRIBUTE2, ATTRIBUTE3): Period range values, displayed and updatable.
  • sh_post_gl (ATTRIBUTE5): A Y/N posting indicator whose default value is derived from the lookup type JGZZ_SRS_SLR_POST_STAT.
  • sh_sob_cur (ATTRIBUTE9): A currency value derived from gl_sets_of_books using $PROFILES$.gl_set_of_bks_id, with a check against gl_mc_reporting_options.

Since the user's search referenced gl_set_of_bks_id, it is worth noting that this profile option supplies the Set of Books context for the ATTRIBUTE9 default query. In multi-org and multiple reporting currency environments, that query explicitly excludes reporting sets of books where reporting options are enabled for application 222.

Related Objects

JGZZCSLP touches several standard and localization objects, including:

Because the program is disabled and its primary artifacts are a SQL*Plus script and descriptive flexfield arguments, its practical association is with the JG localization request group rather than with any public API. Administrators planning a 12.1.1 to 12.2.2 upgrade should confirm whether JGZZCSLP remains required before re-enabling it.