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.
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.
0