Format Payment Instruction Error ORA-01722 ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT"

(Doc ID 949875.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

Oracle Payments - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.
Oracle iPayment - Version: 12.0.1 to 12.0.6
ORA-01722
ORA-06512
IBY_EXTRACTGEN_PVT


Symptoms

Format payment instruction is erroring out with No extract has been previously created. Create extract.

Error Message:
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 272
ORA-06512: at line 1


EXPECTED BEHAVIOR
No error message should be displayed and Extract should be generated.

STEPS TO REPRODUCE
1. Payment navigation
2. Payment header input(Payment method, payment process file)
3. Enter/Adjust invoices button Click
4. select Invoice
5. save
6. Payment format error in the log

BUSINESS IMPACT
Unable to make payments.

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