BI Publisher
Discussion List
-
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed … -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than…
-
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order…
-
SQL Query to fetch Talent Profile History DataSummary SQL Query to fetch Talent Profile History DataContent Hi Experts, How to fetch Talent Profile History Data. Please provide SQL Query. Regards, Bala Version 20AUser_2025-02-05-04-17-04-394 379 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Reports got failed when scheduled in DEV3 completed in DEV2Summary Reports got failed when scheduled in DEV3 completed in DEV2Content Some of our reports got failed when scheduled in DEV3. On analysis we could see that the Data …User_2025-02-06-15-04-02-124 17 views 3 comments 1 point Most recent by Visu Reporting and Analytics for HCM
-
SQL to pull Previous Line ManagerSummary Sample SQL to pull Line Manager from the Previous Assignment RowContent We have created a data model that pulls most current assignment row where actions = Promo…
-
Tables for getting user information under Security consoleSummary Query to get security console User infoContent Hi All, I am developing a BI Publisher report to get the User information that is available under Security console…SuryaMuralidharan 880 views 5 comments 0 points Most recent by Ravi Shinde Reporting and Analytics for HCM
-
How to identify resubmitted goals for approval?Content Hi, I am creating a goal status report where I am able to get proper goal status from the table HRG_GOALS with column GOAL_VERSION_TYPE_CODE except for those who…Nivya Mathire 56 views 6 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Is it possible to initiate HCM BI Publisher Reports from a batch script on a seperate server?Content We are hoping to integrate HCM to a custom EPM implementation using BI Publisher extracts.We are hoping to integrate HCM to a custom EPM implementation using BI …Mike Falconer-160618 39 views 1 comment 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM -
Hide options in cogwheel on embedded DashboardSummary As the title implies, we have a dashboard that we would like to hide some options on.Content Hi all, In the attached picture, we have two dashboards -- the botto…CIT Shane 22 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
General BIP Report AssistanceSummary I have a series of questions about a BIP report I am trying to developContent Hi all, I just have a series of questions about BIP reports/Dashboards when embeddi…CIT Shane 56 views 9 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
User Role Historical DataSummary Getting the Historical data of RoleContent Hi, Is it possible to get the historical data of User Role in HCM? We are not using the End_date on the user role, but…User_2025-02-04-07-19-57-588 63 views 5 comments 1 point Most recent by Ravi Shinde Reporting and Analytics for HCM
-
BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMSummary BI Report: Restrict Line manager access to only his/her reportees in BI Report in Fusion HCMContent Hi All, Please find below URL; https://youtu.be/XSt2S3xBBx0 T…
-
(Under Oracle Review) Data Dictionary for ReportsSummary Create Data Dictionary for ReportsContent We want to have a data dictionary of our reports created Can this be pulled via SQL. 1. Path 2. Report Name 3. Report D…User_2025-02-04-14-57-35-200 50 views 8 comments 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM
-
Creating Charts in BI PublisherSummary Need resources on how to design charts on BI Publisher reportsContent I am needing to create some statistical charts from BI Publisher reports. I have gotten so …Shelly Feyerherm 47 views 2 comments 2 points Most recent by Tom Strudley Reporting and Analytics for HCM -
Error on Report Template - java.lang.ClassCastExceptionSummary In the data model, all is good, data is is showing but when I run the report template this error pops out "java.lang.ClassCastException". Please see attached ima…Mark kristan De los Reyes 19 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Generate barcode in PDF outputContent Hello, I am trying to generate the bar code in a RTF template with an output as PDF. When I use the output as HTML or any other the bar code is printed correctly… -
Recover Deleted Report or FolderSummary How can I recover a deleted report or folder in any environment after deletion?Content Hi all, I would like to know if there is a recover option when a report or…User_2025-02-05-05-51-12-049 84 views 2 comments 0 points Most recent by Karina Ogata Reporting and Analytics for HCM
-
Need past 8 years historical data based on a effective date-OTBI analysisSummary Need past 8 years historical data(Counts based on their color) based on a effective date-OTBI analysis, We need to show data in a Graphical format attached.Conte…Nithin Channa 49 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Selecting All outputs in ESS Job by default?Summary Selecting All outputs in ESS Job by default?Content Hi All, I have created a report with 6 templates and i have created ESS Job for it. I can able to select all …User_2025-02-06-10-33-36-755 33 views 1 comment 0 points Most recent by Lucky Sharma Reporting and Analytics for HCM
-
Data Models Best PracticesSummary Are the Best Practices for Building Data Models using Tables vs. ViewsContent Wondering if there are best practice guidelines for building Data Models? For examp…Denise Izzi 55 views 4 comments 0 points Most recent by Valeriy Gorbunov-80491 Reporting and Analytics for HCM
-
How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisSummary How to get the Latest Hire Date of Employee and compare the same with DFF attribute in OTBI AnalysisContent Hi All, We have a DFF attribute called Beneficial ser…
-
SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBISummary SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBIContent Hi All, Can some one explain to me that how does the below conditions work and what's the in detail meaning…
-
How to fine tune OTBI reportSummary How to fine tune OTBI reportContent Hi All - We created an OTBI report using 2 SA's and embedded it on UI using sandbox for line managers. This fetches assignmen…User_2025-01-25-04-02-13-126 55 views 6 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Need to restrict Moving folders from one folder to another Folder in BISummary Moving BI Folders from one folder to another folderContent Hi Team, We want to restrict Moving the BI folders from one folder to another folder in BI. please sha…
-
Duplicate Values in OTBI ReportSummary Receiving duplicate employee lines due to historical manager changesContent When running a report in Subject area "Worker Assignment Real Time" everything is fin…User_HR5ZQ 519 views 1 comment 0 points Most recent by User_2025-01-30-17-37-30-647 Reporting and Analytics for HCM
-
Logical and Relational Data Model Diagrams For Fusion Applications HCMSummary Logical and Relational Data Model Diagrams For Fusion Applications HCMContent I wondered if there was an updated Fusion Cloud HCM data model to easily identify t…Ruzwan Akram 502 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI vs BIPContent All - on Julian's OTBI call today, I asked about the benefits of using OTBI vs using BIP. I am aware of when we use BIP instead of OTBI (data not available in OT…Prudence K 1.9K views 18 comments 18 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Changing Report Schedule which is running as ExtractSummary Changing Report Schedule which is running as ExtractContent Hi All, I have a report running as an Extract. I want to change schedule of it. Can someone guide me.…User_2025-02-07-19-03-14-525 32 views 2 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM