Hi Rhea, You have to select "Is Greater Than" condition and then add SQL Expression as TIMESTAMPADD(SQL_TSI_DAY, -7, CURRENT_DATE) See the attached image. Hope this fixes the issue. Regards, Arun

Here is a post that may be helpful https://cloudcustomerconnect.oracle.com/posts/c7acda6e57

Hi Divya, * Create a Data Model * Create 2 Data sets in the data model * Use excel template. Here is a link to Creating Excel Template * On one sheet of the Excel Template fetch data from Data Set 1 * On 2nd sheet of the Excel Template fetch data from Data set 2 Thanks, Arun

If there are standard packages used in the data model it may not compile / save correctly when you customize it. I would rather build a new report with the custom logic. Also check if you can use any of the OTBI subject areas to build a new analysis. Thanks, Arun

Hi Divya, Is this OTBI Analysis? Are these from two different subject areas?

I doubt if there is a global option to set the default format. As far as I know you will have to set the default format while creating the report (like i have showed in the word document). May be someone else has a better answer. Thanks, Arun

I have attached a word document that shows how to set a default output format for a report. Thanks, Arun

Hi Satya, Are you trying to create a new custom Data Model? Or trying to customize and existing one? Thanks, Arun

Take a look at "Customize Global Page Template" option. Thanks, Arun

Check fusion.ess_request_history table. If the table is what you are looking for then create a BI Publisher report and you can export the output to Excel / PDF / Word etc. Thanks, Arun

I believe the cloud subscription comes withe Cloud FTP Server. Check if you can utilize the Cloud FTP Server to place your logos. Thanks, Arun

Hi, You cannot create custom packages. Check if there are similar reports in Cloud. The best way is to customize standard reports provided in Oracle Cloud to suit your needs. Thanks, Arun

Hey Dario, Try this out. I didnt get a chance to try it. But let me know if this works. 1. Create an additional Parameter. I am calling it :DRIVER_PARAM. This will have 3 values associated with it "ALL", "MULTIPLE","SINGLE". 2. For the :PARAM value set, dont select the option "Select all" 3. Parameter Selection * The user…

Hi Dario, Did you check my response on 08/29? Did that help? Cheers, Arun

Hi Dario, Lets say that you have the below SELECT statement. SELECT * from EMPLOYEE where emp_num = :PARAM ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Choose the option "pass null value"…

Hi Dario, Is this a BI Report? or a OTBI Analysis? Thanks, Arun

Hi Tim, I believe that is the SQL in the package. For the custom report are you trying to add additional fields? Is this something that you may be able to achieve without modifying the standard package? Thanks, Arun

Hi Tim, Even I couldn't find any information in OER or in support.oracle.com. I found this link though. Not sure if this is going to help. http://demo.enginatics.com/reports/SQLAP_Invoice_Aging_Report_Not_Supported_Reserved_For_Future_Use.html Thanks, Arun

Thanks for the info on Payroll Flow Patterns. I am reading about it. My experience is mostly on Financials :) I agree with you that we need more details from the experts. Regards, Arun

Ashish, Correct me If am wrong. If there is a standard PVO for person_number then Pranav may be able to use it for LOV in a custom ESS Job. As far as I know table validated Value Sets cannot be attached to a parameter as a LOV at this point; meaning you cannot create a custom value set (table validated) and then use it.…