OTBI
Discussion List
-
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER… -
Requisition Filled Date and Time to fill on ORC reportContent I am looking for a way to pull in the requisition filled date into a filled requisition report for ORC. I cannot find that field in the subject areas. In additio…Jennifer Eichholz 97 views 4 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Combining Multiple Question RowsContent I have an ORC report that is pulling our filled reqs and the candidates' information that have been hired into those reqs. We want to see on the report their ans…Jennifer Eichholz 44 views 2 comments 0 points Most recent by Jennifer Eichholz Reporting and Analytics for HCM -
Manager Detail ReportSummary My report doesn't show changes of managerContent Hi, Please see attached XML file. I have copied the output of an old report (I don't have the sql or xml for the…User_2025-02-05-22-44-35-842 57 views 4 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
How to create a Public View Object based on a SQL query and make it available on Order Management ExSummary We want to create a PVO in order to get the query data on Order Management ExtensionsContent Hello guys! We are looking for some information on how to create a P… -
Absence Report with Between DatesSummary Report not workingContent Hi, I have attached the XML for this absence report, can anyone work out why it won't run? I've tried different combinations in the cri…User_2025-02-05-22-44-35-842 30 views 10 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Getting month and year into one column while maintaining date date type - EVALUATE NQSCOnfig.INI errSummary Getting month and year into one column while maintaining date date type EVALUATE NQSCOnfig.INI errorContent Hi - We are trying to graph an analysis that would sh…Roy Paolo Paunlagui 39 views 7 comments 1 point Most recent by Roy Paolo Paunlagui Reporting and Analytics for HCM -
Dependent Change Audit ReportSummary Need to create a report showing dependent option changesContent Hi...I am trying to find out how to create a report/analysis that will show me any employees whos…Denise Haas 50 views 4 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Achive 'My Folders'Summary Archive from Production to Development environmentContent Hi, Yesterday I lost all of my work that was stored in My Folders in the production 'Live' environment …User_2025-02-05-22-44-35-842 19 views 7 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
BI report or OTBI report to list out ALL Pending vacation requests for a managerSummary BI report or OTBI report to list out ALL Pending vacation requests for a managerContent Hi Experts, My manager would like to know if there’s a way to view all th… -
Question about PR PDF reportSummary Data in PR PDF reportContent I would like to know whether PR PDF report could show DFF information. -
Maintenance Cloud integration with service CloudSummary Maintenance Cloud integration with service CloudContent Hi - We have recieved a new attraction on field service cloud with Maintenance cloud. Do we have a direct…User_2025-02-05-11-36-52-799 84 views 6 comments 1 point Most recent by Mohana Gopal S-Oracle Maintenance -
Security Report In OTBISummary We need to Create Security Report in OTBI with details of Roles assigned Date and also the previous role which was deleted.Content Need to Create OTBI reports fo… -
Supplier Registration Approval Cycle Time ReportSummary Dashboard for Supplier Registration Approval Cycle Time by Business RelationshipContent This dashboard will allow you to view the average supplier registration a…Aishwarya Pawar-Oracle 143 views 1 comment 3 points Most recent by User_2025-02-01-08-03-13-309 Supplier Management -
2019 Leavers with salarySummary OTBI report needed showing 2019 leavers & salariesContent Hi, I have been looking through the shared reports centre and previous posts and haven't really found a…User_2025-02-05-22-44-35-842 52 views 14 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Work MissingSummary My Folders is emptyContent Hi, I've had issues logging into OTBI over the last hour, eventually after clearing my caches, browsing history etc and a reboot of th…User_2025-02-05-22-44-35-842 20 views 5 comments 0 points Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM -
Graph to show current monthContent Hi I have attached a very simple graph but I would like it only to display the current months data . I am having difficulties achieving this. Regards MelissaUser_2025-02-06-11-18-47-896 23 views 2 comments 1 point Most recent by User_2025-02-06-11-18-47-896 Reporting and Analytics for HCM -
Termination Reason ActionContent Hi Guys, I have to extract the information about the termination reason. I used this field in my report: "Workforce Management - Worker Assignment Event Real Tim…Giuseppe Iacono 93 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need Help with Date Sorting on Advanced XML ReportSummary Date Sorting on Graph not working properlyContent Hi Experts, I tried reusing an Assignment Change in last 1 year report from the repository over here. The entir…Meet Bhavsar. 39 views 3 comments 0 points Most recent by Meet Bhavsar. Reporting and Analytics for HCM -
How to extract Cost Center with OTBISummary How to extract Cost Center with OTBIContent Hi, We would like to export the cost center structure and corresponding values in OTBI. We are using the functionalit…Hakim Slimani - AXA 364 views 13 comments 3 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM