Work Planning and Crew-shift Schedule Queries - Materialized View Dependency Removed
The application now bypasses the Materialized View (W1_PARENT_ORG_MT_VW) when you perform a crew-shift schedule or work planning query. Previously, the application regularly refreshed W1_PARENT_ORG_MT_VW, which used a DBMS scheduler batch job to retrieve the immediate parent-owning organization during a query. The refresh process resulted in slow performance and delays in the completion of queries.
This improves performance and reduces resource consumption.
Steps to Enable
You don't need to do anything to enable this feature.