OBIEE Answers
Discussion List
-
Unable to copy shortcut to MyFolders due to Path not found - Check the input path entered errorSummary: Hi, Got this error when trying to copy/paste shortcut of a folder to MyFolders : I have full ownership of the folder that i'm trying to copy the shortcut : Plea…Shashidhar Goud 11 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
ORA-00920: invalid relational operator when using Menu parameter with multiple selection enabledSummary: Hi Team, I'm unable to use Menu type parameter in where clause in SQL query in a DataModel when 'Multiple Selection' enabled. Below is the screenshot of the whe…Shashidhar Goud 101 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Create List of Values for Dependent Segments in GL Custom BI Publisher Reports White PaperSummary: Your finance staff may modify standard GL BI Publisher (BIP) reports to address specific business requirements. They may need to run a GL BIP report by various …Helle Hennings-Oracle 541 views 12 comments 14 points Most recent by Jose Carlos Amaral Flinco Financial Management Resource Center -
R13: Project Portfolio Management Cloud OTBI: Subject Areas to Database Tables Mapping SpreadsheetSummary The spreadsheet provides a mapping of the BI Subject Area columns to source database tables and columns. It also has the View Object (VO) names for each column. …Noelle Bartlam-Oracle 5.5K views 24 comments 5 points Most recent by Prosenjeet Bit Reporting and Analytics for ERP
-
Get Recipients from the Analysis as Task Owners from Project Subject AreaSummary: Cannot set dynamic recipients of an email with analysis. The standard functionality should be available using an Agent. The agent was setup for an analysis done…Dejan Begovic 1 view 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP
-
How to create a new KPISummary: How to create a new KPI Content (please ensure you mask any confidential information): Hi Team, How to create a new KPI reports for Finance? Could anyone guide …Venkatesan 1 view 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Allocation percentage for resources in the projectSummary: Hi everyone, We're looking to gather details on project resources, specifically allocation percentages. It's important that these resources are currently assign… -
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …
-
Some columns have null values for certain records and record is not retrieved when the column is selSummary Some columns have null values for certain records and record is not retrieved when the column is selectedContent I am using "Fixed Assets - Asset Depreciation Re…
-
Unable to find custom ESS job created in the scheduled job screenI have created ESS job but unable to find the same in scheduled job screen to run, I have ran "Import User and Role Application Security Data" and "Retrieve Latest LDAP …Thanigainathan R 298 views 4 comments 0 points Most recent by Vijaya Sekhar A-Oracle Reporting and Analytics for ERP
-
Trouble with GaugesSummary: I'm trying to create a simple gauge that shows the percent balance left, but the gauge is not reflecting the correct information. Content (required): I'm using … -
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve… -
Drill down to ERP pages through Infolets as standard onesSummary: Hi, We want to create objectives that are actionable that is, as the standard ones from Oracle. For example, create an infolet that shows the number of invoices…Emma Fayos García 21 views 2 comments 1 point Most recent by Emma Fayos García Reporting and Analytics for ERP
-
Sample SOAP request payload for OTBI Analysis extractSummary Sample SOAP request payload for OTBI Analysis extract using variables or filter criteriaContent I have an OTBI analysis based on the "Procurement - Purchasing Re…
-
Termination count is not showing correctly in OTBI reportSummary: Termination count is not showing correctly in OTBI report Content (please ensure you mask any confidential information): Hi All, We are developing a HR dashboar…Venkatesan 12 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
How to Link Purchase Order Invoices back to Project Costs?Content Hi All We're working on a Project Statement report that brings back a comprehensive breakdown of the project costs and revenue. For the costs, we were able to br… -
I was creating multi partitioned external table received errorHello Tom i was creating multi partitioned external table from parquet file but end up having these error did so much research but not able find cause of this error plea…ankeshphapale1234 31 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to add background color BIP excel template row wise in HCMHi Folks, May I know how to set the row background colour in the Excel template? Thanks Prakash JayavelPrakash Jayavel 31 views 1 comment 1 point Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Read only access to data modelSummary: We want to provide read only access to data model for some key BIP reports, to our Internal audit team as they want to review the code behind key sox reports. W…
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 1.9K views 14 comments 15 points Most recent by Bea Reporting and Analytics for ERP -
Query for Business Units and Legal Entities mapping for Payables.Summary Need query to fetch Business Units and associated Legal Entities mapping for Payables.Content Hi All, I am having requirement to fetch all the Legal Entities ava…
-
Prepayment BalancesSummary Query for Prepayment BalancesContent Hello, We are looking to build a report that lists all current prepayments and balances, there was a Prepayments Status Repo…Elliot Hall-Walker 58 views 3 comments 0 points Most recent by Risandu olitha Reporting and Analytics for ERP
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 491 views 2 comments 0 points Most recent by Bill McLarty55-Oracle Reporting and Analytics for ERP
-
Subject Area to capture Employee detailsSummary: Content (required): Hi, Can someone please let me know the subject area to be used if the requirement is to capture the username, employee first name, employee …Sheneli98 861 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
Schedule BIP report only when it has DataSummary Schedule BIP report only when it has DataContent We have one requirement for BIP report where we have schedule BIP report daily. so we need that if report data i…User_2025-02-07-23-45-47-870 447 views 7 comments 1 point Most recent by User_A19YQ Reporting and Analytics for ERP -
Financials Cloud OTBI Release 12: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 394 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
Is it possible to grant access to a subject area from Administration/Security/Manage Privileges?Summary: If I want to grant access to all employees to one certain subject area (that really has no harmful or sensitive data 😄), is it then possible to give them access…Anders W. Langholm 72 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
SQL query to get transaction date on statement lin, joining CE_BAT_TRANSFERS with CE_STATEMENT_LINESI'm trying to create a query where I want to find the transaction date of an Internal Bank Transfer. The goal is to create a report which is used for reconciliation of b… -
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r…
-
GL Segment Level security and OTBI Subject areasSummary: We have a requirement to secure data down to a legal entity/cost center level for dashboard built in OTBI with the GL Transactions real time subject area. How b…amy hardtke 31 views 2 comments 0 points Most recent by Madhavi Godbole Reporting and Analytics for ERP