OTBI
Discussion List
-
Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team,Summary: Need report of SVC_SERVICE_REQUESTS table details with SR employee, his dept, reporting dept, team, unit,section, trying with following query, but i am getting … -
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 22 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI Report not showing pictures when exported as Web ArchiveSummary: We have an OTBI report that stores images + html values. When extracted as Web Archive, first row displays image just fine, but row2 and row3 are only showing I…CAMIL_Q 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…
-
Are there any jobs to schedule hourly/daily/weekly for OTBI?Summary: We have schedule jobs for various areas of HCM but nothing that runs hourly/daily/weekly for OTBI reporting. Are there any jobs that you can recommend to schedu…LFafard 26 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to derive Running Average of Monthly Attrition rate in one OTBI reportSummary In one OTBI report, I would like to see, the monthly attrition rate and monthly running average attrition rateContent Can anyone please help me how to do this? I…Suresh Pallapothu 167 views 9 comments 0 points Most recent by Matthew Phillips Reporting and Analytics for HCM -
How to create a report with full and part time EMP count as per department ?I have created a headcount report with basic employee info. I want to modify it such that it has Emp ID, Dept ID, Full time & Part Time Empl count. Basically I am lookin…Trupti Khodke 13 views 2 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 125 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
Report Job HistorySummary Report job history only goes back 9 months from current dateContent Hi, After a query from an end user in HR we've noticed that the report job history only seems…
-
How to add a count column for employees aligned to a job in OTBI.Summary: I have created a report in OTBI to show all job names in our business. I need to create a column which does a count on the number of employees who have this job…
-
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
Dashboard prompt not applying to linked analysisSummary: The Dashboard prompt for 'Name' is accurately returning the number of Employees for our 'Headcount' tile, but when navigating to the link analysis for Headcount… -
We are trying to extract month from a date column in OTBI after we convert it to Mountain Time.Summary: We are trying to extract month from a date column in an OTBI report after we convert it to Mountain Time. However we get the month from UTC only.Any suggestions…
-
Information about Report and its linked data modelSummary: looking for any table or Subject area where we can get information about Report and its linked Data model. to ensure that every report linked with report after …Amit_Ekbote 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Need column mapping of With this note in learning assignment in OTBI Subject areaSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI analysis with Termination Reason and Termination Category are failing after 24A upgradeSummary: Hello, All our OTBI analysis with Termination Reason and Termination Category in them are failing after 24A upgrade. I forced deployed PER_ACTION_OCC_EIT_EFF ex…
-
Remove column from Excel BI Publisher reportI have a report containing many columns that I prepared using Excel Publisher and I want to remove a column, but when I upload it back to the system by clicking delete t…Cansel Karasoy 439 views 2 comments 0 points Most recent by Alexandru Burcea-Oracle Reporting and Analytics for HCM -
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 341 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 22 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Employment Terms Assignment Number in OTBI Report AnalysisHow do you retrieve Employment Terms Assignment number format? into an OTBI Report Analysis in the format needed for use in spreadsheet loader template?
-
Can you create a personalized prompt to combine multiple selections into 1 prompt selection?Summary: Wondering if it's possible to create a custom prompt in an OTBI report to create a 'group' to select for a variety of different job name codes? Content (please …
-
How to use TOPN in a filter in a column in OTBISummary: I would like to use a TOPN filter in a column formula in OTBI to provide the latest date. There are multiple lines per employee and just want the latest seniori…
-
Just went live and delivered reports don't return data. Need help troubleshooting Absence Calendar.Summary: I am brand new to Oracle and trying to figure out why we're not seeing data in the delivered reports. The one I'm working on now is the Absence Calendar. I've r…Dana Lockwood 34 views 8 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM
-
Reporting on Leave Duration Without Absence ModuleSummary: Need to report on how long employees have been on a continuous leave using assignment real time subject area. This is for an existing report and my preference i…Matthew Phillips 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
We are not getting GL Cost Center information when we are trying to pull data across learning recordSummary: We have a requirement to pull cost center details in learning history report across learner assignment details. In our project cost center is linked to departme…Pankti Shukla 23 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Can we customize HR Helpdesk DashboardSummary: We have a requirement to customize the HR Helpdesk Dashboard which is available in the Helpdesk requests landing page. The requirement are categorized into 2 pa…
-
Bi Publisher. How do you show parameter values used for the reportSummary: We would like to show on the BI Publisher report output the parameter values used to create the report. Can anyone help with this please. Thank you. Content (pl…Kevin Robertson 13 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 32 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM