Fusion DOO - Unable To Collect Data Using Load Staging Table (Doc ID 1524570.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.4.0.0 to 11.1.9.2.0 [Release 1.0]
Oracle Fusion Global Order Promising - 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

Trying to collect calendar information from eBS by populating MSC_ST_CALENDARS using PL/SQL and running "Load Stating Table"
However, program fails with below error.

Exception in execute() methodJBO-29000: Unexpected exception caught: java.lang.Error, msg=The subscribe server is stopped. The subscribe server is not accepting this call.

The issue can replicated using below steps

1.Created source system using the following navigation:
   Order Orchestration Top Task List > Define Common Order Orchestration Configuration > Manage Customers > Define Source Systems >  Manage Trading Community Source Systems
2. Load data into msc_st_calendars and msc_coll_cycle_status staging tables.

3. Invoke data load from staging tables by following navigation

   Define Sales Order Fulfillment > Collect Orchestration Reference and Transaction data > Manage Orchestration Data Collection Processes>>Click on Perform Data Load

4. Track the progress using Navigator > Tools >Scheduled Processes

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