e-commerce gateway seeded format "Oracle e-commerce gateway" validation error's with "Manual Setting
Upgrade from 11.5.10 to R12.2.6 > recreated in R12 the EDI 820 payment process profile leveraging the seeded "oracle e-commerce gateway" payment format. The PPP was set to payment completion point of When payment is formatted. But this setting generates the following error:
oracle.apps.iby.exception.DatabaseException: SQLException occurred: ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380 ORA-06512: at line 1
I found that in a previous instance (DEV) that if I changed the completion point to "Manual Setting Only", that the "Format Payment Instructions with Text Output" concurrent program stops at "Created" and does not attempt to format. But when I moved this solution to the next instance, I find that the "Format Payment Instructions with Text Output" is again attempting to format and is generating the same error as documented above.