OTBI
Discussion List
-
Project List Details OTBI report not showing any DataSummary: Project List Details OTBI report not showing any Data. Custom role is configured with all the below required duty roles Project Performance Reporting Transactio…Rohit Kumar Singh 8 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Fixed Assets - Entered PeriodSummary Is the "Entered Period" available in any of the Fixed Asset subject areas?Content I have been searching through the various asset-related subject areas for a fie…ndryden 231 views 5 comments 0 points Most recent by Bhagchandani Nayan Reporting and Analytics for ERP
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 25 views 3 comments 0 points Most recent by Toyesh Patra Reporting and Analytics for ERP
-
Unable to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (please ensure you mask any confidential information): The…
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 47 views 3 comments 1 point Most recent by User_WXKBG Reporting and Analytics for ERP
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 83 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2K views 7 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI Report for Payables Distribution SetsSummary: Trying to create OTBI Report of the Distribution Sets along with the details on the account numbers assigned Content (required): Create OTBI Report of Distribut…
-
OTBI Agent - Invoke an HTTP RequestSummary: While invoking an HTTP Request as an Action from Agent, receiving below error in Fusion ERP Cloud. Could you please provide steps on how to resolve this in Fusi…Abhilash K - Deloitte USI 11 views 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 156 views 2 comments 4 points Most recent by SBJ_PPM_1210 Reporting and Analytics for ERP -
Error when performing a multiplication on a calculated measure in OTBISummary: Hello, When trying to perform multiplication on a calculated measurement of the items in the image, An error occurs that I have not been able to resolve. Conten…Kauan_Bohn 42 views 16 comments 0 points Most recent by mathew060581 Reporting and Analytics for ERP -
talent profileSummary: hi, Could I get the pending transaction data (includes items data) which is under approval for employee talent profile. Content (please ensure you mask any conf…User_L2S8E 16 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP
-
Oracle Help desk tables and Queries to develop a reportHi All, I need to develop a custom BI or OTBI report related to the columns below. Please guide me on this Assigned To Assigned to: Email Category Name Channel Name Crea…
-
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe… -
OTBI - Export timeout based on user role?Summary: My manager and I are exporting the same OTBI analysis (excel format). While my export will automatically time out after 10 minutes, hers can export for hours un…
-
How to calculate in OTBI the receivable balance for any transaction on any dateHi all I created a report that shows the balance of receivables for each transaction using Subject Area "Receivables - Transactions Real Time". It shows the current bala…
-
Subject area in OTBI corresponding to XLE_REGISTRATIONS tableSummary: I need to find the subject area in OTBI in which the information about SIREN / SIRET numbers are stored. These data correspond to REGISTRATION_NUMBER column fro…Evgeniya Repnina 18 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Requisition Counts and Year to dateSummary: Requisition Realtime Help! I am trying to create a Requisition report that will display Departments and columns Jan ct, Feb cnt etc and the last column will be …Kobby Adu 104 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
General Guidance on BICC/BIP for PVO JoinsSummary: General guidance on Fusion BICC/BIP for PVO joins & if Fusion supports AI/ML analytics? Content (please ensure you mask any confidential information): My unders…
-
OTBI time out for regular user super user runs in 22 secondsSummary: We have an OTBI analysis that we built. Content (please ensure you mask any confidential information) For a super user it runs in 22 seconds, but for a regular … -
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, VipushaVipusha Chandrakumaran 71 views 7 comments 2 points Most recent by RyanPasca1 Reporting and Analytics for ERP
-
How to give Unarchive option in Custom folder which is read only for a user in BI Catalog?Summary: We have a custom role which gives read only access to the Shared Folders > Custom folder. We also want to provide Unarchive access under the Custom folder. The …
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 51 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
OTBI is repeating the same values for multiple records.Summary: OTBI is Repeating the same values for multiple records, Subject Area Receivables Journal Real Time and Transaction Real Time Content (please ensure you mask any…
-
Can we assign bulk roles to user accounts ( not employees)Summary: Hello All, Can we bulk assign roles to users those are not employees in fusion? Content (please ensure you mask any confidential information): Version (include …Lucky Sharma 11 views 2 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1K views 6 comments 1 point Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec…Anders W. Langholm 66 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
OTBI Prompt - Default Programmatically setting dateSummary: When adding in an accounting period, I'm not able to programmatically set a date with the format YYYY-MM. I've tried a few different things but I can't seem to …