Re: Timeout

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Timeout-tp5268p5324.html

It seems that query does a full table scan to HZ_PARTIES.

What is the object named "XXNCV_HZ_CUSTOMER_PARTY_FIND_V"

This seems custom, as it starts with "XX"

Please ask your developers about it.. This customization may affect the performance.

Check this note as well: Customer Workbench Performance Issue: Customer Search Using Account Number Or Other Fields Is Slow (Doc ID 1399774.1)