My Oracle Support Banner

Create Cost Accounting Distribution Ended In Error State (Doc ID 2699031.1)

Last updated on AUGUST 18, 2020

Applies to:

Oracle Fusion Cost Management Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Cost Management

When running create cost accounting distributions it fails with the following error.

ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on ComputeAcquisitionCosts2/mtpInsertNewCostAdjDtls: ORA-00001: unique constraint (FUSION.CST_ACQ_COST_ADJUSTMENT_DTL_PK) violated createTxnCostsAndCostAdjs() failed due to an unknown Exception. processNewAPInvoiceInfo() failed due to an Exception. processNewTxnsWithInvoices() failed due to an unknown Exception. processClosedPOs() failed due to an unknown Exception.

The issue can be reproduced at will with the following steps:
1. Cost Accounting
2. Run create cost accounting distributions
3. View the log.


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

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