Forum Stats

  • 3,853,805 Users
  • 2,264,277 Discussions
  • 7,905,450 Comments

Discussions

Issue in Discoverer period parameters

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

Capture.PNG

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.