OTBI
Discussion List
-
Linking a Dashboard with an InfoletWe have a PPM Dashboard and multiple reports are linked to that dashboard through a HTML script. This PPM dashboard is mapped with the PPM Infolet using 'Link Detailed R… -
Payables Invoices - Transaction Real TimeSummary: Extracting AP Data and PO status as well Content (please ensure you mask any confidential information): When selecting the required columns like invoice #, date…
-
OTBI - Issue while submitting Custom report - Asset Cost DetailSummary Error while selecting parameters for Custom OTBI report which was copied from Asset Cost Detail reportContent Error while selecting parameters for Custom OTBI re…User_2025-02-04-10-47-46-258 43 views 1 comment 0 points Most recent by Priya_Ananda Reporting and Analytics for ERP -
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
How to hide embedded dashboard setting and help link and create custom dashboard styleContent Hi All, I have embedded a dashboard adding dashboard link to webpage content on the Oracle cloud hcm homepage. 1) I have added "PortalPages" to the link, however…Punam Roy Karmokar 85 views 8 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Oracle Cloud PPM - Reporting period for Project Performance ReportHello Team, As in Oracle EBS Projects we have option to set the Reporting Period separately to generate performance reports for that/up to month. Do we have similar feat…
-
OTBI report timed out for specific Period onward even data count is similarWe are facing issue with a OTBI report that's part of a dashboard. The user runs the report exclusively through this dashboard. It has been working fine since last one y…Abhishek_Kumar_DTV 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Context PO DFF does not appear in OTBI - PO real time subject areaSummary: We have a context DFF at the PO Header, and I am unable to see those DFF's in the OTBI Report (Procurement- PO Real Time). Is there any way to allow the OTBI so…diego m schenquerman 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to know who delete some reports in OTBIA folder containing reports has disappeared from my environment, and we want to know if it was accidentally deleted by a user or where the folder is located.Roy1823 35 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI Agent Returns 25,001 RecordsSummary OTBI Agent Returns 25,001 RecordsContent I created an OTBI analysis. Then, I created an agent that runs the analysis. I schedule the agent and request the format…Daniel McMillian 97 views 7 comments 4 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Restore saved OTBI analyses after user name changeHi guys, One of the HR Users of the customer married last weekend. So her name changed, as well as her username changed. On the old user name she stored some analyses in…Katharina_Seidenfuß 32 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 159 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Unable to get requisition number value when combining with assignment subject areaSummary: Please find the report catalog , unable to see the value for Requisition number. I'm combining below three subject areas and for Recruiting I'm using Number of …
-
Need of PO 'first approved date' in the OTBI subject area to extract the dataPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…
-
Custom role to access Expense Transactions Real Time subject areaSummary: I need help creating a custom role that grants access Expense Transactions Real Time subject area in OTBI. We don't want the users to have access to Expenses in… -
All employees are not visible in OTBI Expense ReportSummary: Business does not want to provide expense manager role and Expense Auditor role to user who will be using this report. Because of this all users are not fetched…
-
User unable to view Employee's address details in OTBI ReportsHi Experts, We have created a report using the subject area 'Workforce Management - Worker Assignment Real Time'. We got the other cloumn values except city, county, sta…
-
Is there a way to filter this way in OTBI?Summary: Content (please ensure you mask any confidential information): I'm extracting columnA from a table. It has both null and not null values. »»»Filter should only …Stefano_Mazzocca 21 views 5 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI analysis on duplicate expense linesSummary: How do you do this? I'm new to OTBI and Fusion ERP. I need to report on duplicate expense lines, meaning an employee accidentally submitted their expense twice …
-
Outage for Import Oracle Fusion Data Extensions for Transactional Business Intelligence?On the documentation page discussing importing DFF fields using Import Oracle Fusion Data Extensions for Transactional Business Intelligence it mentions "Running the pro…Angela Montenaro 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Is the number of rows retrieved from OTBI analysis is increased from 75K?Summary: OTBI analysis can retrieve maximum rows of 75K. But users are now able to retrieve around 160K records from the analysis. Is there any update/change happened in…Mounika Samayamantri 31 views 3 comments 0 points Most recent by GiuliaC-Oracle Reporting and Analytics for ERP
-
Can we Display 'Standard Cost' of Item in Demand Plan Tables?Summary Can we Display 'Standard Cost' of Item in Demand Plan Tables?Content Hi All, We have column 'Standard Cost' in Demand Plan in Items table (as shown in screenshot…Ramesh Choudhary 54 views 3 comments 0 points Most recent by Catherine Alequin Supply Chain Planning and Collaboration -
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th… -
Is there a way line managers can view element entries?Summary: Is there any way line managers can view reports with element entries? I'd like to create an overtime report so they can monitor their reportees claims but it do…
-
How to retrieve AS$_ATTRIBUTE7 in OTBI?Summary: I'm looking for assignment descriptive flexfields and I'm using "Workforce Management - Person Real Time" subject area Content (please ensure you mask any confi…Stefano_Mazzocca 21 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI - Which Subject Area/field provides "Total Unit Cost" value from "Review Item Costs" UI?Hi folks, I'm struggling to find the correct subject area/field within OTBI that calculates the "Total Unit Cost" shown in the "Review Item Costs" UI (Supply Chain Execu…
-
OTBI Subject Area: Fixed Assets - Asset Depreciation Real Time data mismatchIn UI, Asset's Initial units were 100, And 66 units were partially retired and then Transferred out on Oct-24. So the current active units are 34 and the Depreciation Re…
-
Worker HDL Error A primary assignment already exists.Summary: We are trying to load worker data with historical Data in Dev1. We are getting this error(A primary assignment already exists.)for lot of inactive employees. We…Krishna Manmohan 115 views 3 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM -
How to export all the rows from EGO_ITEM_EFF_B Table?Summary: We have a requirement to export all the Attribute Groups Attributes data from EGO_ITEM_EFF_B table in a common format and push it to a downstream application. P…