OTBI
Discussion List
-
OTBI how to include manager department hierarchy in an analysisI have a need to include the Managers department hierarchy in an analysis. The managers department hierarchy does not appear to be a set of standard fields in any of the…Sharon Ferguson 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI users are able to edit the report when they have only Read permissionSummary: OTBI users are able to edit the report when they have only Read permission Content (please ensure you mask any confidential information): Version (include the v…Pablo Schenquerman 31 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Any way to automatically backup OTBI Custom directory?Summary I am trying to think up a way to do backups on the custom reports directory in OTBIContent As the title states, has anyone come up with a way to automatically ba…User_2025-02-06-06-17-13-684 110 views 4 comments 3 points Most recent by Andres Hernandez Suarez Reporting and Analytics for ERP -
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …Saurabh_Mharolkar 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 121 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 61 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 623 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 12 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