View Image No Longer Works After Upgrade and Print Receivables Transactions Errors With 'P_REQUEST_ID'

(Doc ID 2327871.1)

Last updated on NOVEMBER 13, 2017

Applies to:

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

Goal

Problem 1:

View image does not return invoice

Navigation: Home > Receivables > Billing > Tasks > query invoice > view image

It returns a tiny white box in the center of the screen. The word 'view image' and 'ok' are inside of it.

It should return a large box titled with 'view image' and the entire invoice should be returned

This issue only occurs after upgrading to R12 from release 11.

You are using custom template and data model created from release 11.

Problem 2:

Run ESS process: Print Receivables Transactions and it errors. The spawned InvoicePrintReport logfile shows this :

dummy file is deleted
================ BIPJobExecutable Execution Started ============
OutputFile : /u01/APPLTOP/instance/ess/rfd/242619/out/242619.xml
Request ID: 242619 ClassLoader is weblogic.utils.classloaders.GenericClassLoader@1e63d4a7 finder: weblogic.utils.classloaders.CodeGenClassFinder@77932580 annotation: FinancialsEssApp#V2.0@
RequestId:242619
ReportID : /Financials/Receivables/Bill Presentment/DefaultInvoice.xdo
Process : BIPDocGen
The bipJobID : 11579
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. ============

Review error message for InvoicePrintReport RequestId:242619

a. Go to Navigator >> Report and Analytics
b. Go to Browser Catalog
c. Click Home
d. Go to Report Job History
e. Search for your request
f. Click on failed icon
g. Provide the error message.

[INSTANCE_ID=cffar12090s04.usdc2.oraclecloud.com.1501924542838] [INSTANCE_JOB_ID=11579]::oracle.xdo.servlet.scheduler.ProcessingException: ::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=cffar12090s04.usdc2.oraclecloud.com.1501924542838] DataException:[INSTANCE_JOB_ID=11579] oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException: oracle.xdo.XDOException: java.sql.SQLException: ORA-06550: line 19, column 22:

PLS-00302: component 'P_REQUEST_ID' must be declared
ORA-06

 Or review bi logfile which shows this error:

 

java.sql.SQLException: ORA-06550: line 19, column 22:
PLS-00302: component 'P_REQUEST_ID' must be declared
ORA-06550: line 19, column 1:
PL/SQL: Statement ignored

 

Solution

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