My Oracle Support Banner

Import AutoInvoice Error The process has encountered a SQL error. (ERRNO=20301) (ROUTINE=fdpgrs) (REASON=ORA-20301) (Doc ID 2835184.1)

Last updated on SEPTEMBER 06, 2023

Applies to:

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

Symptoms



 Autoinvoice process is ending in error. ravpm.lpc



ERROR
-----------------------
raauir()- UTIL-CURRENT TIME (DATE=06-JAN-2022) (TIME=13:24:42)
Entering raapem+()
The process has encountered a SQL error. (ERRNO=20301) (ROUTINE=fdpgrs) (REASON=ORA-20301: ESS request id 146449 not found
ORA-06512: at "FUSION_ORA_ESS.ESS_MESG", line 83
ORA-06512: at "FUSION_ORA_ESS.ESSUTIL", line 384
ORA-06512: at "FUSION_ORA_ESS.ESS_RUNTIME", line 4152
ORA-06512: at "FUSION_ORA_ESS.ESS_RUNTIME", line 1637) (SQLSTMT=) (VAR_NAME= return true)
raapem: no errors recorded



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load Data into Interface
2. Run Import AutoInvoice
3. Process run Successful however the data it is still in interface



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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.