Shared HR: Can Not Update a Filed "Default Expense Account" When Using API"HR_ASSIGNMENT_API" (Doc ID 2046959.1)

Last updated on MARCH 01, 2017

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.

       <<Example>>

        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

       <<Example>>

        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

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