How to find out the query fetching the serial numbers in th LOV using the trace file o/p
Use the following steps to enable trace.
a. Navigate to the point in the application right before you are
experiencing the problem.
b. Turn trace on by:
Help > Diagnostics > Trace > Trace with Binds and Waits
c. Duplicate the issue and then stop immediately afterwards.
d. Retrieve trace file from the user_dump_dest, which can be located as
follows:
select value from V$PARAMETER where name like 'user%';
e. In the raw trace file ,search for the table 'Mtl_serial_numbers'
This will you take you to the query used in the LOV to fetch those serial numbers.
Use the following steps to enable trace.
a. Navigate to the point in the application right before you are
experiencing the problem.
b. Turn trace on by:
Help > Diagnostics > Trace > Trace with Binds and Waits
c. Duplicate the issue and then stop immediately afterwards.
d. Retrieve trace file from the user_dump_dest, which can be located as
follows:
select value from V$PARAMETER where name like 'user%';
e. In the raw trace file ,search for the table 'Mtl_serial_numbers'
This will you take you to the query used in the LOV to fetch those serial numbers.
No comments:
Post a Comment