Error Transferring Comp Data To HR -- ORA-20001, ORA-06512 (Doc ID 2033365.1)

Last updated on NOVEMBER 18, 2015

Applies to:

Oracle Fusion Workforce Compensation Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Customer is attempting to post compensation data back to HR to update 2 element entries for a group of employees. The elements were originally created by Group Compensation, and customer understands they can only be edited by Compensation. They have done that successfully in test, but in production there is an error (see attachments). The process has been run several times for different people, but the error keeps preventing any updates.

From screenshots I can see the following error:
ORA-20001: Another person modified the record you are attempting to update. Query the results again.
ORA-06512: at “FUSION.CMP_CWB_POST_PROCESS_PKG”, line 4187 ORA-06512: at line 1



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