SQL
Discussion List
-
Retrieve “Processed People” count for Generate Total Compensation Statements ESS process in BIPFor the ESS process Generate Total Compensation Statements, the Scheduled Processes log displays values such as: Selected people: 1921 Processed people: 636 Ineligible p…Ankush Jadhav -Oracle 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 18 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac…Charan Kollipara 1.1K views 14 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM -
Competency Rating in PerformanceSummary I need to pull item ratings and item comments a manager entered in the Competency section in a performance documentContent HELP!!!! I need to pull item ratings a…Gala Meyerovich 184 views 3 comments 1 point Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
R13 20A - How to fetch the error messages from HRC_TXN_ERROR tableSummary Unable to get the failed error message reportContent We are creating a report to pull all the transactions that failed on a given day based on the issue date. We…Suganthi Srinivasan 50 views 2 comments 1 point Most recent by ViswanadhK Reporting and Analytics for HCM
-
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 112 views 6 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM
-
Re-hire employee HDL templateSummary: Hi Expert, We are looking for an HDL template to rehire terminated employees. The requirement is to rehire employees with the same assignment information they h…Md Jamil 21 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 84 views 4 comments 1 point Most recent by Raj Battiwala Reporting and Analytics for HCM -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
Is there any way to get all BI folder level permission details via report?Hi Team, I have a requirement to fetch details of folder level permissions set on each folder in BI catalog. I see different roles/users have different level of access o…Narula Shray 541 views 6 comments 0 points Most recent by Matt Van Asten Reporting and Analytics for HCM -
Report to get Original Date Earned of element entrySummary: Report to get Original Date Earned of element entry Content (please ensure you mask any confidential information): Hi Team, Greetings! Does anyone have the repo…Parag Hiremath 391 views 4 comments 1 point Most recent by Rahul_Jadhav02 Reporting and Analytics for HCM -
We need a query to get Payroll Balance group usages mapped to Balance dimensionSummary: Hi. We need a query to get Payroll Balance group usages mapped to Balance dimension. When dimension changes(Quarter, Run, Month… ) then the Balance group usages…Opkey PA 40 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …
-
ASE_USER_ROLE_MBR table usage restriction and alternate table suggestionSummary: Is ASE_USER_ROLE_MBR not supposed to be used for BI reporting? If yes, what is the reason, and what could be the alternate way to get the role revocation detail…VeerakumarS 23 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to Create Dynamic Parameters in a Data Model?We have a Data Model that uses Parameters and List of Values SQL to automatically determine beginning and ending dates for a report that runs once a day. Well, we though…Dennis Joe 22 views 3 comments 0 points Most recent by Abhishek Jois Reporting and Analytics for HCM
-
Query to get Fusion Workflow ApprovalsHello, Is there a query where i can get all pending approvers for a transaction, not only the current assignee? I was able to identify the current assignee using the bel…
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticesContent This white paper provides the best practices for working with BI catalog folders, and …User720640-Oracle 341 views 8 comments 11 points Most recent by Ulitka Reporting and Analytics for HCM -
Position Extract - Fast formula to get parent position NameSummary: Summary: Hi Experts, I need your assistance. I'm currently working on the position object task. I'm unable to search the parent position DB item in the entity (…
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 192 views 3 comments 0 points Most recent by UdayShinde_Suavis Reporting and Analytics for HCM -
SQL not fetching pending worker created in last 1 hourSummary: SQL not fetching pending worker created in last 1 hour Content (please ensure you mask any confidential information): Hi All, There is a BIP report with burstin…Gayathri K M-Oracle 41 views 6 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
exceeds the maximum limit error even after using filterSummary: exceeds the maximum limit error even after using filter Content (please ensure you mask any confidential information): Hi Team, Greetings! We are getting below …Parag Hiremath 11 views 3 comments 0 points Most recent by Meenakshi K Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i… -
Query to fetch overall rating from Performance documentSummary: Hi All, Can you help me in sql query to fetch overall rating from the performance document? TIA Version (include the version you are using, if applicable): Code…ShawShankk 3.2K views 6 comments 0 points Most recent by Radwan Almomani Reporting and Analytics for HCM
-
Can attachment content be copied on BIP Report outputSummary: Can attachment content be copied on BIP Report output Content (please ensure you mask any confidential information): Hi All, Greetings! We have a requirement ab…Parag Hiremath 11 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Which table has the information for Rule Builder for Checklist Template redwood taskSummary: Hi team, Which table has the information for Rule Builder for Checklist Template redwood task. Need the table where Rule builder name stores for the checklist c…
-
Standard report for Oracle journeysSummary: Standard report for journeys Content (please ensure you mask any confidential information): Hello experts, does anyone know if there are standard reports delive… -
What tables hold questionnaire details for RecruitingSummary: I've created a test interview questionnaire for hiring panel members to complete for shortlisting purposes and want to report on it. Content (please ensure you …Helen Bennallack 21 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
I want SQL query to fetch data from talent review meetings , employee view potential assessmentSummary: below question and answers i need to fetch against the employee. (navigation talent review meeting in progress → select any employee in meeting → Actions tab→ v…Amit Baghel 51 views 7 comments 0 points Most recent by Ritabrata Mukherjee 3004 Reporting and Analytics for HCM
-
Time Change Request Type TableSummary: Hello, does anyone know which table stores the values of Request Type column in Time Change Request page? We are currently building a BIP report and was able to…
-
Show the pod or instance name on an OTBI Analysis?Summary: We need to be able to label the header of an OTBI Analysis with which pod or instance it comes from. It can be pulled into a data model using the following quer…Eric Geddes 102 views 4 comments 2 points Most recent by Eric Geddes Reporting and Analytics for HCM