EBS R12 - Problem of lock with API hz_location_v2pub
In a PL/SQL code, i do a loop on HZ_LOCATIONS to read the location_id for specific city, postal_code and address1 values.
For each location_id found, i want to update the corresponding row in table HZ_LOCATIONS calling the APIs apps.hz_location_v2pub.get_location_rec to access the record then apps.hz_location_v2pub.update_location to update some fields.
But :
For the first location_id, hz_locations table is successfully updated
But for the other ones, no update is done and the error message is displayed:
Error 1 This record of the table hz_locations cannot be locked because it has been updated by another user.