Search Results sql_trace

Overview

JG_RX_C_FAREG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified within ETRM as an "OTHER" API. Its name and structure identify it as the core report engine behind the Fixed Assets Register — a statutory and management report that lists asset cost, additions, adjustments, retirements, transfers, and depreciation by book, period range, and asset category. The "$Header" comment retained in the source (jgrxcfrb.pls, version 115.7, dated 2003/12/30) confirms the module's lineage in the Oracle Assets (FA) family of report packages. In EBS 12.1.1 and 12.2.2, the package operates as the programmatic layer behind a concurrent program, accepting a long, positional parameter list that mirrors the report's submission arguments and returning the standard concurrent manager status pair (errbuf, retcode) to the caller.

Key Procedures and Functions

ETRM documents a single entry point:

• GET_ASSET_RTRMNT_DETAILS — The report driver for asset retirement and register detail. It is declared with the standard concurrent program signature: errbuf and retcode as OUT NOCOPY VARCHAR2, followed by a fixed sequence of IN VARCHAR2 arguments. The documented argument comments map the leading parameters to Book Type, From Period, To Period, a dummy placeholder, Major Category, Minor Category, and Report Type. Argument 8 is the debug_flag and argument 9 is sql_trace, the parameter directly associated with the user's search term. The remaining arguments (10 through 60) are reserved, positional placeholders required by the concurrent program's parameter registration; only the first nine carry documented meaning. The procedure's purpose is to resolve the requested book, accounting period range, and category filters, then produce the retirement/register detail output rows for the report.

Tables Accessed

The ETRM metadata for this package does not enumerate referenced tables or APPS synonyms. By module convention, a Fixed Assets Register report of this type reads the Oracle Assets base and summary tables — asset definitions, book assignments, category structures, transaction history, and period-end depreciation balances — joined to value sets and lookup tables used to translate the book, period, and category arguments. Because no table list is documented here, the definitive set of objects should be confirmed by querying ALL_DEPENDENCIES for this package body in the target instance rather than assumed from a generic inventory.

Usage Notes

GET_ASSET_RTRMNT_DETAILS is intended to be invoked as a concurrent program, most commonly through the standard report submission form or the Concurrent Programs interface, where the positional arguments are supplied in the order declared. It is not a documented public API for direct application calls; custom code that wishes to reuse it must replicate the thirty-plus positional signature and supply the errbuf/retcode pair.

The sql_trace argument is diagnostic, not functional: setting it enables SQL tracing for the report session, which is the usual route when the user's search for "sql_trace" leads to this package. It should be enabled only for troubleshooting on a controlled instance, since tracing a register run across a full book and period range can generate substantial trace files. The debug_flag argument similarly activates verbose logging and is disabled in normal production runs. Given the package's "OTHER" API classification, any modification or direct invocation should be treated as a customization and managed accordingly.