SQL
Discussion List
-
Special Characters in BIP ReportSummary: have requirement of replacing special characters coming in the description column of the BIP report with following: Double quotes replace with '"' need to …Rajdeep_Chavda 298 views 2 comments 0 points Most recent by User_E19UQ Reporting and Analytics for HCM -
when we run the RTF template report we getting below errorSummary: HI Team, we have RTF developed template but now we have enchement on statement of text so we changed the matter but we getting below error. please assitance on …Maddipati Ajay Kumar 68 views 3 comments 0 points Most recent by Rajdeep_Chavda Reporting and Analytics for HCM -
Is Marketing Communications Opt In available in Recruiting OTBI?Summary: We need to report the Redwood Recruiting candidate-profile value “Marketing Communications Opt In”. The value is stored in IRC_CANDIDATES.OPT_IN_MKT_EMAILS_FLAG…KiranSagar.-Oracle 44 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether…VijayaBaskar Ranganathan 745 views 9 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
How to Join FND_BPM_TASK_HISTORY_B with HCM Tables to Retrieve Employee Conversion DateSummary: Hi Everyone, I have an existing Oracle HCM report that retrieves employee Hire and Rehire information. There is now an additional requirement to include the Emp…
-
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…Manoharan 950 views 8 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM
-
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 44 views 4 comments 0 points Most recent by Jenny Scognamgilio Reporting and Analytics for HCM -
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3.8K views 22 comments 1 point Most recent by Mitali Meshram 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 5 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
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 15 views 1 comment 0 points Most recent by Gail Langendorf-Oracle 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 200 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 49 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 133 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 101 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 410 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 79 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 71 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 37 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 363 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 210 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 45 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 16 views 3 comments 0 points Most recent by Meenakshi K 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.4K 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 17 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM