Global HR
Discussion List
-
OTBI > Workforce Profiles – Person Profile Real Time > Cannot count the Persons in different years bContent Hello, We have created the following analysis (PFA S1) The field “Years of Experience Band” first computes the total years of experience by calculating the sum o… -
Opening Excel Template from BISummary Opening Excel TemplateContent Hi ALL, Earlier developer in my company developed BI report using Excel Template. If I want to modify that template how can I extra…User_2025-02-07-19-03-14-525 34 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Need to fetch records with valid primary phone in OTBI analysisSummary In OTBI, How to check if all characters in phone number field is numericContent Hi, In OTBI analysis, I have a requirement to fetch employees whose primary phone…RekhaPK 37 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We…Suganthi Srinivasan 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Turnover Reporting - Do you use Actual Termination Date or Termination Start Date (+1 day)?Summary Went live a few months back and have always used actual termination date for turnover metrics. Trying to gauge if companies are using that date and how they are …Ryan_Sullivan 48 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject area for last log-in by user reportSummary Is there a subject area where I can pull the last time a user logged in?Content There's been a request by a department in my organization to see what employees h…user9020833 102 views 1 comment 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Email Trigger through OTBISummary Need Email to be triggered to IT department if any name changes happens in the 'Last Name' or 'First Name' through OTBI agentsContent Hi Team, we have a requirem…User_2025-01-23-22-36-48-692 236 views 6 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Create Infolet icon is not available on homepageContent Hello Experts, I have enabled HCM Infolets tab in analytics section on homepage. However, I am not able to see Create infolet icon. I have seen couple of posts r…Hetal Vaghela 90 views 10 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Scheduling BI Publisher Reports With Parameter(s)Summary Scheduling BI Publisher Reports With Parameter(s)Content Hi, I want to schedule a report with Parameters. Ex. New Hire Report with "As of Hire Date" as parameter…User_2025-02-07-19-03-14-525 45 views 16 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 101 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Joining Workforce Management & Expenses Subject AreasSummary Seeking to merge details from Expenses subject area in to Workforce Management reportContent I have multiple HR-centric reports the draw on the Absences, Compens…User_2025-01-28-21-32-42-630 29 views 2 comments 0 points Most recent by Hetal Vaghela Reporting and Analytics for HCM
-
Definitive solution for Error 500Summary Forget Accounts toolContent Hi All, When a user id gets changed in Fusion Applications, the subsequent login for accessing of the BI application (Reports & Analy…Alvaro Couto 67 views 1 comment 0 points Most recent by Gabriel Grigorie-Oracle Reporting and Analytics for HCM -
Salary and Assignment Changes ReportContent Hi all - I am working on a few changes reports, and the next one we are working on is assignment changes AND salary changes. I am very comfortable with doing an …Prudence K 116 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 136 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 114 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 217 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 186 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 59 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 39 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 57 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 45 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 36 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ä 47 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