Sample Reports
Discussion List
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat…Gaurav Rath- PGC 51 views 3 comments 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
How can I show the number of rows returned from the report?I created a dashboard from the analysis report and there are parameters for this report. How can I show how many data is returned in the report depending on the paramete…Barış Ergün 71 views 4 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
How to SUM 1st, 2nd, 3rd and 4th occurrence of values in trailer summary record for ETEXT template?Summary: I have a requirement to build a trailer record that includes 4 separate SUM totals based on the occurrence of these totals in the employees record. I can't chan… -
Period Rolling Turnover by Employment CategorySummary: I am trying to get a rolling turnover by employment category. This analysis doesn't change any value even if I provide the assignment category filter. The resul…Anita 31 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
We develop new custom report but we getting some of employes have two recordsSummary: Hi Team, We develop new custom report but we getting some of employes have two records due to terminattion date actuallyin ui no termination date but some have …AjayKumar Maddipati 31 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to get location for position in OTBISummary: How to get location for position in OTBI Content (required): I tried using location name column under Position folder from position real time subject area but i…Swati U 151 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
we have head count nearly 9000 employees and coming to this report only showing 5700 plus employeesSummary: Hi team, we have head count nearly 9000 employees and coming to this report only showing 5700 plus employees may i know how to check the issue. person real time…AjayKumar Maddipati 51 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Not able to find column as Pending changes in Position subject areaSummary: Not able to find column as Pending changes in Position subject area Content (required): In manage position, we have "Pending Changes" column. see attached. Does…Swati U 41 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Enter values for lexical referencesSummary: Content (required): Hello everybody, We are having issues using this query to extract information from the learning module. I suppose that the error is given by…Gerardo Peluso 21 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
Last_updated_by column is showing user name not full name in OTBI reportSummary: Last_updated_by column is showing user name not full name in OTBI report Content (required): Does anyone know how to get full name of the person in last updated…
-
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 321 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Remove White Spaces from RTF TemplateSummary: Hello All, Can any body please suggest on removing white spaces from RTF Template. In the the RTF template ->Right Click Paragraph ,We have tried to set the Par…MilanMohanty 1.6K views 1 comment 0 points Most recent by Natalia Rappleye-Support-Oracle Reporting and Analytics for HCM
-
How to use drilled down in BI Report when I use normal layoutSummary: How to use drilled down in BI Report when I use normal layout Content (required): I have graph in my BI report and what I want is - when we click on graph it sh…
-
Transfer Dashboard's gear icon to the HCM UIHello, Our client has a requirement, in which he wants the user to have access to the page options (gear icon) of the dashboard in the HCM UI, in the exact same manner i…Ioannis Adamou 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 51 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
Payroll Run Error ReportsSummary: Payroll Run Error Reports Content (required): Hi All, Greetings! What is the best option available to get the payroll run error list - apart from the flow 'Run …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
when i ran My Bi reports I'm getting error is ORA-01427: single-row subquery returns more than oneSummary: Hi Team, when i run my report some countries coming data and some of times als coming the data but some times I'm getting below errror: ORA-01427: single-row su…AjayKumar Maddipati 693 views 13 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 11 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
how to create extract such that it should only give the record for which department has changed.Summary: how to create extract such that it should only give the record for which department has changed. Content (required): This is change only extract. I have created…
-
Not able to add filter to question text in OTBI reportSummary Not able to add filter to question text in OTBI report Content (required): I am using "Workforce Management - Checklist Real Time " subject area and when i tried…
-
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
-
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…
-
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 222 views 0 comments 8 points Started by Cindy Klymov-Oracle 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 500 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
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
-
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?
-
New user account password reset statusSummary: Is there a way to fetch the new user account details if the password was reset successfully or not? Content (required): As part of Onboarding process, user acco…
-
Data is not populated in HWR_WLNS_POINTS_REPORT tableSummary: Data is not populated in HWR_WLNS_POINTS_REPORT table Content (required): We have configured the Wellness activities and tasks and, employees have completed the…Jhansi K 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Excel Template ErrorSummary: Hi all, I am working on a excel template and at the time of viewing the data, getting below error. Could any one please let me know the cause of the issue. PS: …