OBI Answers
Discussion List
-
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 4 views 1 comment 0 points Most recent by Andreea Versanu-Oracle Reporting and Analytics for ERP -
Different Checklist IDSummary: Checklist_ID is always equals to Task_ID for the task associated with the particular checklist. do there is some cases where it can be different, please help. C…Yashpal_Mahto 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Custom Folder is unavailable to all the UsersSummary: Our users are not able to see the Custom Folder under Shared Folders All our reports are in the Custom folder. Possibly -mistakenly the permission of the folder…
-
How to Find an IP Address of a User who has Logged in Fusion Application ?Summary: How to Find an IP Address of a User who has Logged in Fusion Application ? Content (please ensure you mask any confidential information): Hello, I have a requir…Cesar Saveedra 397 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
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…
-
Can we enable or disable report one parameter field based on other parameter field input?Summary: We received requirement like, 1) Choose field say start date or end date from drop down 2) Choose Operator Prior/After/Between from drop down 3) Enter Date : Da…Nikatfusion 97 views 1 comment 0 points Most recent by Sridhar Gupta Yerram-Oracle Reporting and Analytics for ERP
-
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… -
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 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Can we access dashboard prompts value in URL as Dynamically in BIP Report?Summary: Hi Experts, We are having a requirement, whenever user clicks on count then it should redirect to the detail report for those specific values selected in Dashbo…
-
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 2.1K views 14 comments 15 points Most recent by Bea Reporting and Analytics for ERP -
Bhavani Rikkula 31 views 2 comments 2 points Most recent by Nagaraju Upputuri 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
-
In Maternity Leave - Absence Type Balance is not Showing for the EmployeeSummary: Created a Maternity leave with Qualification Plan. But Absence Type Balance i am not able to see the number of balance days. -
How to get only Month and year without days in otbi report Pivot table?Hi everyone, I'm working on an OTBI report and I'm stuck with a visualization challenge. I'm using an accounting date in a pivot table, but I want to display each year a…
-
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 515 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 982 views 12 comments 1 point Most recent by Nareshbabu Mallela Reporting and Analytics for ERP
-
A report that tracks user access activity historySummary A report for security that tracks user login history what data or module was touchedContent Does anyone know how/where I can get this information together? This …Kimberly Nguyen 285 views 18 comments 0 points Most recent by Mayur_P 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 395 views 6 comments 3 points Most recent by Ajay Hareesh Reporting and Analytics for ERP
-
segregation of access within BI Reporting (Reports and Analytics)Summary: Requirement to segregate the access in Reports and Analytics such that user who can deploy the reports to PROD, user who can manage the reports (edit/delete) an…
-
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 -
Table/Query to find the BPM work flow notification pending with particular personSummary: We are looking for Workflow notifications (Especially Expense report) pending with one particular person for approval. Do we have any table which stores this de…Thanigainathan R 452 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 268 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
How to add Reports to Task Menu (Reports and Analytics) in UI?Summary How to add Reports to Task Menu (Reports and Analytics) in UI?Content Hi How to add Reports to Task Menu (Reports and Analytics) in UI? We have requirement like … -
How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?Summary: Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI Content (required): We are trying to create a Dashboard which …Waqas Yousuf 254 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
ESS Print Job Queue - Oracle Fusion CloudSummary Accessing the ESS Print Job Queue from Oracle Fusion Cloud.Content Hi, As part of performance testing we ran Invoice Print Program for a wide range of dates, cus… -
OTBI - YTD -For - Period NameSummary YTDContent All->How to calculate Year-To-Date YTD (total amount for a given period) for a amount column from OTBI. when a user selects Period Name from Parameter…
-
OTBI Analysis Subject Area: General Ledger - Balance Real Time "Period Name" range criteria issueContent Hello There, I am using a range critera BETWEEN for a OTBI analysis Subject Area: General Ledger - Balance Real Time column name 'Accounting Period Name' and thi…Donald 219 views 4 comments 0 points Most recent by Chandra Kiran Ushakoela Reporting and Analytics for ERP