Report Delivery
Discussion List
-
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 62 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…Janardhana Kondaveeti 21 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 IDThere was an error rendering this rich post.
-
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 385 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 769 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 21 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 15 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 98 views 9 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
HCM Tables which store BIP/OTBI Scheduled Report email recipientHi Team - We've requirement to list down all the BIP & OTBI reports which are scheduled along with their email recipient details. (some notification could be dynamic bas…
-
BIP Bursting to Email:Output sent as URL:Ability to Change the Position of the URL in the Email BodySummary: BIP Bursting to Email: Output sent as URL: Ability to Change the Position of the URL within the Email Body Content (please ensure you mask any confidential info…
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
How to Trigger 'Send to Fixed Email' for an Integrated Report in a Dashboard Using Action LinksHello, We are trying to automate a dashboard that contains a report (prompted by an OpportunityID) to be sent to our automation server, for example, via a button. Unfort…Marc Joel Oyen 1 view 0 comments 0 points Most recent by Marc Joel Oyen BI Publisher Learning Center
-
Multiple pdf outputs to be sent to single emailSummary: Hi We are looking for sending multiple pdf's from a report, to a single email using bursting query or to be zipped and sent to a single email Content (please en…
-
セールスクラウドで、ロックされたユーザーのリストを毎日出力したいセールスクラウドのユーザーでロックされた人のリストを出力し、毎日特定のアドレスにメール送信したいです。 BIのエージェント機能を使って送信できたらと思うのですが、確認できる…
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says …
-
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 4 comments 0 points Most recent by Eveve Reporting and Analytics for HCM
-
Is there a way to increase the BI Publisher FTP connection timeout?We are currently utilizing a BIP report as part of an integration process with an external system, transmitted via FTP. While the process executes successfully on most d… -
BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the YeaSummary BIP: For Year Parameter, Set Default Value as Current Year and attach LOV (SQL Query LOV) to the Year ParameterContent Hi, This is related to earlier post: https…User_MC37Q 1.1K views 5 comments 1 point Most recent by NIRMAL KUMAR L Reporting and Analytics for HCM -
OTBI output is different for 2 different usersSummary: Hi, We have a custom OTBI report which is scheduled to send report to the Business Users. This report shows that 100 employees have missing family contact infor…Sailajad 21 views 8 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for HCM