Costing Application Program Interface (API) Throws Duplication Error: ORA-20001: HR_6645_ASS_COST_DUPL 'This operation will cause duplicate Costing Data to be Created.'
(Doc ID 1933361.1)
Last updated on JANUARY 01, 2021
Applies to:Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to create multiple rows of cost allocation, the following error occurs but it creates the first entry.
ORA-06512: at "APPS.PAY_COST_ALLOCATION_API", line 721
ORA-06512: at line 30
ERROR_TEXT of HR_6645_ASS_COST_DUPL is "This operation will cause duplicate Costing Data to be Created."
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Run the API(pay_cost_allocation_api.create_cost_allocation) to create multiple lines.
- Get the error HR_6645_ASS_COST_DUPL.
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