OTBI
Discussion List
-
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …Nikhila 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the …
-
OTBI - Project Current Baseline Version and Actual CostSummary: Content (required): I'm trying to create an OTBI Analysis which shows the latest Current Baseline budget for a project, and next to this I would like to have a …
-
Need Guidance on a new feature "VIEW PURCHASE ORDERS AS A REQUESTER USING A DEEP LINK" in Patch23DSummary: The requesters and preparers cannot view PO detail using deep link which is a new feature in Patch23D. Content (please ensure you mask any confidential informat…
-
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…User_2025-02-07-19-03-14-525 240 views 12 comments 1 point Most recent by Aurobindo Ghosh Reporting and Analytics for HCM -
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 61 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
How can I populate LEDGER_SUM columns similar to the standard General Ledger and Subled Account Rep?Does anyone know where we can take the values to populate or calculate these columns in a report? LEDGER_SUM_PR_DR LEDGER_SUM_PR_CR LEDGER_SUM_BAL_DR LEDGER_SUM_BAL_CR W…MARIA EUGENIA VICTORIA LOPEZ-Oracle 1 view 2 comments 0 points Most recent by MARIA EUGENIA VICTORIA LOPEZ-Oracle General Ledger & Intercompany
-
To extract employees list that receive standard notificationHello everyone, is it possible to extract a list of employee that receive a standard e-mail from the system? Thank you Alessandra -
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 32 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 13 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…