OTBI
Discussion List
-
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 -
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 971 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 271 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 51 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 -
Is it possible to have more than 1 completion certificate for specialisation and course?Our client is looking to have up to 5 completion certificate types between specialisations and courses. Is this possible to do? We would want to select which certificate… -
Duplicate Reports sent out by SchedulerSummary: Hi all. A few of the schedulers I have set up are suddenly sending out anywhere from 2-4 reports. This seems to only be happening since our 23C install, at leas…Jessica D 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI: Succession plans report, how can I add the Incumbent person number?Hi all, I have a problem in editing a report on succession plans. I have these columns (Plan ID, Incumbent name, Candidate name, Person number). I want to add a column w…GiovanniD 62 views 1 comment 0 points Most recent by Nancy Lang-Oracle Reporting and Analytics for HCM -
Audit New Hire Initiatives in OBTISummary: Is there a subject area that have Learning Initiatives so we can create a report to audit our New Hire learning? I can't find Initiative Name anywhere. Example … -
How to export 'comments' within OTBI Recruiting Real Time - "Job Application - Interview Feedback"Summary: We have a questionnaire that allows for comments (highlighted in picture below) to be manually added within ORC; when we export the questionnaire we cannot find… -
Length of Service CalucationSummary Need to subtract Current Date from Legal Employer Seniority DateContent Does anyone know of a SQL formula to subtract the current date from Legal Employer Senior…Rebekah Gilday 116 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Report - Performance Goals ApprovalSummary: Hello, Does anyone know how to fetch performance goals approval (pending, draft, etc.) using OTBI? Content (required): Does anyone know how to fetch performance…Hazel De Castro 81 views 2 comments 0 points Most recent by Jenna Fuchs Reporting and Analytics for HCM