R12: Suppliers Report (APXVDVSR): REP-0069, REP-57054 and REP-1401 Errors If Default Payment Method Is Longer Than 30 Characters (Doc ID 728671.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version: 12.0.1 to 12.0.6 - Release: 12.0 to 12.0
Information in this document applies to any platform.
Suppliers Report - APXVDVSR

Symptoms

When attempting to run the Suppliers Report (APXVDVSR) it finishes in error status with the following error message displayed in the log file:
    
     REP-0069: Internal error
     REP-57054: In-process job terminated:Terminated with error:
     REP-1401: MSG-00002: After Get_Company_Name
     MSG-00050: Value for nls_end_of_report :||:c_nls_end_of_report
     MSG-00003: After Get_NLS_Strings
     MSG-00004: After Get_Base_Curr_Data
     MSG-00004: After Giving messages
     MSG-00010: Getting supplier information, order by name...
     REP-1401: 'c_iby_infoformula': Fatal PL/SQL error occurred.
     ORA-06502: PL/SQL: numeric or value error: character string buffer too small
     ORA-06512: at "APPS.A

Report fails only for those Suppliers whose Default Payment Method size is longer than 30 characters

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