Payables and Cash Management - EBS (MOSC)

MOSC Banner

Exception :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

edited Nov 25, 2015 12:58PM in Payables and Cash Management - EBS (MOSC) 2 commentsAnswered

when running the period close analyzer I got the following message for version 200.3

Exception :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

in side AP_ACCTG_DATA_FIX_PKG.Open_Log_Out_Files

Resolved it by opening the opening the description of BODY AP_Acctg_Data_Fix_PKG and changing as follow:

From:

  PROCEDURE Open_Log_Out_Files

       (P_Bug_Number         IN     varchar2,

    P_File_Location         OUT NOCOPY VARCHAR2) IS

    l_log_file           VARCHAR2(30);   ----- <<== original value

    l_out_file           VARCHAR2(30);  ----- <<== original value

    l_file_location    v$parameter.value%type;

    No_Utl_Dir           EXCEPTION;   

    l_date           VARCHAR2(30);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center