OTBI
Discussion List
-
Common Question: How to Edit an Analysis in a DashboardSummary: Explains how to edit an existing analysis in a delivered dashboard. Content: In the relevant section on the xyz properties button, select Edit Analysis. Use Sav…Gail Langendorf-Oracle 12 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI result to show in one lineDear Team How to show the OTBI result in one line, instead of showing them in multiple lines?Surendar 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPASummary Need some practical examples or scenarios where we should have negotiation outcome as BPA/CPAContent We have to give demo to your client on basic understanding o… -
Performance Document Acknowledgement Task Status and Completion DateSummary: We're using the Oracle Cloud HCM Talent Management > Performance Management performance document to manage and document performance improvement plans (PIPs) and…Angie Elliott 56 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Is there any way to display the dashboard in inventory management by sub inventory instead of orgThe customer is requesting to display infolets from the Inventory Management page grouped by subinventory, rather than organization-wide data. Can you please confirm if …Manojj Basetti-Oracle 21 views 2 comments 0 points Most recent by Adnan Siddiqui-Oracle Inventory Management -
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas? -
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 92 views 2 comments 3 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service -
I am looking for a way to report scheduled hours for each employee for each pay periodSummary: I need to compare reported hours vs. scheduled hours Content (please ensure you mask any confidential information): Version (include the version you are using, …Jennifer Johnson 11 views 0 comments 0 points Started by Jennifer Johnson Reporting and Analytics for HCM -
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some … -
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 93 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Blank Specialization Sections and Activities from Workforce Learning - Learning Records Real Time.Summary: When using the Workforce Learning - Learning Records Real Time Subject Area we are getting Blank values for the Specialization Sections and Activities. We are u…David Bean - BW 91 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo… -
OTBI Data access for userHi, We have a few queries regarding OTBI data access behavior. We have a user who is associated as an employee to one Business Unit (BU) under Manage Users. When accessi… -
issue with the link between gl_code_combinations and ZX_ACCOUNTSSummary: I am creating a report to gather the taxes and all invoices related to this tax. Content (please ensure you mask any confidential information): I used the below… -
How to get current timezone as of date in server variable CURRENT_DATE_REP_OTBISummary: How to get current time zone as of date in server variable CURRENT_DATE_REP_OTBI. I am trying to get the correct metrics on the headcount dashboard and what i o…Revanth.Rondla 21 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Highlight Duplicate String ValuesSummary: Content (please ensure you mask any confidential information): In an OTBI analysis, I would like to highlight duplicate string values. Is this possible? We're u… -
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 32 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag… -
Table with sales orders in errorSummary: Looking for the tables where it is whether a sales order is in error. And what that error is. Content (please ensure you mask any confidential information): I w… -
Unable to find the Notes and attachments field in OTBI report - Maintenance Subject AreaSummary: As per the customer requirement, need to get the detailed report for to find the "Notes and Attachments" field (Comments) when adding the Work Order Completion … -
Request: OTBI Report to Identify Self-Enrollment Courses and OfferingsWe are looking to create an OTBI report that helps to identify self-enrollment courses or offerings within our Oracle Learning system. Currently, the process for self-en… -
Can't add column prompt in OTBISummary: Hi, I have an analysis with 3 subject areas. For some reason I'm not being able to add a column prompt to my analysis, the only option is to add a Currency prom… -
Request for Source Tables of Task-Level Cost Columns in Project Financial PlanHello Community, I would like to request clarification regarding the source tables for the following task-level cost columns in the Project Financial Plan (navigation: P…Andika Kurniawan 31 views 4 comments 0 points Most recent by Andy May-Coates-Oracle Project Management -
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 199 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP -
Deeplink for Review cost accounting distributions drilldownSummary: Hi, we are working to define an OTBI, from Subledger Accounting Real Time are that enables drilldown to Cost Management - Review Cost Accounting Distributions. …Roberto de Santos 11 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
Can someone please provide underlying sql query for Available To ReserveSummary: Looking for underlying sql query to get "Available to Reserve" and "Available to Transact" qtys on onhand UI. I tried with joining multiple tables and condition… -
How to add Year to date activity in financial reportSummary: We are creating a financial report where we want to include current period activity and year to date (accumulated activity). How do you suggest that we include … -
OTBI How to filter column YTDI have a formula-based column that is based on other columns, and a table prompt using Accounting Period Name. I am trying to make this column to show values in Year-To-…