Global HR
Discussion List
-
Need help for building Confirmation Letter after probationContent Dear All, I am new to report development in oracle fusion HCM cloud. It would be really helpful if someone can post Confirmation Letter after Probation & Extensi…User_2025-02-06-14-37-05-233 100 views 1 comment 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to see custom fields in OTBI?Content Hello experts, I have created a custom field in worker assignment page. How can I see custom fields in OTBI? Are there any batch processes to launch? Thanks in a…Valerio Curzi 61 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Job field empty for one employee but filled for other employeeSummary In a report the job field for some employees is empty and for some it does contain informationContent I have created a report with two subject areas (workforce m…Inge Marinus 21 views 3 comments 0 points Most recent by Inge Marinus Reporting and Analytics for HCM -
Here is the below query need to put some manual calculation formula. Can any one please help me in dSummary round(base_salary * 4.81%)Content SELECT DISTINCT(b.person_number) "EMPLOYEE No.", b.person_id as "Unique_id", (case when C.MIDDLE_NAMES is null then C.FIRST_NAM…User_2025-02-07-09-10-02-492 55 views 2 comments 0 points Most recent by User_2025-02-07-09-10-02-492 Reporting and Analytics for HCM
-
Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainSummary Reporting Requirement to Find Employee's VP or above Manager Level in Reporting ChainContent Hi, I am not sure this is possible within a single select statement … -
Pending Workflow Notifications DashboardSummary Dashboard to be created for pending workflow notiifcationsContent Hi all, We are trying to create a dashboard which will display the number of pending workflow n…User_U7T4G 115 views 11 comments 0 points Most recent by Ankush Rode Reporting and Analytics for HCM -
Manager Name for a Position in an AnalysisSummary Pull in name or assignment numberContent Can you pull in the position manager in an analysis off of the position? I see supervisor ID and supervisor assignment i…Lynn B 17 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
FTP File delivery - PGP Encrypted with required extensionSummary PGP encrypted output with desired extensions.Content Hi All, We have a requirement to generate the extract output which is text format but > Delivery method : FT…Prerna Tuteja-61210 61 views 5 comments 0 points Most recent by Prerna Tuteja-61210 Reporting and Analytics for HCM
-
Effective Date Issue?Content Hi Experts, I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringin…User_2025-01-28-05-39-23-766 124 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Termination date for Rehire employeesSummary Termination date for Rehire employeesContent How to display termination date for rehire employees in OTBI report. We want only the latest assignment record to be…User_2025-02-01-05-31-10-698 135 views 18 comments 2 points Most recent by Lindsay Lamont Reporting and Analytics for HCM
-
Work MissingSummary My Folders is emptyContent Hi, I've had issues logging into OTBI over the last hour, eventually after clearing my caches, browsing history etc and a reboot of th…User_2025-02-05-22-44-35-842 20 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Need Help with Date Sorting on Advanced XML ReportSummary Date Sorting on Graph not working properlyContent Hi Experts, I tried reusing an Assignment Change in last 1 year report from the repository over here. The entir…Meet Bhavsar. 39 views 3 comments 0 points Most recent by Meet Bhavsar. Reporting and Analytics for HCM -
How to extract Cost Center with OTBISummary How to extract Cost Center with OTBIContent Hi, We would like to export the cost center structure and corresponding values in OTBI. We are using the functionalit…Hakim Slimani - AXA 356 views 13 comments 3 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Analysis showing 2 Record for manager update for employees.Summary How can we remove duplicate record for line manager change.Content HI, I have created the analysis in the subject area "Workforce Management - Worker Assignment …Farooq Syed, CPA, PMP, CISA 54 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM -
Termination Date Using Column ReferenceSummary Get a greater than term date if business unit = thisContent UPDATE: I have attached a copy of the XML of the original report. My goal is to only bring back termi… -
Analytics Section on HomepageContent Hello Everyone, Has anyone used "Analytics" section on homepage to display reports/dashboards? Currently, it displays Order to cash infolets and Service infolets…Hetal Vaghela 72 views 4 comments 1 point Most recent by Pooja_Chowdhary-Oracle Reporting and Analytics for HCM -
Changing Column HeadingsSummary Any implications for existing reports?Content Hi, I recently learnt that column headings can be permanently re-named by saving the new column heading as a system…User_2025-02-05-22-44-35-842 36 views 4 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
Org Chart in OTBISummary Ability to create Org Chart in OTBIContent Hi All, I am looking at ways to create an Org Chart in OTBI, which will display the Hierarchy in a Tree View similar t…User_2025-03-07-00-53-57-686 612 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Analysis- restrict access at field level?Summary Want to hide a field within a subject area in analysisContent We have a requirement to create an analysis & then restrict access at field level within the subjec…Delia Coelho 29 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Analysis or Report not returning any resultsContent I'm hoping there is something obvious I'm not doing right, but every time I try and run an Analysis or Report in BI Publisher, it returns No Results as per the s…User_2025-02-05-23-39-39-057 50 views 6 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HR_ORG_UNIT_CLASSIFICATIONS_F not aligned with HR_ALL_ORGANIZATION_UNITS_FSummary Some fields are empty in HR_ORG_UNIT_CLASSIFICATIONS_F although populated in HR_ALL_ORGANIZATION_UNITS_F for some departments onlyContent We are using OTBI for s… -
HR Help Desk - Organizational hierarchySummary Need to add "Level 3" to an exciting help desk reportContent Hello, I wonder if anyone can help me out. I need to add "Level 3" of the organizational hierarchy t…Mitch_123456 42 views 4 comments 0 points Most recent by Mitch_123456 Reporting and Analytics for HCM
-
how to send the Salary Slip email PDFSummary we need to send the Salary Slip email PDFContent is there any option to send the Salary slip PDF with password protected. -
Default Cost Center in Expense AccountSummary Default Cost Center in Expense Account when entering Department information on Employee AssignmentContent Hi, we are storing Cost Center information on the Depar…User_2025-01-31-15-09-07-564 375 views 1 comment 0 points Most recent by Tom Strudley Reporting and Analytics for HCM
-
Employees who had their job changed?Summary OTBI report for all employees who had their job changeContent Hi Experts, Is it possible to create a report in OTBI which gives me a list of all employees who ha…
-
OTBI reports not working in 20ASummary All OTBI reports are erroring out in 20AContent We recently got our test instances upgraded to 20A over the weekend and all our OTBI reports are not working. We …Roy Paolo Paunlagui 84 views 10 comments 0 points Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM
-
HR Help DeskSummary Subject area details/mappingContent Good afternoon, i was wondering if we have any supporting documents for the "New" help desk subject areas like "Service - CRM…Mitch_123456 45 views 1 comment 0 points Most recent by Balaji Durai-Oracle Reporting and Analytics for HCM
-
Which table stores the Manage Set Assignments detailsSummary Which table stores the Manage Set Assignments detailsContent Hi Team, Can some one point me to the table which stores the Manage Set Assignments details. Go to M…Pavan Gadepalli 51 views 2 comments 0 points Most recent by Pavan Gadepalli Reporting and Analytics for HCM
-
Issue with Annualized Salary in OTBISummary Anunaluzed Salary not showing up in OTBI analysisContent Hi - We are in the process of building/moving our BIP reports to analysis but have been encountering iss…Roy Paolo Paunlagui 49 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report sorting based on supervisor hierarchy 1 followed by hierarchy 2Summary Requirement: Report sorting logic required to sort based on Supervisory Hierarchy 1 followed by Supervisory Hierarchy 2 as displayed in the table above. Kindly l…