Online Patching Database Compliance Checker Indicating Violation Snapshot Views Incorrectly Referencing Schema Table Instead of APPS Synonym (Doc ID 2233923.1)

Last updated on JUNE 28, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

Snapshots are incorrectly referencing the tables instead of apps synonyms, this is causing violation of Online Patching Rules

Additional information:
As per EBS Online Patching Database Compliance Checker report the views definition need to be changed to be in compliance with the following:

"views may operate incorrectly after the referenced table has been patched. Only the synonyms (from APPS schema) which are not impacted by patching process, should stand on the base of the views definition";

From Doc ID 1531121.1 running ADZDDBCC.sql (Lists objects that violate Online Patching Development standards and that require manual intervention in order to address the violations) has listed the following in SECTION-26 the following : MRP_FORECAST_DATES_SN, MRP_FORECAST_DSGN_SN, MTL_DEMAND_SN, MTL_MTRX_TMP_SN, MTL_OH_QTYS_SN, MTL_RESERVATIONS_SN, MTL_SUPPLY_SN, MTL_SYS_ITEMS_SN, OE_ODR_LINES_SN, WSH_TRIP_SN, WSH_TRIP_STOP_SN, WSH_TRIP_STOP_SN

 

 

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