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:
Oracle Advanced Supply Chain Planning - Version 12.2.6 and laterInformation 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 |