'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
(Doc ID 759388.1)
Last updated on JULY 01, 2019
Applies to:Oracle Human Resources - Version 12.0.3 and later
Information in this document applies to any platform.
Checked for relevance on 25-NOV-2011
-- Problem Statement:
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'
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document