HZ_ORGANIZATION_PROFILES record cannot be locked as it has been updated by another user
Oracle Version: Oracle R12
This record in table HZ_ORGANIZATION_PROFILES cannot be locked as it has been updated by another user.
Cause of Issue:
The issue is because data was not cleansed before it was migrated meaning that incorrect values were loaded that completely by-passed the validation process.
The image below shows 2 VAT registration values that had been migrated into the system.
The issue is that the Registration Number used would not get validated had it been entered through the front end. As a result, when the record is updated it is causing the issue seen in the next step.
To resolve the issue, you need to go to the ‘Tax Manager’ responsibility, then Parties > Party Tax Profiles. Then use ‘Third Party’ or ‘Third Party Site’ as the party type and enter the supplier or customer name in the ‘Party Name’ field.
Click ‘Go’. And then the ‘Update Tax Profile’.
Go to the ‘Tax Registration’ tab and find the migrated tax registrations and click update on them as shown in the next image.
Use the same date for the ‘Effective from’ as used in the ‘Effective to’ date.
Repeat for the other Registration.
When available, we provide additional resources to a particular support item, such as User Guides, blog posts, support videos and links to recommended Oracle solutions.
GCC VAT Oracle Learning Series
Want to know how to set tax up for Oman, Kuwait, Bahrain, Qatar, United Arab Emirates and Saudi Arabia then sign up to our free webinar series.