My Oracle Support Banner

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.

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

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



Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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