Search Results print_report

Overview

CE_BANK_STMT_SQL_LDR is an Oracle Cash Management (CE) package body in the APPS schema that supports the import of bank statement data into Oracle E-Business Suite. Its principal role is to load flat files produced by external banking sources into the CE_BANK_STMT_INT_MAP interface staging table using Oracle SQL*Loader, and to drive the associated concurrent request output handling. The package body is registered in ETRM with an API classification of OTHER, indicating that it is an internal utility rather than a formally published public API. The header revision (120.7) dates from 2006, and the object remains part of the shipped Cash Management code base in both 12.1.1 and 12.2.2.

Key Procedures and Functions

• PRINT_REPORT — Submits a concurrent request that prints the Cash SQLLDR Report. The procedure reads the current concurrent request ID via the CONC_REQUEST_ID profile option and retrieves the print options (number of copies, print style, printer, and save-output flag) through FND_CONCURRENT.GET_REQUEST_PRINT_OPTIONS. Its stated documentation purpose is to print out the errors encountered during a SQL*Loader run. This is the object the user searched for under "print_report".
• CALL_SQL_LOADER — Invokes the SQL*Loader utility to load bank statement data into the interface table. It is the companion routine to PRINT_REPORT, executing the load and providing the diagnostics that are later printed.
• SPEC_REVISION — Returns the package specification revision string by referencing the global G_spec_revision, allowing support and diagnostics to confirm the code level in use.
• BODY_REVISION — Returns the package body revision string ('$Revision: 120.7 $'), used for the same version-verification purpose.

A private package variable, l_DEBUG, is initialised from the CE_DEBUG profile option and gates debug output routed through CEP_STANDARD.DEBUG. It supports values 'Y' and 'C', with ordinary runs defaulting to 'N'.

Tables Accessed

Two primary objects are documented as referenced through APPS synonyms:

• CE_BANK_STMT_INT_MAP — the bank statement interface mapping table. The SQL*Loader run populates this staging area with parsed statement records prior to validation and transfer into the live Cash Management statement tables.
• FND_CONCURRENT_PROGRAMS — the concurrent program definition table, consulted to resolve the report and loader program definitions associated with the print and load requests.

Usage Notes

The package is invoked in the context of the Bank Statement Import process. A user typically runs the SQL*Loader-based import concurrent program, which calls CALL_SQL_LOADER to load the data file, and PRINT_REPORT to submit a print request for the loader error output when diagnostics are needed. The print routine depends on the invoking request having a valid CONC_REQUEST_ID profile value, so it must be called from within a concurrent request context rather than from interactive SQL. One other EBS package references this body, confirming it is a supporting utility within the Cash Management import flow.