Oracle EBS lov Speed optimization

First, the phenomenon

This address: http://blog.csdn.net/sunansheng/article/details/50952758

When our EBS Lov SQL is more complex to write. or more data volume, Lov pop-up display speed, or directly fill in the number and then move to the other input box (Validate from list open case) will appear busy status, users need to wait!

Second, analysis

1. Click the Lovbutton pop-up selection box:

Query the entire data of Lov SQL directly, large amount of data or SQL complex. Slow query + Slow data transfer.

Watermark/2/text/ahr0cdovl2jsb2cuy3nkbi5uzxqv/font/5a6l5l2t/fontsize/400/fill/i0jbqkfcma==/dissolve/70/gravity /center "/>

2. Fill in the number and move the cursor to the other input boxes:
The forms interface is more stupid. The first query all the data, and then filter the number, to infer whether there is a ticket, or there is no repeat number.

Second, the Optimization method

Set the properties of Lov Filter before display:yes 

1: When you open lov you do not actively query, waiting for the user to enter the query criteria,% represents the query all

Effect 2: When you enter a number to move to another location. The speed is very fast.

(Original: first query all data, and then filter the ticket.) Now: Bring the document number directly into SQL

Oracle EBS lov Speed optimization