BI Publisher
Discussion List
-
Do we have any sql to identify the recruiting hirerarchy details?Summary Do we have any sql to identify the recruiting hirerarchy details?Content Would like to know if we have any sql for recruiting hierarchy details (like recruiting … -
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E…Dhanuka Chamal 428 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 51 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti…Ananya Sadhukhan 50 views 2 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for HCM
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…GTS Narayanen 44 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
SETSTAT is something that isn’t supported by AWS. How to solve?Summary Trying to deposit a file on a FTP but getting errorContent Hello, we need to deposit a file on an FTP of our partner. I'm using Oracle HCM BI. The configuration …Nicola Petri 27 views 1 comment 0 points Most recent by Hari Arumugam Reporting and Analytics for HCM
-
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected …Akshat Rajpurohit 30 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a …Alvaro Couto 32 views 3 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
in Hyperlink translated as %3c?EVALUATION_ID?%3eSummary in Hyperlink translated as %3c?EVALUATION_ID?%3eContent Hi, We are trying to add a hyperlink on BIP report with a EVALUATION_ID. EVAlUATION_ID is translated per…Salman 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not able to print pdf output after setting pdf security to true in report propertiesSummary Not able to print pdf output after setting pdf security to true in report propertiesContent Hi All, In order to avoid document modification we have set report le…User_XT9HW 12 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 24 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI…Janardhana K 33 views 4 comments 0 points Most recent by Janardhana K Reporting and Analytics for HCM -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …User_2025-02-10-15-06-52-222 63 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM
-
.cvs output file is splitting in 2 columns I want it one column only.Content Hi Experts, I have BI Report and I want output as .csv Tab Delimited. I did all setup and when I schedule this report I see output in 2 columns (A & B). I want i…User_2025-02-07-19-03-14-525 22 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Aggregate function on ValueSet is not workingSummary Aggregate function on ValueSet is not workingContent I have attached my query containing the where clause which is not working. Even the below value set is not w…Jaeyshree Kumaran 25 views 2 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM
-
Webservice to pull obiee reportSummary Webservice to pull obiee reportContent Hello all, Does anyone know how we can initiate a web service to pull a specific OBIEE report? Or is there a API that can …Nizar Kassam 30 views 2 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateSummary Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateContent Hi experts, I have an excel template ( from a benefits extract) in …Aloka Bhattacharya 18 views 1 comment 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
User Manual for adding OTBI report to HR dashboardSummary User Manual for adding OTBI report to HR dashboardContent Hi Team, Can any share user manual/White paper for adding a OTBI report to HR dashboard. Appreciate you…Dinesh Neredu 40 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho…Punam Roy Karmokar 21 views 2 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
BI Publisher Bursting Real Time Notification/TriggerSummary BI Publisher Bursting Real Time Notification/TriggerContent Hi experts! I need to create and send an email notification whenever a person has enrolled or complet…Raymund Jerome 301 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…Prudhvi Indukuri 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bursting Report With Multiple AttachmentSummary Bursting Report With Multiple AttachmentContent Hi Team We have a requirement to attach multiple document using busting query, How to add multiple attachment in …[Deleted User] 40 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en…Joe Roberts-Oracle 35 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 19 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t…Punam Roy Karmokar 26 views 1 comment 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Need Help : 9 BOX Talent ReviewContent Hi Expets, I have been looking catlog or some kind of link form which we can build or design 9 BOX Talent Review. Tried in different sources and not able to find…Kiran Kancherla 37 views 5 comments 0 points Most recent by Aparna Damle Reporting and Analytics for HCM
-
Post 21B release HRC_TXN_DATA.Data cache column doesn't show XMLSummary Approved/Rejected Global transfer transaction XML data is not coming up in HRC_TXN_DATA data cache column.Content Hi All, We are aware of HRC_TXN_DATA data cache…Hari Arumugam 43 views 1 comment 0 points Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…[Deleted User] 40 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM