Report Delivery
Discussion List
-
SQL to pull Number of Days between two dates (one is a Parameter Date)?I'm currently using BIP Report. This sequel works on me if I'd like to use SYSDATE: TO_NUMBER(TRUNC(SYSDATE) - TO_DATE(TO_CHAR(SEN.SENIORITY_DATE, 'YYYY-MM-DD'),'YYYY-MM… -
OTBI-ORC report issue on filter of candidate job application dateSummary: HI Team, when we apply the filter of candidate job application date report running long time without result but when we remove the filter on date it takes only …AjayKumar Maddipati 32 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to send UCM file as an email attachment using BI publisher reportSummary: How to send UCM file as an email attachment using BI publisher report Content (required): Hi Experts, We need to extract a PDF file from UCM and send as a email…Venkatesan 693 views 15 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
IN BI Report two parameters From Date to TO Date but need to change TO Date as sysdateSummary: Hi Team, I have changed parameter Todate as SysDate but it correct or not I'm not sure, any one could you please check this is correct data or not on below quer…AjayKumar Maddipati 21 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
IN OTBI Absence Real time issue on accrual balanceSummary: we have requirement is to show the report as ui(Annual accrual balance of annual accural ) in below screen shot but shown as below wrong Could you please assist…AjayKumar Maddipati 52 views 6 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Empty Reports on BIP Result files with DATA_DSSummary DATA_DS file removalContent Hello. I have created a daily BIP report that is sent to an SFTP, however the report is not expected to result in records every day. … -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 71 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…Jessica D 82 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
Vinay Prasad 21 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Watermark not coming in HTML ( Email body) outputContent We got a requirement to send an email (not an attachment in email) to user on his/her anniversary. We are trying to use BIP bursting concept to send an email. In…Naveen Jayaraman-48236 80 views 5 comments 0 points Most recent by Ruma Bhatnagar-Oracle Reporting and Analytics for HCM -
Problem with the sender for a bursting reportHi folks! I'm developing a simple notification with BI Publisher report using the bursting, but if I use for sender any address with domain @customer.com the system indi…Gian Luca Triglia 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to get bursting delivery detailsSummary: How to get bursting delivery details Content (please ensure you mask any confidential information): Hi All, We need to develop a BI report to show the bursting …Venkatesan 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Onboarding Report Jobs failingSummary: we have 15days and 30days reports but when we schedule the report it failing and even self also failed . we are used data parameters duration of 16 months . Det…AjayKumar Maddipati 42 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Host address in BI publisher reportIs it possible to get the host address in the BI publisher report? Regards, NivyaNivya Mathire 41 views 8 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Act as Proxy Manager for Line Manager DashboardSummary: As an HR user with view all, I am unable to proxy the line manager view what they can see in their own dashboard. In Workforce Compensation, there is Act as Pro…Sonia Canumay 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 62 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How do I download Diagnostic Test Reports?I have run several diagnostic tests regarding an issue we are experiencing. I can view the report, but am also needing to download the tests/reports in HTML. Does anyone…Alicia Martens 293 views 2 comments 0 points Most recent by Alicia Martens Reporting and Analytics for HCM -
How to join worker assignemnt real time and Higher education person Real timeSummary: Hi Team, We unable to add the two subject areas ? Any one assisatnce me on ? We need RACE colum from Higher education person Real time. Content (please ensure y…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 81 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Lookup Type-Lookup Code-Meaning Max LengthSummary Looking to confirm max length of Meaning field.Content Hello all! We are looking to distribute our labor distribution report. We enter the department number in l…Michael Cashin 960 views 12 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Is it feasible to Print an Entire Dashboard (with multiple pages)?Summary: Is it feasible to Print an Entire Dashboard (with multiple pages)? Content (please ensure you mask any confidential information): I would like to print an Entir…Harish Malik 31 views 4 comments 0 points Most recent by Harish Malik Reporting and Analytics for HCM -
Standard report to track dashboard and reports accessesHi, is there a standard report that is useful to track users accesses in Dashboard HR and also the detail on which reports in this dashboard they access? We configured t…Mara Tammaro 11 views 2 comments 0 points Most recent by Mara Tammaro Reporting and Analytics for HCM
-
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 21 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 307 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Scheduling a BIP Report for Biweekly...Summary Bi-Weekly schedulingContent HI All, I was wondering if there was any way to easily schedule a report to be run bi-weekly. We have some reports that need to be ru…User_2025-02-04-08-51-08-912 179 views 4 comments 2 points Most recent by Sree Latha Reporting and Analytics for HCM
-
Can we dynamically change paramters value in each execution run of scheduled BI report.Summary: We want to change the report paramter value in each execution run of scheduled BI report. Content (please ensure you mask any confidential information): Version…Sourabh_Patial 31 views 4 comments 0 points Most recent by Sourabh_Patial Reporting and Analytics for HCM
-
How to improve the performance of OTBI dashboards and reportContent Hi, We have created a custom dashboard. And few reports are taking long time to respond. Can someone tell me how can I improve the performance of Dashboards and …Nivya Mathire 86 views 12 comments 0 points Most recent by Rizwan Basha Reporting and Analytics for HCM
-
We have OnBoarding_15Days_Report but timeout error coming on below querySummary: Hi Team, we have OnBoarding_15Days_Report its runing ok but few days onwords we getting error is timed out error, we apply one year durationand even schedule al…AjayKumar Maddipati 41 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM