Reports
Discussion List
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 133 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
No of days old in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Error on NLS_DATE_LANGUAGE code for Traditional and Simplified ChineseHello, We are editing a data model to update the date in a report for custom languages Traditional and Simplified Chinese and we are facing this error : "ORA-12702: inva…Lise_Rekik_Acc 36 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us…
-
Email Correspondences/System Notifications ReportSummary: Looking for report(s) which would list all email correspondences we currently have set up, the status, frequency and recipients. As well as a listing all system…GMV 26 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration
-
query to get details of Potential assessment in talent review which is completed by the Managerneed to know the tables and links between the tables where to get the Manager Assessed Avg Performance, Manager Assessed Risk of Loss, Manager Assessed Potential, Manage…Sanduni Pathirathne 344 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 37 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM -
OTBI Dashboard Design - Export ButtonHi all, I'm currently working on an OTBI Dashboard that certain groups across the business will use. We're using a mixture of Performance Tiles, Graphs and Tables and I …
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the…
-
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 964 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 19 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
ORA-20001:An internal assertion test couldnt be completed at location pay_balance_pkg.chk_rel_actionSummary: Custom BIP report is developed and It is not working from ESS job. Note: When it directly run from BI Publisher is working. Error: Waiting Time: 2 seconds Trigg…Bejoylin 304 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
address purpose Filed and table locationSummary: Looking to add the address purpose field into a previous BI report Content (required): I have a previous supply report i had built in BI publisher, a recent req…RJ Blankenship 120 views 6 comments 0 points Most recent by H.Chauhan Reporting and Analytics for HCM -
OTBI > Ability to AggregateSummary: OTBI > Ability to Aggregate Content (please ensure you mask any confidential information): Hello All, In order to prevent the repetition of the Time Card Commen…
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…GJ79 50 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle Reporting and Analytics for HCM
-
Write a BIP report query in which termination records should be picked only once in output fileSummary: My requirement is: I have to write a query in BIP report to fetch the current and future hire employees, and termination records should be picked only once. The…Anuroopa Sahoo 107 views 1 comment 0 points Most recent by Serban Nicolae-Oracle Reporting and Analytics for HCM
-
Report footer not showing completely in report outputSummary: Report footer not showing completely in report output. My client wants to display this footer on all the reports. When I run the report then everything in the f…Consultant Ian 15 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
how to show different content for in app and email workflow notificationswe have a requirement to show different content for in app and email notifications of RESIGNATION. So I used below condition in the RTF template using the oracle docs. …Dara Nagasai 38 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
I have made changes to emps to workers from our integration urls but unable to find AssignmentDffId"Summary: I have made changes to emps to workers from our integration urls for testing one url need this "AssignmentDffId" but i have checked frontend as well as backend …
-
Learning Access Group Organization Chart Selection Method Details -BIP Table mappingSummary: We have a requirement to develop BIP report for all learning items where we need to fetch the name of selection method for Organization Chart Criteria. We have …Kamini Kaushik-Oracle 16 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
How to add Calendar chart in OTBI Analysis under Learning Module?Summary: Hi Everyone, I have a requirement to implement a Calendar Dashboard that has an identifier if an activity is scheduled for that date - e.g. turns green if class…Prashanth Sangram-Oracle 44 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
IRC_REQUISITIONS_B AND PER_ALLOCATED_TASKS RELATION in oracle table and viewsSummary: Need to build Onboarding - Overdue Tasks Report Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Pradnya_Pampatwar 410 views 1 comment 0 points Most recent by Prabhu Mohan-Oracle Reporting and Analytics for HCM
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person detailsChetana Pawar 15 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The …Vijay Ramani VJ 1.9K views 9 comments 0 points Most recent by Naveen kumar 99 Reporting and Analytics for HCM -
Option to download multiple file from content serverSummary: Using BI Publisher report, I have extracted multiple files to content server , Whats the way to download all files from content server Content (please ensure yo…ROOPESH MADAN-Oracle 26 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle BI Publisher Learning Center -
No results using subject area Help Desk - HR Service Request LifecycleSummary: I'm trying to create an analysis using Help Desk - HR Service Request Lifecycle. In particular I need to see the data such as "Previous assignee resource id" or…
-
feasibility check of triggering Manager's direct and indirect reportees dataHi Team, Requirement: I have a requirement to trigger the report to managers as an attachment. The report should include data from both direct and indirect reporters. Co…Haritha 16 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to send a report to a network folderSummary: Is there a way to schedule a report or Agent to send directly to a network folder? Content (please ensure you mask any confidential information): Version (inclu…THawkins_LGI 153 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Showing error in BIP report ScheduleSummary: Hi Experts, we are facing following error during report scheduling. Content (please ensure you mask any confidential information): Version (include the version …