Unable To Print Invoices - SQL Error

(Doc ID 2284606.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version and later
Information in this document applies to any platform.


When attempting to Print Transactions,
the following error occurs.

From Request ID: 142096

Following child requests were not successful:
Request Id State Process
------------------- ------------ --------------------
142097 Error InvoicePrintReport
l_retcode: 1
Any Email Record : N
o_retcode: 0

From Request ID: 142097

dummy file is deleted
================ BIPJobExecutable Execution Started ============
OutputFile : /u01/APPLTOP/instance/ess/rfd/142097/out/142097.xml
Request ID: 142097 ClassLoader is weblogic.utils.classloaders.GenericClassLoader@2c5a18f1 finder: weblogic.utils.classloaders.CodeGenClassFinder@5bf3319b annotation: FinancialsEssApp#V2.0@
ReportID : /Financials/Receivables/Bill Presentment/DefaultInvoice.xdo
Process : BIPDocGen
The bipJobID : 6819
bipJobID is updated to ESSRuntimeService
BIP_STATUS_URL is added to ESSRuntimeService
================ BIPJobExecutable is running in async mode. ============
================ Please check the ess status for more detail info. ============

The issue has the following business impact:
Due to this issue, users cannot print transactions.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms