Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Have issue with Period Name returning data on two reports - Disposal and Fixed Asset

Received Response
14
Views
1
Comments
Mblankenship
Mblankenship Rank 1 - Community Starter
in Oracle Analytics Publisher

We have two reports that we are trying to return data on and using the following clause: (this is a parameter and a column in the report)

WHERE 

(fdp.PERIOD_NAME IN(:P_Asset_Calendar_Period_Name) OR 'ALL' IN(:P_Asset_Calendar_Period_Name || 'All'))


Period Name is a text field, but running into time out issues when All is selected or no data retuning when Null or multiple are selected. Any one have any ideas, I have two developers working on this for 5 days right now and we need some help.


Oracle Fusion

BIP reports

Tagged:

Answers