OTBI
Discussion List
-
R13-SQL Supplier informationSummary R13-SQL Supplier informationContent Hello : I was wondering if you can share with me any SQL to get the Supplier information. I have the following one but it is …gabriel kinovisques-163562 47 views 3 comments 2 points Most recent by gabriel kinovisques-163562 Payables, Payments & Cash Management -
OTBI Custom Dashboard Not Populating CorrectlySummary Admin and User views are completely differentContent Good morning everyone! I wanted to reach out and see if anyone has experienced issues with viewing data in a…User_2025-02-10-17-54-21-557 45 views 4 comments 1 point Most recent by User_2025-02-10-17-54-21-557 Expenses -
Report: Project Number is '000000' for most of projects in report.Summary Report: Project Number is '000000' for most of projects in report.Content Hi All, Report: Project Number is '000000' for most of the projects in the report. Vers… -
Goal Plan Status ReportContent Hi, I am looking for a report that will tell me the goal plan status and if anything requires approval. Has anyone created something like this? I tried using the…tiffnyc 65 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Inventory Transactions short cut keysSummary which short cut keys can be used to accelerate the data entryContent Dear, I am looking for a shortcut key on the inventory transaction screen, for example, whil… -
Which table/view stores information of Data models / BI Reports / OTBI reports created or updatedSummary I need the table that stores the information of Data models / BI Reports / OTBI reports created or updatedContent I need the table that stores the information of…Rohit Saha 1.1K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Talent Review| Succession Plan| Career Development - All in One ReportSummary This report will give employees' Performance, Talent Review, Succession and Career detailsContent If your customer wants a detailed report on Talent management w…Mani Iyer-81826 114 views 6 comments 0 points Most recent by User_2025-02-08-07-12-44-872 Reporting and Analytics for HCM -
Round a summed total?Summary Round a summed total?Content I have an OTBI analysis and on a column it does the aggregate sum - so summing each value based on how I have it grouped in the resu…Cathy 23 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI - Date prompt from and to dateContent Hi Team, I am using a date prompt between from and to date. Issue is that during negative testing - user is trying to check if the system gives error for From da…Shikha Agarwal 32 views 4 comments 2 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
Termination analysis does not bring all records when dynamic dates are usedSummary When a hard coded dates are used in the analysis or date is entered through the prompt selection, it works fine. However when the range is determined dynamically…User_2025-02-10-17-54-52-878 47 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. …Arti P 30 views 1 comment 0 points Most recent by Nitika Arora-Oracle Reporting and Analytics for HCM -
Is there a way to put a pause/hold on all the BI reports schedule in HCM and resume them after few dSummary We need to pause the schedules in PROD for few days and we don't know how many user schedule the BI/OTBI report jobs. We need to pause all the jobs at one go and…User_F89L9 94 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Analysis of platform usabilityContent Hello experts Does anyone have any query analysis or report that enables us to see system data like. Users who are accessing most the POD (LOGINS) Which Modules …Pedro Teixeira 21 views 3 comments 1 point Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM -
OTBI | Learn Module | Need an analysis to get specialization name, it's corresponding module name ,Content I am working on an OTBI report where I need to fetch specialization name, it's corresponding module name , course name, offering name, offering status, learner. … -
Need a query for a date parameter dependent to another date parameter.Content Hello all, There's a query I need to get the month names separately with one parameter and another parameter to select a date range. The month name parameter sho…Sushan Peiris 551 views 1 comment 3 points Most recent by Sushan Peiris Reporting and Analytics for SCM -
Pull data between 2 dates using Subject AreasSummary Pull data between 2 datesContent Good Evening, Has any one had luck with pulling historical information in between 2 dates? For example, we had someone who was o…User_2025-01-23-21-37-42-476 47 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Deleting an Offering that was previously marked completeSummary I am trying to delete a duplicate record. I am unable to reset the activity through the manage activities screen and when when I try to edit it though a spreadsh… -
Job DurationSummary Provides the duration of the workers in a specific jobContent This analysis provides the duration(in days) of the workers in all the jobs that they have held so …Raghavendra Raghunath-Oracle 210 views 15 comments 6 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
Learning Assignment Event TypeContent Hello Experts. I need to do an Analysis that gives me if the course assignment is Required or Voluntary. I was Unable to map it into the Workforce Learning - Lea…Pedro Teixeira 53 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI for enrollment in OLC - Selection of one Department in One locattion and All Departments in AnoContent Hi there, I am using OTBI report for enrollment in OLC. I need to create a report that includes - All the Departments in Location A and - One Department in Locat…Bobby Jourdan 26 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
OTBI - Reporting Monthly Net Pay ValueContent Hi all, Does anyone know the correct subject area and field to use in order to report on the net pay value an employee would receive? I've been looking at the fo… -
Reporting on Termination and Performance Review Data in the same analysisSummary I am trying to pull a report that shows employees performance review rating before their termination as well as their termination reason.Content I am attempting … -
How to calculate the Bonus amount only for asset cost adjustments and not for asset additions?Summary How to calculate the Bonus amount only for asset cost adjustments and not for asset additions?Content Hi Experts, How to calculate the Bonus amount only for asse… -
Is it possible to created Facts/Measure in Logical SQLSummary Is it possible to created Facts/Measure in Logical SQLContent Hi all, I need to pivot and show percentage of a column but seems like it is not possible to create…Raymund Jerome 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM