OTBI
Discussion List
-
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 24 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to print a prompted date selectionSummary: I have an analysis with a date range prompt on the field Work Relationship Start Date. I would like to display in the report the range that the user selected. W… -
Aaron Reynolds 12 views 1 comment 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
How do I create a severance report using payroll run result real time subject area ?I am trying to build a severance report for codes - SVR, RTN, SVK, SVL, WRN. I am looking to get the earnings in the below format but I am struggling to find the fields …Trupti Khodke 41 views 4 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Compensation Salary History Details Real Time not showing data for leaversSummary: Hi all I have built a report in OTBI using the Compensation - Salary History Details Real Time. I noticed I am missing data for employees who have left the orga…NusratB 73 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Redwood Help Desk - Departmental StructureHi all, Does anyone have any suggestions on how to report on the department of the individuals available (Affected Party, Contact, Agent, etc) within the Redwood Help De…
-
OTBI Termination Date Filter Syntax QuerySummary: Hiya, I am trying to filter out any records where the Termination Date is before the current date. If the termination date is after the current date then the re…Kevin Robertson 22 views 2 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Possibility to download the subject areas field in OTBISummary: Possibility to download the subject areas field in OTBI Content (please ensure you mask any confidential information): Hi experts, does anyone know if it is pos… -
Do release updates affect the seetings in the Custom BI Webcat Reporting Duty Role?Summary: We want to limit the access to seeded reports as described here How to Revoke User Access to Seeded OTBI Content in Oracle HCM Cloud | by Manoj Gupta | Medium, …Sa_De_Or 7 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Workforce Structures > Job Detail Screen - Can You Report a History of Changes?Summary: Is there a way to write an OTBI report that shows old and new values, field name and date of change entered on the Job Detail screen (Workforce Structures/Job D…
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
Need to find Entry Grade against Position in OTBISummary: Position Entry Grade reporting in OTBI Content (please ensure you mask any confidential information): Having issues with posting that I believe may be due to mi…Stephen Prentice 63 views 6 comments 0 points Most recent by Stephen Prentice Reporting and Analytics for HCM
-
Query to get the rollover balance of Annual Absence Plan on January-1-2024Summary: Hi Guys, i have i have scenario, Plan A and Plan B. Plan A is Base plan and Plan B is target Plan where rollover is being transferred. for example Plan A has 20…
-
Schedule report to run based on Last Run DateSummary: Is there a way to schedule a report to run starting from last run date? Content (please ensure you mask any confidential information): Version (include the vers…THawkins_LGI 32 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
MAX last modified date in Dev Goal Count Report returning blank fieldSummary: I am trying to create a report that will pull the entire employee population along with their Development Goal Counts and the most recent date they made a modif…Vis Perera 32 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
HY000. Code: 60009. The user request exceeded the maximum query governing executioContent We have created an analysis with BI Admin role. When we are running this analysis with BI consumer/author role. we are getting error: HY000. Code: 60009. [nQSErr…
-
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 32 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 61 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 145 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 21 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 125 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 42 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)