SQL
Discussion List
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 71 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
OTBI how to list repeated valuesSummary how to use list component to repeat valuesContent Hello, I've created a customized report in OTBI and it i'm using the list component to present the data retriev…User_2025-02-05-18-37-12-438 88 views 5 comments 3 points Most recent by Pratik Raval Reporting and Analytics for SCM -
Personal Payment Method Processing OrderSummary: Hi all So I've seen this asked before on another post but there wasn't a solution. The processing order for Personal Payment Methods doesn't appear to match up …SimonG 101 views 7 comments 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM -
query to get timecard calculation for an employeeCan anyone help me getting sql query for calculated quantity in Timecards entries of an employee.
-
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 52 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 21 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 11 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…
-
Fix duplicate records using PER_EXT_SEC_ASSIGNMENT_NOW_FUTURE_UESummary: Including both the latest and reinstatement (‘DS_AFFECTATION’) records using an OR condition works in BIP but produces duplicates in the HCM extract using PER_E…
-
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 22 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 52 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 11 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle 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 102 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 64 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 11 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle 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 5.3K 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 41 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
-
How to fetch the calculation card association details TRU for a specific assignmentSummary: I am currently working on fetching the TRU for Tax withholding calculation card. The calculation card has association and association details. It uses US taxati…
-
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… -
Equivalent way to get running query for different processSummary: Equivalent way to get running query for different process Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to g… -
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 87 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.
-
Archive Information and Generate Report Takes longer time to completeSummary: Archive Information and Generate Report Takes longer time to complete Content (please ensure you mask any confidential information): Hi Team, Greetings! This qu…