Cost Accounting Distributions errors with - TradeEventInterfaceProcessor/insertTradeEvents: ORA-00904: "TRANSACTION_EVENT_ID": invalid identifier
Last updated on DECEMBER 08, 2017
Applies to:Oracle Fusion Cost Management Cloud Service - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Information in this document applies to any platform.
On : 126.96.36.199.0 version, Cost Management
After upgrading/provisioning to R12 following October, on running 'Create Cost Accounting Distributions' get the following 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.
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.
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