OTBI
Discussion List
-
OTBI Custom ImagesHi all, Just a quick one I'm hoping someone knows the answer to! We've been using our own custom images for reporting and have noticed that the system allows us to uploa…MikeW 21 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM -
get earliest hire date by action typeSummary: Hello, I'm trying to get, in OTBI, a result of the earliest "Employee Hire Date", based on a specific HR action (Rehire in this case). The Analysis is to get “E…Alons 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Spend Authorization created by the user in the past is not visible in SA DashboardSummary: Spend Authorization created by the user in the past (Approved) is not visible in Employee's Spend Authorization Dashboard. But the user is able to see when he c…
-
Is it possible to report on which workers are scheduled to work on a particular date?Summary: Content (required): I'd like to be able to report on which employees are scheduled to work on a certain date, based on the work schedule held for them, and what…Leanne W 131 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Merge Two OTBI Subject Area For PO receipt dateHi , We have a requirement to develop OTBI report for the following fields ( promised date, Requested Date and Receipt date) for po using two OTBI subject areas we are u…Prathyusha pari 123 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
OTBI Date Prompts for two analyses in order to compare data fieldsSummary: OTBI Date Prompts for two analyses in order to compare data fields. I used the instructions of this page OTBI HCM historical reporting (v-cdn.net) to set the da…Sa_De_Or 62 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL Link between Project billing event and AR invoice?Summary: I need to identify the event which generated an AR invoice. Which table stores this information? Content (please ensure you mask any confidential information): …alejandro.vizcaino 624 views 2 comments 0 points Most recent by alejandro.vizcaino Project Management
-
What values to pass to lexical references to Physical inventory Tags Data modelSummary: We have customized the Physical Inventory Tags data model and report. Then we tried to modify a column. However, I don't know what values to pass to the 4 lexic…
-
How to get Periodic accrual Projected Hours Value in OTBISummary: how to get Periodic accrual Projected Hours Value in OTBI Content (please ensure you mask any confidential information): Version (include the version you are us…
-
Custom Calculated Measure to Sum Two Calculated Measure Fields Not Calculating CorrectlySummary: I want to have a column called, "Total Costs" which sums the amounts from two calculated measure fields but for values where one of the calculated measure field… -
BIP performance after 24ASummary: We have one BI Publisher report that will not complete in any of our Oracle 24A environments. It has a data model size of 661 rows and has numerous Validation m…Thane_Fuller 61 views 2 comments 0 points Most recent by Thane_Fuller Reporting and Analytics for HCM
-
OTBI Report to get Candidate Education Start date and end dateHi Everyone, I have requirement of get candidate education start date and end date in OTBI report. Navigation : My Client Groups > Hiring > Job requisition> Applications…Rajdeep Chavda 21 views 4 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM
-
Work Order Traveler Report Customization and use standard option to printSummary Work Order Traveler Report Customization and use standard option to printContent Hi Want to know whether we can use customize maintenance work order traveler- (S…
-
as of date birthdaySummary: Hello, Please assist on the following... We were able to calculate person ‘Age’ based on presentation variable @{asofdate} for the Headcount page on LM dashboar…
-
Report on questionaire details tagged to a courseHi, I have requirement to fetch Questionaire name, question text and answer text tagged to activity of a course but I am facing an issue while joining the learning item …User_2025-11-14-00-02-48-758 1 view 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
how to get the learners already assigned not to captured in the otbi reportSummary: When trying to assign the learners through the learning initiative using the OTBI report. the requirement is to not capture the same users to get assigned to th…
-
How to create an OTBT analysis to get results if the benefit plan got declined?Summary: We need to create an analysis to get employee results when they selected the decline option for a specific benefit plan. Which subject area I need to use ? Cont…Ayesha Iroshani 21 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 13 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service -
How to get the PO Charge Account fieldSummary: Find a Rest Api or SQL Query to get the PO Charge Account field Content (required): Hi experts, I feel lost, I am looking for a Rest Api to find the pointed fie… -
Email Correspondences/System Notifications ReportSummary: Looking for report(s) which would list all email correspondences we currently have set up, the status, frequency and recipients. As well as a listing all system…GMV 21 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration
-
How to create analysis for Check-in Documents Created vs. Not Created?I need an analysis to get a list of employees who haven't created their Check-in Documents yet. I'm currently using Workforce Performance - Performance Check-In Real Tim…Welsey 31 views 2 comments 0 points Most recent by Suman Chenumalla-Support-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard Design - Export ButtonHi all, I'm currently working on an OTBI Dashboard that certain groups across the business will use. We're using a mixture of Performance Tiles, Graphs and Tables and I …
-
OTBI Report for Document Records Descriptive FlexfieldsHello Experts Step 1 : I Have Created a Document (Eg: External Training Request) using Task Document type. Step 2: Using Task: Document Records Descriptive Flexfields, I…
-
ESS and MSS ReportSummary: How can I report the number of transactions that were done through ESS and MSS? We want to check which countries are using the self-service the most against the…
-
Ethnicity DashboardSummary After applying "Two or more races" code, ethnicity count gets incorrectContent Applied "Display Ethnicity" logic code as per the post below to fix "Two or more r…User_2025-02-10-17-54-52-878 122 views 8 comments 0 points Most recent by Daren Reporting and Analytics for HCM -
Is there a way to use environment-aware variables for dashboard action links?Summary: Instead of hardcoding urls for dashboard action links, is there an environment-aware variable that can be used? For example, instead of https://sample-dev2.xx.x… -
FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle CloudSummary: FA-SAAS Enhanced SQL Guardrails and Tuning for Long Running BI SQLs for Oracle Cloud Content (required): We got mail from Oracle Cloud Saying following : As par…Swati U 996 views 7 comments 0 points Most recent by Avinash Veeranna Reporting and Analytics for HCM
-
Assignment Manager Prompt - Direct and Indirect ManagersHi all, Does anyone know if its possible to use Assignment Manager as a prompt for a dashboard and also include the full direct and indirect managers for the user? At th…
-
Footer is not displaying when data of custom report is output in WordSummary: Footer is not displaying when custom report is exported to Word. What is causing the footer to disappear when report is exported to Word? I can see the footer w…Consultant Ian 11 views 2 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM