SQL
Discussion List
-
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 HCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Devel…Rashmi M-Oracle 25.9K views 28 comments 12 points Most recent by Brooke Bucher Reporting and Analytics for HCM -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
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 30 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 50 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 30 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 31 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 24 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 72 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 110 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 71 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 28 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 40 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 301 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 542 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 30 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 71 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 31 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.