My Oracle Support Banner

'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 DECEMBER 03, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.