Sample Reports
Discussion List
-
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…
-
Need to get a report for PO's where we can filter by BU'sSummary Need to get a report for PO's where we can filter by BU'sContent Hello, Grateful if you can help on how to get a list of all GRN's for Received Shipments for a S…User_2025-02-05-12-20-44-163 36 views 5 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
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 -
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 543 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
-
How to Remove Edit Option for OTBI Report.Summary: Content (required): Hello Friends We have made a custom role and added duty role -"Receiving Transaction Analysis Duty". Assigned this role to a user. But I do …Ashish_Kumar 151 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for SCM -
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: … -
DD-MON-YYYY format is not workingSummary: We have a requirement to display the date format as "DD-MON-YYYY'. Ex. 14-FEB-2025. We are using RTF Template. In the query I am not doing any kind of formattin…
-
Learning Audit ReportSummary: Our client has a requirement to be able to audit on the following objects in Oracle Learning Cloud. currently oracle dont provide an out of the box solution to …Nirupa Gnanendran 141 views 2 comments 1 point Most recent by Nirupa Gnanendran Reporting and Analytics for HCM
-
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
in my below only getting for india data and one processSummary: Hi sir, for above query with out put country parameter or process name parameter only geting india and regination process ? when i scedule the report but i seei…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Prior Job in Promotion ReportSummary: Add prior job to OTBI report. Content (required): I have a promotion OBIT report that works great. I have a request to add in the employee's prior job. How can …Greg Rank 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sample OTBI Dashboards/Reports - RecruitingSummary: Content (required): Are there any recent shared sample packs of dashboards or reports related to ORC Recruiting? Version (include the version you are using, if …Toni Olivier 179 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 21 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 283 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 3.2K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
OTBI Turnover Dashboard for Line ManagersSummary: I would like to provide a Turnover Dashboard for Line Managers in OTBI but the seeded / sample dashboards provided by Oracle are not returning data when logging…User_2025-03-07-20-15-16-297 151 views 13 comments 0 points Most recent by User_2025-03-07-20-15-16-297 Reporting and Analytics for HCM
-
Using Variables in Etext templateSummary: Hi Team, I was reviewing a oracle guide for etext template. For one of my requirement I am trying to use Variables in etext template. GetVar(var-name) ResetVar(…Mohan Murali 1.9K views 6 comments 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
Difference between data table join.Summary: Difference between data table join. Content (required): Hello All, I have some confusion on table joins. Please refer below example. I have two data tables. PER…
-
Where can I find prebuilt report and analysis list and pdf samples?Summary: Location of prebuilt report and analysis list and pdf samples on docs.oracle.com Content (required): The links do not work at https://docs.oracle.com/en/cloud/s…Rona Jeongco 81 views 2 comments 0 points Most recent by Rona Jeongco Reporting and Analytics for ERP
-
Table name and column for Projects To ProcurementSummary Table name and column for Projects To ProcurementContent Hi Champs, what could be possible Table name and column for Projects To Procurement and payables or any …