'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

Symptoms

-- 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.

ERROR
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'

Cause

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