SQL
Discussion List
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 664 views 5 comments 0 points Most recent by Yahya Khan Reporting and Analytics for HCM -
SQL Query for timecard approval to BPM workflowObjective : SQL Query to get Approver Name, Approval Date and Status of Timecards Imported in Project Cost Issue : I am unable to find a link between HWM_TM_REC and Work…Palash Kumar Singh 186 views 2 comments 0 points Most recent by Palash Kumar Singh Reporting and Analytics for HCM -
Query to get ESS job details which are running more than 24 hoursSummary: Query to get ESS job details which are running more than 24 hours Content (required): Query to get ESS job details which are running more than 24 hours, I need …
-
When I add filter to query the report goes in timeoutSummary: Slow learning (WARF) query Content (please ensure you mask any confidential information): https://us.v-cdn.net/6034893/uploads/S9IJ8KIYKON0/learning-query.txt I…Stefano_Mazzocca 11 views 1 comment 0 points Most recent by Stefano_Mazzocca Reporting and Analytics for HCM -
In which table can I find the Proposed Worker Type field in Workrelationship?Hi, I want to add the Proposed Worker Type field on the person screen to my report as in the screenshot below, but this information returns an id in the per_all_assignme…Cansel Karasoy 1.6K views 8 comments 0 points Most recent by User_E31A6 Reporting and Analytics for HCM -
SQL query to display HCM Extract flow and output file sizeSummary: Does anyone have a query that displays the size of file generated for flows completed? sometimes files are empty or very small like 1kb, this would help for fas…
-
How to handle null values while Summing in RTF TemplateSummary How to handle null values while Summing in RTF TemplateContent Hi Team, Please advise with syntax for to handle null values while Summing values in RTF Template …User_2025-01-29-00-33-34-534 1.1K views 4 comments 0 points Most recent by User_NPE6A Reporting and Analytics for HCM -
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 31 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 11 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
How to get users logged on info in HCMSummary: User session info required Content (required): Need to get logon info for users. Seems to be a few posts but not a concrete answer. FND_SESSIONS seems to hold t… -
Unable to fetch retro time card adjustments from the HCM backendHi All, We have a requirement to pull retro time card adjustments through the Changes Only HCM Extract. However, we are unable to fetch these adjustments from the HCM ba…
-
unable to load competencies due to QualifierId2Summary: I've tried to load Talent Profile Competencies multiple times, but no luck. First time around I tried with no QualifierId2/QualifierCode2 column and then second…
-
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table… -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 52 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Table for Payroll Transfer Status and Payroll Processing StatusWe need to get Payroll Transfer Status and Payroll Processing Status. Where are these information gets stored? Please share if you have any inputs. We have tried using p…Manoharan 553 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
What is the functional difference b/w fusion_ora_ess.request_history and fusion.ess_request_historySummary: What is the functional difference between fusion_ora_ess.request_history and fusion.ess_request_history and please explain ErrorType codes present in fusion.ess…
-
Is there any way to get back the archived transactions related workflow transactionsSummary: I want to get the information on archived transactions details. Content (please ensure you mask any confidential information): Recently we have click on archive…VishnuVardhan Raju 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a table which stores Absence balance for future date of and incremental planSummary: We are looking for a table or sql query which gives Absence balance as on future date. Absence plan is incremental, and accrual process will run for every bi we…
-
Query for Acknowledgement / Approve section for Overall Performance EvaluationHello! I would like to build a query which will receive the approval/acknowledgment of a specific section. Unfortunatelly in the ratings or section tables we cant corela…
-
Is there other table store info about qualified entitlement planHi Teams, table anc_per_abs_qual_entl is holding the data when user records an absence, do we have any other table or view stores the entitlement information when user n…
-
SQL query for Planned Schedules on Time ManagementHello! I need help in developing an SQL query for generating the Planned Schedules for employees on the Time Management navigation: My Client Groups>Time Management> Pla…Hassan Mohsin LC 174 views 8 comments 0 points Most recent by ganesh_b-Oracle Reporting and Analytics for HCM
-
HCM Extract takes more time when bind parameters included in Process config groupSummary: Hi Team, We have built a HCM Extract which fetches Core HR Data. I am using Use bind variables during action creation phase. - Y_ALL. We are running HCM Extract…
-
Requesting details on the Fusion Tables used to extract “Tax Rate” from Values Defined by CriteriaDetails: We are creating an outbound custom BI Report to send Payroll Balance and Calculation Card details to Fidelity. One of the requirements is to extract Tax Rate of…Manjuk7070 16 views 0 comments 0 points Started by Manjuk7070 Payroll and Global Payroll Interface (GPI)
-
The filter should show just the Years: 2021 2022 2023 2024Hi, this is about the excel format ,When the user clicks on the filter for Date of Joining or Last Working Day, instead of seeing individual dates like:30-Jan-2023 08-Fe…SenthilRaja 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…
-
Item Master ReportSummary Item Master ReportContent Hello, Can you please advise if there is an option or a seeded report in Fusion where we can get a list of all item code with their res…User_2025-02-05-12-20-44-163 217 views 9 comments 0 points Most recent by Chandramouli Potnuru Reporting and Analytics for SCM
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 517 views 10 comments 0 points Most recent by Thomas Samuel19 Reporting and Analytics for HCM