R12: Positive Pay File with Additional Parameters Fails with ORA-06512 (Doc ID 824456.1)

Last updated on APRIL 25, 2014

Applies to:

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

Symptoms

After patching 8287114 & its prereqs, 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.

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