OM: Sales Order Form: Refresh Method (Query Coordination)

OM: Sales Order Form: Refresh Method (Query Coordination) , is a very important profile option available in Oracle Order management. Though usage of this profile is not very common. This profile option if set properly helps you to improve performance especially if you are doing some cascade operations on large # of lines.
For example –

1. Cascade operations on 100+ lines 
2. Cascade operations on a model with 100+ options/class, with show lines = yes
3. In continuation of the point # 2 , let’s consider a case where we have a sales order with 5+ model and each model has 100-200 option/class and we need to perform cascade operations, also show lines = yes

Profile option - OM: Sales Order Form: Refresh Method (Query Coordination)
Internal Name - OM_UI_REFRESH_METHOD
This profile option determines whether the screen is refreshed after every save. There are four options available:

1. Automatic Refresh with Repositioning of Cursor: When the profile is set to this option then screen is refreshed and also the cursor is repositioned to the original line from which the save operation was performed.
2. Automatic Refresh without Repositioning of Cursor: When the profile is set to this option then screen is refreshed and the cursor is always positioned on the first line.
3. Manual: With this option, users have to explicitly re-query to see the latest changes. Users are also not prompted with a message.
4. Askme: A dialog box is prompted for the users to decide whether they want to refresh the screen to see the new data. If the user selects yes, then the screen is refreshed. If the user selects No then screen is not refreshed.

With show lines = Yes , if we perform our cascade operations with Profile value is 
•    Automatic Refresh with Repositioning of Cursor
•    Automatic Refresh without Repositioning of Cursor
In such scenario cascade operation will be very time consuming , as cursor will move from line to line till it reach the last line ( as show lines = yes) and then system will reposition to Original record or First record.
On the Other hand other 2 option will not refresh the UI immediately after the cascade operations and also cursor position will remain same and total time consume by cascade operation will be very very less as compared if we choose other 2 options.
For more details feel free to contact us at sgupta@eoracleapps.com