Collections are Failing with an error: Destination Side Phase:DONE Status:DATABASEERROR (Doc ID 2094624.1)

Last updated on DECEMBER 20, 2016

Applies to:

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

Symptoms

When running Collections the following errors are shown in the ESS Job Log file:

Collection process parameters are source system OPS, organization group and collection entities [CALASSOC, CALENDAR, CURRENCY, INTSHIPNETWORK, ONHAND, ORDORCHREFOBJ, ORGPARAM, CARRIERMODESERLEVEL, SUBINV, UOM].
Organizations: [GED]
Collection Cycle Id: 398
Source Side Phase:UNKNOWN Status:null
Source side processing for the cycle completed.
Destination Side Phase:DONE Status:DATABASEERROR
Destination Side got Error:DATABASEERROR
Collection can't be completed reason : Collection cycle failed. Contact your system administrator.

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