Category 81
Discussion List
-
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…
-
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 32 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 13 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 22 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) -
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 24 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI) -
Hi do you have a sample query for sql oracle that will provide Hours ?Hi, We have a requirement from client that we need to provide the hours of an employee but this is the logic. If regular employee - Get the Hours from Element Entry If A…
-
'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 -
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…
-
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
-
Grade values not appearing in the notification templatePlease refer to the document below for more information about the encountered issue. Thank you.VDoolhur 2 views 1 comment 0 points Most recent by ravali koaduru-Oracle Reporting and Analytics for HCM
-
Does anyone know the arguments for pay_balance_utility.get_bal_grp_usage_values?Summary: Content (required): I would like to run a quick SQL to validate the balance group usage without creating and running a full HCM Extract. This procedure was ment…Scott Paulin 62 views 8 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Reasons for invoking the Benefits waive optionSummary: There is the option to configure the Waive option for Benefits Plans but is there also an option to configure reasons for waiving Benefit Plans? Or does Oracle …Peter Bealls 14 views 2 comments 0 points Most recent by Peter Bealls 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 …
-
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…
-
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 635 views 4 comments 0 points Most recent by Amit Mundlye-27103 Reporting and Analytics for HCM
-
Adding Grade Details to Standard Approval Workflow Notifications using Custom templateBusiness has a requirement to add Grade under Employment Details section that is displayed in the delivered/standard Workflow Approval notifications. We have tried achie…Neeraj Awate 15 views 1 comment 0 points Most recent by Claudiu Postolache-Support-Oracle Human Capital Management
-
getting 406 Not Acceptable error while running the rest api for "Role Assignment Audit Report"Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…POOJAJSINGH 13 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
table that stores "Enable Role for Access from All IP Addresses" indicator value (Role Basic inform)Summary: table that stores "Enable Role for Access from All IP Addresses" indicator in role page Content (please ensure you mask any confidential information): Need to k…SaiPavan Kumar Gadepalli 40 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
how to disable expired identity service provider(SSO)?Summary: In our single sign on configuration page(Security console), we see two expired identity service provider(certificates) with Enable Flag= Yes, we would like to k…Sushant95-Oracle 22 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security