OTBI
Discussion List
-
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 643 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 527 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 22 views 5 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
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 41 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 441 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 362 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 1 view 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…
-
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…
-
Fixed Asset approval status datasource in OTBISummary: Do we have OTBI subject area to create list of unapproved assets? A customer is creating OTBI report to extract unapproval asset list. If not is there any equiv… -
Sample Oracle BI Reports for Spend Authorization RequestsSummary Dashboard for Spend Authorization RequestsContent This dashboard will allow you to view the following key details: * Number of spend authorization requests by St…Aishwarya Pawar-Oracle 66 views 2 comments 2 points Most recent by Conor Pewterbaugh Supplier Management
-
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…
-
Missing Overall Feedback and Max Questionnaire Score in OTBIwe have a business requirement to report the Overall Feedback Score for each feedback provided in Oracle Recruiting Cloud using OTBI. We explored the available subject a…
-
Not able to view entire employees details in Subject area only able to view own recordSummary: i was able to extract employee details using Assignment subject area but now when I am using the subject area it is only displaying my data. I have all the role…
-
Supplier Portal Dashboard Not Working – Error: “The specified criteria didn’t result in any data”Hi, We are facing an issue where the Supplier Portal standard dashboard is not working and is not displaying any data in our instance. I have attached screenshots for yo…