Receivables - EBS (MOSC)

MOSC Banner

error in hz_location_v2pub.create_location while creating locaton

edited May 15, 2017 7:48AM in Receivables - EBS (MOSC) 3 commentsAnswered
Hi,

I am getting the followin\g error while creating the loation.

return status = U

msg_count = 1

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

any help in regards

code i am using to create loacation.

DECLARE
  loc_rec       hz_location_v2pub.location_rec_type;
  x_return_status        VARCHAR2(32767);
  x_msg_count            NUMBER;
  x_msg_data             VARCHAR2(32767);
  x_location_id number;
  err_msg       varchar2(32767);
  p_count       number;

begin
  loc_rec.country           := 'Saudi Arabia';
  loc_rec.address1          := 'Street 10';
  loc_Rec.city              := 'Jeddah';
  loc_rec.created_by_module := 'TCA_V1_API';

  hz_location_v2pub.create_location(p_init_msg_list => 'T',

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