Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
BIP Report timing out for select Associates in-consistentlySummary: This report is run by about 165 associates. Almost 80% of runs are successful where others are getting “Time out error” for rest. It’s not consistent, though. C… -
Report to identify employees with corruption in "PER_PERSON_NAMES_F" tableSummary: Hello, We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused er…
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
Performance Issues for specific usersSummary: Some users receive the same error message of timing out while trying to pull a report. However, I can pull the same report without any issues. I am trying to de…
-
Recruitment - Candidates How to get a SMS/Email Communication Message History OTBI AnalysisSummary: Hi, On a Requisition via the Messages Tab a Recruiter sends out messages to candidates via Email or SMS using templates or custom messages. We need to have the …
-
Bullet points formatting getting changed during output of bursting BIP reportSummary: We have bursting report which sends email notifications. We have designed the RTF template and providing some instructions like below format. But while sending … -
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…
-
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…
-
Which Subject Area holds Management Level, Retention Risk, Vacancy Risk and MobilitySummary: I'm trying to create a Talent report, but unable to find few attributes in any Subject Area, and those attributes are Management Level, Retention Risk, Vacancy …
-
Need Header even No Data returns on BI Publisher output (CSV)Summary Header is not coming in BI report when No Data returns (CSV)Content In My BI Report, I am passing date as a parameter. When No Data Returns for date parameter, H…
-
../ directory path reference tag in RTF is not working properly in BI Analytics.Summary: ../ directory path reference tag in RTF is not working properly in BI Analytics. Content (please ensure you mask any confidential information): We are using the…
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin… -
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below … -
How can I report on a specific pay element in OTBI?Summary: I need to be able to include a specific pay element but OTBI excludes anyone who doesn't have this Content (please ensure you mask any confidential information)… -
Oracle Tables for Benefits Person InfoSummary: I am checking the tables for the Person Info data in Benefit Enrollment page for Employee Content (please ensure you mask any confidential information): Version…
-
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
We have Job Application - Progression"."Current Phase" but it showing only phase like New onlySummary: Hi Team, Below subject area we rae using to know the Job Application - Progression"."Current Phase it showing of New or another phase but we need days in Phase … -
Newly created prompt by one user not seen for other userWe wanted all BUs to be by default selected when LM Dashboard is opened up. So we modified the existing prompt by removing the filter of selecting the topmost BU. When c…
-
Unable to get the Enterprise Seniority Date Person level in OTBISummary: Hi all, I am not able to find the field related to Enterprise Seniority Date Person Level in OTBI using the subject area Workforce Management – Worker Assignmen… -
Filter null values on a DashboardSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use… -
Scheduled absences not showing in Absence OTBI ReportSummary: Hi All, Scheduled absences ("Workforce Management - Accrual Real Time"."Front-Loaded Plan"."Scheduled Absences") not pulling any data in my OTBI report. Could a…
-
How to bulk update location namesSummary: Need to bulk change location names and location codes. We have thousands of records but have not found an effective way to make these updates. Content (please e…
-
NULL values in OTBISummary: I think it is generally best practice to suppress NULL values in OTBI, but client wants to keep them in report. But in their case, it's selective. Can we enable…
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …
-
Headcount value 0 for some employeesSummary: I was comparing the headcount (the built-in fact) against the employee detail row wise data and the counts did not match. I noticed that some employees had the …
-
Add a hyperlink to an image in a BI Publisher Interactive reportSummary: In an interactive report, it is possible to add a link to text using the appropriate icon, but how do you do it on an image? Thank you Content (please ensure yo…
-
Restrict insertion of salary records with no changesSummary: Whenever we do transfers, promotions, and local/global transfers that do not have any changes to salary, salary records get inserted and the inserted record app…
-
BI Publisher report that shows learning activities scoreSummary: Activity score not showing in BIP Content (required): Hi, I'm trying to build a BI Publisher Report with information about learning activities inside courses. I…
-
How to remove extra rows in report?Summary: Hello, I need help on removing these extra rows. These are my filters. Can you help to check what's wrong? Content (please ensure you mask any confidential info…