SQL
Discussion List
-
Visibility on per_person_secured_list_vSummary: Content (please ensure you mask any confidential information): What roles/setup are needed to be able to see rows on per_person_secured_list_v? Version (include…Stefano_Mazzocca 21 views 1 comment 0 points Most recent by Naveen_CCC Reporting and Analytics for HCM -
Fetch Eligibility profiles data in BIP reports.Hello Community, We are creating a eligibility profile report that fetches all parameters used in eligibility profile. Currently we are fetching the data under employmen…Shubham_R 42 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
What is the back end column where component values of a worksheet plan are storedSummary: In what back end tables-columns are the values of columns: "Budget Percentage - Employee - Component 2" , "Percentage of Eligible Salary - Component 2" and "Bud…Abishek R 17 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Customize Bill of Lading Report and Packing List ReportSummary: Hello. Has anyone here experienced customizing Bill of Lading Report and Packing List Report to add more fields? How do you get the XML for these two reports an… -
Unauthorized Access: please contact the administrator. (wlf_assignment_records_f)Summary: Content (please ensure you mask any confidential information): What privileges are needed in order to be able to see wlf_assignment_records_f table? Version (in…Stefano_Mazzocca 34 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Table to get the Time Card Required field in Payroll Relationship page.Summary: We have a requirement to pull the "Time Card Required" field on the Payroll Relationship page. But we are unable to get the table. Please help me with the table…Rengaraj G 21 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to retrieve all active recurring ESS scheduled processes in Oracle Fusion CloudHi Experts, In Oracle Fusion ClouD, how can I retrieve a list of all active ESS scheduled jobs along with Process Name, Request ID, Submitted By, Frequency, Next Run Dat…Tejeswari 57 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
While creating Value set on oracle fusion getting error.The value column is not valid. (FND-2806)Summary: The value column is not valid. (FND-2806) In value set TID_Grade_Value, value column LISTAGG(distinct(prv.value), '; ') WITHIN GROUP(order by prv.value ) "UPGRA…Ashutosh12 1.8K views 6 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
primary address querySummary: Content (please ensure you mask any confidential information): Is it possible to tell when an address is set as primary? I see both PER_ADDRESSES_F and per_pers…Stefano_Mazzocca 50 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 109 views 6 comments 4 points Most recent by Akhilesh_Singh Reporting and Analytics for HCM -
Is there a table that store calculated time in time cardHello, I would like to ask whether this information is stored directly in a specific table or if it is derived through a calculation. Kindly advise. I've seen this view …
-
Oracle Recruiting Offer Dashboard ReportingSummary: Oracle Recruiting Offer Dashboard Reporting Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well. This requ…Parag Hiremath 65 views 6 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM -
Is PER_ACTION_OCCURRENCES.CREATED_BY reliable for identifying the initiator?Summary: We use PER_ACTION_OCCURRENCES in our HCM reporting to identify who initiated an assignment transaction (Employee, Manager or HR). Historically, CREATED_BY has b…SimonG 72 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 1.2K views 14 comments 2 points Most recent by Clare Murtagh Reporting and Analytics for HCM
-
Consolidated Offer Report and DashboardSummary: Consolidated Offer Report and Dashboard Content (please ensure you mask any confidential information): Hi All, Greetings! Hope you are doing well! We are lookin…Parag Hiremath 42 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Reporting the candidate offer transaction approval attachmentsSummary: Reporting the candidate offer transaction approval attachments Content (please ensure you mask any confidential information): Hi All, Greetings! This is about t…Parag Hiremath 23 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
BI SQL FILTERWhen I search for a code in a filter, it correctly returns two values—as shown in the query below—but when I select both, only one code appears in the list of selected v…Rosita Santosuosso 45 views 4 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
How to report on how long a candidate has been in a particular phase and stateSummary: I would like to report on the length of time that candidates remains in each phase and related state. Content (required): A report that shows how long candidate… -
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 300 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Oracle Fusion HCM Fast Formula Compilation Issue – PLSQL_CREATED = N and Missing Database ObjectsSummary: Hi All, We are currently facing a compilation issue with one of our custom Fast Formulas in Oracle Fusion HCM. I would appreciate any guidance from the communit…
-
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 524 views 6 comments 0 points Most recent by PhilippeTawk 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 1K views 7 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign… -
What is the field name of checklist status?Summary: Content (please ensure you mask any confidential information): Unfortunately it is not per_allocated_checklists_vl.CHECKLIST_STATUS, any other idea? Version (in…Stefano_Mazzocca 36 views 2 comments 0 points Most recent by Bhaskar Konar 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 73 views 3 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM -
Query to get the scheduled work hours of employee from shifts the employee has assignedContent I have a requirement to report the weekly work hours the employee is scheduled for. Employee will be assigned work schedule and work schedule will be liked with …Raghavendra M 6K views 10 comments 0 points Most recent by PhilippeTawk Reporting and Analytics for HCM
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 36 views 9 comments 0 points Most recent by User_16WBA Reporting and Analytics for HCM
-
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
What entitlement and roles do I need to be able to create and run query using sqls in BI report.Summary: What entitlement and roles do I need to be able to create and run query using sqls in BI report. I can access Person Management from the UI. But I want to creat…Sunny G 71 views 8 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
Agents and RecipientsSummary: Does anyone know how I can get a list of Agents and recipients out into a report? Content (please ensure you mask any confidential information): I need to get a…