OTBI
Discussion List
-
OM Redwood - Ability to embed OTBI report to create order pageHi, We need an option to embed a custom OTBI report to redwood order management create order page. We need to be able to pass bind parameters to the report. This was pos… -
Can we use two Subject Areas together in OTBI Report?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Tejas Chirke 1 view 1 comment 0 points Most recent by Saravanan Veeraragavan Product Master Data Management -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject… -
Redwood Purchasing Landing Page - Seeded KPIs and OTBI Analyses AvailabilityHi All, I'm implementing the new Redwood Purchasing Landing Page feature and trying to add KPIs to the Visualization Configurations page. When I access the configuration… -
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p… -
OTBI - Checklist Questionnaire ReportingSummary OTBI Reporting on HR Checklist QuestionnaireContent Hello, Did any one try out OTBI report on Checklist questionnaire in 20C update. I have tried one, I am able …User_2025-02-05-07-43-29-505 729 views 32 comments 2 points Most recent by PranitSawant Reporting and Analytics for HCM -
Is it possible to change the subject/content of the email sent out to requestors on a PO?Summary: Currently, once a PO is implemented, the requestor on the PO lines will be notified via bell icon and email notification. Is it possible to update the email con…
-
Convert Double Data Type to Words in OTBISummary: I am trying to build a report (OTBI analysis) where a double data type field (the Amount column) needs to be displayed in words. For example, if the amount is 3…Nur Anisa Zulkhairi 21 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Report to extract initiatives associated to Learning ItemsHello all, We're trying to create a report which should extract for each learning item (specialization, course, offer etc) the initiative(s) created and its status (acti… -
Manager not appearing in Termination reportContent Hi, We just recently implemented Oracle Fusion HCM and still trying to work some issues out. One of the issues when I try to pull a termination report that I cre…User_2025-01-23-20-22-05-099 114 views 13 comments 1 point Most recent by gclampitt Reporting and Analytics for HCM -
Issue: Barcode generated in BI Publisher Report but Not Scannable in OTMSummary: We are attempting to generate a barcode in a BI Publisher report. In our RTF template, we tested several barcode fonts—including Code 128, Libre Barcode 39 Exte… -
Fixed Asset OTBI Report - Assets Source Line InformationSummary: Fixed Asset OTBI Report - Assets Source Line Information Content (please ensure you mask any confidential information): We are trying to make a OTBI report for … -
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): …Helen Thomas 41 views 13 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM -
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… -
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…User_F89L9 431 views 8 comments 0 points Most recent by Lavanya_Sriraman Reporting and Analytics for HCM -
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 485 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 573 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 271 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… -
What is the deep link URL for Procurement receipts?Summary: We want to create an action link on OTBI report - when the user clicks on the receipt number, it should open up in the application ( Procurement - My receipts) …Astrid Ferrao-Oracle 398 views 11 comments 0 points Most recent by Kaustubh Sawant Inventory Management -
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