Data Corruption in PAY_COST_ALLOCATION_F Table: Effective End Date is Prior to the Effective Start Date
(Doc ID 2100564.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
Find that there is a data issue on the table PAY_COST_ALLOCATION_F. Effective end date is prior to the effective start date
The issue can be reproduced at will with the following steps.
(N) ORACLE HRMS Manager -> People -> Enter and Maintain -> Assignment -> Costing
1. User is trying to enter Assignment Costing for a new employee and it shows the error APP-PER-06645 : This operation will cause duplicate Costing Data to be Created
2. Found document : While trying to assign a Cost Code to an employee error APP-PER-06645: This operation will cause duplicate Costing Data to be Created (Doc ID 844958.1)
3. Tried to delete it using PAY_COST_ALLOCATION_API and failed with the message PRIMARY KEY not found.
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