OTBI
Discussion List
-
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 -
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 23 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 117 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 82 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 65 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Some of employees not showing checklist task name of 30days HR questionarieSummary: Hi Team, we have onboading perosn task list but some of employees have not showing even task name also and task status also. any one assist me on ? that issue s…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Tables available for ConnectionsHi, What are the tables available for "Connections" reporting. Regards, NivyaNivya Mathire 51 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
NEW ATTRIBUTES AND MEASURES IN LEARNING RECORDS REAL TIME OTBI SUBJECT AREA 23A upgradeSummary: Following are our questions related to this topic:-NEW ATTRIBUTES AND MEASURES IN LEARNING RECORDS REAL TIME OTBI SUBJECT AREA We have several reports created u… -
Can we send the notifications attaching completion certificates to the learners ?Summary: We would like to send the notifications to the learners post completion of learning along with the certificate attachment. Content (required): Version (include … -
Catalog objects not visible while creating Data model using Oracle BI analysisSummary Catalog objects not visible while creating Data model using Oracle BI analysisContent I am creating a new Data Set using Oracle BI Analysis, when I click on Orac…User_2025-02-03-21-28-21-735 53 views 3 comments 0 points Most recent by David Wright - More4apps Reporting and Analytics for HCM -
Need Deeplinks for Requisition and InvoiceSummary: When trying to use the Requisition deeplink in OTBI analysis report, it's not opening the Requisition view details page. View Requisition Details (PURCHASE_REQU…Arunima Pandey 21 views 1 comment 0 points Most recent by Michael Gibby - Huron Consulting Group Purchasing -
How to inactivate an Item in Product ManagementSummary: How to inactivate an Item in Product Management Content (required): How to inactivate an Item in Product Management. We need to inactivate Item/Product so that … -
Report to show OTBI filters/parametersSummary Report to show OTBI filters/parametersContent Is there a report available, or a way, to pull report filters/parameters out of OTBI analyses to view? I have a lar…User_2025-02-08-04-25-10-086 55 views 4 comments 0 points Most recent by Caroline.E.B. Reporting and Analytics for HCM -
How to calculate the number of active assignments for a personSummary: Question from a beginner: How can I calculate the number of active assignments for a person to isolate profiles with potential duplicate assignments? Content (r… -
How to add a prompts of From and To date and allow the data to filter by this in OTBI?Summary: How to filter the data to be FROM and TO date on the salary change date. I need a prompt to be used to filter the data for these dates. Thank you. Content (requ…Max W 223 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to purge the tables JG_FSCL_HDRS_ATRB_INT and JG_FSCL_LINES_ATRB_INTSummary: Hi, we need to purge this tables JG_FSCL_HDRS_ATRB_INT JG_FSCL_LINES_ATRB_INT How can I do this? Content (required): Version (include the version you are using,…Alex Pagliarini - Ninecon 41 views 1 comment 0 points Most recent by Raghuram Saradka-Oracle Tax & Global