Sample Reports
Discussion List
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 355 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM -
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 71 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…a.w.anand 2.9K views 9 comments 0 points Most recent by Gongati Nandish Kumar-Oracle Reporting and Analytics for HCM
-
401K Annual Census ReportSummary: We are new to Oracle Cloud and looking for a 401(k) or 403(b) Annual Census file. It would include Name, SSN, DOB, Hire Date, Term Date, Status, Gross Earnings,…
-
Sample Dashboard in Oracle LearningSummary: Sample Dashboard in Oracle Learning Hi All We are trying to develop a custom dashboard in Oracle Learning. Can you please share with us any sample dashboard tha…
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 21 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 541 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM -
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list… -
abcdabcdShyam Rajbhar 11 views 2 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Query to get Roles hierarchySummary: A query to get role hierarchy by role ode Content (please ensure you mask any confidential information): Want a query where i can pass the role code, and get al…Osama_Mo 294 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
How to fetch Import errors for Project tasksSummary: Where Import errors for Project tasks will get stored .W e dont see them in PJF_OPEN_XFACE_REPORT table and PJF_TASK_ERRORS table after import run. Content (ple…Lakshmi Bandlamudi 195 views 7 comments 0 points Most recent by Venkat Patlola-Oracle Project Management
-
Are there any List of Seeded Reports for Learning ManagementSummary: Hi team, Are any seeded reports in Learning Management. If so, is there a list of it that we can viewed? Regards, Omar Jawed Shaikh
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…Nivya Mathire 91 views 8 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 94 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya Mathire 81 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM
-
R13 How to generate a Trial Balance Report from OTBISummary R13 How to generate a Trial Balance from OTBContent R13 How to generate a Trial Balance from OTBIHello : I was wondering if you can share with me any document ho…gabriel kinovisques-163562 402 views 9 comments 0 points Most recent by Sachi Patel Reporting and Analytics for ERP
-
sql query to fetch item number detailsSummary: We need a SQL query to fetch the item number, business unit, inventory item id, unit cost, total cost, sub inventory code, organization name. Kindly let us know…Dilip.Murugan-Oracle 3.2K views 11 comments 0 points Most recent by Harshitha S Motagi Reporting and Analytics for ERP
-
Pivot TableSummary: Hi, I need help with a report format. Object 1: Contains Question IDs Object 2: Contains Question IDs and Response fields We have a table that includes Question…Anusha716 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
A report that will show the Fusion Role's last update dateGood afternoon. I wonder if there's a Fusion Report that will provide the date when the Fusion roles were last updated? Let's say a specific role was updated by Oracle d…
-
How to find out columns with empty value in Oracle fusion table through query ?Summary: Hello... I want to make a query to get all blank column names from a Oracle fusion table…Kindly help me in writing the query. Thanks. Content (please ensure you…I am a learner 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Creating a Unified Report for Job Application Details and Pre-screening ResponsesHello Cloud Customer Connect Community, I hope you're all doing well. I'm currently facing a challenge and would greatly appreciate your expert insights. I am in the pro…HarishVummidi 41 views 2 comments 1 point Most recent by HarishVummidi Reporting and Analytics for HCM -
Fail Activity 1 must continue to activity 2, Missing SCORM SCORE,Summary: We have a learning that Tests the learner knowledge of the content and if they aren't able to complete with a passing score after 2 attempts in activity 1 they …
-
How to translate Amount in Words from English to Arabic language in rtf templateSummary: we have a requirement to print Payment amount in Words (English) to Arabic language in check template. The expectation is that, translate below given English te…SireeshaJaladi 559 views 9 comments 0 points Most recent by ArjunReddy88 Reporting and Analytics for ERP
-
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 75 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
Emailing an OTBI Analyses does not send data for prompt selectedSummary: OTBI Prompt data selected does not match data when emailed. Detailed overview: I have a prompt built into an Analyses report, that enables a manager to select t… -
Project Costing (PPM) table where Invoice numbers stores.Summary Project Costing (PPM) table where Invoice numbers stores.Content Hi Gurus, I am in development of Project reports. I have to capture AP invoices details which ar…
-
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 101 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales