Unable To Print Invoices - SQL Error
(Doc ID 2284606.1)
Last updated on AUGUST 26, 2023
Applies to:
Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to Print Transactions,
the following error occurs.
ERROR
-----------------------
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
AR_ESS_PLSQL_WRAPPER_PKG.PRINT_INVOICES(-)
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@
RequestId:142097
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. ============
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot print transactions.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |