SQL
Discussion List
-
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo…Sujeeth Chinta 833 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM -
how to create Dynamic Parameter in Logical SQL in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 105 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Query to get the list of roles in applicationSummary Query to get the list of roles in applicationContent Hi Experts, Is there any seeded query or custom query available to pull the list of all seeded and custom ro…Charan Kollipara 1.7K views 8 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
auditing for document of records viewwe have a requirement to get auditing report for who are viewing the document of records. we are trying to get it from OTBI but data is not coming from those columns. ca…Dara Nagasai 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Query for Role – AOR Mapping ReportHi All, We need a query for "Role – AOR Mapping Report". Can someone help to provide the query of this if anyone has already gone through this type of requirement? The f…
-
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 138 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det… -
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
From which table can I obtain the Manager Overall Rating field?Hi, I want to add the Manager Overall Rating field to a report. Can I do this with SQL? In which table do I find this field? In OTBI, I can achieve this by using the Wor…Cansel Karasoy 228 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIAJoycieee 21 views 1 comment 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …
-
Randomization of employee list(from different BU/Department) for every runSummary: Report to fetch Random list employees for every run Content (please ensure you mask any confidential information): I need the report to fetch randomized list of…Raksha Govindaraj 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
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 65 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 23 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 400 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 22 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 86 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…