BI Publisher
Discussion List
-
How to use Hyperlink in RTF templates?Summary: Hello Experts, Is it possible to use Hyperlink in RTF templates? Like, in the report output, the Person Number attribute will have a hyperlink, once the user cl…Abhishek Premchandra-Oracle 804 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to split by page break with the date rangeSummary: Can we apply split by page break with in the date range? For example if we pass date parameters with in the 3 weeks date range, then report should pull 1st week…User_YPR68 22 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Application channelSummary: Mobile vs Desktop - Is there a way to report on how candidates are applying, whether it be on a mobile device or from a desktop/laptop? Content (required): We a…Mitch_123456 21 views 1 comment 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
How to split excel template into multiple sheets for each employeeSummary: We need to split the excel template into multiple tabs for each employee. For Example if any excel template has 3 employees in the output, then we need to split…User_YPR68 1.1K views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 325 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
in RTF how to use a parent attribute for comparison inside a child repeating group while summingSummary: In a rtf template we are trying to compare the value of child attribute to a parent attribute if the value matches then the sum of an child repeating attribute …Gadigeppa Boragalli 435 views 0 comments 0 points Started by Gadigeppa Boragalli Reporting and Analytics for HCM
-
Any way to find that scheduled BI report is running or got struckSummary:Any way to find that scheduled BI report is running or got struck Content (required): Hi All, We have scheduled a Custom BI Report to pull some payroll related d…Charan Kollipara 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
How to change path color for a node path in Hierarchy TreeSummary: Change color of the node path in Hierarchy Tree. Content (required): Hi All, We are creating a manager hierarchy tree report, our client wants to change the col…User_GFPRZ 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
List of All reports in BI PublisherHi Experts, Do we have any table or web service that can list out all reports present in a BI Publisher instance? So far we have used: XXXXX.oraclecloud.com:443/xmlpserv…Aloka Bhattacharya 506 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP Report is missing the schedule - How to find the reason for the miss?Summary: We have a BIP report which is scheduled to run daily with scheduled end date in 2024. However, the report hasn't run since 15th Sep. It is not failing either. H…MandeepGupta 16 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Printing details on a single row using a EText Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 135 views 8 comments 2 points Most recent by Bhupendra Singh Rawat-Oracle Reporting and Analytics for HCM -
BIP - Talent RatingsSummary: Hello, Good day! I'm running a report in BIP but facing performance issue when I'm trying to create multiple data sets. One data set for employee details and on…Hazel De Castro 24 views 0 comments 0 points Started by Hazel De Castro Reporting and Analytics for HCM
-
Consolidated List of OTBI and BI Publisher Reports Posted (10 August 2015)Content The following is the list of published OTBI and BI Publisher reports for Fusion HCM between 15 June and 10 August 2015: * Address Changes After Date * Marital St…Julian Challenger-Oracle 343 views 5 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 322 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Training, Documentation, FAQs and moreContent Just a reminder that there is a knowledge article on My Oracle Support that provides a wealth of information on HCM Cloud OTBI (and also some on BI Publisher). Y…Julian Challenger-Oracle 540 views 6 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Table which stores the descr (or Meaning) of ASSIGNMENT_TYPE AND PERIOD_TYPE field valueSummary: Hi All, I see the Per_all_assignment_M have the assignment_type as one/two letter words. Which table I can able to see the descr? Same of the PERIOD_type in Per…Prabhu Krishnamoorthy 43 views 1 comment 0 points Most recent by MandeepGupta 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…
-
P45 filing dateSummary: P45 filing date in OTBI (or SQL code if not in OTBI) Content (required): Does anyone know where in OTBI I can find the P45 filed date (see bottom of screenshot)…
-
BIP Report - Performance & Potential RatingSummary: Hello, Does anyone know how can I create report out of this sample data by means of using BIP? Best Regards, Content (required): Hello, Does anyone know how can…Hazel De Castro 48 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 350 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Hyperlinking BI Publisher reports in a DashboardContent Hello, We have a requirement to create a dashboard which will list all the reports available for certain user popluation. As per screenshot you can see that we m… -
Rtf template special character errorSummary: Content (required): Hello everybody, I was having a problem concerning the extraction of certain data to insert in an rtf template in word. In particular, extra…Gerardo Peluso 41 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Can't see 'Administration' Tab in Catalog?Summary: Content (required): Can't see 'Administration' Tab in Catalog after the last update? any feedback? note: the user has all related (HR Analyst, Admin Roles, and …Walid Hamdy 55 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
BI Publisher report formattingSummary: I have a BIP report that I need to export (to FTP eventually) to CSV format but I cannot get the formatting to stay. Content (required): The BIP report needs to…Scott Conaway 21 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
NI thresholds - How to report in OTBISummary: Please can someone confirm if it is possible to report on NI thresholds using OTBI. Alternatively, which table in BIP can we derive the NI thresholds from Conte…
-
Locate Job Requisition Submissions Questionnaire ResponsesSummary: Hi all, I am attempting to write a BI report that will show an applicants response to a specific question asked during the job application submission. Can you p… -
How can I query uploaded learning content?Summary: Is there an easy way in BIP to query learning content title and file name? In my particular case they have been batch uploaded via REST API, but I don't think t…
-
Ask for table name - who answered the questionnaire, the questions and answersSummary: Ask for table name - who answered the questionnaire, the questions and answers Content (required): Table name for Questionnaire related have found the following… -
ORA-01841: (full) year must be between -4713 and +9999, and not be 0Summary: Encountering an error ORA-01841: (full) year must be between -4713 and +9999, and not be 0 when trying to pull a value from the element's input value. Data type…RenzelkeithCoquia 366 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM