OTBI
Discussion List
-
Learning Items for Pending WorkersSummary: Unable to pull Pending Worker information from Learning Records Real Time DM and Assingment Real Time DM Content (please ensure you mask any confidential inform… -
Changing Offering Coordinator field in OLC not updating OTBISummary We are able to update an Offering Coordinator in OLC but the change is not reflected in OTBI reports.Content We are currently looking at creating an OTBI report … -
How to create report for pending Process Requisitions that not assigned yet to Purchase order.Summary: How to create report for pending Process Requisitions that not assigned yet to Purchase order. Content (required): Version (include the version you are using, i…Mohamed Haamdy 31 views 4 comments 0 points Most recent by Goopikrishnan Jayaraman-Oracle Reporting and Analytics for SCM
-
Specialization Completion PercentageSummary: I am looking to build an OTBI report that lists by associate an enrolled learning specialization and a summary count of the number of the courses in the special…Kristen Arner 61 views 5 comments 0 points Most recent by PEEMA O-CHA Reporting and Analytics for HCM -
General Ledger Journal and Subledger Transaction Mapping ReportIt looks like Oracle has provided this report for China localization only, we have a similar requirement for US operations, is it possible to run this report for Non Chi…
-
OTBI > Permissions > HR Specialist cannot open DashboardContent Hello All, I will appreciate your support on the issue below: The HR Specialist with Data Role “AUIB Human Resource Specialist” cannot open the Dashboard (File “…
-
Grouping in OTBISummary: Hello, In the screenshot there are 3 lines here coming from one transaction. I want to group these into one line with all the data you can see on the screenshot…
-
How to Retrieve Deleted By and Activated By in HCM Learning Module for Reports?Summary: We have a requirement that needs to display the Deleted By and Activated By fields using a BIP Report / SQL Query. We have tried looking for these in fields HCM…
-
Project Contract Receivables collectionIs there any analysis that can reflect the project invoices collection cycle since invoicing till receivables receipts?
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
What is the Subject Area for News and Announcements (which are displayed on the user home page)?Summary: We have a requirement to show employee announcements in an OTBI dashboard, so we want to know the subject area for the same. Content (required): Subject Area fo…Bhukya Vamsi Naik 41 views 4 comments 0 points Most recent by gguittini Reporting and Analytics for HCM
-
How to Show Serial item attributes in Product Genealogy pageSummary: Hello All, Please let me know if you have implemented solution to show Serial item attributes in the Product Genealogy page. One of my customer wants to see the…Vishnuvarth Subramanian-Oracle 11 views 1 comment 0 points Most recent by Raj C -Oracle Manufacturing
-
HR is unable to view own record on 1 Report in OTBISummary: Hi Team, Our HR Team has raised a concerned wherein they are unable to access/ view their own data (means the one who's extracting the report) in 1 of our repor…
-
Extract all the financial transactions pending for approvalHi All, We have a requirement to create a single report to fetch the details of all workflow transactions (Invoice Approval/Requisition Approval /Purchasing Document App…Truptesh Solanki 11 views 2 comments 0 points Most recent by Rohit Kumar Singh Payables, Payments & Cash Management
-
Need help configuring BPM Workflow Task for Issue NotificationsSummary: I have tried to customize the Issue Notifications Catalog workflow template for the Create Issues task under Project Management, but it is not reflecting my new…
-
Need help on the Attrition % formulaSummary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…Shreya Datir 62 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Economic production quantitySummary: Hello All, One of my customer follows the Quote to Cash process for building Configure to Order (CTO) items. They do not manufacture, but assemble products base…Vishnuvarth Subramanian-Oracle 21 views 1 comment 0 points Most recent by Radhakrishnan Angappan-Oracle Manufacturing
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for … -
OTBI report for FND LOOKUPSSummary: I need to create an OTBI analysis for FND LOOKUPs. Through OTBI Lineage document I found there is a View object for fnd lookup. "FscmTopModelAM.AnalyticsService…
-
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu…User_2025-02-04-23-22-13-274 113 views 9 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM -
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…stusc 53 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM