Receivables - EBS (MOSC)

MOSC Banner

Error while creating location using HZ_LOCATION_V2PUB.CREATE_LOCATION

edited Mar 10, 2016 7:23AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi,

I have a requirement to create location with street_number, po_box_number. The API doesn't allow me to pass few fields like street_number.

Error Message: The street_number column is obsolete.  You are not allowed to pass a value to this column.

Could you please suggest.

Sample code I tested:

DECLARE

p_location_rec   HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

x_location_id    NUMBER;

x_return_status  VARCHAR2(2000);

x_msg_count      NUMBER;

x_msg_data       VARCHAR2(2000);

BEGIN

p_location_rec.country           := 'PL';

p_location_rec.address1          := 'Addr_1';

p_location_rec.city              := 'C3';

p_location_rec.postal_code       := '';

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