OTBI
Discussion List
-
OTBI Dashboard not reflecting the analysis dataSummary: When certain parameters are used in a dashboard, a couple columns return null values. The raw analysis does include data for these columns. This just started oc…
-
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
-
Help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM.Summary: Greetings, i need some help in connecting the table FND_FLEX_VALUES_VL with one of the HR tables in HCM. Content (please ensure you mask any confidential inform…
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 11 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Dashboard access and rolesSummary: To start with, big thanks to all who reply. So went live with Fusion on January 2024. I have put together a dashboard using "Receiving - Purchase Receipts Real …Than0s 34 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 238 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
How to Stop Duplication of Billed Amount in AnalysisSummary: I am attempting to build a report which will combine corporate card data and expenses data. The goal is to track corporate card transactions to the expense repo…Ashley Dore 12 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Missing PJF Tables/Views (i.e PJF_TASKS_V) In BICC PVO Data Lineage RepositorySummary: Hi Team, We need to extract data from Oracle and send it to our downstream systems. We're using BICC for this data extraction process. Our current challenge is …
-
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…Greg Aulson 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
How do I see all scheduled recurring jobs & detailsI have come into a situation where folks have been allowed to schedule recurring jobs under their own IDs. This creates a handful of issues (in my mind at least): No one…Matt Mossman 171 views 12 comments 1 point Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
Analysis to retrieve total element amount per month and yearly trendSummary: Good afternoon, I'm trying to build an analysis to get the total amount of elements (e.g., variable pay) + salary that is valid in a specific month in some coun…ammiano 22 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 124 views 6 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh…Ankit_Bhadja 16 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for ERP
-
Hide column in a data modelSummary: Hi Team, We have requirement to generate an XML output with parent and child relationships for AR invoice data. We have created a parent dataset with customer_t…
-
Numbers Format Issue Standard Purchase Order ReportDear All, The format of numbers in the purchase order BI standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the…George Mattar 22 views 3 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for ERP
-
Is there an advanced official source about the map view feature in OTBI?I would like to try using the map view in OTBI and followed the guide below for configuration, but only the background map is displaying. I would like to know if there i…Andy K W, SO 33 views 2 comments 1 point Most recent by Andy K W, SO Reporting and Analytics for ERP
-
Missing Data in Custom Report for Scheduled ProcessesSummary: We have created a custom report to meet the requirement of viewing all scheduled processes created by all users. In this report, we aim to display columns such …Srikanth Dodla 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle 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…
-
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
-
Depreciation Projection Report in Oracle Fusion CloudSummary Depreciation Projection Report in Oracle Fusion Cloud in Fixed AssetsContent Hi Friends, In Oracle Fusion, is there any report to project depreciation, similar t…
-
How to populate tax rate name under Receivables-Transactions Real time subject area in an OTBIWe built an OTBI report with the subject area - Receivables-Transactions Real time. We do not see an option to select the tax rate name/code such as GST, HST etc. Only t…Lakshmi Kanchi 11 views 2 comments 1 point Most recent by Lakshmi Kanchi Reporting and Analytics for ERP
-
Need help for getting Average cost of an item column in OTBI Subject areaHello experts, I need some quick help in for my OTBI Analysis which is for supply chain module. I want to calculate the Sum of Debits and Credits in Inventory. For that …NIKHIL M Y 52 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
display column based on promptSummary: I want to add a prompt (Yes/No) to display a column. I'd settle for a prompt that forks to two different results tables as well. Content (please ensure you mask…
-
ERP Report Sharing CentreSummary LocationContent Hi All, The HCM report sharing centre (https://cloudcustomerconnect.oracle.com/resources/5c46181001/summary) is a hive of activity, but the ERP o…Mark_Daynes 148 views 6 comments 2 points Most recent by DennisOliver Reporting and Analytics for ERP
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 33 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
I can't find rest APIS to get some columns in work structures, person and assignmentsI can't find the rest APIS to get some columns in work structures, person and assignments. Attached are Excel sheets that include the missing fields.
-
VVattikuti 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Data Security in Custom BI Reports in Oracle Fusion Financials CloudSummary Data Security in Custom BI Reports in Oracle Fusion FinancialsContent Hi, We have lot of Custom BI Reports developed across financials Module ( AP , AR, FA , GL …Udit_Manchanda 486 views 9 comments 2 points Most recent by rahul.gupta.scm Reporting and Analytics for ERP
-
Need to control the access for users from copying/moving BI folders.Summary: Users with BI Author role are able to Move (Drag and drop) the BI folders to a different location. This is causing issues since the report/folder is not found i…Shashikanth Kumar P-Oracle 11 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle BI Publisher Learning Center
-
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