OTBI
Discussion List
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 120 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Deep link for a reportI have created a new page entry under "My Team" and i want a report to be triggered when someone clicks on that. Screenshot attached. How can i obtain the link to a repo…Girish Bhatia 25 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal …Clifford Trett 26 views 1 comment 0 points Most recent by Chris Ford Reporting and Analytics for HCM -
Poor performance with CASE statement and sub-querySummary: Custom analysis with CASE statement extremely slow Content (required): Good afternoon, I have created an OTBI analysis that yields the names of line managers wh…ammiano 53 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
"Add to Favorites" is not working as expected for OTBI reportsSummary: Hi When I add a OTBI report(having input parameters) to Favorites, the output resulting from favorite displays the output without asking for input parameters. I…
-
Learn Admin view on Workflow ApprovalSummary: Dear Community, Is there a way for Learn Admin to view on Workflow Approval? Currently Transaction Console is granted only to IT Admin. Worklist is not able to … -
Audit ReportHi Experts, Can we have an audit report in the system on employee details change which included any change relevant to employee assignment, DOR and personal info etc.
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo…Rebekah Gilday 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …Jessica D 7 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there a way to show an Assignment Completion Date and its Renewal Assignment Date in a Report?Summary: We have a CPR Course. We need to show when someone's completed the course and when their renewal assignment will start. Is this even possible? Content (required…
-
How can I create a historical overview from a flexfield CHARACTER Data type?I have data information stored in a CHARACTER data type flexfield. To expose it in an analysis in Oracle Business Intelligence (OITBI), I navigate to the 'Incentive Comp…Priscila Banqueri 12 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Matrix Manager - Why does OTBI return multiple matrix managers for each employeeSummary: We use Line Manager and Compensation Manager when creating or updating an employee assignment. Our reports should return no more than two managers for the curre…Michael Grant 196 views 6 comments 0 points Most recent by Michael Grant Reporting and Analytics for HCM -
How to filter for Finalized territories in Sales - CRM Territory Resource subject area?Summary: How to filter for Finalized territories in Sales - CRM Territory Resource subject area analysis? Content (required): I'm using Sales - CRM Territory Resource su…Chin Chi-Oracle 52 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Position Vacancy ReportHello, does anyone know how I could report on vacant positions in HCM? I need to be able to report on both positions that are currently vacant, and positions that were v…User_2025-02-07-03-52-39-913 711 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to derive Consumed Quantity ValueSummary: Requirement is to get the Review Supply Availability for a resource , I got the Table which stores the Supply quantity value, I am not getting the source table/…
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …
-
Forcast deprciationSummary Forcast deprciation by category and cost centreContent Hello i need one asset report standard or customize query for extract total deprecation for cats per categ… -
If you think you do OTBI really well and have a large portfolio - Can we connect?Summary: We are fairly new to OTBI (just implemented HCM) and struggling a bit with how to best govern scheduling, enhance performance of OTBI reports which at this time…Luke.esh 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Management - Worker Assignment Real Time andSummary: Hi, I'm currently working on 'Workforce Management - Worker Assignment Real Time' and it gives me 'No Results The specified criteria didn't result in any data' …
-
Dynamic Link to Oracle Business Intelligence Dashboard Not WorkingContent Hello, We are trying to use the dynamic link functionality for a custom icon so that when users click the icon, they are re-directed to the Oracle Business Intel…Dustin Dominic 101 views 7 comments 2 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Employee Missing PPM detailsSummary: Hi everyone, I need a query for those employees whose bank details are missing(PPM), If anyone has this query. Please share with me. Thank you.Saher 15 views 3 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
Payroll - Element Entries - Real Time Subject AreaSummary: We have a requirement to enable our Reward Team to have the ability to report on Element Entry Values. I have read many similar posts regarding this and i under…Tony Donnachie 281 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
AR Cash ReceiptsSummary Which Role gives us the access to print AR Cash Receipt Print report?Content Which Role gives us the access to print AR Cash Receipt Print report? Version 21BKanika Mahajan 46 views 2 comments 0 points Most recent by Srivatsav PR-Oracle Receivables & Collections
-
How to increase the number of Last 7 Days for the Infolet "Accrual Write Off"Summary: In receipt accounting overview page, the Infolet "Accrual Write Off" shows only the accruals written off in last 7 Days. We need to increase this number to be 3…
-
EBS to fusion pricing data Migration - PRICE_LIST_CHARGES_INTSummary: Hi We want to migrate ebs data using PriceListImportTemplate fbdi. In this template, we have a "PRICE_LIST_CHARGES_INT" and we want to know which EBS table data…
-
OTBI create/edit/view accesshi, We have a requirement to give OTBI access to business users. business user should be able to create/edit/view report for all the subject areas Should not have access…Nivya Mathire 54 views 3 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
How to automatically expand the Organization Tree in OTBI?Summary: How to automatically expand the Organization Tree in OTBI? Content (required): I want display the Organization Tree in a hierarchy in PDF. When I export the dat…