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 DECEMBER 08, 2022

Applies to:

Symptoms

Problem Statement:

When trying to update the assignment information by using the API"hr_assignment_api.update_emp_asg", the following error happens.

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

1. Open the form "GL Accounts".
   Responsibility: Related to GL responsibility (N) Setup -> Accounts -> Combinations
2. Create an account A as below.
   
   　  <>
   
       Account                            Effective Dates(From)
       ------------------------  -----------------------
       10.100.10.A0007.0000  01-JAN-2014
3. 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
4. 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

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