Format Payment Instruction Error ORA-01722 ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT"
Last updated on MARCH 26, 2018
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
Format payment instruction is erroring out with No extract has been previously created. Create extract.
java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 272
ORA-06512: at line 1
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
6. Payment format error in the log
Unable to make payments.
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