Core HR
Discussion List
-
Not able to View Job history for OBIEE Agents in Fusion HCMSummary Not able to View Job history for OBIEE Agents in Fusion HCMContent Hi, As of now in OTBI we are not able to view the job History for the Agent? this feature is v…Pradeep Akula 28 views 3 comments 2 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI) -
OTBI Reports take into Account AoR settings ?Summary OTBI Reports take into Account AoR settings ?Content When running an OTBI report would they only see employee data in the output according to their Area of Respo…Ruzwan Akram 41 views 2 comments 0 points Most recent by user2992875 General Transactional Reporting (OTBI)
-
Pivote future is available in OTBISummary Pivote future is available in OTBIContent Hi All,ecause of I have the requirement to develop the exit clearance report using OTBI.In Current case i am getting 10…vijay salve-151928 34 views 5 comments 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI)
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…
-
Usage of LAG function in Oracle BIP's child data set - Any Limitations?Summary Usage of LAG function in Oracle BIP's child data set - Any Limitations?Content Hello, I am trying to LAG function in a child dataset of Oracle BIP but it gives a…SantoshKumarB 15 views 1 comment 0 points Most recent by SantoshKumarB General Transactional Reporting (OTBI) -
is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ?Summary is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ?Content Hello,We would like to know if there is an existing report …Revital Mefano 45 views 3 comments 0 points Most recent by Gina Consalvo General Transactional Reporting (OTBI) -
Current Timestamp Not Updating on OTBI ReportContent Hello, I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was …Matthew Voss 54 views 8 comments 1 point Most recent by RichardChan General Transactional Reporting (OTBI) -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the promptContent Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repor…Brenda Jacks-49721 95 views 1 comment 1 point Most recent by RichardChan General Transactional Reporting (OTBI)
-
Reporting on Current Payroll Balances for a colleague i.e P60 Rate, Holiday Rates, Court Orders (othSummary Payroll Reports or Fusion pages that display the individual colleagues current BalancesContent Hello, Is anybody aware of a method in which we can view a colleag…Brad Hughes 49 views 1 comment 0 points Most recent by RyanPatrick General Transactional Reporting (OTBI) -
Terminations ReportContent Hi I am currently trying to create a terminations report. I cannot find the following: - Termination Action - Termination Reason I am using the Workforce Managem…Aaron Leggett 221 views 8 comments 1 point Most recent by Jatinder Tanda General Transactional Reporting (OTBI) -
Reporting Options for data source in PaaS and SaaSSummary Reporting Options for data source in PaaS and SaaSContent I understand we have OTBI and BI tools available to report out of SaaS Data Source. Similarly, * What a…Raghuram Nanda Krishnamachary 51 views 1 comment 0 points Most recent by Shakher Sharma General Transactional Reporting (OTBI)
-
Contract Changes in HCM CloudSummary How to handle changes to contract using HCM CloudContent Hi, We are using HCM Cloud and one of our areas we are falling down on is changes to peoples contracts I…Graeme Thomson 25 views 0 comments 0 points Started by Graeme Thomson General Transactional Reporting (OTBI)
-
Different report in same Excel file with differents sheetSummary Different report in same Excel file with differents sheetContent Hi Experts, I created 3 new reports as per our customer requirements. But they need all the repo…Nirmal Kumar L 34 views 3 comments 0 points Most recent by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Time in role reportSummary I need to create a time in role reportContent I need to create a time in role report. In our old system we had a calc which said minimum Effective Date for Emplo…Peter Kirwan 21 views 2 comments 0 points Most recent by Clyde Ramcharan-61521 General Transactional Reporting (OTBI)
-
Dashboard ReportSummary Dashboard ReportContent Hi all, Can we able to make the Dashboard and Report width size equally while we are using 2 layouts? I have highlighted in yellow color,…Naveen Kumar Loganathan 206 views 5 comments 1 point Most recent by Julian Challenger-Oracle General Transactional Reporting (OTBI)
-
Bursting ReportSummary A report on Probation which bursts out to Line ManagersContent is there any example reports which look at Probation Period? Also sample reports for Bursting?Peter Kirwan 89 views 1 comment 0 points Most recent by Sowdhaminya Murugan General Transactional Reporting (OTBI)
-
Report Employee Photo in Custom DashboardSummary Is there a way to display an employee photo in a custom dashboard?Content We have a custom Talent Profile dashboard and I am wondering if there is a way to pull …Brenda Jacks-49721 48 views 5 comments 0 points Most recent by Sandor Banfi-52443 General Transactional Reporting (OTBI)
-
How to schedule OBI Jobs using generic userContent Hi All, We have several reports in OBI which we schedule from our personal logic, but this is not correct we should have a capability to schedule them using a ge…Tarun Dadhich 43 views 0 comments 2 points Started by Tarun Dadhich General Transactional Reporting (OTBI) -
Error occurs in query when we add one line in where conditionSummary Error occurs in query when we add one line in where conditionContent Hi, While adding this line in the existing query the below error occurs. Line used in where …Nirmal Kumar L 24 views 0 comments 0 points Started by Nirmal Kumar L General Transactional Reporting (OTBI)
-
Missing Name Infomration in Subject AreaSummary Cannot find field for Preferred Name, Employee Salutation, etcContent I cannot find the following fields in the worker or any other subject area. Preferred Name,…Thomas Drzaic 25 views 4 comments 1 point Most recent by AbulKhair General Transactional Reporting (OTBI)
-
HCM OTBI Reporting Challenge with User FoldersSummary Unable to see all user folders in Admin ViewContent In OTBI, our team is unable to see the entire listing of the User folders. Sometimes, they are visible, but m…Jonathan Jackson-2093 42 views 1 comment 0 points Most recent by jcs General Transactional Reporting (OTBI)
-
Exporting report in CSV adds extra space to fieldSummary CSV report adds a space to a field, which doesnt happen when report is exported via Excel.Content Hi, I have one report which is automatically scheduled to be se…Christopher Finnerty-57466 25 views 2 comments 0 points Most recent by Christopher Finnerty-57466 General Transactional Reporting (OTBI)
-
OTBI Data Security is not working for Documents of Record Real Time Subject AreaSummary OTBI Data Security is not working for Documents of Record Real Time Subject Areakrishiveth 18 views 1 comment 1 point Most recent by krishiveth General Transactional Reporting (OTBI) -
How to do MAX Date Logic less than Prompted AsOfDate in AnalysisSummary Trying to get the maximum Salary Change Date in OTBI AnalysisContent I am trying to convert a filter to SQL to get the maximum Salary Change Date that is less th…Brenda Jacks-49721 78 views 1 comment 1 point Most recent by rashid ramzan-45341 General Transactional Reporting (OTBI)
-
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank detailsContent how do I create a audit report for employees bank details. This needs to show …Peter Kirwan 74 views 1 comment 0 points Most recent by Ruzwan Akram General Transactional Reporting (OTBI)
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…Peter Kirwan 57 views 4 comments 1 point Most recent by Ramesh Nakka General Transactional Reporting (OTBI)
-
Cell Splitting based on special characterSummary Split a field into two columns based on characterContent Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns inst…Kristen Magno 21 views 2 comments 0 points Most recent by Kim Welker General Transactional Reporting (OTBI)
-
Help with my SQL CodeSummary Help with my SQL CodeContent I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like …Ruzwan Akram 56 views 1 comment 1 point Most recent by Ruzwan Akram General Transactional Reporting (OTBI)
-
SQL IS NULL errorContent Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…Aaron Leggett 32 views 3 comments 0 points Most recent by Neil Peacock General Transactional Reporting (OTBI)
-
StatsSummary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…Peter Kirwan 24 views 1 comment 0 points Most recent by Chris Dabel General Transactional Reporting (OTBI)