Forum Stats

  • 3,853,481 Users
  • 2,264,226 Discussions


how to confirm LOV's sql statement

Richard_001-Oracle Member Posts: 65 Employee
edited Mar 6, 2019 10:59AM in Discoverer

our customer wants to confirm lov's sql statement,because they are checking what objects are used by lov before

they upgrade to ebs 12.2.7.

we know custom folder will be used to create item class for lov,so for confirming the sql statement executed for lov

they have to extract sql from custom folder,that means they should use the sql below Note

Where The SQL For Discoverer EUL Custom Folders Is Stored (Doc ID 1323871.1)

but the above Note is limited now,we are not sure if we can guide it to customer,

could anyone advise us on this? or if there is any other way to accomplish confirming lov's sql?




  • sbeck-Oracle
    sbeck-Oracle Member Posts: 116 Employee
    edited Mar 6, 2019 10:59AM

    Hello Richard,

    Please be aware that premier support for Discoverer 11g ended June 2014.  Version is the final / terminal release of the Discoverer product.  Discoverer is at end of life.  Any software update (OS, browser, Java, WLS, EBS, etc.) released after June 2014 has not specifically been certified or tested and may cause issues for Discoverer.  Therefore, it is important to maintain a stable Discoverer environment for as long as it takes to move to OBIEE or other replacement.

    You are correct, Note 1323871.1 is no longer available and will not help your customer.

    If a custom folder was used to create the LOV, the SQL that created it is accessible using Discoverer Administration edition (Admin). 

    In Admin, select (highlight) the Custom Folder.  Use the right mouse button and choose Properties from the menu.  In the properties you will see the SQL used to create the custom folder. 

    See Discoverer Admin guide, chapter 6, section "6.11 How to edit a custom folder's SQL statement" for more information on how to use Admin.