OTBI
Discussion List
-
Report on employee careers of interestContent Hi, Has anyone built a report that indicates people and their careers of interest under career development in Oracle HCM Cloud? I am specifically looking to buil…Dishti Malhotra-Oracle 28 views 2 comments 0 points Most recent by Krista Kay Reporting and Analytics for HCM -
Report - Notifications a learner received on learningsSummary SQL / Report to Get List of notifications a learner receivedContent Team, We have a requirement to build a report to display Offering Details (Offering Title, St…
-
CIP Assets cost is not stored in FA_BOOKS_SUMMARY as expectedContent Hi, We are building a custom BI Publisher report that should, among other things, show the cost of a CIP asset within a specific period from and to range. We are…
-
Time Cards - Calculated Time breakdownContent Hello We have a reporting requirement to show the calculated time breakdown by Type. Is it possible to bring this data in a OTBI report? In which folder do we ha…Ridma Karunanathan 43 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
Unit Cost of an Item for OTBI reportContent Hi I am create an OTBI report and required the Unit cost of an items. I am using "Costing - Item Cost Real Time" subject area, but its showing multiple rates. I …
-
Missing Salary Report on OTBIContent Hi all. I'm trying to build a simple report on OTBI that reports the employees who are missing salary at the current date. I tried to use both Compensation - sal…BenZionP 80 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Performance Impact of multiple contexts on a Supporting Reference with BalancesSummary Topic discusses the performance impact of source from multiple contexts on Supporting Reference Reporting.Content Within a single supporting reference with balan…Daniel Martin 47 views 3 comments 1 point Most recent by Shyam Santhanam Subledger Accounting & Accounting Hub
-
OTBI query: extract Withdrawal Reason, Data and CommentContent Hello, In the Learning subject area I cannot find the following info to extract: Withdrawn Date, Withdrawal Reason and Withdrawal Comment. Are they available? Wh…Daniela Spaseska-Oracle 57 views 3 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Limit Datepicker in OTBI parametersSummary Datepicker to limit the user to select only dates from past till today and not any future datesContent Can we limit OTBI Parameter Datepicker to show dates only …pooja yelsangikar-Oracle 33 views 4 comments 1 point Most recent by pooja yelsangikar-Oracle Reporting and Analytics for HCM -
Accrual Balance Report is showing double the actual valueSummary Accrual Report is showing the balance as double what it should beContent Hi, I have created a accrual balance report in OTBI using the Accrual Real Time subject …
-
Knowledge article view fact returning 0Content We have an OTBI report listing all of our knowledge articles and have included the # of article views fact from the Knowledge Management - Article Summary Histor…Tasha 32 views 1 comment 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Need help on OTBISummary Sum of Balances in OTBI reportContent Hi Team, We are creating one report. Our requirement is to print the balance value in such a way that balance value of A an…
-
Date fields using excel templatesContent Is there a way to print date fields on excel based BI publisher reports where excel can recognize it as an actual date field? Is this the only solution https://d…User_2025-02-10-08-27-16-805 27 views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
UOM Convesion from OTBI subject ateaContent Hi Expert I want to Convert UOM code from BAG to EA (UOM Converted to EA) using OTBI Subject area.Can you please let me know do you have any idea on UOM conversi…
-
WO Custom Report - QuerySummary WO Custom Report - QueryContent Greetings! Need WO layout report or Query, if someone could share Please. -
Reporting on the positions colleagues are working in (factoring in secondments)Content Im looking to report through OTBI on where colleagues are currently working, factoring in secondments. For example I only want 1 row to appear for each colleague…MattW 35 views 9 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Retrieving Historical Data on all fields in Worker Assignment Real TimeContent I have built a report a report pulling fields from worker and department and have entered SET VARIABLE PARM_EFFECTIVE_DATE = '@{report_Date}{@{system.currentTime…Sharon Harper 37 views 4 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
How t get inactive employees less than 500 net payment from "Payroll-Payroll balances real time subSummary Ho t Pulling inactive employees from"Payroll-Payroll balances real time subject area" .Content Hello Gurus, I am trying to pull all employee including terminated…Manju01 75 views 20 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM -
Date Filter with Default value FailsContent I am new to OTBI and have tried to follow the various posts etc. about creating a report with a filter on the criteria and have used a presentation variable. How…Sharon Harper 41 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM
-
OTBI division operator in calculated column formula is not producing correct results - in RecruitingSummary The division operator in a calculated formula is not producing correct results in the Recruiting - Recruiting Events Real Time subject area.Content In OTBI, when… -
report out on offer letter templateSummary How can we report out on which offer letter template was selected for a candidateRiti Malhotra 29 views 3 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
OTBI KFF Description In The GL Subject Area Is Displaying As Concatenated Code + Description: How toSummary Doc ID 2537985.1 Describes how to fix KFF value descriptions so that they are consistent with the GL KFF descriptions (not concatenated), but it didn't work for …