Fusion DOO - Unable To Collect Data Using Load Staging Table
Last updated on JANUARY 23, 2017
Applies to:Oracle Fusion Distributed Order Orchestration - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Oracle Fusion Global Order Promising - Version 126.96.36.199.0 to 188.8.131.52.0 [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
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