Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
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
Mblankenship
Rank 1 - Community Starter
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:
0
Answers
-
Hi, Can you please share the error you are getting? what is the data source of your data set?
0
