Search Results org_string




Overview
Explore in AI Chat

Overview

The concurrent program MSDDEMPSP, presented to users under the name Push Setup Parameters, is a component of the Oracle Demand Planning module, identified in the E-Business Suite Technical Reference Manual (ETRM) under the product code MSD – Demand Planning. Its documented function is to push setup parameters, meaning it propagates or refreshes configuration data required by the Demand Planning engine so that planning runs operate against current organizational and system settings. The program is enabled (Yes) in the documented ETRM 12.2.2 metadata and is available for submission through the standard concurrent manager framework in both Oracle EBS 12.1.1 and 12.2.2 environments.

Execution Details

The program is registered with an Execution Method of PL/SQL Stored Procedure and uses the Standard argument method. Its executable is recorded as MSDDEMPSP, and the execution file resolves to the PL/SQL package procedure msd_dem_push_setup_parameters.push_setup_parameters. No subroutine name is defined. Because it executes as a stored procedure rather than a report or host script, output is not produced as a printable report; instead, the program performs database-level processing and reports completion status through the concurrent request log and, where applicable, the request output file.

How to Run

Users submit the program through the standard Submit Requests (SRS) window, selecting the request name associated with MSDDEMPSP. The metadata documents a set of standard SRS attributes, including ATTRIBUTE1 through ATTRIBUTE3. ATTRIBUTE1 is bound to the value x_sr_instance_id, mapping the request to its SRS instance context. ATTRIBUTE2 is associated with a list of values sourced from the view msc_org_groups_v:

  • ATTRIBUTE2 – List of values: select org_group, org_string from msc_org_groups_v where instance_id is null, with the descriptive column labeled x_collection_group. This is the parameter most relevant to an org_string search: it exposes the organization group and its concatenated organization string, allowing the user to target a specific organization group when pushing setup parameters.
  • ATTRIBUTE3 – List of values: SELECT meaning FROM mfg_lookups WHERE lookup_type = 'SYS_YES_NO' AND lookup_code = 2, providing a standard Yes/No selection.

Before submitting, confirm that the target organization group is valid and that no conflicting planning process is running. Because the program modifies setup data used by Demand Planning, submission is typically scheduled during periods of low planning activity to avoid contention.

Related Objects

The principal interface object referenced by the program’s parameters is the view MSC_ORG_GROUPS_V, which supplies the organization group and organization string (org_string) values used to scope the push operation. The lookup view MFG_LOOKUPS (lookup type SYS_YES_NO) supplies the Yes/No selection used by ATTRIBUTE3. The executable procedure resides in the package MSD_DEM_PUSH_SETUP_PARAMETERS. Related Demand Planning programs in the MSD module, such as collection and planning engine concurrent programs, consume the setup parameters that this program distributes, and the organization group definitions used here are shared with the MSC collection schema used by Advanced Supply Chain Planning.

  • Concurrent Program: MSDDEMPSP 12.2.2

    execution_filename: msd_dem_push_setup_parameters.push_setup_parameters ,  product: MSD - Demand Planning ,  user_name: MSDDEMPSP ,  description: Push Setup Parameters ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: MSDDEMCHD 12.2.2

    execution_filename: msd_dem_collect_history_data.collect_history_data ,  product: MSD - Demand Planning ,  user_name: MSDDEMCHD ,  description: Collect History Data ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: MSDDEMPSP 12.1.1

    execution_filename: msd_dem_push_setup_parameters.push_setup_parameters ,  product: MSD - Demand Planning ,  user_name: MSDDEMPSP ,  description: Push Setup Parameters ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: MSDDEMCHD 12.1.1

    execution_filename: msd_dem_collect_history_data.collect_history_data ,  product: MSD - Demand Planning ,  user_name: MSDDEMCHD ,  description: Collect History Data ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure ,