My Oracle Support Banner

Costing Error: ORA-00001: Unique Constraint (HR.PAY_COST_ALLOCATION_KEYFLE_PK) Violated (Doc ID 2631464.1)

Last updated on JANUARY 27, 2020

Applies to:

Oracle Payroll - Version 12.1 HRMS RUP12 and later
Information in this document applies to any platform.

Symptoms

After applying HRMS 12.1 RUP 12 or 12.2 RUP 13, Costing errors for some employees.


ERROR
-----------------------
No suspense account in pay_payrolls_f table
An unexpected error has occurred. Please inform your system administrator that the error: ORA-00001: unique constraint (HR.PAY_COST_ALLOCATION_KEYFLE_PK) violated occurred when the FND_FLEX_SERVER package tried to execute the SQL statement
invalid code combination


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run Costing process


Changes

 Applied HRMS 12.1 RUP 12 or 12.2 RUP 13

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.