OTBI
Discussion List
-
HCM OTBI Index ColumnsSummary This workbook documents index columns in HCM OTBI subject areas.Content This document is published by Oracle OTBI Development. Index columns use database index f…User720640-Oracle 330 views 4 comments 10 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report to show accruals created against each business unitSummary: We have 100+ procurement business units . During the period close (period end accruals) , it is difficult to run the un invoiced receipt accrual report for each… -
How to add logical sql analysis to dashboardContent Hi, I have created logical sql OTBI analysis , now I want to add this into Dashboard page which is already having dashboard prompt(all are column prompts) and ot…User_7836 207 views 28 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Join "Enterprise Quality Actions Real Time"/"Enterprise Quality Issues Real Time" subject areas OTBISummary: From Quality Issues subject area I can access just some of the related Quality Action fields (From the Relationship) I want to access more of the Quality Action…
-
Business Title Not Pulling CorrectlyContent We are currently migrating to use the delivered business title field, but I'm having some difficulty pulling it into an OTBI report. If I don't add any employee …User_2025-01-31-00-25-12-234 25 views 3 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
Audit trail for supplier portal usageSummary: Audit trail for supplier portal usage Content (required): Hello I was wondering if there are any BI report or Dashboard to track supplier portal usage. I think …
-
How to split in two different columns an information through OTBISummary: Need to create an additional column for "Email type" Content (required): Need to have two different column for work email + personal email and not different row…Virginia M. Calvi 181 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Which table has patching info in oracle cloud ?Summary: Oracle is deploying one off patches for SR fixes/issues, is there a way to identify the patch deployments in any tables ? Content (required): We need a table or…User_2025-03-07-19-29-15-074 11 views 2 comments 0 points Most recent by User_2025-03-07-19-29-15-074 Supply Chain Planning and Collaboration
-
GL Segments-OTBI ReportsSummary: I wanted to enable the 'Intercompany Segment' of the COA for OTBI reporting. Followed the steps as per the note- Fusion Financials OTBI : Setting up General Led… -
Performance Tile counting assignments based on the sum of a flex field by assignment.Summary: Since upgrading to 22A we're having trouble with a performance tile used to count assignments based on the sum of a flex field we've designed and I'm looking fo…Rob F 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Remove filter values from Export to Excel from DashboardSummary: Content (required): I would like to remove the filter from a dashboard when exporting to Excel. As seen below there is a screenshot of the Excel export I made. …Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
OTBI - Is it possible to retrieve working days per employee?Summary: Hi, We are using absence mgmt module (no time and labor) and one of the reports requires us to display how many days a month is an employee supposed to work (ba…HulyaAkan76 131 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I have create a analysis on seniority subject area but few employees who have seniority are missingSummary: I have create a analysis on seniority subject area but few employees who have seniority are missing Content (required): how it can happen and where to start che…Yechiel 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Effective DatingSummary: I'm using Compensation - Salary History Details RT subject area to get someone's salary as at 29-10-21 (so in that subject area I use the Salary Change DateUser_A80ZS 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Burst notifications are sent to inactive managersSummary: We have notifications to inform the current manager about the contract expiry dates of their employees. The OTBI was done using the Worker Assignment Real Time …Ridma Karunanathan 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report services are not working post 22A upgradeSummary: REST services related to OTBI are failing in the system which worked fine until the 22A upgrade. Content (required): One of them is 'runDataModel' which we use …Goutham.Manthri 21 views 1 comment 0 points Most recent by Goutham.Manthri Reporting and Analytics for SCM
-
Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY are unable to see their own development goals.Summary: Users with FBI_CAREER_DEV_TRANSACTION_ANALYSIS_DUTY inherited by either ORA_PER_LINE_MANAGER_ABSTRACT role or ORA_PER_HUMAN_RESOURCE_ANALYST_JOB role are unable…Maciej Kozakiewicz 11 views 2 comments 0 points Most recent by Maciej Kozakiewicz Reporting and Analytics for HCM
-
Additional comments and Reason for joining can't fetch the OTBI reportSummary: Question test to response answer in Pivot Table format Content (required): Formula for Question test CASE WHEN "Checklist Questionnaire"."Question Text" = 'What…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM