My Oracle Support Banner

Update Synonyms procedure - What it does and why it is important to EBS/ASCP - Demantra implementations (Doc ID 1061331.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.


This document discusses the Update Synonyms procedure and what is does and what objects it updates. 

1) When should it be run?

Anytime a Demantra -  EBS/ASCP integration patch is run.  Example of one of these patches is <Patch 8703840>

2) How is this procedure run?

Navigation -
   Demand Management System Administrator
      -> Other  -> Requests
                  -> Submit a New Request  -> Single Request

Special instructions for Clients who have more than one Demantra schema

The "Update Synonyms" concurrent program has a hidden parameter p_schema_name.

If the user has only one Demantra schema then the user can leave the parameter to be hidden. But, if the user has mutiple demantra schemas then user can enable hidden parameter to visibility.

System Administrator Responsibility   
    -> Concurrent
        -> Program
            -> Define

After enabling the parameter, when the user submits the concurrent program then the user can specify against which demantra schema user wishes to run the concurrent program.
Enabling the parameter option is given to select the correct Demantra schema out of multiple schemas by the user

3) What are the more common issues that indicate that this Update Synonyms procedure needs to be run?

Any issue where EBS/ASCP doesn't seem to be communicating correctly.  For example, a user logs into the Demand Management responsibility in EBS but does not get transferred over to the Demantra application


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.