Reports
Discussion List
-
Dependent parameters not working as expected in BI Data modelSummary: We have two parameters - one parameter is of Date type and second one is Menu type. Menu type is a sql based parameter and dependent on date. Whenever I'm chang…Meenakshi K 121 views 2 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM -
How to display old and new cost center in HCM extractSummary: How to display old and new cost center in HCM extract Content (required): We are creating one HCM extract report to display old and new cost center. We are able…
-
we need subject area for career and peoformance in performance Connect ConversationsSummary: Hi Team, we need to track the career and peoformance>peoformance>connect conservation >Performance Document Name related columns in OTBI any one have any idea h…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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…Angie Elliott 21 views 2 comments 0 points Most recent by Angie Elliott Reporting and Analytics for HCM -
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 1 view 0 comments 0 points Started by Tiw.Jyotsna-Oracle 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…
-
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 23 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 221 views 0 comments 8 points Started by Cindy Klymov-Oracle 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 21 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle 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 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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…User_2025-02-04-07-00-18-658 70 views 3 comments 0 points Most recent by Naramsetty Ashok 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 212 views 10 comments 0 points Most recent by Raghavendra Raghunath-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 -
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 21 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 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
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 841 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 761 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 541 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report for Performance DocumentSummary: Hi Folks, I would like to access a report that will display any 'transferred' performance documents within the Performance System. We would also like to filter …Sowmiya Velusamy 41 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 61 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
Oracle Standard Reports - Who to ContactContent Hi all - who do we contact about making an adjustment on the Oracle delivered standard reports? Our team was looking at the Line Manager Dashboard (Shared Folder…Prudence K 88 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can…
-
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 21 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Query to find All grade Rate values with Grade codeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sowmiya Velusamy 3K views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Learning ProgressContent we are trying to mimic the reporting for learning on the front end that shows progress (1/5) for the specialization or course but I can't find this field. see sc…Riti Malhotra 49 views 3 comments 1 point Most recent by Lanette Frank-Oracle Reporting and Analytics for HCM