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
-
Scheduling reports without BI Administrator roleSummary: Content (required): One of our HR teams needs to be able to schedule reports to users other than themselves. They do not have the BI Administrator role as this …
-
BIP Report Bursting - Need to split a large file into multiple small filesSummary: Need to split a large file into multiple small files Content (required): We developed few reports to send data to 3rd party systems. For the initial run, these …
-
Can I run a scheduled BI Publisher Report?Summary: I created a schedule for a BI Publisher report to run in the future. I would also like to run it now. I know with OTBI reports there was an option to "Run" in t…
-
Benefits Change ReportSummary: Hello, Looking for a report that shows a before/after comparison of benefits. In one line it should report: Name, Current Plan, Current Option, Current EE Rate,…
-
I need to prepare pension payover report for Uk legislation in BIPSummary: Condition for this Report is that Employees should not come in Report during opt-out period end date and after opt-out end date employees Employee Contribution …
-
Run Assignment Name and Job Name Mismatch as OTBI ReportSummary: Currently in order to run this report I go through the "Run Diagnostic Test" select and run, is there a way I can create this as a report in OTBI and schedule i…
-
Are Quick Actions ReportableSummary: Is there a way to report on Quick Action data via OTBI? If not, how can you pull data related to Quick Actions? Content (required): Version (include the version…
-
Since 22B, Some Agents using an Unknown User in "Run as: Specified User"Summary: We have had a few agents stop running since 22B, when researching we found that these agents were using a user not defined in our system (Maureen Armstrong). Co…
-
How to rename the person image downloaded using rtf template in BI PublisherSummary: Requirement to download the person image (person photo) from Oracle cloud HCM. I am able to download it but not sure how to rename the default name of the photo…
-
Are there some standard prebuilt reports available for Performance Management?Summary: Hello Everyone, We'd need to build some reports for our client as part of the Performance Management Implementation . Is there a set of some standard performanc…
-
Person Seniority Real Time - Issue if a future dated row exists?Summary: Person Seniority Real Time - Issue if a future dated row exists Content (required): We realized today that when we are running Seniority Dates from "Workforce M…
-
New Bite-Size Learning Videos Published for HCM AnalyticsSummary: Need to learn how to modify OTBI analytics? Please check out the new Bite Size Learning videos just published to the Oracle Help Center Bite-Size Library page: …
-
SQL or Table names to find the Security Profiles for the Data Role ID..Summary: Looking for a backend Table name or sample sql which can provide the List of Security profiles and mapped date Roles attached the Online page of it. Content (re…
-
How do I find which assignment categories and termination types are included in our turnover report?Summary: Content (required): My company utilizes the dashboard functionality to capture turnover. In addition, a department completes a turnover report separate from the…
-
How to create a printable report?Summary: Content (required): Hello everyone, We are trying to understand what are the needed steps to give the opportunity to the users to print the performance report. …
-
How to fetch all the columns from different folders in OTBI Payroll?Summary: Content (required): In Payroll-Payroll Balance Real Time Subject Area, when i am fetching the column from different folder ,it is showing "no results". How to f…
-
Difference between SQL Data Sources?Summary: Content (required): Hello everyone, We are trying to create a new Data Model for Performance Management in HCM by using an SQL Query. However, we are not sure w…
-
Need Output as a XML for generate payslip process in Flow patternSummary Need Output as a XML for generate payslip process in Flow patternContent Hi Team, we have a requirement to get the payslip xml from generate payslip process , we…
-
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…
-
Double Column PromptSummary Can we do double column prompt in OTBI like we can in data model?Content In data models, we can create double column LOV similar to... select description, id fro…
-
Wrap Heading Text OTBISummary: I know I have to be missing something simple, but trying to find out how to show the entire title of the included screenshot (Full title is Number of Job Applic…
-
Query - Classroom at activity level in LearningSummary: Hello, does anyone have a query how to get the classroom at activity level in Learning? Thank you so much. Content (required): Version (include the version you …
-
Facing Error when exporting to excel using the formatted optionSummary: When I export reports from OTBI into excel using the formatted option I receive errors stating 'We found a problem with some content in 'File Name'. This then o…
-
Annual Leave Following Maternity LeaveSummary: Pick up if an absence spell directly follows a different type of absence, Content (required): In OTBI is there anyway to detect if an an absence spell directly …
-
How to create Cross subject area analysis - real time (Checklist and Worker Assignment) - ErrorSummary: Error creating cross subject area analysis - Error View Display Error Odbc driver returned an error (SQLExecDirectW). Content (required): Error when joining sub…
-
Work Schedules OTBI - employee missing from analysis if no work scheduleSummary: Work Schedules - if employee does not have a work schedule they are missing from the analysis Content (required): We create OTBI analysis using Worker Assignmen…
-
Work Relationship Last Update Date vs Current DateSummary: Hello - we are trying to create a Termination report that will be scheduled to run daily with the condition that the termination date equals Current Date OR the…
-
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…
-
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…
-
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …