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 MARCH 08, 2017

Applies to:

Oracle Human Resources - Version: 12.0.3 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.
Checked for relevance on 25-NOV-2011


-- Problem Statement:

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'


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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