My Oracle Support Banner

Synonym is dropped then it not re-created pointing to Edittioned view OE_ORDER_LINES_ALL (Doc ID 2659241.1)

Last updated on APRIL 17, 2020

Applies to:

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

Symptoms

12.2.9 with RDBMS 19c

Run standard setup for ASCP data collections
This executes steps to
A> create materialized view log on base table
e.g. from trace file - (INTERNAL TESTCASE -
LINE 8843
PARSING IN CURSOR #139802567431272 len=44 dep=1 uid=5 oct=47 lid=5 tim=16802440167 hv=1030056790 ad='10b1c1f28' sqlid='g7d55n8yqauuq'
begin ONT.apps_ddl.apps_ddl(:ddl_text); end;
...
BINDS #139802567431272:
CREATE SNAPSHOT LOG ON ONT.OE_ORDER_LINES_ALL WITH ROWID

B> create materialized view on the base table
BINDS #139802565858712:
  value="SQL: CREATE MATERIALIZED VIEW "APPS"."OE_ODR_LINES_SN" ("INVENTORY_ITEM_ID", "ORGANIZATION_ID", "ORDER_QUANTITY_UOM", "ORDERED_QUANTITY", "HEADER_ID", "SHIPPED_QUANTITY", "DEMAND_CLASS", "SCHEDULE_SHIP_DATE", "SALESREP_ID", "LINE_ID", "ATO_LINE_ID", "PROJ"...


PROBLEM
------------------
During this sequence the synonym is dropped AND THEN it not re-created pointing to Edittioned view OE_ORDER_LINES_ALL#

>>> BEFORE
select * from dba_synonyms where synonym_name like 'OE_ORDER_LINES_ALL';
OWNER - APPS
SYNONYM_NAME - OE_ORDER_LINES_ALL
TABLE_OWNER ONT
TABLE_NAME - OE_ORDER_LINES_ALL#

>>> AFTER
select * from dba_synonyms where synonym_name like 'OE_ORDER_LINES_ALL';
OWNER - APPS
SYNONYM_NAME - OE_ORDER_LINES_ALL
TABLE_OWNER ONT
TABLE_NAME - OE_ORDER_LINES_ALL <<<< NOT THE EDITIONED VIEW

MSC code uses standard calls to AD code and RDBMS code

Cause

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
Symptoms
Cause
Solution
References


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