Get Started with Redwood: Oracle Cloud SCM and Purchasing
Global HR
Discussion List
-
Calculating Hours for Salaried EmployeesSummary Requirement to calculate hours for salaried employeesContent We have a report requirement that fetches Earnings and Hours for all employees for each pay period. …SuryaMuralidharan 137 views 2 comments 0 points Most recent by Crystal Starr-Oracle Reporting and Analytics for HCM -
OTBI CASE Statement across Subject AreasSummary Attempting to write CASE IF statement for data across subject areas in OTBI and receive errorContent Business requirement is to write a CASE IF statement to popu…user9020833 118 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Empty fields are not displayed when exporting XML from Data ModelSummary Empty fields are not displayed when exporting XML from Data ModelContent Hello, I am building a Data Model to get one row with several columns, and I need to exp…
-
Unable to view Full-Time Equivalent value from OTBIContent Hi All, We created OTBI report based on "Workforce Management - Worker Assignment Real Time" subject area but unable to view "Full-Time Equivalent" data from OTB…
-
Reporting on Questionnaire ResponsesContent Hi All, We're getting ready to deploy an onboarding questionnaire as a task in our enterprise onboarding checklist. Does anyone know which subject area can be us…Lauren Owen 219 views 15 comments 0 points Most recent by Shweta Ganguly-Oracle Reporting and Analytics for HCM
-
Emergency Contact Report not returning phone resultsSummary The phone results in the Person Contact Relationship folder is not returning any resultsContent Using the Workforce Management - Person Real Time subject area. P…User_2025-01-28-20-43-56-568 108 views 18 comments 0 points Most recent by User_2025-01-31-18-28-58-561 Reporting and Analytics for HCM -
Job Change/Promotion Offer LetterSummary Looking for examples of using BI to create form letters for employee changesContent We are not using the recruiting cloud, and this is not something for new hire…Rob Stahly 185 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Bursting Query in BIP Using Multiple Subject Area Data Model Not WorkingSummary Created a data model using multiple subject areas and I want to use both to burst, but the where clause is not working.Content Hi all, We have a requirement to s…User_2025-01-31-00-25-12-234 61 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Requirement to develop BI publisher email alertContent Dear All, I have a requirement to develop a BIP email alert. Is there any document available for the same? Can someone guide me for this requirement?User_2025-02-06-14-37-05-233 48 views 10 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
When filtering on 2020 data for Turnover Dashboard, 12/31/19 terminations are included.Summary When filtering on 2020 data for Turnover Dashboard, 12/31/19 terminations are included.Content We have a dashboard for turnover data. There are several prompts t…User_2025-01-28-20-43-56-568 40 views 7 comments 0 points Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
Person Extra Information Effective Start DateSummary I need to report on the Effective Start Date from the Extra Information screen within Manage ColleagueContent Hello, I need to report on the latest effective sta…User_2025-01-28-05-32-59-092 58 views 8 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
EFFECTIVE DATES IN EFF'SSummary EFFECTIVE DATES IN EFF'SContent I am 20 A and looking for effective start date and end date for Person EIT but dont find it in the OTBI. I am looking at followin…Ritwick Chatterjee 53 views 1 comment 1 point Most recent by Ritwick Chatterjee Reporting and Analytics for HCM -
Where the Audit details that are shown in application storedSummary Where the Audit details that are shown in application storedContent In the Assignment details, When we click on the view History, We can see the history for the …GTS Narayanen 46 views 4 comments 0 points Most recent by GTS Narayanen Reporting and Analytics for HCM
-
Data model to Fetch Proposed value of Job in Workflow notification seeded TemplateContent Hi, I have a requirement to add job title in Transfer Details section of seeded Workflow notification(Transfer Report). I managed to fetch Current Value of Job b…User_2025-02-06-14-37-05-233 39 views 2 comments 0 points Most recent by User_2025-02-06-14-37-05-233 Reporting and Analytics for HCM
-
Newly Added Lookup Values not available in OTBI - Service date rule at person levelSummary Newly Added Lookup Values not available in OTBI - Service date rule at person levelContent Hi Team, Newly Added Lookup Values not available in OTBI. Lookup type …
-
Line Manager information of Future hired WorkerContent Hi, I have created OTBI report listing all our future hired Workers (xml attached). For some reason the Line Manager information is not populated on the report. …Niko Hölttä 48 views 10 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM
-
R13 20A - What are the common fields to join with Issue Details and Transaction details Subject areaSummary Need help with OTBI subject areaContent We are trying to create a transaction failure report for the transactions that are failed on a daily basis due to MSS tra…Suganthi Srinivasan 64 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Adding Dynamic BI Publisher Link to DashboardSummary Creation of a simple dashboard with links to all reports in our instance (static BIP links don't solve our issues)Content Hi all, We are trying to create a more …User_2025-02-05-05-51-12-049 134 views 17 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Where to find definitions for each standard OTBI measure?Summary I'd like to see the definitions or specific criteria used for defining which HCM transactions affect each of the predefined standard measures in OTBIContent Is t…James Hoffmann 86 views 10 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBISummary Issue with Text file output for eText Template with Data Model with 2 Data Sets in OTBIContent I have a report using a Data Model that uses 2 data sets. I use an…DavidBlake 158 views 13 comments 0 points Most recent by Gregg Vadasz Reporting and Analytics for HCM -
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 101 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 22 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 57 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 116 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 19 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 126 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