My Oracle Support Banner

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 to [Release 1.0]
Oracle Fusion Global Order Promising - Version to [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***


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


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

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