ASSIGNMENT COSTING > Data corruption on PAY_COST_ALLOCATION_F
Last updated on FEBRUARY 20, 2018
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
-- Expected Behaviour
expect start date BEFORE end 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.
4. need to delete the row.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms