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

Last updated on FEBRUARY 01, 2024

Applies to:

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

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