My Oracle Support Banner

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 DECEMBER 04, 2019

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.