Receivables - EBS (MOSC)

MOSC Banner

Unable to create the province in the hz_locations using the hz_location_v2pub.create_location

I am trying to create a location using the API in the following format:

hz_location_v2pub.create_location
                                     (p_init_msg_list      => fnd_api.g_true,
                                      p_location_rec       => l_location_rec,
                                      x_location_id        => l_chr_created_loc_id,
                                      x_return_status      => l_chr_return_status,
                                      x_msg_count          => l_num_msg_count,
                                      x_msg_data           => l_chr_msg_data
                                     );

The l_location_rec is of type HZ_LOCATION_V2PUB.LOCATION_REC_TYPE and in this there is a provision to pass the 'province' to the record. I have passed that value but the location gets created properly with values for address1, address2, address3, city, postal_code, country, etc. But even though the province value is passed in the record, it is not populating the province field while creating the location. Any pointers are helpful to nail down the issue.

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