OTBI
Discussion List
-
In which table is the information about who rejected the notifications with rejected status?Hi, I would like to access the information on who and on what date the rejected leave notifications were rejected in the system. I would appreciate it if you could share… -
'Range Values' in calculation factor from element definition pageHello Experts, I have requirement to get all details of calculation factor , Please check below image to identify requirement. Thanks.Rajdeep Chavda 31 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
Is there a report or query to see changes for employees Loans status before payroll runsHello All, Is there a report or query to see changes to employees Loans status before payroll runs, for example if they refinance , new etc? Thanks, Version 23CGail Wilmoth 21 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM -
Custom OTBI report using UNION and getting errorUsing UNION to create a custom OTBI report and am getting this error: "Result field position x, has metadata type of integer, but the actual result data type is varchar.…vidyaxkarnam 64 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to sort characters numerically in OTBI?I'd like to order these custom values in OTBI numerically. However, this is how my current values sorted: The requirement is to sort them like this: 0-0.5 0.5-1 1-3 3-5 … -
Payroll Balances Real Time not returning zero valuesContent We are using the folder Payroll balances Real Time to bring back for a payroll run those people who have zero gross pay, however, although in the person results …
-
I have a report with element totals and I need to filter so it only shows the total rowSummary: I was able to get totals by month for each element. Now I need to only have the Totals row visible. Any ideas? See below. I do not want each element total to sh…
-
OTBI report not displaying seniority dates for secondary WRSummary: OTBI report designed out of delivered subject area - "Workforce Management - Person Seniority Real Time", is displaying only the primary WR seniority dates. Whe…Suchayan_Garai 148 views 25 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Salary Amount Fast Formula Compilation ErrorSummary: Fast Formula for getting Salary Amount is giving compilation error saying: the assignment uses inconsistent data types Content (please ensure you mask any confi…
-
Unable to extract learning course rating and link it to the related courseSummary: Hi, I can extract learning course rating data, by course participants, from OTBI subject area 'Workforce Learning: Learning Records Realtime' but I am unable to…Paul Morrissey 22 views 4 comments 0 points Most recent by Paul Morrissey Reporting and Analytics for HCM
-
User System Usage ReportSummary: User System Usage Report Content (please ensure you mask any confidential information): Hi Team, Greetings! We are looking to get the data for the periodic or d…Parag Hiremath 131 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 41 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
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 21 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 11 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 23 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 165 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 11 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 133 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…