Hi bwdata, Basically, you are inquiring about how to know the email delivery status that is triggered from BI. For BI Publisher report jobs, you can review the Output delivered status from the "Report Job History" page. Still, if the status shows as delivered but no email is received, you need to reach out to support to…

Hi Kevin, You may review this help center doc: https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/access-favorites-easily.html Regards, Raghavan

Hi , @DhanashreeG if data does not exist in a specific column, don't think any feature is available to make the report job fail with warn/error. Alternatively, you may try adding a trigger in the data model. https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/triggers.html…

Hi @User_Y2R87, Try below: === Select TO_CHAR( ADD_MONTHS( TRUNC(SYSDATE,'YYYY') , LEVEL-4 ), 'YYYYMM' ) Month FROM dual CONNECT BY LEVEL <= 12 ==== Best Regards, Raghavan

Hi, Which Subject Area(SA) are you using? Do you mean to say, that no separate columns are available in that SA? Regards, Raghavan

Hi, Generally {$SYSDATE()-1$} means the previous day, I don't think hours can be deducted. Let's see if anyone shares some info on this. Regards, Raghavan

Hi, To understand more about the access issue. Create a new user and assign an Employee role, BI admin role and check whether you can set up an FTP connection. Oracle Fusion BI: How to Add the BI Administrator Role to a user. (Doc ID 2238277.1) Regards, Raghavan

Hi Nita, What do you mean by ' it's possible to write log files for Custom ESS BIP job or not?' can you please elaborate more? Regards, Raghavan

Hi, Check this thread if it helps: https://community.oracle.com/customerconnect/discussion/546466/creating-dependent-prompt-in-otbi-analysis Regards, Raghavan

Hi Sharmila, >You may create a BIP report and pull UCM attachments. How to create Custom UCM datasource To Retrieve The Text Attachments for PDF ? (Doc ID 2643214.1) PRC:PO: How To Customize The Data Model To Retrieve The Text Attachments From Ucm And Display Them In Po Pdf? (Doc ID 2384563.1) >The same can be delivered to…