Hi, what's the error you are getting? Regards Youssef

I am using Oracle BI Publisher 11.1.1.7.160719 (build:20160620.0157) The query above is for my class LOV How do I confirm that one or more params are null when it breaks? The "NULL Value Passed" option is selected so when the user select "All" Departments, a null value is passed to the class LOV and the ...(least(:P_DEPT)…

How do we capture queries when report job is fails? while scheduling report I did not see a diagnostic tab to choose log files, the only tabs I see are "General" "Output" "Schedule" and "Notification" Where do I find the log file to upload and check for the timestamp? Thanks

I am logged as admin but I don't believe this version has the same tabs or at least not at the same place? this is what I see

Thank Sven for the reference but I am not sure if the client will accept this workaround. Thanks Youssef

Hi Sven, I do pass null to pass all values using the least function. Using native BIP setup to pass all values doesn't work since their is more than 999 different values and form my understanding if we choose "all value passed" we are limited. The only workaround I found to pass more than 999 selection is to use the least…

Do you know how frequent the report is getting failed --> No I don't have this statistic but. I am trying right now and it is working but unfortunately it will fail later on. please check :p_bu does not have any data issues like in place of number there may be symbols--> BU has no symbols (only number data type and 3…

We use the report on demand. When the report fails it fails before the parameters load. I will schedule the report and hope to get information on which parameter is failing. Thanks for the suggestion, I will update the thread with the results.

Update: It's 4:15pm - Report is up and running again without no apparent changes Job Name : test Job Executed Date : May 25, 2018 4:16:51 PM EDT Status : Job was successfully processed

Hi Venkat, It seems to fail between 1pm and 3pm. the scheduler was was running fine every 5 minutes and now it failed with the following error. Job processor caused exception [INSTANCE_ID=srv-bidev-01.1489010620834] [INSTANCE_JOB_ID=2977]::::ERROR_GETTING_REPORT_DATA::[INSTANCE_ID=srv-bidev-01.1489010620834]…

Oracle BI Publisher 11.1.1.7.160719 (build:20160620.0157) I have 9 LOV / Parameters I attached the lov queries on .txt file. Thanks for your prompt response

Hi, try if the <?choose:?><?when:element!=""?> statement works --> try both quotes '' and double cotes "" For example: <?choose:?> <?when:MY_VARIABLE!=""?><?MY_VARIABLE?><?end when?> <?otherwise:?>3<?end otherwise?> <?end choose?> also, if your tag is within a repeating group you might want to add the path for example…

Hi, In addition you have a third option, it would be to call the image stored on a subtemplate https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3064 1-Create a subtemplate (.RTF as well) , add your image between template tag Example <template:logo> image<?end template?>…

Hello, Can you share your layout or screenshot and your xml sample data? You try to create two tables with 10 columns each and put a page break between them and create a repeating group. With more details I am sure we can help you. Cheers Youssef

Hi Tim, On the screen-shot we see the link as I hover over it but when I click on it I get an error. To answer your question, it's a reverse proxy which traffic redirect though. Regards Youssef

The workaround sounds good. Thanks Tim

Hello User, Please share your template. If the data are not visible, it could be due to your syntax on your meta data sheet. Regards, Youssef

Hi, You might want to refer to this thread Here's an example SELECT TO_DATE(TO_CHAR(TO_TIMESTAMP ('1999-02-08-08.16.14.534441', 'YYYY-MM-DD HH24:MI:SS.FF'),'MM-DD-YYYY'),'MM-DD-YYYY') as date1 FROM DUAL Regards, Youssef

Hi, Please give us more details on what you are trying to achieve? From my understanding you need two date parameters so you can add in your data set query SELECT ... FROM .... WHERE DATE BETWEEN :DATE1 and :DATE2 OR by period of time you mean Period 1, Period 2, Period 3,... and so on... ? In that case you need to handle…

What's the error? Also, can you share your template and XML file? Regards, Youssef