Receivables - EBS (MOSC)

MOSC Banner

EBS R12 - Problem of lock with API hz_location_v2pub

edited Jun 10, 2013 7:37AM in Receivables - EBS (MOSC) 3 commentsAnswered ✓
Hello,

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.

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