OTBI
Discussion List
-
Need inputs to get the DFF fields in Worker folder in OTBI analysisSummary: Need inputs to get the DFF fields in Worker folder in OTBI analysis Content (required): We have few DFF fields in Employement and Person UI/Screen. As of now we…Visu 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to print sum of Position FTEs by Business Units in OTBISummary:We have a requirement in OTBI to fetch business unit name and Position FTEs. But we have to print the sum of FTEs grouping it by each business unit. We are using…Sovan Mishra-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Database mapping documentsSummary: We've recently moved to 21D but the latest database mapping document we have is REL13_21_C_HCM_OTBI_Database_Mapping_with_ViewObjects can anyone point me in the…User_A80ZS 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Sum Parts of a ColumnSummary: We have a table with the %age of absence per absence name however on the pie chart, I need to sum the ones that are at the lower end of the spectrum. Content (r…Dawn Cawston - CPS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Create a report to show both accrual values for an employee and absence value for an employeeSummary: I want to create a report, that shows how much holiday an employee has left on their balance, and in the same report show how many days of absence an employee h…Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM
-
Assignment Expense InformationSummary Sourcing/Auditing the assignment Expense informationContent Hello, We're trying to audit the Expenses Information stored on the on the Manage Employment screen w… -
What is the Subject Area for the new MCR fields?Summary: Trying to locate the Role_identifer and the Teacher Reference Number. They are both showing in the employment screen but cannot find them in the assignment subj… -
Ability for an employee to run a report from talent profile page with Badge outputSummary: Ability for an employee to run a report from talent profile page with Badge output Content (required): We are in the process of implementing learning module and… -
Can we report on screening questions responses?Summary: Is there a possibility to report on screening questions in OR? I am not able to find them in the subject area. i.e. the yes or no responses Content (required): …Mitch_123456 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Creating dependent prompt in OTBI analysisSummary Creating dependent prompt in OTBI analysisContent Team, I have created a variabl 1st prompt for "Review Period" with "@{variables.ReviewPeriod}". Now i am trying…User_2025-02-01-03-43-13-079 99 views 12 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
how to Limit the prompt values based on the result of the analysis?Content I'm creating a validation report in OTBI which contains Employment data of contractors. The requirement is to be able to prompt on Business Unit. I want the list…Tom Van Iseghem 121 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM -
OTBI Prompts-How to restrict the values of other fields based on the values selected in other fieldsSummary: Hello, is it feasible with OTBI prompts to restrict the values of other fields based on the values selected in other fields? Example: AMNS India BU = Department…Hazel De Castro 21 views 7 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…User_2025-02-11-05-19-35-410 31 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Use of MAX function to get current Tax CodeSummary: I need to tweak a repot which shows all the tax codes under one employee with dates against them, however I just need the current tax code that is applied. Cont…
-
Termination Date less than and greater than 3 months of current dateSummary: I'm trying to work out how to write a formula for a Leavers report that will bring back everyone who has left the department in the last 3 months and projected …
-
Reporting transaction history in HCMContent Hi all, We are currently looking for a way to report transaction history specifically for terminations. We've found what were using shows the most recent update …User_2025-02-05-20-24-10-848 63 views 4 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM
-
OTBI Agent ScheduleSummary: We encountered an issue today with a monthly report that is scheduled to run at 7 AM EST ran and delivered the report at 2 AM. Have anyone encountered this issu…
-
Min and Max columns on Assignment Effective Dates are blank in OTBI analysisSummary: 'Latest Assignment Start Date', 'Earliest Assignment End Date' columns showed data while building the report. After adding more columns and filter condition the…Vinay Hardas 255 views 9 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Document Eligibility disappears in the new year/ Where to go for data related questions?Summary: Performance Document Eligibilities are disappearing in previous years. Where can we go to find reasons why the data is disappearing from reports? Content (requi…
-
Getting Invalid URL Error while adding the BI report URL as embeded content in the dashboardSummary: I am trying to add the existing BI report to in the dashboard.Though i ma providing the correct BI Report URL while adding embedded content i am still getting t…minati_behera-Oracle 11 views 0 comments 0 points Started by minati_behera-Oracle Reporting and Analytics for HCM
-
Need to compare 2 columns in an OTBI pivot tableSummary: I'm wanting to find out if this requirement is possible within OTBI. I have 2 dollar amounts 1 for each date paid. I need to compare the 2 amounts and look for … -
How can I exctract Person Address ID field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Address ID field to overwrite employee home addresses by HDL. Is it possible to find this f…Valerio Curzi 33 views 2 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
Which is better: "Filters and Variables" vs "Results of another analysis"Summary: Are hidden dashboard prompts better than getting the results of another analysis? Content (required): When building dashboards, we occasionally have a need for …
-
OTBI usage dashboardSummary: Identifying OTBI usage for performance monitoring Content (required): Is there a seeded OTBI Usage Dashboard? Have seen below post and wondering if Oracle alrea…ZenG 32 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Employee Referral ReportSummary Looking for an employee referral report that will run on a condition that current date is 6 months after hire dateContent We have a DFF that tells us if someone …User_2025-01-28-20-43-56-568 98 views 6 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM
-
OTBI Edit Column Formula for YYYYMMDDSummary: Hello, We tried using the solution listed in the Oracle Doc below but unable to successfully edit the column formula of the OTBI analysis for Workforce Manageme…User_2025-02-11-05-19-35-410 493 views 7 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sSummary OTBI: Need to create a OTBI with 3 different compound layout and download it in excel (3 different sheets in the excel: one tab for each compound layout)Content …User_MC37Q 92 views 9 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
No results after adding a column in subject area Workforce Management-Documents of Record Real TimeSummary: Content (required): Hi there We are trying to create OTBI report for a type of Document that we have. Actually, there are 6 specific custom made types, but when…Bobby Jourdan 47 views 16 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Time Stamp Diff based on User Entered Date ValueSummary: Time Stamp Difference function calculating with user prompted date value Content (required): I am using the following function to calculate years of service. I'…Jennifer Wiggs 32 views 8 comments 0 points Most recent by Jennifer Wiggs Reporting and Analytics for HCM
-
Report of Delta for Old and New ManagersSummary: Hi, I need to create a report / analysis that would pull the results for the employees who have a new manager value. I have taken first steps by creating an ana…J_Haskell 22 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM