This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,890,294 Users
  • 2,269,776 Discussions


Issue in Discoverer period parameters

3501942 Member Posts: 1
edited Aug 8, 2017 1:34PM in Discoverer

We have developed a discoverer Report to fetch the GL period statuses with the parameters Period_From and Period_to and application_name. The Report is working as expected but in one case it is failing. When we give the parameter Period_from as 'ADJ' period and Period_TO as 'ADJ' period it is showing as No data found. The same if we run the query in SQl developer with the same parameters it is retrieving the data.

In Discoverer we have handled the conditions in parameters as per below screenshot.


If suppose we consider in Period_From as  'ADJ-15' and Period_to as 'ADJ-15' then the start date will be 31-dec-15. so if we run the query to find the period status for the start_date(FROM) >=31-Dec-15 and start_date(TO) <=31-Dec-15 it should retrieve the data, but its not retrieving in our case.So, Could anyone please suggest?..

This discussion has been closed.