SQL
Discussion List
-
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee. -
Need SQL query to get the report category details based on the HCM Extract nameSummary: Need SQL query to get the report category details based on the Extract name Content (please ensure you mask any confidential information): We need SQL query to …
-
last update date not getting for Business unitSummary: Hi We have deactivated Business unit. i was looking for last update date in view#fun_all_business_units_v but i am not seeing any change last_update_date. May I…
-
In Oracle Fusion TEST, Profile Codes shown in front end but not in HRT_PROFILES_B table.Summary: In oracle fusion TEST instance, am able to see the Profile Codes for Talent Profiles in front end, but am not able to see it in HRT_PROFILES_B Table. Whereas I …
-
How to Query Cost Code from Oracle Fusion HCM OTL Time Card Tables?Summary: Hi Community, I need help identifying which table/column stores the Cost Code information visible in the OTL Time Card interface in Oracle Fusion HCM. Context: …Vishal Purohit 30 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
I need a query to fetch top performing employees in talent managementSummary: I need a query to fetch top performing employees in talent management Content (please ensure you mask any confidential information): Version (include the versio…
-
Roles and Privileges Real TimeI am required to show the date when a user was assigned a role. Is that possible either with this subject area or through a custom query. My output needs to be: Person N…David Boudreau 19 views 4 comments 0 points Most recent by David Boudreau Reporting and Analytics for HCM
-
I need a query which will fetch Percentage of employees with succession plansSummary: I need a query which will fetch Percentage of employees with succession plans in fusion hcm talent management Content (please ensure you mask any confidential i…Pritha 7 views 1 comment 0 points Most recent by Suman Chenumalla-Support-Oracle Career and Succession
-
HCM Audit Table Differences - Do the audit tables keep deleted rows and the regular table does not?I want to understand the difference of contents between a "regular" table and an "audit table" that has an "_" underscore at the end of the name. I am calling PER_ALL_AS…
-
Changing Date format to 'DD/MON/YYYY' in SQL for BIP reportHi, Can you please suggest how to change the Date format to 'DD/MON/YYYY' in the SQL for BIP Reports. Thanks in advance. -
How to Associate RTF template with Data Model and configure E-Signature Validation.Summary: Hello All, Need support on below requirement. Kindly share if you have any reference. I am trying to the Fleet Safety acknowledgment document with an electronic…RamkumarKadhiravan 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
APISummary: Hi Expert, How to get the ( additionalInformationDetailsUniqID)? I have only URL and Offer ID how shall i get the additionalInformationDetailsUniqID? /hcmRestAp…
-
How to find out who/when edited BPM Worklist about Access ActionsSummary: What are the tables/views enable us to find out some audit info that who and when have edited the BPM worklist, e.g. ApprovePerformanceGoal, about the Access > …Hellen Zhao-5941 26 views 2 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Require User Account Status update history.Summary: Dear Oracle Community, We got an issue regarding the Users Account status. There's statuses turned to Inactive. We want to know who has made changes to the acco…Muzammil_789 12 views 2 comments 0 points Most recent by Rambabu Laveti-Support-Oracle Reporting and Analytics for HCM
-
write a sql query to fetch average percentage of budget utilizationSummary: write a sql query to fetch average percentage of budget utilization Content (please ensure you mask any confidential information): write a sql query to fetch av…Pritha 7 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Sql query to find the pending document of record detailsSummary: I am looking for query to find the pending document of record details. I can see the approved once in table hr_documents_of_record. Content (please ensure you m…Rahul K-Oracle 466 views 2 comments 0 points Most recent by Domenico P. Reporting and Analytics for HCM
-
Is there usage and adoption reports for HCM?Summary: Is there usage and adoption reports for HCM? I see the adoption reports for CRM, but none for HCM. We need some info for a business case we are presenting to pu…TerryM01 96 views 7 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get shift name start time, end time for certain date, from the work schedule caledarSummary: In oracle Fusion, We need a query to identify the shift name , shift start time and shift end time as the following parameters shall be passed Emp number Date C…MHanif 22 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
How to get shift name start time, end time for certain date after manually change the workSummary: I need to retrieve the shift name, start time, and end time for a specific date after manually updating the work schedule calendar. How can I get these updated …Sanduni Pathirathne 12 views 1 comment 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Query to fetch data entered by employee in an ICP requestI am looking to build a query on the ICP request raised by an employee. This should include submitted and approved transactions. However, there are certain fields for wh…SHRUTI PRIYA 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to Query Reported Time for Specific Payroll Time Types Based on Time CategorySummary: I'm trying to query reported time entries for specific Payroll Time Types that belong to a particular Time Category — in my case, the category is called "**** T… -
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 4.9K views 8 comments 0 points Most recent by Siddhesh_Nisal Reporting and Analytics for HCM
-
Need Help Identifying Tables for Custom Oracle Audit Report with Product, Business Object TypeSummary: Hello Oracle Community, I'm trying to build a custom audit report similar to Oracle's standard audit output with the following columns: User Product Event Type …Vishal Purohit 18 views 2 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM
-
SQL Query - Pending Benefit Transactions that would prevent Employee TerminationHello, Hope you are well. Does anyone have a SQL query available, that displays any Active/In-Flight/Pending Benefit Transactions which would cause the Termination of an…David Oldfield 1 view 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report Date Parameters needed START: (First_Day of Last month) END: (Last_Day of Last_month)Summary: Hi Forum: I'm looking to use below to accomplish General tab for Scheduling a report START: Last_Day(ADD_MONTHS(SYSDATE,-2))+1 First_day END: Last_Day(ADD_MONTH… -
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 71 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
Comment Column is splitting into multiple rows in Excel outputComment Column is splitting into multiple rows in Excel output for online BI template.
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 874 views 16 comments 0 points Most recent by AMIT KUMAR YADAV Reporting and Analytics for HCM -
Dynamic Date Prompts and SQL Setup for OTBI Workforce ReportSummary: Assistance needed with creating a dynamic OTBI report that allows users to enter date ranges for Assignment Details Effective Start Date and Assignment Details …ReiV 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM