My Oracle Support Banner

R12: AP: The Positive Pay File Errors with No extract has been previously created. ORA-06510: PL/SQL: unhandled user-defined (Doc ID 824456.1)

Last updated on FEBRUARY 18, 2019

Applies to:

Oracle Payables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

After applying 8287114, the Positive Pay File with Additional Parameters report fails with:

No extract has been previously created. Create extract.
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined
exception
ORA-06512: at "APPS.IBY_FD_EXTRACT_GEN_PVT", line 1342
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 362
ORA-06512: at line 1


The report still fails with the same error even after manually recompiling the packages IBY_FD_EXTRACT_GEN_PVT & IBY_EXTRACTGEN_PVT.

Changes

 

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
Changes
Cause
Solution
 
 Standard Patching Process
 Patch Wizard
 Have more questions?
References

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