SQL
Discussion List
-
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…
-
SQL to fetch the history ratings from talent profilesSummary: Hi, Could any help me with the SQL Query or table names to fetch the ratings from the talent profile. Navigation: Me>career and performance>skills and qualifica…
-
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…
-
Need table names or SQL for Approved OTL timecard details in BIPSummary: Hi Team, I Need table names or SQL for Approved OTL timecard details in BIP. We need particular person entries and along with approver comments. Navigator->my c…Janardhan ACS-Oracle 155 views 4 comments 0 points Most recent by JamesOR Reporting and Analytics for HCM
-
23D:AUDIT MASS DOWNLOAD OF DOCUMENT RECORDS-hr_dor_mass_requestsHello All I am trying to query the hr_dor_mass_requests and its populating the values. It populates the numeric values for status and object version number as 3,4,7. wha…
-
Audit Report for Talent for changes in skills and qualification pageSummary: Audit Report for Talent for changes in skills and qualification page Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there…Parag Hiremath 2 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 26 views 5 comments 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
ORA-01719: outer join operator (+) not allowed in operand of OR or IN with payroll reportHi, The environment was recently upgraded to version 24D. Following this upgrade, the payroll report started encountering the attached error during execution (ORA-01719:…Saurav R-Oracle 17 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM
-
how to loop through a value set from a fast formula to get multiple valuesHi All, I have requirement to get multiple rows from a value set from a loop and then add up all the returned values from the value set in the fast formula. how can this…
-
How to return values within a subquery by referencing tables from outer query?Summary: Content (please ensure you mask any confidential information): How can I return the name of the task owner from Oracle HCM Journeys using the Task Owner Person …Giuseppe_Cannova 25 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas…
-
SUM in Table ValuesetTeam, We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful. SELECT SUM(peevf.screen_entry_value) FROM pay_element_entries_f …Manoharan 41 views 3 comments 0 points Most recent by Lohit Kad-Oracle Reporting and Analytics for HCM
-
Need SQL Query to fetch degree of the employeeSummary: Hi experts, I need an SQL query to retrieve the degree of an employee. If possible, please provide sample data along with the table and column names to help me …Arti_Priya 19 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…Yaniv 684 views 18 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to know the table that contains bonus amount in Individual compensation.Summary: I'm looking for the table that stores Bonus amounts entered through the Individual Compensation module. I need the table that stores the person_id, assignment_i…Prerna Mhaisane 51 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query to retrieve employee country (work relationship level)Summary: Content (please ensure you mask any confidential information): Hello experts, is there a way to retrieve Country field at the employee level by SQL query? If so…Valerio Curzi 32 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
"Test Notification Email Address" TableHi, Is it possible to query the BPM Worklist "Test Notification Email Address" from a table? Thanks, Derrin
-
how to convert blob type to actual text in oracleSummary: the underlying tables store the xml data of employees in blob format, the customer wanted to see the exact content of this File_data column in output results.. …Rama123-Oracle 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle 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 22 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Trying to Retrieve the Specific Ethnicity Record Associated with each Period of ServiceSummary:It appears that there is a separate row in table per_ethnicities for each of an employee's period of service. Looking for a query Content (please ensure you mask…ChicagoConsultant 8 views 1 comment 0 points Most recent by ChicagoConsultant Reporting and Analytics for HCM
-
Approvals are in progress. Info is lockedHello, I am trying to transfer an employee from one legal entity to another and I am getting a message that approvals are in progress. I tried to run the Conflicting Tra…Catherine Abi Samra 106 views 6 comments 0 points Most recent by Rahul M Reporting and Analytics for HCM
-
Query to retrieve Payroll Relationship information at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, please could you share a sample query to retrieve the attached data visible in the…Valerio Curzi 21 views 2 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How to fetch Cost Center Details which are mapped at Department LevelContent Hi Team, In our organisation we mapped Cost Center at Department level. How to fetch those cost center details. If anyone have SQL query please help me. I tried …Raviteja Sompalli 5.5K views 6 comments 0 points Most recent by Rahul Chapara Reporting and Analytics for HCM
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 309 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM
-
Need to generate a sequence number in outbound file at BIP. How to achieve thatSummary: Need to generate a sequence number in outbound file at BIP. How to achieve that Content (please ensure you mask any confidential information): Need to generate …Ishtiaque AHmed 30 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Please Help with Audit approval QuerySummary: The auditor has requested the dates of the last updates made to our Audit approval rules for the following areas: Job Offer Job Requisition Approval Termination…Global Support Desk 18 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1K views 6 comments 0 points Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Query to extract Journey ID, Journey Name and task IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a query retrieving all Journey details loaded at the employee level? T…Valerio Curzi 181 views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM