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.

Symptoms


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.


Cause

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.