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

Last updated on MARCH 20, 2024

Applies to:

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

Purpose

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.

15. ERROR: FND_CMN_PROC_INTERNAL_ERROR

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

17. ValidatePeriodEss: ESS Job Result: BP:ERROR: Process rolled back and aborted due to SQL Exception on ValidatePeriod/uncostedCTCTxns: ORA-01555: snapshot too old: rollback segment number 101 with name "_SYSSMU101_1105271941$" too small

18. Error : A perpetual average cost is required to cost the outgoing inventory transaction

19. Error: The item cost profile was not generated.

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