Get Started with Redwood: Oracle Cloud SCM and Purchasing
Global HR
Discussion List
-
Infolet for Personal InformationContent Good Day All, i have created numerous infolets in the new UI and all work fine. One of the infolets is for Length of Service. Now if you are a Line Manager you w…CB Trett 89 views 4 comments 2 points Most recent by Swati SinghVerma Reporting and Analytics for HCM -
Employees Hired in the Last 7 DaysContent Hi Guys, I'm trying to generate a report to show employees who were hired in the last 7 days. I've created a Data model and basically inserted this statement int…Ivy__Valverde 142 views 12 comments 2 points Most recent by Christian_Kaladjian-Oracle Reporting and Analytics for HCM -
Action Link on Performance TileSummary Opening detailed report (attached via action link) in separate tabContent Hi All, We are compiling a dashboard which has multiple performance tiles in one sectio…Ankush Rode 60 views 9 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Original Hire Date and Grade ReportContent Hi, I am looking to report on original hire date, grade and time in a grade. Could anybody please help on this? Thank you!MohammadAfghanul Khair 48 views 5 comments 2 points Most recent by Jessie Jones Reporting and Analytics for HCM
-
Updating Existing GeographiesContent Hi, Would like to know if it's possible to insert a value to existing geographies? Like I want to add a code for a county?SunnyJaiswal 40 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Set default parameter for date to SYSDATE in BIP Data ModelContent Hello I have a date parameter in my BI Publisher Data Model, and I would like to set it by defaut to today's date. I tried using CURRENT_DATE and SYSDATE but it …
-
Get legal entities addresses in a BI Publisher Data ModelContent Hello, I am creating letters templates based on a BI Publisher Data Model. Inside these letters I need to put the address of the employee's legal entity. Is it p…
-
Area of Responsibility - Work Contacts - Table NameSummary Area of Responsibility - Work Contacts - Table NameContent Where the work contacts (Area of Responsibility) are stored in the database. If you know they are stor…SAKTHI SUNDAR 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Previous and Current values for a shift, crew, rotation beginsSummary Due to Covid-19 we have had to introduce new shifts for our job sites. Need to report both current and previous values for auditingContent I have been tasked wit…User_2025-02-04-08-51-08-912 36 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get the last incumbent date for vacant positionsSummary Trying to get details on vacant positions as to when it was last filledContent Looking to get whether the position ever had an incumbent and if so what the last …Mario B 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to count number of Management layers between an incumbent and the top of the organizationContent Looking to find a way to count all the management layers between employees in an organization. Have been able to do a span of control report but need to count ho…Mario B 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to report on hires, terminations, promos, transfers between sub-departmentsSummary I need to produce a monthly report showing key assignment events and movement between sub-departments (custom field on assignment record)Content I have a require…James Hoffmann 117 views 22 comments 1 point Most recent by James Hoffmann Reporting and Analytics for HCM
-
Fetching resignation reason and separation/resignation type in sqlSummary Fetching resignation reason and separation/resignation type in sqlContent Hi all, How to fetch resignation reason and separation/resignation type(ie.resignation …User_2025-01-29-01-27-20-754 583 views 12 comments 0 points Most recent by User_OWH0W Reporting and Analytics for HCM
-
SQL query time out error in BI ReportsSummary Getting SQL query time out error in BI ReportsContent Hi Experts, We are getting SQL query time out error in BI Reports. have made changes Query Time out to 1000…User_2025-02-06-19-27-47-357 104 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
00/00/0Summary Cannot filter on report returnContent Hi all I am looking at working pattern reporting. All our full time standard working hours peeps inherit their working patt…Dawn Cawston - CPS 39 views 7 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Job seniority date reportSummary Job Seniority Date reportContent I just created a rule in "configure seniority date" section for job, level workrelationsihp. Then i ran the populate process aga…Adil_R 87 views 3 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Seniority Dimension OTBI ReportingSummary Seniority date dimension added in 19D for V3 seniority datesContent Hello, 19D introduced a new dimension for Seniority Date reporting, specifically for use with…Whitney Van Way 47 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 35 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 39 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 42 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 50 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 103 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 93 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 46 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 66 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 120 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM