My Oracle Support Banner

Error in Multiple Assignment Uploads Using EBS Payroll Integration with HCM Cloud (Doc ID 2410107.1)

Last updated on JUNE 16, 2018

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP10 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

When using the Oracle EBS Payroll Integration with HCM Cloud, if multiple assignments exist for an employee, the process Load HCM Cloud Data for Payroll Integration ends in error.

Error Message: "ORA-20001: Invalid ID
The ASSIGNMENT_ID value does not exist as of the effective date."

Error Code: -20001
Error stack: "ORA-20001: Invalid ID
The ASSIGNMENT_ID value does not exist as of the effective date."

Error Backtrace: "ORA-06512: at "APPS.HR_ASG_BUDGET_VALUE_API", line 172
ORA-06512: at "APPS.PER_RI_B_MERGE_WORKER", line 2367"

 

 

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

  1.  HCM Cloud Integration Administrator

  2.  Function: Import and Load Data > Import File (to import a new worker file) > Click Continue
     
  3.  On the Schedule Request: Define page, Enter the data of configuration name, data set name, file name and business object

  4. The file is downloaded from UCM content using the concurrent program “Import HCM Cloud Data File for Payroll Integration”

  5. Then we select “Load”

  6. Then select “Submit” and the concurrent program “Load HCM Cloud Data for Payroll Integration for Payroll Integration” is executed

 

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!


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