BI Publisher
Discussion List
-
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 200 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM -
Fields for day start week and end weekSummary Create 2 fields in OTBI report for start date of the week and end dato of the weekContent Hi, Sorry for the dummy question but I couldn't figure out how to do it… -
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar…User_MC37Q 74 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to get the from email address in BurstingContent Hi All, In the bursting query for the parameter3 value we are passing "bipublisher-report@oracle.com" and able to get the email after report submitted. If we use…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Hire/Seniority DatesSummary How do I report on these dates in OTBI/BIP?Content Hi all - I know that Julian had a great post about what the individual dates are (https://cloudcustomerconnect…Prudence K 145 views 7 comments 0 points Most recent by User_2025-01-25-01-10-42-578 Reporting and Analytics for HCM -
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 40 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C…User_MC37Q 90 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
BIP BurstingSummary Image in RTF Template received as attachment in emailContent Hi, We have a requirement to have company Logo and some images in the email notification, which will…Sivakumaran Muthusamy-Oracle 112 views 4 comments 0 points Most recent by Unknown Reporting and Analytics for HCM -
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…User_MC37Q 37 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Release 13 - 50000 cell limit in BI Answers??Summary Our reports no longer can export the data they need!Content Hi all, Following our upgrade of release 13 there seems to be a limit on 50000 cells exported, we hav…Kevin M Storrie 181 views 33 comments 2 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' …Mohit Gupta-45440 119 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Possible to embed link to run a report, inside a Dashboard pageSummary Embed link to run a report, inside a Dashboard pageContent We have a request to embed a link in a Manger's Dashboard that will allow them to run a pre-built repo… -
OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format)Summary OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format) should come up.Content Hi, I have a OTBI analysis where I ha…User_MC37Q 56 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
How to give incremental Sequence in a Bi ReportContent Hi, I have requirement to create position report where I need to give sequence number like 1,2,3 etc. What need to used in data model to achieve this in BI publi…User_2025-01-31-01-21-22-432 84 views 2 comments 0 points Most recent by User_2025-01-31-01-21-22-432 Reporting and Analytics for HCM
-
Handling data field containing a comma while generating CSV files using etext templates in BI PublisSummary Handling data field containing a comma while generating CSV files using etext templates in BI PublisherContent Hi, I have an etext template to create a .csv (com…Aloka Bhattacharya 745 views 3 comments 3 points Most recent by Timothy Orrange Reporting and Analytics for HCM -
Can we use run time parameter in Bursting?Summary Email BurstingContent Hi Everyone, Can we use parameter in bursting like we use in our sql. Regards, Poornima PaliwalUser_2025-01-31-01-21-22-432 44 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…User_2025-01-25-04-02-13-126 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to receive assignmentId from Compensation Page & pull out Legal Employer based on itSummary How to receive assignmentId from Compensation Page & pull out Legal Employer based on itContent Hi guys, we are facing an issue related to compensation page. In …User_2025-01-28-21-18-09-074 40 views 14 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Areas of Responsibility assign to workers- how can we pull data in reports?Content Hello, If someone can share his knowledge regarding how can we pull the data - responsibilities assigned to workers? we want to track the employees's areas of re…User_2025-01-22-19-54-47-882 73 views 4 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu…
-
Scheduler Account LoginContent Hi all - we have a problem we are hoping you can assist :) Right now, we have a few developers that will schedule reports. However they are the only ones that ca…Prudence K 36 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Scheduled processes reportSummary need to create a report to show all our scheduled processesContent hi, we have a lot of Scheduled processes who run every day. need to create a report showing al…User_2025-01-30-04-14-21-127 169 views 2 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for HCM
-
FTP using PPKContent Hi all - need your help on this one! I am not overly familiar with using FTP, but can muddle my way through when using a regular set-up (host, login, password). …
-
BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Summary BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Content Hi, I would like to know when is a entry made into table:PER_CONTRACTS_F. I beli…
-
Converting BI Analysis to BIP (Easily)Summary Need to convert existing analysis to BIPContent Is there an easy way, if any, to do this? -
Need to use 2 stand-alone data groups in an extract without any connect clauseSummary Need to use 2 stand-alone data groups in an extract without any connect clauseAloka Bhattacharya 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher …
-
In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Summary In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Content Hi All, In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE…