SQL
Discussion List
-
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 8 views 0 comments 3 points Started by Parag Hiremath 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 126 views 1 comment 0 points Most recent by Matthew Hancock Reporting and Analytics for HCM -
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 31 views 2 comments 0 points Most recent by Ramchander Pothanolla 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 72 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 898 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 78 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 499 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 49 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 72 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 3 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 350 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 1K views 2 comments 0 points Most recent by Ramchander Pothanolla 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 532 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 28 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 15 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
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…
-
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 1.1K views 3 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
How do I define the dashboard prompt to include date range on the same columnSummary: Need help in defining the dashboard prompt to include date range on the same column, for example: date range on hire date and how to incorporate in BI Publisher…Surabhi Kumari 335 views 9 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Need a report which can provide details if any scheduled job runs and BI report run got missed.Hi Team, We have a requirement in place that if any report schedule and job schedule got skipped due to any reason then we need a BI or OTBI report by which we can track…Sanchit_Jauhari_2211 31 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to get Statement of Earnings (Payroll -> Person Results -> Calculate Payroll)Team, It would be helpful if you can guide me on how to fetch Earnings Value. (Highlighted one).Manoharan 196 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to join a Timesheet Row to an Absence Row (HWM_TM_RPT_ENTRY_V to ANC_PER_ABS_ENTRIES)Summary: If we have a person with 2 timesheet rows on the same day, each representing half day of absence, and we have 2 absence rows each of a different absence type - …
-
Table / View for New Features and Opt In Features?Summary: Is there a table / view that can be queried via BIP which would allow us to create a report of all of the implemented and non implemented features as seen in th…Monica Fundak 45 views 6 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
how to get the organization and customer hierarchy data from tables in oracle fusion planningSummary: Hi Team, What all are the table to extract the organization and customer hierarchy data from tables/BI report in oracle supply chain planning cloud? Content (pl…Nitin Aavasarmol 310 views 1 comment 0 points Most recent by gclampitt Supply Chain Planning and Collaboration
-
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 830 views 12 comments 1 point Most recent by User_FVSCP Reporting and Analytics for HCM -
I need to retrieve a list of all data roles and job roles associated with a given privilege.When querying by privilege name, I want to capture all the corresponding data roles and job roles linked to it. I attempted using the tables ASE_PRIVILEGE_VL and ASE_PRI… -
How is Business_Group_Id in PER_ALL_PEOPLE_F a foreign key to HR_ORGANIZATION_UNITS which is a view?How does the BUSINESS_GROUP_ID column in the PER_ALL_PEOPLE_F table function as a foreign key to the HR_ORGANIZATION_UNITS view, given that the view is not a physical ta…Aryan Yadav 26 views 3 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BIP Query to get only base elementsSummary BIP Query to get only base elementsContent While creating elements, there will be shadow elements that will get created automatically. Is there anyway to get onl…Sowdha Murugan 547 views 4 comments 0 points Most recent by Rakesh Kanukanti Reporting and Analytics for HCM -
how long data can store fa_fusion_soainfra.wftask this tableSummary: Need information about this table how long data will be store Content (please ensure you mask any confidential information): Version (include the version you ar…Nagendra Chitra-Oracle 66 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM
-
HCM Workflow ReportSummary All HCM transactions current status of the workflow and approval detailsContent Hi, I'm trying to create a report to display all HCM transactions Current status …