Salaries Loaded By HDL Cannot Be Edited - Error On Submit: Salary element entry could not be created. (CMP-1005343) ORA-20001: The identifier ... is invalid ORA-06512: at "FUSION.PAY_SALARY_INTERFACE" (Doc ID 2498559.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Symptoms

We are not using Fusion Payroll (using EBS on-premise) but need to manage the salary in Fusion HCM. We have loaded salaries using HDL but cannot add new proposal or edit existing salary record. Get error on Submit "Salary element entry could not be created. (CMP-1005343)
Reason for this error: ORA-20001: The identifier 30000000XXXXXXX for the payroll relationship, employment terms, or assignment passed to the entry level ID parameter is invalid. Details: The employment level ID included with the entry for the XXX Monthly Salary element must be a valid ID number for the employment level indicated. The employment level must also match the employment level at which entries can be created for this element. For example, you cannot use an assignment ID to create a terms level entry, and the assignment ID submit ORA-06512: at "FUSION.PAY_SALARY_INTERFACE", line 1202 ORA-06512: at line 1 ."
Create a new employee and add salary works as expected and edits to the salary proposal can be made and so can new salary proposals.
Issue appears to only affect HDL loaded salaries.

Details:
The error occurs when updating (edit) an existing salary proposal or when creating a new proposal.
This is the same payroll that is attached to test worker created and linked to payroll and salary proposal manually and it updates without error.
Note: We do not use Fusion payroll but are using Fusion Compensation which will be used for salary increases, bonus management, etc. so the payroll is not complete build.
We are not live. Previously only tested on manually loaded salary proposals and it works fine.
All employees where salary was loaded with HDL that have been tested fail (random selection of about 10) and manually created initial salary proposals can be undated without error.

Changes

Cause

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