SQL
Discussion List
-
Performance Issue - per_availability_details.Get_availability_detailsWe've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over… -
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 11 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 42 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 179 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 42 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 128 views 6 comments 0 points Most recent by ViswanadhK 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 …
-
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 394 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 52 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 46 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 31 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…Osama_Mo 4.2K views 11 comments 1 point Most recent by Jayanth Sarma Reporting and Analytics for HCM
-
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 353 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 202 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 42 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 12 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…Ayoub AFRASS 961 views 6 comments 0 points Most recent by Sudha Gopal Reporting and Analytics for HCM -
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…Subash Ravichandran 3.3K 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 16 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 32 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 65 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 101 views 4 comments 2 points Most recent by Eric Geddes Reporting and Analytics for HCM -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 71 views 5 comments 0 points Most recent by Pratiksha Sawandkar Reporting and Analytics for SCM