Unable To Print Invoices - SQL Error

(Doc ID 2284606.1)

Last updated on SEPTEMBER 08, 2017

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.12.1.0.0 and later
Information 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

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