'ORA-20001: A value has been provided for a non-enabled': Error When Legal Entities Address Location Is Modified Using HR_LOCATION_API.UPDATE_LOCATION_LEGAL_ADR API
Last updated on MARCH 08, 2017
Applies to:Oracle Human Resources - Version: 12.0.3
Information in this document applies to any platform.
Checked for relevance on 25-NOV-2011
On 12.0.3 in Production/Test:
When attempting to update legal address location end date using hr_location_api.update_location_legal_adr api, the following error occurs.
ORA-20001: A value has been provided for a non-enabled or non-existent descriptive flexfield segment.
ORA-06512: at "APPS.HR_LOCATION_API", line 1665
ORA-06512: at line 11
There is no error when the address style value passed to the parameter 'p_style' is 'GENERIC', but the issue occurs when the address style is changed to 'MX_GLB':
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Go to the Inventory Responsibility to Setup -> Organizations -> Locations and query all the legal address
-> Have an inactive date
-> Able to delete the location but not the date field
2. Run hr_location_api.update_location_legal_adr api script to update the date and other information in legal address location with style 'MX_GLB'
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms