Negative Cost_Type_ID
I had encountered an issue during performing the standard cost update program. If this program is suddenly aborted, the cost_type_id is negative.
I had to create a DELETE script to clean up the CST_ITEM_COSTS and CST_ITEM_COST_DETAILS tables with the negative cost_type_id records.
Is there an existing patch that will prevent the negative cost_type_IDs to be created?
Is there another way that will prevent me from creating the DELETE script?
I am currently using Oracle R12(12.1.2).
Thank you.