My Oracle Support Banner

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 later
Information 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

 

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

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


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