My Oracle Support Banner

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
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

To view full details, 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 a vibrant support community of peers and Oracle experts.