My Oracle Support Banner

Fusion CST: How to Troubleshoot Common Cost Processor Errors (Doc ID 2261010.1)

Last updated on FEBRUARY 02, 2019

Applies to:

Oracle Fusion Cost Management
Oracle Fusion Cost Management Cloud Service
Information in this document applies to any platform.


 The purpose of this document is to troubleshoot Create Cost Accounting Distributions Program or Cost Processor Errors

Troubleshooting Steps

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
Troubleshooting Steps
 Captured Exceptions
1. ERROR : “The outgoing inventory transaction could not be costed because a perpetual average cost was not found”
 2. ERROR: “The incoming inventory transaction could not be costed because an existing layer cost was not found to use as the actual cost of the item”
 3. ERROR: "The standard cost for this transaction does not exist"
 4. ERROR: "The transaction could not be processed because the receiving transaction information is missing"
 5. ERROR: "The costing period XXXXX for the transactions is not open"
 6. ERROR: "The transaction period XXXXX is closed for general ledger"
 7. ERROR: "Issue transaction was put on hold to avoid generating negative inventory"
8. ERROR: "Issue transaction is fully costed but not yet fully depleted due to unresolved negative inventory quantities" 
ERROR: "Issue transaction was processed to zero quantity with remaining quantities put on hold"
 9. ERROR "The transfer receipt cannot be costed until the issue transaction is fully processed with sufficient on-hand quantity"
 10. ERROR: "The receipt is missing a cost"
 11. ERROR : "Distributions were not created for the COGS transaction"
 12. ERROR: "The transaction could not be interfaced as the corresponding work order or operation information does not exist in the source system"
 Un-captured Exceptions
 12. ERROR: ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on CstPreProcessor/qppInsertTxfrSuppressionErrors: ORA-01400: cannot insert NULL into ("FUSION"."CST_PREP_ERRORS_GT"."ERROR_CODE")
 13. ERROR: CostProcessorEss: ESS Job Result: CstPreProcessor/qppUpdateTxnGroupsForTradeEventsInCit4InvTxnId: ORA-01652: unable to extend temp segment by 128 in tablespace FUSION_TEMP
14. ERROR : ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on ProcessAPInterface/insertAutoAccrualForAccrClr: ORA-00001: unique constraint (FUSION.CMR_AUTO_ACCRUAL_CLR_DTLS_PK) violated moveAPData() failed due to an unknown Exception.
16. ERROR: Request XXXXX completed in error. Error Msg: CstPreProcessor/qppUpdateTxnGroupsForTradeEventsInCit4InvTxnId:ORA-01555: snapshot too old: rollback segment number 35 with name "_SYSSMU35_1304902523$" too small

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