Report Delivery
Discussion List
-
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ… -
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 61 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 11 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Conditionally send report to email ONLY if query returns data resultsIs it possible to setup a schedule in BI Publisher to run every day that will only output a report to EMAIL if the query fetches at least one row of data? In other words…
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
Best practices for Journeys reporting in Workforce Management - Checklist Real Time subject area?Summary: Subject Area: Workforce Management - Checklist Real Time Need: Leverage best reporting practices to drive adoption rates and system monitoring for allocated jou…William_Johnson 101 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 42 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
OBIEE to FTP site?Content Does anyone know if it is possible to create a report in OBI and then drop it to a SFTP site? I don't see a way to do this using the delivery options in OBI, whi…User_2025-01-28-20-42-41-981 50 views 12 comments 0 points Most recent by Samarpan Reporting and Analytics for HCM -
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro…HarishVummidi 61 views 1 comment 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
BIP jobs are getting stuckSummary: BIP jobs are getting stuck Content (required): Hi Team, Greetings! We have been observing that multiple BIP jobs ( manual or scheduled) are getting stuck and re…Parag Hiremath 181 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBISummary: Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBI Content (required): Version (include the version you are us…Swati U 71 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 31 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 31 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle 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…Swati U 441 views 10 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Report Missing NotificationsHi All, We have loads of notifications we have from Oracle and few we develop custom. We have them scheduled and some are BI Bursting notifications. Due to multiple reas…Vibha Pandey - Oracle 41 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
I can't view a job option in more menu for default report ?I can't view a job option in the more menu and the scheduled job doesn't appear on the Manage Report Jobs page for default reports. but it works well and shows scheduled…New 41 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle BI Publisher Learning Center
-
Function to replace accent characters with respective characterSummary: Function to replace accent characters with respective character ex: O'Brian to O Brian, Noël to be Noel I need something like ascii using which it will directly…
-
I am working on one of the change only extract but I am not getting OLD values for few recordsSummary: I am working on one of the change only extract but I am not getting OLD values for few records Content (required): I am working on one of the change only with p…
-
Report on Assessment in LearningSummary: Hi Reporting Experts, Is it possible to build a report on assessment for OLC in which we can determine who has changed assessment questions and date and time of…Saurabh Pratap Singh 51 views 2 comments 0 points Most recent by Saurabh Pratap Singh Reporting and Analytics for HCM -
Can we have any job process to run HDL(.dat) file which output of BI reportSummary: Can we have any job process to run HDL(.dat) file which is output of BI report Content (required): Can we have any job process to run HDL(.dat) file which is ou…
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 41 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 332 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
How many WorkEmails can we add to a filter while creating a Filter in Alert ComposerSummary: Trying to add work Email Id's to an expression using 'OR' operator. Has anyone used it before and know how many emails can we use in one batch. Content (require…
-
Email Body not bursting correctly (22C)Summary: Content (required): Hi Since we went live with the 22C patch, notifications burst from OTBI are not including anything in the body of the email sent to recipien…