OTBI
Discussion List
-
Which exact privilege or duty role allows user to access Security dashboard?Summary: We want to give user access to below seeded reports. Currently "Application Implementation Consultant" gives that access but we cannot assign the role due to ot… -
Fetch OTBI report output in csv format to transfer to 3rd party serverHow can we fetch OTBI report output in csv or any other format(not xml) and transfer to 3rd party vendor server(using OIC SFTP adapter). Tried to use ****.oraclecloud.co… -
PO description should be only available for specific users with specific rolesSummary:We need to restrict data for specific columns of subject area based on the Login Credentials and assigned specific roles to the user in OTBI. Eg: PO description … -
Buyer Assignment Rules OTBI ReportGood Day Experts, Is there a way to create an OTBI report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Applicatio… -
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one …Elavarasan S 31 views 10 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
Learning reports / dashboards - any good examples to share?Summary: Any learning reports or dashboards that people would like to share? Content (required): My company is moving from managing all training administration on spread…Lee-GT 512 views 9 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
Adding Prompts to BI Publisher Data Models that are based on OTBI ReportsContent Hello, We are implementing OLC and are making certificates in BI Publisher. To make it a little easier we've build the data model off an OTBI report, but we are …User_2025-01-31-00-25-12-234 119 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
No data displayed in Goods Received not Invoiced ReportSummary: Hi, I am using seeded OTBI Report 'Goods Received not Invoiced Report' and made a custom report with the same subject area i.e. Costing- Receipt Accounting Real…Vijayalakshmi Matcha - Oracle-Oracle 581 views 4 comments 0 points Most recent by cylim Reporting and Analytics for SCM -
Learning Calendar is not working as expectedSummary: Hi Team, @Mandeep Gupta I'm trying to enable the Learning Calendar in the Administrator Dashboard. Currently, I'm facing an issue with the Learning Calendar OTB… -
Static URL for an analysisI am creating a tile on the My TEam page for a report, how do I build the static URL for an out of the box analysis that I have created a report from? I was able to do s… -
How to enable Export options when analysis added to Reports and AnalyticsSummary: Enable export options below a report from an analysis Content (please ensure you mask any confidential information): We have created custom analysis and made th…Alexandre Chea-Oracle 343 views 12 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Person real time and Assignment real time securityWe have an OTBI analysis for passport and visa details. It combines the Person Real Time and Assignment Real Time subject areas. One employee has a current assignment in…Stephen Jones 21 views 5 comments 0 points Most recent by Stephen Jones Reporting and Analytics for HCM -
SQL query to get remaining life, depreciation for the month, depreciation expense account in FusionSummary: SQL query to get remaining life, depreciation for the month, depreciation expense account in Oracle Fusion for Assets Content (required): Version (include the v… -
Missing current month data in OTBI for payrollSummary: Missing current month data in OTBI for payroll Content (please ensure you mask any confidential information): We have facing an issue where the current pay peri… -
Need document on how to migrate Value Set from HCM Extarct to from one instance to another instanceSummary: Need document on how to migrate Value Set from one instance to another instance Content (please ensure you mask any confidential information): Hi Team, I am usi…Ketan-Oracle 21 views 1 comment 3 points Most recent by JayeshKori-Oracle Reporting and Analytics for HCM -
How do we access OTBI reports in redwood inventory?Summary: In the Classic UI users are able to access OTBI reports from the drawer on the right of the screen. How do users access OTBI reports in Redwood Inventory? Conte… -
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't…User_2025-01-31-00-25-12-234 433 views 8 comments 0 points Most recent by PraveenNvP Reporting and Analytics for HCM -
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 129 views 5 comments 1 point Most recent by Rich Merkel Reporting and Analytics for ERP -
Is it possible to run an OTBI report and the results to be what my manager would seeI want to be able to build reports in OTBI for employees to run, with the results to return as if it was their line manager running the report themselves. I understand t…Helen Tilling 1 view 0 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM -
While im creating a analysis report, when i add the invoice number it duplicates the rowSummary: Im creating a report in analysis when basics fields like Order, source order, customer, item and basic of the order line everything fine. But when i add the inv… -
Original Candidate sourceSummary: Content (required): Is it possible to capture candidate’s original source via reporting? Currently the system only tracks application source and we lose key dat…Riti Malhotra 41 views 3 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM -
Labor Distribution - Reporting Attribute to Identify Labor Costs that are Eligible for ReprocessingSummary: We need to be able to proactively identify labor costs that are eligible for reprocessing based on changes to corresponding labor schedules. For example, if a l… -
OTBI Report with future hires and terminationsHello, We are attempting to build a report to help our partners keep track of I-9 completions. We are using the subject areas Worker Assignment Event Real Time and Work …joshvanlaan 321 views 10 comments 0 points Most recent by Kimberly B. Reporting and Analytics for HCM -
otbi is fetching the amount details for only USD currencies not for all currenciesotbi is fetching the amount details for only USD currencies not for all currencies do we need to enable any profile options, apart from USD we are unable to get the amou…Akhila.Allagadda 51 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Agent Not Sending Files to Distribution List EmailGood Day Experts, We have an OTBI Agent that is not sending the file to a distribution list email. The OTBI Agent is sending our dashboard to an excel file. Sending to i…JMLMIII 61 views 6 comments 0 points Most recent by Vidhya Nadarajan-Oracle Reporting and Analytics for HCM -
Where can we find bank account suffix from Supplier site bank account Subject area?Summary: Supplier bank account suffix in OTBI Content (please ensure you mask any confidential information): The Account Suffix is located under Additional Information i…Uma Scherer 1 view 1 comment 0 points Most recent by SankarBalu Payables, Payments & Cash Management -
pension reason for leaving qualifying schemeSummary: Report on Employees who have opted out of a pension scheme. Content (please ensure you mask any confidential information): Hi All. Trying to create a report tha… -
How doo_headers_all and por_requisition tables are related .Summary: We need to write query to connect doo_headers and requisition to get po_number and receipt . or it can be connect from PO or RCV tables? how can i form query wi… -
Cannot select attributes from 2 different folders in same Subject AreaSummary: I select "- Negotiation Header Detail"."Negotiation Number" and "- Supplier List Detail"."Trading Partner Id", 2 columns from same Subject Area and 2 different … -
How do we access OTBI reports in redwood inventory?Summary: In the Classic UI users are able to access OTBI reports from the drawer on the right of the screen. How do users access OTBI reports in Redwood Inventory? Conte…