Performance Issue With Oracle Procurement Command Center Data Load po-pcc-orders

Oct 29, 2021 8:06AM

HI

Looks like the performance hit is here:

select to_date(null), to_date(null), full_name, NULL , To_char(person_id)

from

PER_PEOPLE_V7 order by ( CASE WHEN d_termination_date < SYSDATE THEN

'Inactif' ELSE 'Actif' END ) , full_name

call count cpu elapsed disk query current rows

------- ------ -------- ---------- ---------- ---------- ---------- ----------

Parse 1453 0.48 0.86 0 0 0 0

Execute 1453 0.06 0.10 0 0 0 0

Fetch 22347065 2167.59 3778.16 2965 54581590 0 22347065

------- ------ -------- ---------- ---------- ---------- ---------- ----------

total 22349971 2168.14 3779.14 2965 54581590 0 22347065

Trying to use our internal ECC forums to see if anyone has similar issue or an idea to resolve

ECC Data Load po-pcc-orders processing does not complete due to a performance issue on the per_people_v7 view. Someone can help me ?

Enterprise Command Center Framework - EBS (MOSC)