CMRO: Slow Performance After RDBMS Upgrade - Unable To Perform Sign-Off
(Doc ID 2615519.1)
Last updated on JULY 14, 2020
Applies to:Oracle Complex Maintenance, Repair, & Overhaul - Version 12.2.8 and later
Information in this document applies to any platform.
After upgrading the database from 22.214.171.124 to 126.96.36.199, users encounter performance issues and are unable to perform a Sign-Off for a Work Order.
From the RDBMS utilities, the DBAs can see high values due to concurrency.
WHERE PARENT_UC_HEADER_ID IS NULL START WITH UNIT_CONFIG_HEADER_ID = :B1 CONNECT BY UNIT_CONFIG_HEADER_ID = PRIOR PARENT_UC_HEADER_ID
(R) Complex Maintenance, Repair, and Overhaul
(N) Data Clerk Workbench > Work Orders
- Search for Visit and/or Workorder and click GO
- Select and Click Update
- Click on Sign-off
=> Transaction Not getting Completed.
(N) Execution > Production Planning > Work Orders
- Search for the visit or Workorder to signoff
- Select the Workorder to signoff and select ‘Sign off Maintenance Requirement’ from the action list
- Click on Go
- Choose the options:
. Signoff all pending child Maintenance Requirements
. Complete all pending Jobs and Operations
. Use these actual dates
. Select a Technician
- Click on Apply
=> The page keeps on loading and take almost 30 minutes to signoff.
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