OTBI
Discussion List
-
Report image only visible in pdf not in wordSummary: Hi all, We noticed that when downloading a custom report in word we cannot see the image/enterprise logo attached. Whereas, when downloading the same report in …Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by SankarBalu Reporting and Analytics for ERP -
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 482 views 10 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
Procurement Procure to Pay real time subject area no data showing on purchase order measurements colProcurement Procure to Pay real time subject area no data showing on purchase order measurements Ordered Amount, Delivered Amount and Open Ordered Amounts User has AP ro… -
Query to fetch manage person contribution transaction dataSummary: Need a sql query to fetch transaction details of a ICP plan containing details of plan name, its input values, status of the transaction and the level of approv… -
How to rename BI Publisher excel output spreadsheet.(sheet1, Sheet2,...)Summary: Business needs to display Sheet1,Sheet2.... to different names when generating the output in Excel through BI Publisher. Content (required): Business needs to d…kalyan gade 636 views 6 comments 0 points Most recent by User_GMBW9 Reporting & Analytics for Fusion Service -
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 1.4K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 524 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
How to convert column into HTML format in BIP datamodelSummary: OTBI column output: Here how same column appears in SQL Datamodel in BIP So, could you kindly help on how we can convert this Comment column to be displayed as … -
Display manager and employees' phone numbers on a single row in OTBI analysis reportHi I try to display the manager and employees' phone numbers and email on a single row in otbi analysis table, but without any success. For the employee, I use this form…rrr 21 views 5 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
Inventory Aging ReportSummary Any Custom or Standard Inventory Aging Report available in FusionContent Looking for Inventory Aging report with 1-2, 3-4,5 Years Buckets data for the inventory … -
The Program Name is not populating in the ERP Project Costing module.Summary: The Program Name exists upstream but did not flow into the Project Costing module. As a result, costs are missing from the Project Cost by Transaction report. C… -
delete value set valuesSummary: Good Morning Can I delete value set values (account values ) in the account segment took the wrong hierarchy by mistakeEsraa Yousef 34 views 6 comments 0 points Most recent by Venkatesh Padamwar General Ledger & Intercompany -
Cloud Bi Bursting report output showing each email [external] in mail inbox, how to correct.Hi all, we have cloud Bi bursting report output, showing each email subject [external] in mailbox. How to remove external description. Kindly guide me.sasi 11 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration -
How to enable COA to pull account segments into OTBI when they were not originally setup to do so?Summary: I would like information on other potential workarounds to enable Account Segments for use in OTBI reporting when they were not originally configured to do so. … -
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 434 views 12 comments 0 points Most recent by Aishwarya_Muchandi Inventory Management -
Unable to get the data from Workforce Management - Worker Assignment Real Time in OTBISummary Unable to get the data if we include Assignment Manager, Assignment Manager (Unsecured), Assignment Manager List, or Assignment Manager List (Unsecured) foldersC… -
Where to store and print specific text on customer Accounts Receivable (AR) invoices?Summary: I’m using Oracle 25D, we have a business requirement to print supplier–customer specific text on Accounts Receivable invoices. The text should vary depending on… -
Redirection link to a report using environment variableSummary: #{header["host"]} variable in page entry Static URL no longer valid Content (please ensure you mask any confidential information): Hello, I used to use #{header… -
Income Statement and Balance Sheet reportsSummary Are there a Balance Sheet and/or Income Statement reports available in ERP Cloud?Content I'm surprised there isn't an out of the box version for an Income Statem…User_2025-01-25-00-55-11-011 361 views 8 comments 2 points Most recent by Christine_Inoapps Reporting and Analytics for ERP -
Report Query to Determine Subject Area UsageSummary: With the 26A release, the Workforce Management - Vacancy Real Time subject area is being discontinued. Is there a query that can be run in OTBI that will provid…Nick Henderson 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Capitalized Interest Transactions are not populating in the Project Costing Transaction ReportSummary: Capitalized interest transactions for these projects are visible in the Generate Capitalized Interest Transactions report, but the same projects do not appear i… -
Access BIP Report from Oracle AI Agent Studio using Rest APISummary: Hi I want to get requisition approval history of pending requisition in Oracle AI Agent Studio. and for that i created BIP report from workflow tables and tryin…Mayank Agrawal 608 212 views 4 comments 0 points Most recent by Michael Gibby - Huron Consulting Group Self Service Procurement -
OTBI results in errors saying "The specified criteria didn't result in any data."Summary: OTBI results in errors below Error Message : The specified criteria didn't result in any data. This is often caused by applying filters and/or selection steps t… -
Link Between Workflow Table (FA_FUSION_SOAINFRA.WFTASK) & quality (ENQ_ISSUES_B) in oracle fusionHi All, we are developing a report to get the Quality Issue approval notification details. We are unable to link the WFTASK to ENQ_ISSUES_B. The WFTASK.IDENTIFICATIONKEY…
-
How to find the Report path with the report nameSummary: I have the report received to one of the recipient. The recipient request to add another person name to the report scheduling. I do not have the information whe… -
OTBI issue issue,Workforce Management – Absence Real Time subject area.Summary: Hi , OTBI issue issue, calculated absence duration when using the Workforce Management – Absence Real Time subject area. Example: Employee submitted three conse…Anil.ar.kumar-Oracle 12 views 3 comments 0 points Most recent by Anil.ar.kumar-Oracle Reporting and Analytics for HCM