BI Publisher
Discussion List
-
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 33 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 Kondaveeti 45 views 4 comments 0 points Most recent by Janardhana Kondaveeti 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 62 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 21 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 45 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 28 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 16 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 39 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 347 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 20 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] 38 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 34 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 25 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 39 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
-
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…Abhishek_Jain 91 views 2 comments 2 points Most recent by Hari Arumugam Reporting and Analytics for HCM
-
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 30 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM
-
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 248 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 42 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t…Prabhu Krishnamoorthy 6 views 2 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 191 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created…Prabhu Krishnamoorthy 18 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM