Seeded Request 'COLLECT SHIPMENT AND BOOKING HISTORY' fails in 'Push setup parameters' and Parameters on the Source and on Planning instance with Error(3) in MSDDEMPSP module: Push Setup Parameters (Doc ID 1082260.1)

Last updated on JUNE 12, 2023

Applies to:

Symptoms

The seeded request set fails in the first stage 'Push setup parameters'
They have separate instances for source and planning. Not sure what profiles need to be set in what environment.
Source : 11i
Planning: r12

STEPS
--------
From Demand Management System Administrator
Collections --> Oracle Systems --> Shipment and Booking History

+---------------------------------------------------------------------------+
Demand Planning: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MSDDEMPSP module: Push Setup Parameters
+---------------------------------------------------------------------------+

Current system time is 24-FEB-2010 10:25:25

+---------------------------------------------------------------------------+

**Starts**24-FEB-2010 10:25:25
**Ends**24-FEB-2010 10:25:26
Profiles not set
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Push Setup Parameters Program
-----------------------------
Source Instance ID : 1
DB Link: @EBS_PERP

Warning - The collection of customers, ship to locations (customer sites), regions,
and other level values in the geography dimension from e-business source
instance to Demand Planning depends on the profile, MSD:Customer Attribute.
It is recommended to set the profile to selectively collect these level values.
To collect all the available geography dimension level values, please clear
out the dummy profile value. Until the profile value is set appropriately or
cleared out, only the dummy level value (other) will be collected into
Demand Management for geography dimension.
Push Profiles
---------------

-------------------------------------------------------------
Profile Name - Value
-------------------------------------------------------------
Profile MSD_DEM_CATEGORY_SET_NAME -
Profile MSD_DEM_CONVERSION_TYPE -
Profile MSD_DEM_CURRENCY_CODE - USD
Profile MSD_DEM_primary_ORG - 83
Profile MSD_DEM_CUSTOMER_ATTRIBUTE - NONE
Profile MSD_DEM_TWO_LEVEL_PLANNING - 2
Profile MSD_DEM_SCHEMA - DEMANTRA
-------------------------------------------------------------

Please make sure that profiles MSD_DEM_CONVERSION_TYPE and MSD_DEM_primary_ORG are set in Source instance
and MSD_DEM_CURRENCY_CODE and MSD_DEM_SCHEMA profiles in the Planning Server are set.
Error(3): msd_dem_push_setup_parameters.push_setup_parameters - 24-FEB-10
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...


Finished executing request completion options.

+---------------------------------------------------------------------------+
Exceptions posted by this request:
Concurrent Request for "Push Setup Parameters" has completed with error.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 24-FEB-2010 10:25:26

+---------------------------------------------------------------------------+

Changes

Cause

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