Category 81
Discussion List
-
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…Angie Elliott 23 views 2 comments 0 points Most recent by Angie Elliott Reporting and Analytics for HCM -
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 …Tiw.Jyotsna-Oracle 3 views 0 comments 0 points Started by Tiw.Jyotsna-Oracle Reporting and Analytics for HCM
-
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…Gail Wilmoth 45 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
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…S Shree 55 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to get list of valid Procedure Elements which are used in Payroll HCM Extracts?Summary: We are trying to customize a seeded payroll extract. As most of the extracts use procedure elements to fetch data, we wanted to know if we have some documentati…
-
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… -
Which Table Assignment Hours Details StoredSummary: Which Table Assignment Hours Details Stored Content (required): Hi Team, Please guide me to get the table name which stored assignment hours details. Please fin…Vasanthakumar Ravi 25 views 4 comments 0 points Most recent by Vasanthakumar Ravi Workforce Management -
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: …Cindy Klymov-Oracle 224 views 0 comments 8 points Started by Cindy Klymov-Oracle Reporting and Analytics for HCM -
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…Prabhu Krishnamoorthy 560 views 4 comments 0 points Most recent by Prabhu Krishnamoorthy Reporting and Analytics for HCM -
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. …Agapi 24 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
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…Deepika Huron 42 views 5 comments 0 points Most recent by David Bean-259734 Reporting and Analytics for HCM
-
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…Agapi 54 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Parag Hiremath 199 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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…Jessica D 35 views 2 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for HCM
-
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 …Hazel De Castro 43 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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…Dannielle Dellucci 12 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
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 …David McLellan 14 views 0 comments 1 point Started by David McLellan Reporting and Analytics for HCM
-
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…Luciavw 33 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Michelle Hughes 93 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
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…Mohit Sinha-Oracle 58 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
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…Ashutosh12 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
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 …Thulasi Ram 76 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to display URL or attachment in OTBISummary: After adding attachment url from subject area facing this error Content (required): Health and Safety module Version (include the version you are using, if appl…Surya -Oracle 160 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 828 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM