Report Delivery
Discussion List
-
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 13 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 -
Hide Schedule and Job option from reportSummary: Hide Schedule and Job option from report Content (please ensure you mask any confidential information): Hello experts, does anyone know how to hide the followin… -
Agents used to Schedule Analyses not working since 25DSince the 25D update, we can no longer edit or create new Agents for our Analyses. Everything was working normally before 25D. It looks like the update disabled the “Ena…Rebecca Hawker 1 view 1 comment 0 points Most recent by Rebecca Hawker Reporting and Analytics for HCM -
Restrict user to go to Analytics pageIs there a way to restrict user to access to Reports & Analytics page. From Structure i have disable the Report & analytics page from Navigator and springboard. But we a…Sourabh Patial 96 views 9 comments 0 points Most recent by Sourabh Patial Reporting and Analytics for HCM -
Problem with scheduling OTBI reports - error messagesContent I've set up loads of scheduled OTBI reports in the last few months. Although they are still coming through by email when they should, if I try to set up any new …User_2025-02-05-04-46-07-194 75 views 3 comments 1 point Most recent by Rebecca Hawker Reporting and Analytics for HCM -
In oracle BIP Bursting can we able to send 2 different attachments in one emailIn oracle BIP Bursting can we able to send 2 different attachments in one email -
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t…Helen Tilling 1 view 0 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM -
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…JMLMIII 61 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM -
How can I get Double Quotes in eText file for column data which has comma (,)Summary: How can I ensure that data containing a comma (,) is enclosed in double quotes when exporting a comma-separated values .txt file from Oracle Example 1 (No comma…JanardhanaKondaveeti 24 views 3 comments 0 points Most recent by MJ_ Reporting and Analytics for HCM -
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s… -
OTBI agent More Details - success?Some OTBI Agents More Details read: "Last Run 09/12/2025 8:00 AM GMT+00:00 | Agent Successful | Next Run 10/12/2025 8:00 AM GMT+00:00". Other agent More Details read "La…Stephen Jones 11 views 0 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
Multiple Absence Actions Sharing the Same Object IDwhen an employee submits an absence request and the status is Pending Approval, the employee can still edit or withdraw that request. The expected behavior in the databa… -
How to pull Survey results from a Journey in OTBISummary: Cannot seem to pull any results in OTBI using 'Workforce Management - Survey Journey Responses Real Time. Specifically need to easily and cleanly see Questionna… -
Can we use invalid custom 'From email address' for BI Report Notification?Hi Everyone, We are trying to personalize 'Email From Address' for BI Reporting Delivery. We have changed 'Email From Address' by navigating to /xmlpserver → Administrat…BinduTammineni 1 view 0 comments 0 points Most recent by BinduTammineni Reporting and Analytics for HCM -
Burst to Documents of RecordSummary BI publisher report bursting to DoR possible?Content Hey, We would like to create a BIP report (containing the approved notice period and other relevant data) in…Ann Van Roosbroeck 391 views 4 comments 2 points Most recent by Tara Samari-237472 Reporting and Analytics for HCM -
Bursting files by department code in .csv formatSummary: Bursting files by department code in .csv format is running into error. Content (required): I'm using this query to burst files by Bursting Key = department cod…Aloka Bhattacharya 775 views 8 comments 0 points Most recent by Hemanth Kumar Reddy Reporting and Analytics for HCM -
ESS Job Status Shows "Error" Despite Successful Report Output in Oracle FusionHi Team, We are facing an issue in Oracle Fusion Applications where a report or ESS job scheduled via "Schedule New Process" generates the expected output file, but the … -
BIP report scheduled with ET time zone and the report got triggered in UTC timescheduled the BIP report in ET time zone at 1:00 AM but the report got triggered at 9:00 AM ET. ca anyone help us to understand what causes this?Akhila.Allagadda 1 view 1 comment 0 points Most recent by Akhila.Allagadda BI Publisher Learning Center -
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…Saher 51 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Schedule BI Publisher report to run every first Monday based on Fiscal Month EndWe need to schedule a BI Publisher report which should be ran on every first Monday when the Fiscal Month ends. For exm : January 2025 Fiscal year starts from 12/28/2024…Lakshmi Prasanna Bandaru 22 views 1 comment 0 points Most recent by Shankar-Oracle BI Publisher Learning Center -
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need … -
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
What particular role or privilege needed to gain access to Manage Report Jobs page?Summary: What particular role or privilege needed to gain access to Manage Report Jobs page as well as the list of scheduled report jobs? Here's the example:Welsey 94 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM