OTBI
Discussion List
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 13 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
OTBI report for ChecklistSummary: OTBI report for Checklist Content (required): Tring to create OTBI report for Checklist for a questionnaire, however, the questions are not reflected nor the re…
-
Checklist not assignedSummary Checklist not assignedContent We have multiple onboarding checklist by country etc and want to report where one of these checklist has not been assigned to a new…Emily Robinson 53 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
The BIP Catalog page search box is inoperable.Summary: I've been looking into it for a long time, but I've never figured out why the BIP catalog page search box doesn't work. I tried the same thing in multiple insta…User_2025-10-24-00-15-43-324 13 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM
-
GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report requiredSummary: GRN Receipt has more than one invoice with sum Qty and Sum Amount seeded report required Content (required): Business wants seeded report/query to show GRN has … -
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…Hem 41 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Extract Draft Status on ECO for a Report in OTBISummary: Business needs the ability to see what Change Orders have a Status in Draft to better understand metrics. Per SR 3-28465964691 this is not something Oracle OTBI… -
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 -
BOM Cost Report for Average costingSummary: Customer is requesting for a BOM Cost report. But the available one in OTBI is applicable for Standard Costing (as Scenario information is required as parameter…
-
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 114 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 120 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 …
-
OTBI: Projects–Cross Subject Area Analysis–Real Time Subject Area is returning incorrect valuesSummary: A Dashboard using the Projects – Cross Subject Area Analysis – Real Time Subject Area is returning incorrect values for the Current EAC Cost. Content (required)…
-
OTBI: Projects–Cross Subject Area Analysis–Real Time Subject Area is returning incorrect valuesSummary: A Dashboard using the Projects – Cross Subject Area Analysis – Real Time Subject Area is returning incorrect values for the Current EAC Cost. Content (required)…
-
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