Search Results concurrent




Overview
Explore in AI Chat

Overview

The concurrent program JGZZVSLD is owned by the JG – Regional Localizations product family within Oracle E-Business Suite. Its user-facing name and description are both recorded as Supplier Balances Detail Report. As its name implies, the program is designed to produce a detailed listing of supplier balances, allowing localization-specific reporting on amounts owed to or outstanding against suppliers within a given ledger context.

A defining characteristic of this object, as documented in the ETRM metadata for release 12.2.2, is that it is marked Enabled: No. This indicates the program is shipped in a disabled state and is not intended to be submitted in a standard configuration without deliberate enablement by an administrator. The JG product family covers regional localization requirements, and programs such as JGZZVSLD are typically provided to satisfy statutory or country-specific reporting obligations rather than general ledger-wide reporting needs.

Execution Details

The documented execution attributes for JGZZVSLD are as follows:

  • Execution Method: Oracle Reports
  • Argument Method: Standard
  • Executable: JGZZVSLD
  • Execution Filename: JGZZVSLD
  • User Name (Executable): JGZZVSLD

Because the execution method is Oracle Reports, the program is driven by an RDF report definition and is invoked through the Oracle Reports runtime rather than PL/SQL or a host script. The Standard argument method means the report accepts its parameters through the standard SRS parameter framework, with values supplied at submission time or derived from profile options and value sets.

How to Run

The program is submitted through the standard Submit Request (SRS) flow: navigate to the relevant responsibility, choose Run, select Supplier Balances Detail Report, and enter the required parameters. Before submission, note that the program must first be enabled, since the metadata records it as disabled.

The documented parameter metadata references several report arguments, including:

  • ATTRIBUTE18 – associated with the value sh_post_gl, displayable but not inserted or updated.
  • ATTRIBUTE4 – associated with sh_per_from, controlling the reporting period start.
  • ATTRIBUTE5 – associated with sh_per_to, controlling the reporting period end.
  • ATTRIBUTE1 – defaulted from a SQL query returning the ledger currency code from gl_sets_of_books for the current set of books profile, with a multi-currency reporting option check against gl_mc_reporting_options.

Each parameter carries a shared name (for example, sh_sob_cur, sh_post_gl, sh_per_from, sh_per_to), which links the SRS argument to the underlying report parameter. Users typically supply the period range and posting/GL options, while the ledger currency is derived automatically from the session profile.

Related Objects

The parameter SQL and shared names indicate dependencies on core General Ledger and multi-currency reporting objects, including:

The supplier balance data itself is drawn from the standard Oracle Payables supplier and invoice distributions schema. Because the program sits in the JG localization family, it is commonly associated with other JG regional reports that share the SRS value sets and currency handling logic.