Cost Accounting Distributions errors with - TradeEventInterfaceProcessor/insertTradeEvents: ORA-00904: "TRANSACTION_EVENT_ID": invalid identifier

(Doc ID 2336943.1)

Last updated on DECEMBER 08, 2017

Applies to:

Oracle Fusion Cost Management Cloud Service - Version 11.12.1.0.0 to 11.12.1.0.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Cost Management

After upgrading/provisioning to R12 following October, on running 'Create Cost Accounting Distributions' get the following error
 

ERROR
-----------------------
CostProcessorEss: ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on TradeEventInterfaceProcessor/insertTradeEvents: ORA-00904: "TRANSACTION_EVENT_ID": invalid identifier cmr preprocess failed due to an UnknownException.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create an inventory transaction (Miscellaneous Receipt/Issue)
2. Run Transfer Transactions from Inventory to Costing - This is completed successfully
3. From Cost Accounting UI, run Create Cost Accounting Distributions. See the above error while reviewing cost accounting distributions.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms