Reports
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 31 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Project CostingSummary Project CostingContent 1. How do you Transfer Cost from one project to the next? 2. how to split cost from one project to multiple? 3. How to correct duplicate l… -
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 11 views 1 comment 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
How to extract LEGAL_ENTITY_IDENTIFIER?I need a SQL query for a BI report to extract the LEGAL_ENTITY_IDENTIFIER, starting from a department.Gian Luca Triglia 123 views 1 comment 0 points Most recent by Raghavan p-Oracle 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 81 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
is there any lease standard report for data conversion validation?Summary: is there any lease standard report for data conversion validation? Content (please ensure you mask any confidential information): Version (include the version y…
-
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 21 views 2 comments 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 81 views 6 comments 0 points Most recent by Stephen Prentice Reporting and Analytics for HCM
-
Hima Bindu Kukkala-Oracle 11 views 1 comment 0 points Most recent by Pradeep Balakrishnan Project Management
-
ReportLocation function is not working in Report books.Hi, We have inserted "ReportLocation" function in the report's footer which is working fine while generating individual reports. We have created Report books using those…JyotiSharma 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How to report on data from Workforce Assignment Event Real Time and Workforce Assignment Real TimeSummary: We have a requirement to report historical employee headcount based off values stored in an Assignment DFF. We get accurate historical data only when an action …David Boudreau 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 31 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 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need Data base Oracle tables stored ThirdPartyOrganizationPaymentMethod details.I am working on a conversion BIP report for ThirdPartyOrganizationPaymentMethod . Can you please share a sample SQL to query these information we loaded using HDL.… -
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… -
Custom Time Balance PropertyHi everyone! Im having issues related to the Custom Time balance, ex; When Applying custom Time Balance Property , please suggest the way to apply custom Time Balance Pr…
-
UK Check/Cheuqe Payslip ReportSummary: UK Cheque payslip report query Content (required): I am adding the SQL query for custom cheque payslip report. Employee will have the payment method as cheque o…Arti P 21 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) -
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 -
Change Report for PayrollSummary: We are looking for a Report to show previous and current values for any change to Person Name, Address, Assignment, reason for change and who approved the chang…
-
Text in Report does not show correct amountIt was found that the Text in migrated Report does not show correct amount. Before migration, the problem does not exist in FR report. Steps: 1. Generate FR Report “Text…
-
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 …
-
How to retrieve asset category base rate for previous month & current month using sqlRetrieve asset category base rate for previous month & current month using sqlSravan Kumar Meka 1 view 0 comments 0 points Most recent by Sravan Kumar Meka BI Publisher Learning Center
-
Index -1 out of bounds for length 10Summary: I have used Excel Template for the data model and getting following error: Index -1 out of bounds for length 10 Issue is there was already an excel template wit…Amit Mundlye-27103 811 views 4 comments 0 points Most recent by Amit Mundlye-27103 Reporting and Analytics for HCM
-
implication to change YEAR and PERIOD Dimension to Single Time DimensionSummary: Content (please ensure you mask any confidential information): Hi Oracle Regarding the new feature: Single Time Dimension Does someone know what are the implica…NKW 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close