OTBI
Discussion List
-
View Journal via Deep Link in OTBISummary: Is it possible to view a journal using a deep link in OTBI? Content (required): I was able to find the Journal Entry deep link (Journal Entry (XLA_SUBLEDGER_VIE…Njeri Macharia 368 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
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 subject area - Attribute to get the no. of Hours spent on each learning itemSummary: Hi Team, We need OTBI subject area and attribute details to fetch the no. of hours spent on each learning item. Content (required): Version (include the version… -
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 61 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 -
Increase font for Dashboard Link objectSummary: Increase font for Dashboard Link object Content (required): We are developing the report landing page using a dashboard page where we want to link all reports. …Ajit Dani-Oracle 31 views 3 comments 1 point Most recent by Ajit Dani-Oracle Reporting and Analytics for HCM -
List of fields from project billing that is transferred over to AR Invoice data modelSummary: Is there a way to obtain a list of fields from project billing that is transferred over to AR Invoice data model following invoice generation process. I'm keen …Raj Mohanraju FRNT 21 views 3 comments 0 points Most recent by Zaheer Ahmed-Oracle Project Management -
Department EFFHi, From which table can I find the EFF field defined on the department? If you know, can you share? Regards,Cansel Karasoy 61 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM