SQL
Discussion List
-
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od… -
HCM Experience Design Studio ReportSummary HCM Experience Design Studio ReportContent Does anyone know if there is a Subject Area or Table that contains the Rules created in the HCM Experience Design Stud…User_2025-01-23-21-24-21-434 79 views 9 comments 4 points Most recent by HRIS_EC Reporting and Analytics for HCM -
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
HCM Extract Scheduled - Unable to execute previous datesSummary: Hi Everyone, We have scheduled HCM Extracts in Fusion to run daily/weekly based on vendor frequencies. To increment the input parameter - effective date automat…
-
Multiple Proficiency Level records per Competency HCMSummary: We have multiple Proficiency Level rows per Competency. It is not clear which proficiency level in the report is the correct one. We expect the report to show o…
-
Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …Phaneendra Vallapu 225 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
A HR rep user should access all active emp of USA, except Partner and Managing Partner jobs in OTBIPrevious access rights: all employees in USA New access rights to be given: all employees in USA, except Partner and Managing Partner jobs The active employees report is…Shouvika 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… -
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 154 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
Need query to calculate average cost of item.Summary: Need query to calculate average cost of item. Cannot use the item PAC from the PAC item cost table instead wanted to use the inbound transaction for calculating…Mukesh_Kr 166 views 1 comment 0 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM
-
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co… -
Table for BPM Worklist vacation periodNeed a query for BPM Worklist vacation period Rules. Which table stores the below information.Aishwarya Somvanshi 162 views 3 comments 0 points Most recent by Madhavi.Modala Reporting and Analytics for HCM
-
How to connect periods of service with schedule assignmentsSummary: Hello, I am currently trying to report on the work schedule assignments for employees with a past termination date. Would anybody know how to connect the two ta…Dan_Hinsley 31 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to query user details if person_id and party_id are null and no data in per_ldap_users?Summary: Customer has requested a report to display all the usernames along with their first name, last name, email etc. I have encountered a username for whom person_id…Abhi_19 455 views 2 comments 0 points Most recent by Adrian Nae-Oracle Reporting and Analytics for HCM
-
Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Summary Need a SQL query to get the value for Parent Position for the employee's Assignment Position.Content Need a SQL query to get the value for Parent Position for th…JP Chandran 2.5K views 6 comments 0 points Most recent by user3929728 Reporting and Analytics for HCM -
Does anyone know how to find Journal Entries Details in Cost Transactions?Hi Everyone, Does anyone know a query to get Journal Entries Details in Cost Transactions?S.heha.n 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Custom Expense Approval Notification (Preferred Name)Overall Question: How can I use a custom Report/DM for expense report notifications instead of the delivered one? Context: We have a requirement that our Expense Report …Alex Cardenas 51 views 9 comments 0 points Most recent by Alex Cardenas Reporting and Analytics for HCM -
How can we get a list of all Scheduled BIP Reports in Oracle HCM CloudSummary: We are looking for a SQL using which we can get a list of all Scheduled BIP Reports and their recent status Content (please ensure you mask any confidential inf…Mridula Mitra Pal 64 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Address change report to capture old and new valuesSummary: I have not been able to build or find a report that captures address change data. We have been looking for something and was wondering if the community would be…Tammy Hemmingson 305 views 5 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Query to fetch manager hierarchy based on Functional Reports-toSummary: Need help in fetching manager hierarchy based on most recently assigned Functional Reports-to manager. Content (please ensure you mask any confidential informat…Dinky Dudeja 460 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
In OTBI, how to set the filters to fetch data between the last 3 years to the current year?Hello, I'd like to create an analysis to fetch Performance Rating from the last 3 years up to this year based on "- Competencies"."Review End Date". How to set a dynamic…Lise_Rekik_Acc 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Terminated Employee QuerySummary: Can anybody Please share a query where the Terminated Employee should be Pulled in the query on the Day of Termination as Active Record. Content (please ensure …MilanMohanty 1.3K views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
What is the alternative of EXTRACTVALUE function and how to use it?Summary: Hi All, As EXTRACTVALUE function is no longer supported in Oracle SQL, the Data Models designed using EXTRACTVALUE is throwing error. The alternative is suggest…Robinson Ng 102 views 3 comments 0 points Most recent by Jordan Ritchie Reporting and Analytics for HCM
-
sql statement to get the performance document current taskSummary: sql statement to get the performance document current task Content (please ensure you mask any confidential information): Hi Team, I need these below two column…Malak 951 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
Item attribute values by revisionsHello, we are trying to extract an attribute value from ego_item_eff_b in all revisions of a specific item. This means that we want to extract data with the following st…
-
Asking for some tips for these column in OTBI to BIPSummary: Hi there!. May I ask some idea where I could find these columns in https://docs.oracle.com/en/cloud/saas/human-resources/24c/oedmh/hcm-tables-and-views.html#Pri…
-
How to return the max value based on a column?Summary: Content (please ensure you mask any confidential information): I've created a report using Workforce Learning - Learning Records Real Time subject area. The fol…Giuseppe Cannova 71 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM