Category 81
Discussion List
-
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) -
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 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 -
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 62 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 1 view 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 12 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 730 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 11 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 12 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 42 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 21 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
How to find user login to fusion application was via mobile or web browserSummary: Hello Team, We have a requirement to know the login to fusion application was done via mobile or webbrowser by the user. Appreciate your thoughts. Content (plea…Shiva Prasad M 22 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Reporting Variance - Security Console vs Security Detail ExtractWe would like to understand the source of truth for user roles and privileges. We have a report that is looping through the ASE_ROLE_ROLE_MBR table linking the child and…Clare Paone 27 views 1 comment 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
Information of the logged in userCan I detect which operating system or device the user logging in to the system is using?Sinem Kara 12 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
EL expression not working inside Questionnaire in Performance documentSummary: Below EL expression not working inside Questionnaire in Performance document: #{(pageFlowScope.pDocumentInfoMap['pPerformanceDocumentName'] ne 'Document name')}…SagarLaddha 22 views 3 comments 0 points Most recent by Adriana Tudor-Oracle Reporting and Analytics for HCM -
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 154 views 25 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is the Revoke User Access field from HCM termination process available in BI Publisher?Summary: The field "Revoke User Access" stores option of revoking user access on Termination. We need to pull it in a BI Publisher report, but we have not been able to f…
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 284 views 5 comments 0 points Most recent by MandeepGupta 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 24 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 135 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)
-
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 …