Physical Inventory Form Does Not Open Due To Performance Issue (Doc ID 2795284.1)

Last updated on AUGUST 22, 2023

Applies to:

Symptoms

The "Physical Inventories" form Performance is very slow and takes a long time to open

STEPS 
1. Responsibility: Inventory
2. Navigation: Counting -> Physical Inventory -> Physical Inventories > See the form takes a long time to open

SQL Trace identified below query causing the performance issue -

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 4 0.00 0.00 0 0 0 0
Execute 4 0.00 0.00 0 0 0 0
Fetch 4 15.32 399.95 1280096 1289426 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 12 15.33 399.96 1280096 1289426 0 0

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.