Error: "ORA-20001: The default code combination does not exist for the date effective period of the assignment " When updating DEFAULT EXPENSE ACCOUT Using API"HR_ASSIGNMENT_API" in Shared HR
(Doc ID 2046959.1)
Last updated on JUNE 02, 2024
Applies to:
Oracle Human Resources - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
When trying to update the assignment information by using the API"hr_assignment_api.update_emp_asg", the following error happens.
ORA-20001: The default code combination does not exist for the date effective
period of the assignment.
The specified default code combination does exist in the table
GL_CODE_COMBINATIONS or exists but is not active for the date effective
period of the assignment.
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 11173
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 9677
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 9327
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 8998
ORA-6512: Line 12
period of the assignment.
The specified default code combination does exist in the table
GL_CODE_COMBINATIONS or exists but is not active for the date effective
period of the assignment.
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 11173
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 9677
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 9327
ORA-6512: "APPS.HR_ASSIGNMENT_API", Line 8998
ORA-6512: Line 12
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Open the form "GL Accounts".
Responsibility: Related to GL responsibility (N) Setup -> Accounts -> Combinations - Create an account A as below.
<>
Account Effective Dates(From)
------------------------ -----------------------
10.100.10.A0007.0000 01-JAN-2014 - Open the Form "Enter Person" and create the employee A as below.
Responsibility: Related to HR responsibility (N) People -> Enter and Maintain
<>
Employment Dates: 01-APR-2011 - Try to update the Default Expense Account by using the API "HR_ASSIGNMENT_API.UPDATE_EMP_ASG" as below.
p_assignment_id => 4240 --AssignmentID of employee A
p_default_code_comb_id => 2087 --Default Expense Account of Account A
p_set_of_books_id => 4903 --Leadger
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 |
References |