Work Planning and Crew-shift Schedule Queries - Materialized View Dependency Removed

The W1_PARENT_ORG_MT_VW materialized view is regularly refreshed in both staging and production environments using a DBMS scheduler batch job. However, this refresh process, which completely refreshes the data, is causing performance delays. To mitigate this issue, all crew shift schedules and work planning search queries that use the materialized view have been redesigned and no longer rely on this materialized view.

Rework work planning and crew shift schedule search queries to bypass the materialized view improves performance and reducing resource consumption.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

Due to the redesign of the work planning and crew-shift schedule queries, the W1_PARENT_ORG_MT_VW materialized view is no longer needed and has been removed. Customers should review their custom code and remove any references to the W1_PARENT_ORG_MT_VW materialized view. Specific base package zones that have been impacted by this change include the following:

• Activity Information (W1-WPACTQ1)
• Activity Information (W1-SCHDLRQ4)
• Labor Requirement Information (W1-SCHDLRQ6)
• Previously Scheduled Unfinished Work (W1-SCHDLRQ2)
• Location Information (W1-SCHDLRQ5)
• Schedule (W1-SCHDLRQ1)
• Work Order Information (W1-SCHDLRQ3)