OTBI
Discussion List
-
Compensation - which table contains the comments ?Content Hello, In the compensation sheet, you can add a column in which the manager can add a comment. I need to extract all the comments with BI Publisher or OTBI. Is a…User_2025-01-25-01-33-46-269 45 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Sickness Absence & Right to Work DashboardsContent Hello, I'm looking to provide two dashboards to the business based around 1) sickness absence and 2) the status of an employees right to work (nationality/passpo…User_2025-01-29-19-59-51-150 82 views 2 comments 0 points Most recent by User_2025-01-29-19-59-51-150 Reporting and Analytics for HCM -
OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is usedSummary OTBI Error: The View Object "HcmTopModelAnalyticsGlobalAM.ManagerHierarchyAM.PersonNameDPVO" is used as the destination of more than one View LinkContent We are …User_2025-01-25-04-02-13-126 39 views 6 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM -
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle).Content This note provides information about Fusion OTBI R12 PB10 (…User720640-Oracle 145 views 0 comments 0 points Most recent by User720640-Oracle Reporting and Analytics for ERP -
Important Information About Fusion OTBI R12 Patch Bundle 10Summary This note provides information about Fusion OTBI R12 PB10 (2017 October monthly patch bundle)Content This note provides information about Fusion OTBI R12 PB10 (2…User720640-Oracle 41 views 0 comments 0 points Most recent by User720640-Oracle Reporting and Analytics for HCM -
Error 500 --Internal Server Error - BIP ReportsSummary Error 500 --Internal Server ErrorContent We have created a BIP reports but when we run it we get the following error message. Is there a way to fix it? thank you -
Talent Profile data of ex-employees?Summary To be able to analyze the quality of talent that have left our companyContent Hi CC Community, We are trying to get Talent Profile data from OTBI. More specifica…Pnguyen-Oracle 49 views 2 comments 0 points Most recent by Pnguyen-Oracle Reporting and Analytics for HCM -
Intercompany out of balance reportContent Hello Gurus we looking at developing the following report we are not using AGIS and we have one ledger only. we would like to get the account balance twice on th… -
Tables vs Subject AreaSummary How to quickly find the right Subject Area from a particular tableContent Hello everyone, I have a Disco report based on the following tables. So, we may say the…Alvaro Couto 120 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Number of hires by contract type in OTBI reportSummary I want to use 2 subject areas (contract type) and assi event real time to display number of hires by contractContent Hello, I m not able to join the number of hi…User_I6AXL 34 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Termination report with subquerySummary Looking for a subquery that would eliminate currently active employees form termination reportContent Hello, I am trying to build a termination report for our or…User_2025-01-29-23-59-58-976 96 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How get approver comments?Content Hi All, I am just trying to find a subject area to get the approval comments at the point of approval of a performance document? Is it possible to get from subje…Achala Munasinghe 57 views 5 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Rel12 PB8: OTBI HCM Prompts subject areaSummary A new subject area has been added to the list of HCM OTBI subject areas. The purpose of this subject area is to setup dashboard prompts and use them in the dashb…Raghavendra Raghunath-Oracle 164 views 1 comment 6 points Most recent by AbulKhair Reporting and Analytics for HCM -
Content Pack - Oracle Fusion Cloud (Financials, Supply Chain and Manufacturing)Summary Where can I find Content pack for Data Visualization / OAC for Oracle Fusion CloudContent hi there, Does anyone know where to find the content packs for data vis…User_2025-01-28-08-30-45-744 90 views 0 comments 0 points Most recent by User_2025-01-28-08-30-45-744 Reporting and Analytics for ERP -
OTBI HCM Prompts Subject AreaSummary How do I use the Subject Area: OTBI HCM Promps?Content Hi all - I noticed a subject area I had not seen before: OTBI HCM Prompts. I am unsure how to use this, bu… -
OTBI vs OBIA (Data Warehouse)Summary When do I use OTBI vs OBIA?Content Hi all - I am still learning our environments and would like to understand when to use OTBI/BIP and when to use OBIA (Oracle d… -
Worker's Folder Take Forever To Load in OTBI Subject AreaSummary Worker's Folder Take Forever To Load in OTBI Subject AreaContent After the Release 12 upgrade, we have been facing issues creating Analysis, the Worker's Folder …AbulKhair 57 views 16 comments 1 point Most recent by Vijay Thakur-25679 Reporting and Analytics for HCM -
Need help setting the Month-end Date on ReportsSummary Need help setting the Month-end Date on ReportsContent The Calendar month-end date reported from the Time dimension on historical subject areas is reporting one …User_2025-01-22-19-28-28-240 74 views 2 comments 0 points Most recent by Cindy Sutrisna-24907 Reporting and Analytics for HCM -
OTBI Analysis Based On Static DataSummary Is it possible to create OTBI Analysis Based on static data in Oracle HCM Cloud?Content Hi Experts, I am aware we can create BI Data Model using static data( Exc…AshishERPCloud 94 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Number of employee with a salary = 0Content Hello, I try to do a really simple OTBI : get the number of employee with a salary = 0 I don't manage to do this, I have 0 result with the code below is there so…User_2025-01-25-01-33-46-269 81 views 9 comments 0 points Most recent by User_2025-01-25-01-33-46-269 Reporting and Analytics for HCM -
Subject Areas and Roles - R12Content Can anyone point me in the direction of some documentation which shows which Roles can access which Subject Areas across ERP for Fusion R12? Thanks Dean WillifordUser_2025-01-29-00-51-37-288 87 views 4 comments 0 points Most recent by Venkateswarlu Yenuganti-23335 Reporting and Analytics for ERP -
Report Table Results TruncatedSummary Formatting Report OutpuitContent Anyone know how I accidently shrunk the table results like the attached pic?User_2025-01-28-08-47-04-905 31 views 9 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
OTBI Comp Report That Restricts ViewsSummary OTBI Compensation Report using a custom DM needs restriction on dataContent We've created an OTBI comp report using a custom data model. This report is allows mg…User_2025-01-25-00-37-41-739 42 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Talent Profile ReportsContent Our legal team has requested an audit trail type of report for Talent Profile details. Specifically they want time stamps of when data was added or removed by wh…Amanda Miller-8078 193 views 1 comment 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Performance Rating Status - "Not Started", "Ready", or blankSummary Unable to see employees eligible for their Performance Review but haven't began the processContent Has anyone been able to pull employees eligible for a Performa…User_2025-01-28-08-47-04-905 63 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to show the grand total with group by option ?Summary How to show the grand total with group by option ?Content Can you please help us how to show the grand totals with group by option. I am trying to bring the repo…User_AEMC1 80 views 10 comments 0 points Most recent by Vikram Agarwal-43618 Reporting and Analytics for ERP -
GUID codes in OTBISummary Can i obtain specific GUID codes from OTBI?Content Hi, Can I use OTBI to extract the GUID codes for specific data fields? For example, I would like the GUID for …User_2025-01-28-05-39-23-766 66 views 7 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM -
R12 Upgrade: OTBI Reports are not runningContent Since the R12 upgrade when trying to run any OTBI Report by clicking on Apply or OK, nothing happens in the page, and the report does not generate. Open the repo…Rebecca Smith-27468 60 views 8 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM