Category 81
Discussion List
-
Query that fetch Calendar Events and LocationSummary: I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but …Matheus Roberto 309 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id… -
Parag Hiremath 2 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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 23 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 11 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
-
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 104 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 74 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Unable to generate payslip in biweekly employeesSummary: We processed usual payroll flow in pods however for biweekly employees, Datas are not generating. Content (please ensure you mask any confidential information):…Pablo Calizo 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Can we Autopopulate TRU as per the Legal Employer, when when hiring an employee.Summary: When hiring an Employee/converting a Pending Worker, in the Payroll detail section, we need to auto-populate the TRU as per Legal Employer. Is this achievable t…Megha N. 13 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
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
-
How to Create a Report for "Correct Employment" Transactions?Summary: I need to create a report for all the Correct Transactions performed by the HR team in a day/week/month but not sure which table to use? Is there a way to repor…Amit Mundlye-27103 15 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
department reportSummary: How to extract or Query to get this information Note No.of employees Means Count Content (please ensure you mask any confidential information): Version (include…ahmed foly 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Columns within the PER_SHARE_INFORMATION table is not populating.Summary: Business need request has come in to build a report regarding shared data access. I have used the PER_SHARE_INFORMATION table. This gives me the employees who a…Max W 51 views 1 comment 0 points Most recent by Iulian Brinzoi-Nuta - HCM-Oracle Reporting and Analytics for HCM
-
benefits cancelled before coverage start dateSummary: Hello Experts, I have to extract in BIP the employees that cancelled or changed a benefit plan before the coverage effective start date. Can you explain me how …Sebastian La Spina 22 views 1 comment 0 points Most recent by Andreea_Nuck-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 3 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 67 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…
-
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 33 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 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 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… -
Assignment Organization and relationship to Worked Hours and DollarsSummary: Assignment - Worked Organization Content (required): What is the purpose of the Assignment Organization and how does it relate to where the employee worked for …Jill 12 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
For Statutory Deductions Register, how to segragate Federal and Provincial Totals for Quebec?Summary: The statutory deductions registers gives totals while combining provincial and federals. For the province of Quebec, they need to remit separately to different …Nabil.S 21 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)