Performance Issue on the Quote Form in R12:

Performance Issue on the Quote Form

Step 1: run Apps Check  & to find Database Triggers

Note :See Note 739401.1 - R12 Diagnostics APPS CHECK Report: OMCHECK.sql

Please disable the  custom triggers only

ALTER TRIGGER <triger-Name>  DISABLE;

2. Please verify the results of the following query,so we can review the trigger details:

set markup html on;

spool Trigger_details.html;

select trigger_name, when_clause, status, description, trigger_body  from dba_triggers  where trigger_name in ('SVRASO_QUOTE_HEADERS_AI','SVRQOT_CUST_PART_NUM_HEADER','SVRQOT_CUST_PART_NUM_LINES');

set markup html off;

spool off;

Note: After disabling the Custom Code the performance of this form has become normal / still issue the performance

3. Since you were unable to generate the debug log, please generate a sql trace so that we can see where the time is being spent when the issue occurs:

- Make sure all the debugging profiles are disabled.

- Enable the trace by selecting > Help > Diagnostics > Trace -> Trace with Binds

- Reproduce the issue by entering a line on one of the quotes where performance is slow

- After the line is saved, Disable tracing by selecting > Help > Diagnostics > Trace > No Trace

- Gather trace file from the location given by the system when you enable/disable the tracing

- Upload the raw trace file to the SR

- Then using the raw trace, generate a sorted tkprof and upload this as well

Example: tkprof traceN.trc traceN.out explain=apps/apps sort='(prsela,exeela,fchela)'

4. Upload the Quoting debug logs generated while reproducing the issue

See Note 430265.1 for instructions on generating these logs.

+++++++++++++ID 1368018.1.+++++++++++++++