Performance: Takes Very Long Time To Open Purchase Order Approval Notifications In Worklist
(Doc ID 2932551.1)
Last updated on APRIL 23, 2023
Applies to:
Oracle Purchasing - Version 12.2.11 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
System is taking very long time to open Purchase Order Approval Notifications in worklist. (Table/View captured during performance trace are po_distribution_xml and po_lines_xml)
STEPS TO REPLICATE
The issue can be reproduced at will with the following steps:
1. Create PO and submit for approval
2. Open the Notification
3. Performance issue
Changes
EBS Version Upgrade(any version Eg: upgrade from 12.1.3 to higher)
or
Database upgrade to 19C and above. (From 12c to 19c / moving EBS to OCI / Moving to Database as Service)
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 |
Changes |
Cause |
Solution |
References |