OTBI
Discussion List
-
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 46 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 35 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 26 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.Farooq Syed, CPA, PMP, CISA, TOGAF 23 views 2 comments 0 points Most recent by LEHampton Maintenance -
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 73 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 … -
What is the best naming convention for Master Org? IMO - Inventory Master org or MAS - Master OrgSummary What is the best naming convention for Master Org? IMO - Inventory Master org or MAS - Master OrgContent Just wanted to ask a quick questions on defining master …
-
Good practices on number of attributes, number of custom objects and number of custom triggers in inContent Hello guys, I'm looking for some guidance from Oracle on good practices related to the number of custom attributes, custom objects and custom triggers (for examp…User_2025-02-05-08-52-13-026 21 views 2 comments 5 points Most recent by User_2025-02-05-08-52-13-026 Product Development
-
How to view the assessment report for the leanersSummary OTBI Assessment reportContent Dear All, Please advise, how to view how many learners attended the assessment. Please guide me with steps to download the specific… -
Unable to cancel the dropship line when the line status is in Requistion Created status.Summary Unable to cancel the dropship line when the line status is in Requistion Created status. Item is a CTO Model, when tried to cancel it gives Process constraint Er…
-
Report for Share and Retain and Share and ReleaseSummary Report for Share and Retain and Share and ReleaseContent Is there anyway we can report off of Share and Retain and Share and Release from performance document Is…Reddykrishna Chidella-Oracle 32 views 2 comments 2 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Pull Succession Plan Name with Talent Profiles.Content I have created a report to pull latest Performance, Potential, Risk of Loss And Impact of Loss from Talent Profiles. Is there a way to add Succession Plan name t…User_2025-02-10-08-27-16-805 27 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Quick and Batch PaymentSummary Quick and Batch PaymentContent Quick and Batch Payment- I need to add a unique number to quick or batch payment, therefore I need a field that is available to bo…
-
Workshop - A Modern Solution for your Oracle Cloud!Summary Derive greater value out of Oracle Cloud with our Next-Gen Managed ServicesContent If your company is like many others, you’ve invested in Oracle applications to…User_W4MMU 27 views 0 comments 1 point Most recent by User_W4MMU Reporting & Analytics for Fusion Service
-
Oracle SQL - Display rows as columns - Many to Many RelationshipSummary Oracle SQL - Display rows as columns - Many to Many RelationshipContent Good day! I need some guidance if I want to do is actually possible in Oracle SQL. I have…Raymund Jerome 36 views 2 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM