OTBI
Discussion List
-
How to use manufacturing to create a PO with variable cost for same work order quantitySummary How to use manufacturing to create a PO with variable cost for same work order quantityContent We are implementing fusion manufacturing and our business needs to… -
Employee Information Listed Report RequiredContent Hi Experts, Is there a report that provides the below information in a list? Attached Most of this information is pulled from the below areas: 1) Person Manageme…Tony Roff 30 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Receipting ReportsContent Hi Is there a report that tracks PO's and the receipted amount? thanks Tony Version 19CTony Roff 47 views 1 comment 1 point Most recent by User_2025-02-06-00-59-55-679 Reporting and Analytics for ERP -
Custom Field in report with more Subject AreasContent Hi Guys, I have to create a report with some custom fields, but I need some fields that are in another subject area. When I have been inserted the other subject …Giuseppe Iacono 33 views 11 comments 0 points Most recent by User_2025-02-05-07-02-34-538 Reporting and Analytics for HCM -
Compare null value of label in OTBI reportSummary Evaluate if the return value is nullContent Hi everyone, I have a report to show certain information of an employee by organization that report works correctly b…Cesar Tepetla Corte 52 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to create a OSP PO with 3 lines in a single purchase orderSummary How to create a OSP PO with 3 lines in a single purchase orderContent Hi all, The requirement is if we create a work order and approve it will trigger to create … -
Problem with Organization Chart Tree ReportContent Hi Guys, We need to use a Tree organization chart. We realized the following report, but we have a problem: The Ceo is positioned in the upper left corner and no…Giuseppe Iacono 213 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Person Name Change and Primary Email ChangeSummary Need report to show if a name or email changed (can be in separate reports) from prior dayContent How can I get a report that shows if someone had a name change …Mike Borghoff 76 views 7 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
How to Identify Managers in HCM (Reporting)Content Hi All, We have an OTBI Report where as per the user running the report, we are fetching all the direct and indirect reportees. We are observing that for a certa…Vibha Pandey - Oracle 70 views 21 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI access for custom roleContent I have created a custom role to access profile items. I need to give OTBI access related to the profiles to that custom role Role hierarchy involves following OR…Ayesha Thilakarathna 89 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Can we have an alias in OTBI Analysis Subject AreaSummary Can we have an alias in OTBI Analysis Subject AreaContent Can we have an alias in OTBI Analysis Subject Area like below, or is there another way. SELECT SubjectA… -
Report on Cost Center ManagerContent I'm trying to get a list extracted from the system that just shows the Department Name, Cost Center (number), and Cost Center Manager. Through Workforce Manageme…Jon Kelly 302 views 5 comments 3 points Most recent by Meredith Bickell Reporting and Analytics for HCM -
Reporting on Areas of Responsibility in OTBI - HELP NEEDED!Content Hi, If you are interested in reporting on Areas of Responsibility in OTBI, then please update this idea (https://cloudcustomerconnect.oracle.com/posts/b296e7d4e4…Julian Challenger-Oracle 64 views 2 comments 9 points Most recent by User_2025-02-05-07-43-29-505 Reporting and Analytics for HCM -
How to get the list of custom reports under "Custom" folder?Summary How to get the list of custom reports under "Custom" folder?Content How to get the list of custom reports under "Custom" folder?GTS Narayanen 162 views 5 comments 2 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Delivery of Certificates best practicesSummary What are some best practices on the delivery of completion certificates?Content We have 26 different templates with hundreds or courses that will be mapped to th… -
Worker Address History in OTBI!Summary Worker Address History ReportContent Hi All, Do we have any Primary Address History for a Worker available in OTBI SA's? I am only able to get the Real Time Addr…User_2025-07-18-02-05-33-261 169 views 7 comments 0 points Most recent by Jay Shankar-178473 Reporting and Analytics for HCM -
OTBI Performance Tile - Does not RefreshSummary OTBI Performance Tile - Does not RefreshContent Hello, Can anyone please help with this strange issue? I am using a Performance Tile to display the number of Doc…SantoshKumarBhairi 40 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI Report for Line ManagerSummary Data Security for Line Manager to view indirect reporteesContent Hi, I'm still learing the OTBI reporting. I'm trying to create a report for Line Managers to see…Senthilkumar Anbalagan 184 views 3 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
OTBI Dashboard Prompt: How to "Display" one meaning to User, but Presentation Variable has another mSummary OTBI Complex Prompt is used to filter the type of data within report, but user needs simple list to pick fromContent Hello All, I have an OTBI requirement to dis…User_2025-02-04-11-20-13-378 83 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which table stores 'Transaction Number' in Project CostsSummary Looking for backend table that stores 'Transaction Number' in Project CostsContent Hi All, I'm looking for backend table that stores 'Transaction Number' in Proj…Sumanth Kunimakki-21932 328 views 7 comments 0 points Most recent by Rasu P Reporting and Analytics for ERP -
Reports with hardcoded parameters performing better then those with bind variablesContent Hello, We have a peculiar problem, we have a query for gl balances report which when run by hardcoding the Legal entity and period runs fine fetching all our dat… -
Organization HeadcountSummary Provides the headcount of the organization hierarchy based on input organization nameContent This analyses displays a total of 5 levels of organization hierarchy…Raghavendra Raghunath-Oracle 115 views 2 comments 3 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM