OTBI
Discussion List
-
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 31 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-…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
How to change the Currency in Total Price column in "Print Transfer Order Status Report"Hello Experts, We have a client requirement to change the $ to euro symbol in "Total Price" column in "Print Transfer Order Status Report" (Requisition View) Currently w…Balaji Midhun Kumar Sanagapalli 11 views 1 comment 0 points Most recent by Graeme Gerber Inventory Management
-
List of UI Labels effected with User Interface Text tool - renaming of labelsCustomer needs a list of effected UI labels (on pages/modules) when using the User Interface Text tool for renaming labels in Fusion environment. Is there SQL for me to …Sharne Thysse 21 views 4 comments 3 points Most recent by Shaik Azeez Reporting and Analytics for ERP
-
Is the 75000 row limit for OTBI reports just a limit on the output?For an OTBI report, the SQL automatically adds "FETCH FIRST 75001 ROWS ONLY." Is this only referring to the output of the report? Or is it also referring to the total po…
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…Raghavendra Raghunath-Oracle 2.1K views 47 comments 13 points Most recent by Visvanath-Oracle Reporting and Analytics for HCM -
Not able to retrieve data from Security - Roles and Privileges Real Time subject area.We are not able to retrieve data from Security - Roles and Privileges Real Time subject area. We are trying to fetch columns from the folder Function Security Policy, Da… -
Guidance Needed: BI Report with After Data Event Trigger in Oracle Fusion HCMSummary: BI Report with After Data Event Trigger in Oracle Fusion HCM Content (please ensure you mask any confidential information): Hello All, We have a requirement to …Vasanthakumar Ravi 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
REST API to get sales Order line tax amountI am looking for Sales order tax amount for each line. In front end i am able to see tax amount for each line. but when I check it through API, I am getting only total t…
-
How increase limit of rows in otbi analysisSummary: How increase limit of rows in otbi analysis Content (required): Customer have some Analysis created and he want to know if there are some possibility to export …Adriana Martins 1.4K views 8 comments 1 point Most recent by SureshRamanujam Receivables & Collections
-
HCM OTBI Filter by Legal Employer of current userSummary: Hi Oracle community, i am fairly new to OTBI specifically in HCM OTBI and would like to check how to achieve in adding analysis filter to get records where lega…JSalarza 161 views 7 comments 0 points Most recent by Challa Ramya-Oracle Reporting and Analytics for HCM
-
Subject area for "Total Shipping Cost Recorded" on Shipment pageSummary: Please anyone provide exact attribute and subject area for "Total Shipping Cost Recorded" on Shipment page Content (please ensure you mask any confidential info…
-
Report listing active users with current and past assigned roles (with start and end date)Summary: Report listing active users with current and past assigned roles (with start and end date). Content (please ensure you mask any confidential information): Clien…
-
Facing Error while generating Fixed Assets Data in OTBIHello, We have around 30 Asset Books, For my user all the Asset Book access given. I'm trying to do an analysis in OTBI by using the Fixed Assets Depreciation Real Time …Shagulhameed 12 views 1 comment 0 points Most recent by Lily Wang 026 Reporting and Analytics for ERP