Format Payment Instruction Error ORA-01722 ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT"
(Doc ID 949875.1)
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!