Encounter 'ORA-20001: PER_289702_INVALID_MANAGER:' Error While Calling 'HR_ORGANIZATION_API.UPDATE_ORG_INFORMATION' API
(Doc ID 2781799.1)
Last updated on JUNE 07, 2021
Applies to:
Oracle Human Resources - Version 12.2 HRMS RUP12 and laterInformation in this document applies to any platform.
Symptoms
When trying to update Organization Information for "Organization Reporting Information" using API, the following error occurs
ERROR
--------
ORA-20001: PER_289702_INVALID_MANAGER:
STEPS
-------
The issue can be reproduced at will with the following steps:
1. Login using SQL Developer
2. Execute the Application Program Interface (API) "HR_ORGANIZATION_API.UPDATE_ORG_INFORMATION". This API is used to update the DFF segments of "Org Developer DF" based on the context that is passed to the API parameter "p_org_info_type_code".
3. When the above API is executed with Context Code as "Organization Name Alias", the above error is encountered.
ADDITIONAL INFORMATION
---------------------------------
1. Under the "Org Developer DF" there are many contexts. One of the context code is "Organization Name Alias". Context information and corresponding segment configurations are given below:
Context Information:
==============
DFF Title : Org Developer DF
Context Code : Organization Name Alias
Name : Organization Reporting Information
Segment Information:
==============
Name Column Value Set
------ ------------------------- -----------
Start_Date ORG_INFORMATION3 FND_STANDARD_DATE
End_Date ORG_INFORMATION4 FND_STANDARD_DATE
Reporting Name ORG_INFORMATION1 30 Characters
Manager ORG_INFORMATION2 HR_COST_CENTER_MANAGER
2. The values that are stored against this context are displayed as "Reporting Information" under "Others" in Organization form. Navigation to access the same is given below.
HRMS Manager -> Work Structures -> Organization -> Description -> HR Organization (Classification) -> Others -> Reporting Information
Cause
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
Symptoms |
Cause |
Solution |