Report Delivery
Discussion List
-
How to Trigger Bursting Email to Employee with 2 Attachments Along with Email BodySummary: Hi, We have developed a custom bursting report which has Email body configured in Parameter5 and single pdf attachement is generated based on rtf template. We g…puja suryanarayana 1 view 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages… -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 202 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 310 views 14 comments 3 points Most recent by Nathan CCC Reporting and Analytics for HCM -
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM…User_2025-02-05-22-13-16-277 929 views 7 comments 3 points Most recent by Aditya Jena Reporting and Analytics for HCM -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 67 views 14 comments 0 points Most recent by Milan_Chandra Reporting and Analytics for HCM -
In Bursting How to get email bounce back if email address is incorrectDeveloped email bursting functionality for users. However, when an email address is invalid, we need to capture the bounce-back. In the current design, emails are trigge… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser… -
Ways to securely send OTBI reports through agents?Summary What are the ways to securely send OTBI reports through agents?Content I think this has been asked a few times in the past, but just wondering what are the ways … -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.5K views 21 comments 1 point Most recent by SangeethaSekar-Oracle Reporting and Analytics for HCM -
Need to know DB table for BIP report history 'Output and Delivery' sectionHi team, We need table name to build report to extract 'Output and Delivery' (highlighted in orange box)from BIP report history, any help is highly appreciated. Regards,…Kalpesh Salunke-Oracle 1 view 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center -
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…Wouter.Schaap 51 views 6 comments 0 points Most recent by DanielJMcMillian Reporting and Analytics for HCM -
oracle.xdo.template.online.dms.common.XDODmsException: IO Exception was thrown! nullSummary: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.template.online.dms.common.XDODm…Malak 101 views 7 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
HCM Extract Delivery via emailSummary Attempting to send a extract via BI report in emailContent We have an extract setup that uses Bi to deliver the data in a report. In the extract, we are able to …Rob Stahly 706 views 7 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…MaheshRayudu7 61 views 2 comments 0 points Most recent by User_G9ACJ Reporting and Analytics for HCM -
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.6K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM -
What Oracle IP address(es) should be provided to recipients of reports via SFTP delivery option?Summary: We need to provide IP addresses to an external third party so that they can whitelist them in order to successfully receive BI Publisher reports directly from O…BeachDreamer 541 views 6 comments 0 points Most recent by User_525NM Reporting and Analytics for HCM -
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: …Welsey 4.6K views 6 comments 1 point Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):… -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end … -
Oracle Email Bursting QueriesHi Team,We have a requirement to develop a bursting report that should deliver only a long formatted email body without any attachments. The email body needs to include … -
There is time delay to display requested absence information in the tables.Summary: There is time delay to display requested absence information in the tables ‘ANC_PER_ABS_ENTRIES’ and ‘FND_BPM_TASK_B’, Is there any other tables can be used to …AntonyD 1 view 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Job Requisition Approval Workflow Template – Approval Comments Not VisibleSummary: Hi Oracle Community, I am working on the seeded Job Requisition Approval Workflow Notification Template in Oracle Fusion HCM and have run into an issue with app…Vishal Purohit 21 views 0 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe… -
Different vision in OTBI than in UISummary: Hello We have moved to a Redwood theme in our UI but then our OTBI report look at change. It now looks very old school. Also please note that when we open it in…LucieWS 11 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …Abdul Raqueeb 1 view 0 comments 0 points Most recent by Abdul Raqueeb Reporting and Analytics for HCM -
Bursting to get xml as an attachment from xsl templateSummary: Hello Experts, I have a report where I am using xsl template as layout. Our requirement is to send the report output in xml format to the destination email, but…Jaswant Prajapati 91 views 2 comments 0 points Most recent by User_DXHDL Reporting and Analytics for HCM -
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical… -
OTBI Agent sends spoiled action linksSummary: OTBI Agent sends spoiled action links Content (please ensure you mask any confidential information): Hi experts, I am working on the new job applications list O…Volodymyr Faranosov 11 views 3 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM -
Query optimization for HCM audit report with UNION ALL + UNPIVOT - need hints/index strategySummary: My audit trail query (HCM objects with UNION ALL for 30+ audit tables) was taking 12 minutes with left join on tables per_all_assignments_m and per_all_people_f…Vishal Purohit 1 view 0 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM