SQL
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 22 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… -
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 -
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 …
-
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 49 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 21 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 11 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security
-
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 273 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…
-
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 136 views 2 comments 0 points Most recent by Parag Hiremath Fusion Applications Administration -
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 …
-
Changing Aggregation/Group of Column in OTBIHello, I have a Logical SQL report to combine data from the "Workforce Succession Management - Incumbent Plans Real Time" and "Workforce Succession Management - Plan Can…Nick Dorfner 24 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 123 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I am getting exception error for one of scheduled report through bursting.Summary: I am getting exception error for one of scheduled report through bursting. Does anyone know what should be the reason. Content (required): Job Priority: Normal …
-
Send a BIP report to PRINTERSummary: How to send a BIP Report output to PRINTER directly Delivery output should be directly sent to PRINTER Content (required): Version (include the version you are …Mudhassar 132 views 6 comments 0 points Most recent by Nagarjuna Nudurupati Reporting and Analytics for HCM
-
In which table does the Candidate Selection Process Code field is storedSummary: I'm trying to fetch the Candidate Selection Process code, but couldn't figure it out where this field is stored. Content (please ensure you mask any confidentia…Sujeeth Chinta 623 views 3 comments 0 points Most recent by Sujeeth Chinta Reporting and Analytics for HCM -
Assignment Manager - Performance Document ReportingHi all, We've built a report that we'd like managers to be able to run that'll return their direct and indirect reports Performance document status details. The issue we…
-
OTBI report how to display parameter list of values only with the report result in the list ?Hello , In OTBI report, we would like to have a list of values on parameter “location “ based on the values of the report result . Only the values that are extracted fro…Revital Mefano 374 views 4 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…Sinem Kara 21 views 1 comment 0 points Most recent by Florin Loghin-Oracle Reporting and Analytics for HCM
-
How can I join General ledger and ExpensesHow can I join General ledger and Expenses I am precisely looking to join below tables gl_je_lines gl_ledgers exm_expense_types Much appreciate your help on this
-
Where retrieving Process Workforce compensation change statements processes Transaction IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where I could find the Transaction ID when processing Workforce compen…
-
fast formula to have the eligibility criteriaSummary: Eligibility Criteria to Assign Benefits Tasks through Journeys Content (please ensure you mask any confidential information): I have built a fast formula to hav… -
OTBI_Pivot_IndexSummary: Hi, If anyone knows how to use index on pivot table in OTBI, I would greatly appreciate your help. Thank you. Regards, Melek Content (please ensure you mask any…Melek Cinar 21 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
2 Date prompts to pull data OTBISummary: I am trying to pull a report that gives me all Current Terminations and back-dated Terminations. To do so I need the prompt to pull dates from BOTH fields. Term…THawkins_LGI 31 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
Inactive pending worker data is being pulled in the OTBI Pending worker report.I have created a pending worker report using the logical SQL. In pending worker report Rehires are being pulled onto the pending worker report where the candidate record…Nishu_Kumari 42 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Report of employees with element entries during the pay period NOT calculated due to ineligibility.Summary: For reconciliation purposes we need to identify the elements that were not included in the calculation process for employees since they were not eligible for th…
-
Data model with excel as source not workingSummary: Data model with excel as source not working Content (required): Hi Team, Greetings! We have the data model with 2 groups - one with excel as the source and othe…Parag Hiremath 21 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …MikeW 27 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
i want to join (PAY_PAYMENT_TYPES) tables with person details.wanted to fetch payment type and payment source highlighted in the below snapshot.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)