1 / 6

Why is that LOV in the screen not returning me desired value?

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'.

brielle
Download Presentation

Why is that LOV in the screen not returning me desired value?

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Why is that LOV in the screen not returning me desired value? http://oracle.anilpassi.com

  2. 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

  3. 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

  4. 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

  5. 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

  6. Thanks http://oracle.anilpassi.com

More Related