Not Able to Query Column ALTERNATE_ROUTING_DESIGNATOR In MSC_ROUTINGS and MSC_SUPPLIES (Doc ID 2102013.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Memory Based Planner

Facing issue with ALTERNATE_ROUTING_DESIGNATOR column in MSC_ROUTINGS

Issue seen when upgrading system to 12.2.4.1 with 12.1.3 and with online patching with ebs functionality enabled.
We are facing issue like ALTERNATE_ROUTING_DESIGNATOR column we have in MSC_ROUTINGS synonym , but doesn't have this column in MSC_ROUTINGS table.
Now we would like to know the reason why it is not there in Table. When we are trying to access this ALTERNATE_ROUTING_DESIGNATOR column from MSC_ROUTINGS table we are getting invalid identifier error.

Issue exists when we issue a alias in front of the table name (MSC.), however when we reference the table directly like MSC_SUPPLIES or MSC_ROUTINGS,
then we have these columns. In the later case, this is pointing to synonym in APPS and these columns exists in the Synonym.
 

ERROR
-----------------------
Expect to see the same columns even in the MSC Schema.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run a SQL and see that the columns are not existing in the MSC tables when the table name is prefixed with the schema name MSC.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Not able to query the columns in the MSC schema.

Cause

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