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 MARCH 14, 2022

Applies to:

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


 Autoinvoice process is ending in error. ravpm.lpc

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

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


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

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