R12: CLL F033, Format Payment Instructions Failing with "ORA-06503: PL/SQL: Function returned without value, ORA-06512" After Apply Note 428474.1 (Doc ID 1926385.1)

Last updated on AUGUST 02, 2017

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

R12 - CLL F033 - Format Payment Instruction Error after implementing required code from Note 428474.1.
When revert back changes of Note 428474.1, error does not occur However, the electronic payment file is not generated.

Payments created in IBY_PAYMENTS_ but not in AP_CHECKS_ALL

There are no invalid objects.

iby_transaction_errors has no rows for the PPR inn issue (Note 1399413.1 is verfied).


ERROR
-----------------------
java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380
ORA-06512: at line 1



Changes

Apply Note 428474.1 (Special Instructions for Brazilian Localization Installation in R12). Section of "Brazilian Payables Electronic File Transfer custom code changes"

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