OTBI
Discussion List
-
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 11 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 1 view 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 11 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 164 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 51 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 701 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 936 views 11 comments 2 points Most recent by ahmed alsharief 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 11 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 11 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 274 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 52 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… -
OTBI: Remove Duplicated records that have different Assignment Start DatesSummary: I am running a report that is returning multiple records for the same employees. The difference is the Assignment Start Dates. I want only the record with the m…Darrin N 111 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Unable to get below requirement of absence columns in BI or OTBISummary: Hi Team, I need to develop thebelow cloumns through OTBI , how can we get below cloumns in absence subject areas. in between 1st apr-22 to 31st mar 23 but i don…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
How to execute web services using Groovy on Order Management Extensions?Summary We want to create an extension that runs a report on Oracle Business Intelligence to get the content of its responseContent Hello guys! We were looking into a wa… -
Report parameter definitionHi, There is a absence start and end date in the absence used report I created.and when i select start and end dates i want to see absences in that range this is how i d…Cansel Karasoy 21 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM