-
Impose security that segregates data by BU in lower environments for report development
Organization Name PriceWaterhouseCoopers Description Impose security that segregates data by BU in lower environments for report development Use Case and Business Need In the case of access for territory "Reporting champions" in order to develop local reports in Oracle. Idea was to provide access to “OTBI reporting areas”…
-
Looking for functionality to change currency preferences from OTBI in mass
Organization Name Nottingham City Council Description When testing reports, we found that the output was showing no GBP values in columns which should show values, but they are blank. We investigated and found that the reason is because the default currency setting for the user is incorrect. It is set to be Default - User…
-
Restrict User to swiping of Reports or Folders from another place to another
Organization Name NTT Data Description Hi Team, Is there any way to restrict the user from swiping (Drag and Drop) the reports or folders from one place to another in BI page. May be using security or policies.This may be happening unintentionally without the knowledge of the user sometimes. Eg: a report or analysis has…
-
Restrict User to swiping of Reports or Folders from another place to another
Organization Name NTT Data Description Hi Team, Is there any way to restrict the user from swiping (Drag and Drop) the reports or folders from one place to another in BI page. May be using security or policies.This may be happening unintentionally without the knowledge of the user sometimes. Eg: a report or analysis has…
-
Access to favorite OTBI folder from OEC top
Description I created a shot cut icon on the OEC top screen to access my favorite OTBI folder. I refer to the following manual.…
-
FscmTopModelAM.ScmExtractAM.InvBiccExtractAM.LocatorFlexFieldBIVO Unavailable in BICC PVO list
Organization Name Ricoh Europe PLC Description The below list of PVOs of SCM module has discrepancy between documents as well as with BICC, the below table have the details and the list of PVOs. The documents I have used for analysis are present right after the table with the link. PVO Name>…
-
ARCS Report - Multi-Select Prompt?
Organization Name MGM Resorts International Description Would like to request an Enhancement to have a prompt for our users that would allow them to be able to have a multi-select capabilities for multiple entities for our reports in ARCS. Within the Reconciliation page, we can do various filters that allows multi-select,…
-
Certify OBIA 11.1.1.10.3 with RHEL 7.9
Organization Name AMEX Description We want to upgrade OBIA from 11.1.1.10.2 to 11.1.1.10.3. This is an out-of-place upgrade. Currently OBIA 11.1.1.10.3 is certified for RHEL 7.5 and 7.8. The BI Server where we will be installing OBIA 11.1.1.10.3 has RHEL 7.9 OS. Our company policy is to apply the latest security patches to…
-
Certify OBIA 11.1.1.10.3 with RHEL 7.9
Organization Name AMEX Description We want to upgrade OBIA from 11.1.1.10.2 to 11.1.1.10.3. This is an out-of-place upgrade. Currently OBIA 11.1.1.10.3 is certified for RHEL 7.5 and 7.8. The BI Server where we will be installing OBIA 11.1.1.10.3 has RHEL 7.9 OS. Our company policy is to apply the latest security patches to…
-
Increase OTBI Subject Area Procurement - Purchasing Real Time
Description We are requesting that Oracle increase the OTBI subject area "Procurement - Purchasing Real Time" to include more information from requisitions and agreements. Use Case and Business Need This is the main subject area used by our company. In order to create reports with meaningful information, we often need to…
-
OTBI Report Creation tools are antiquated
Organization Name Citizens Property Insurance Corporation Description The current tools that are used to create OTBI reports are not easy to use and are antiquated. We are asking for better report creation tools. Use Case and Business Need It is extremely hard to put things in the correct place based on where the system…
-
OTBI Create analysis- More Columns Dialog Box Columns cannot expand.
Organization Name General Electric Company Description Hi Team, We are working in SCP cloud of version 19B (11.13.19.04.0) Please navigate to Reports & Analytics--> Select Supply Chain Planning Real time area-->Create Analysis--> Continue until "Sort & Filter " train stop then Expand add Filter drop down, select "More…
-
OTBI: Increase 300 object listing limit for folders and objects
Organization Name Hormel Foods Description List all catalog objects in a folder instead of limiting to 300 without a way to page through the rest of the results or keep scrolling to the end of the list. Use Case and Business Need Unable to manage all objects in a folder if there are more than 300. It is common to have more…
-
Price Book Subject Area
Description As a continuation of conversation with Priscila T. (Technical Support Principal) on community platform and on support i would like to justify importance of ER registered in case to implement Price Book OBTI Subject Area: Bug 21378220 : NEED ABILITY PUBLISH A CUSTOM SUBJECTFOR PRICE BOOK AND PRICE BOOK LINE…
-
OACS - FIN and HR - Mass Upload/Migrate Application Roles
Organization Name Southern Description Hi, We are using OACS Classic and OACS DV. We are currently on Version 5.8 going to Version 5.9 in January 2021. We have IDCS enabled environments. The roles and role assignment flow from FA to OACS via IDCS is working correctly. We are able to create OACS roles manually (application…
-
Import Oracle Fusion Human Capital Management (HCM) Security Roles into Oracle Analytics Cloud (OAC)
Organization Name Arcadis Description We are trying to import the Security Roles from Oracle Fusion Human Capital Management (HCM) into Oracle Analytics Cloud (OAC) but we are encountering difficulties since we are not able to get the correct tables from Fusion HCM. We already create an Oracle SR and the feedback that we…
-
OTBI Dashboard prompt - display option of NULL to user instead of *)nqgtn(*
Description When using the standard "Specific Column Values" feature to limit the list of values in a dashboard prompt, we include NULL from the picklist as one of the selectable values. When the user goes to use the prompt, instead of seeing NULL they see *)nqgtn(* which obviously makes no sense to them. All other values…
-
Logical SQL more comparable to Oracle SQL
Description Many times OTBI logical sql is needed to pull the appropriate data from the subject areas and join multiple subject areas as needed into one subject area. However, using logical sql can be tedious and daunting based on syntax requirements and the need to alias tables multiple times. It would be incredibly…
-
OACS Classic - Administration - Catalog Groups
Organization Name Southern Description In FA, SaaS, it is possible to create catalog groups in OBIEE to manage catalog permission. In OACS Classic, it is not yet feasible to create catalog groups to manage catalog security. Attached in the Idea Lab shows the difference in Administration capabilities between both…
-
To make the BIP report self-Incompatibility
Organization Name Black & Veatch Corp. Description As now their is no way to make the BIP report self-Incompatibility. Their should way to make the BIP report and OTBI report self-Incompatibility per setup. Use Case and Business Need The report cause issue running multiple instance at the same time. Original Idea Number:…
-
To make the BIP report self-Incompatibility
Organization Name Black & Veatch Corp. Description As now their is no way to make the BIP report self-Incompatibility. Their should way to make the BIP report and OTBI report self-Incompatibility per setup. Use Case and Business Need The report cause issue running multiple instance at the same time. Original Idea Number:…
-
GSI - Data Source Access across Oracle Pillars (HCM and FIN) - BI Admin
Organization Name Southern Description The Oracle Idea Lab is logged to highlight a gap in the BI Publisher security design. As of today, a user with the ability to create a data model has the ability to query any data source: Navigation > OBIEE > New > Published Reporting > Data Model > > New Data Set > SQL Query > Data…
-
Need BICC PVO to extract data for Uninvoiced Receipt Accruals
Organization Name The Cleveland Clinic Foundation Description We need a BICC PVO to extract data for Uninvoiced Receipt Accruals In other words, we need a BICC PVO (or many PVO's) to extract the same data as these two standard "Supply Chain Management/Cost Management" reports (union of data of the two reports)): -…
-
Need BICC PVO to extract data for Uninvoiced Receipt Accruals
Organization Name The Cleveland Clinic Foundation Description We need a BICC PVO to extract data for Uninvoiced Receipt Accruals In other words, we need a BICC PVO (or many PVO's) to extract the same data as these two standard "Supply Chain Management/Cost Management" reports (union of data of the two reports)): -…
-
Data Access Security by Department
Description Data Access Security by Department Use Case and Business Need Use Case: We wanted to build out dashboards in OTBI for the Cost Center managers to be able to see the financial performance of their cost centers. OCS helped us with this, and reccomended that we implemented Segment Value Security, which ended up…
-
Metadata file which is extracted from UCM should be same from the file which is extracted from Expo
Organization Name Motorola Solutions Inc Description Metadata file which is extracted from UCM is different from the file which is extracted from Export Meta Data Definition(BICC) for the same data store. Use Case and Business Need Use Case: Primary Key mapping in Metadata file which is extracted from Data store -> Export…
-
OTBI Budget version rejected not in OTBI subject area "Project Control - Budgets Real Time"
Organization Name MGM Resorts International Operations Description OTBI Budget version rejected not in OTBI subject area "Project Control - Budgets Real Time". We are having other budget status not the rejected one. SR # SR 3-24671091331 raised for this issue and they recommend raising ER. Use Case and Business Need…
-
OTBI Budget version rejected not in OTBI subject area "Project Control - Budgets Real Time"
Organization Name MGM Resorts International Operations Description OTBI Budget version rejected not in OTBI subject area "Project Control - Budgets Real Time". We are having other budget status not the rejected one. SR # SR 3-24671091331 raised for this issue and they recommend raising ER. Use Case and Business Need…
-
Include the open interface tables and the error tables in the OTBI areas
Organization Name Landsbond Christelijke Mutualiteiten Description It should be possible to report upon the open interface tables and the errors that occurred during the import processes. When building an end-2end-integration, it is needed to have an view on the transactions sent from the source application and compare…
-
Pretrained ML Models to predict Change Order Cycle Time
Description FAW or OTBI should create ML models to predict Change Order Cycle time for different verticals. An example - * A model created on Manufacturing Industries' data (public data if available) can be trained and provided to customer as a value-add * The model can use PCA (principal component analysis) to figure out…
