My Oracle Support Banner

ASSIGNMENT COSTING > Data corruption on PAY_COST_ALLOCATION_F (Doc ID 2100564.1)

Last updated on MARCH 27, 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

 -- Steps
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.


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.