SQL
Discussion List
-
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "…Cansel Karasoy 11 views 2 comments 0 points Most recent by Bianca Culea-Oracle Reporting and Analytics for HCM -
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM -
BPM Approval notification BI report for "Request a New Position" notificationSummary: When an employee is moved between departments, a "Request a New Position" notification is distributed. This notification provides details on positional details …Maruthi T 11 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…Manoharan 91 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 31 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
Journey Audit_action_type_Summary: From table PER_ALLOCATED_CHECKLISTS_TL_ in AUDIT_ACTION_TYPE_ how to get 'DELETE' value I am unable to get it, from the backend. I have deleted the assigned Jou…Afrid_3R3AE 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
-
-
How to Restrict BIP report data based on the AORsSummary: Hi All, @Mandeep Gupta --> If you have faced any such type issues kindly help me with this. I have a requirement to build a BIP report in such a way that If emp…Dasari Dileep 461 views 3 comments 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…
-
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
-
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 111 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
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…
-
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 21 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
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…
-
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…
-
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…
-
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…
-
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 51 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 31 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 291 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 131 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 21 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM