My Oracle Support Banner

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

Last updated on JANUARY 27, 2021

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

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.