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

Last updated on AUGUST 20, 2024

Applies to:

Symptoms

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"...


ANALYSIS
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

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