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.'
Last updated on JUNE 26, 2017
Applies to:Oracle Payroll - Version 11.5.10 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms