OTBI
Discussion List
-
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… -
Output Manager Hierarchy in OTBI with fixed column postionsSummary: Can OTBI output all employees with their manager hierarchy in fixed positions (consistent column data)? Content (please ensure you mask any confidential informa…
-
I’m unable to see the LOT DFFs on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin We need to query items using the Maintain …
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 45.2K views 196 comments 126 points Most recent by EvanN__ Reporting and Analytics for HCM -
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…
-
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 595 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.3K views 7 comments 1 point Most recent by User_GMBW9 Reporting and Analytics for ERP
-
SQL query to fetch public holiday according to the work schedule of an employee.Summary: need a SQL query that fetches public holiday according to the work schedule of an employee. Content (please ensure you mask any confidential information): I nee…
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real TimeSummary: I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their las…S. Johnson 16 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 -
Reporting on SCORM & HACP Learner Interactions in Oracle LearningSummary: Learning departments often want to understand how learners are responding to questions included in their SCORM-based courses, to assess whether there are proble…Jamie Rancourt-Oracle 4.1K views 92 comments 12 points Most recent by Andy Pearce - Nationwide Learning -
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 19 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… -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 29 views 2 comments 0 points Most recent by Laraine Cunningham Reporting and Analytics for HCM
-
How to grant read-only access to "Costing - Inventory Valuation Real Time" without UI AccessSummary: How to grant read-only access to "Costing - Inventory Valuation Real Time" without Application access. Content (required): We have a requirement where we need a…Yasser Ali 62 views 3 comments 0 points Most recent by NatalieyaMoro Reporting and Analytics for SCM
-
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 25 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 14 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
Is it possible to change the account sign convention at the system level in Oracle ERP Cloud?Summary: Hello Experts, I would like to confirm whether it is possible to change the default sign convention (natural balance for each account type, e.g., Revenue and Li…Yuyeon KIM-Oracle 15 views 2 comments 0 points Most recent by Yuyeon KIM-Oracle General Ledger & Intercompany
-
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 430 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 363 views 8 comments 2 points Most recent by User_RCQ6I Reporting and Analytics for ERP