BI Publisher
Discussion List
-
Create a ORC Report with Records having hyperlink to ORCSummary Hyperlink to candidate ProfileContent Hi All, I have a requirement where I need to create an ORC report with candidate data. This report should have a hyperlink …Vibha Pandey - Oracle 49 views 4 comments 0 points Most recent by User_GIUF2 Reporting and Analytics for HCM -
Convert OTBI Analysis into BIP ReportSummary Convert OTBI to BIPContent Hi All, As our population in HCM is fast-growing, we are noticing some of the disadvantages of OTBI, performance, # of input records ,…User_KOLMZ 967 views 7 comments 1 point Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
BIP Report Bursting for L1 and L2 ManagersSummary BIP Bursting Report for L1 and L2 ManagersContent Hi Team, I am using a single Data Model and 3 Templates(for 3 different Jobs ). I am using two columns to pull …Anjan Polimera 30 views 2 comments 0 points Most recent by Anjan Polimera Reporting and Analytics for HCM
-
Combine Data tables in Data model as one similar to Union AllSummary Is there a way to combine tables in the Data Model which is similar to Union All? For example creating another table where they call all the table in the Data Mo…Mark kristan De los Reyes 38 views 4 comments 1 point Most recent by Denise Izzi Reporting and Analytics for HCM -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip …GauravGupta39 717 views 2 comments 0 points Most recent by Priyanka More-Oracle Reporting and Analytics for HCM
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 35 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for HCM
-
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 459 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 48 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 53 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 45 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 30 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 33 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_Arif 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 9 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 26 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 34 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 65 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 24 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 36 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 29 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 17 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 41 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 330 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] 42 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM