Order Creation Fails With:- The creation of an orchestration order failed due to a system error.prepareForOrchestration failed with error (Doc ID 2090032.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Distributed Order Orchestration - Version 11.1.9.2.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Symptoms

Orders Created using the order creation Web service fail.

This note describes three similar errors that may be reported:

The creation of an orchestration order failed due to a system error.prepareForOrchestration failed with error ERROR

 

The creation of an orchestration order failed due to a system error.prepareForOrchestration failed with error The transaction could not be processed due to an unconditional constraint on operation UPDATE on attribute OrderedDate of entity Order Header.

 

The creation of an orchestration order failed due to a system error.prepareForOrchestration failed with error DOO-Changes to orders that use orchestration process DOO_BillOnlyGenericProcess are not allowed


In these instances the order payload for four different orders included:


NOTE:
1. The SourceTransactionNumber and SourceTransactionIdentifier are NOT the same
2. For the orders the same SourceTransactionIdentifier has been used
3. For Order HITECH0027, the TransactionOn (i.e. Ordered Date has changed)
4. For Order HITECH0019, an Orchestration Process is assigned that does NOT allow 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