why is that lov in the screen not returning me desired value n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Why is that LOV in the screen not returning me desired value? PowerPoint Presentation
Download Presentation
Why is that LOV in the screen not returning me desired value?

Loading in 2 Seconds...

play fullscreen
1 / 6

Why is that LOV in the screen not returning me desired value? - PowerPoint PPT Presentation


  • 95 Views
  • Uploaded on

Why is that LOV in the screen not returning me desired value?. Debugging LOV In a EBS screen, the LOV in this form does not bring back any records (in D2K) ?. Find the trace file location On the SQL*Plus run to find trace directory select value from v$parameter where name like 'user_dump_dest'.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Why is that LOV in the screen not returning me desired value?' - brielle


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
debugging lov in a ebs screen the lov in this form does not bring back any records in d2k
Debugging LOVIn a EBS screen, the LOV in this form does not bring back any records (in D2K) ?

Find the trace file locationOn the SQL*Plus run to find trace directoryselect value from v$parameter where name like 'user_dump_dest'

Use help/diagnostics to enable trace

Set trace with binds and waits, using help menu. Using the “binds” option, you will get to see value of the variables in SQL.

Go to database machine, to the trace directory, and ensure that you can access that trace file on the DB Server

You will be shown the path & name of the trace file

Now for test case, enter value in LOV field, and tab out to initiate SQL behind the LOV on that field. By doing so, this SQL that retrieves data for LOV will get written into the trace file

http://oracle.anilpassi.com

debugging lov
Debugging LOV

Inside the trace file, you can see the SQL and its bind values`

The trace files shows the SQL that was executed

For each SQL statement, you will also see the variable values in the trace file

:1 equates to Bind#0:2 equates to Bind#1Hence you can construct the exact SQL that screen is running

Extract the SQL with its Bind Variable Value so that it can be run offline in SQL*Plus Session

http://oracle.anilpassi.com

instead of running the trace can t i simply open the form and see the query in record group
Instead of running the trace, can’t I simply open the form and see the query in Record Group?

Yes, you can but :-Trace file gives you the bind variable valuesThe record group might have been altered programmatically or by Forms Personalization or from CUSTOM.pll. Hence using this technique, you get the end product SQL statement

http://oracle.anilpassi.com

other scenario s where this technique is useful
Other scenario’s where this technique is useful

You might be requested to develop a report that prints the data that is displayed from a screen. In this case, you can nick the SQL’s that screen uses, fine tune them for performance, and your report is almost ready.

You may wish to know the list of inserts/updates & deletes that are taking place from a screen, during data entry.

You may also wish to find out the SQL Statements/Cursors that are executed/fetched for validations.

http://oracle.anilpassi.com

thanks
Thanks

http://oracle.anilpassi.com