BI Publisher
Discussion List
-
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 89 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 40 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 Long 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 121 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 92 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 786 views 3 comments 4 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 22 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… -
BI Publisher Bursting: Need to display report content in the e-mail body, instead of as an attachmenSummary BI Publisher Bursting: Need to display report content in the e-mail body, instead of as an attachment.Content Hi All, I have a requirement where I need to send a… -
OTBI report to view worker performance detailsSummary Report for line manager/supervisorContent We have a requirement to create a report to view employee performance details including past performance history to the…User_2025-01-28-21-18-43-496 75 views 2 comments 0 points Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM -
BI Report job outputsSummary Downloading all outputs in one goContent Hi guys, Do you know if there is any way to download all outputs at once? I have downloaded each sheet only separately. …Alvaro Couto 30 views 5 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Unable to use Organization field with person profileSummary Trying to use organization field with person profile data (education) in OTBIContent Hello I want to include Organization details (Organization Level 02 Name) in…Mohit Gupta-45440 54 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Custom report tablesContent We have a requirement to create a custom report to get division wise PD tasks status for following details. Appreciate someone can let us know the tables to refe…User_2025-01-28-21-18-43-496 57 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s…User_I6AXL 43 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Fusion Role vs Reporting RoleSummary Is there a way to see what the reporting role is for someone's Fusion security role?Content Hi all - when I look at the Fusion roles for our employees, I would l… -
FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Summary FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Content Hi All, I have formed the below query in BI Publisher Data Mod…