SQL
Discussion List
-
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 84 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 … -
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 211 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 8 views 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 27 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 155 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
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 161 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 39 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 434 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 -
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 59 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 65 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 302 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 446 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 32 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.2K 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 106 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 905 views 3 comments 0 points Most recent by Himavarsha Sathpadi Reporting and Analytics for HCM
-
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 73 views 2 comments 0 points Most recent by Sai Darbha-Oracle Reporting and Analytics for HCM -
Error message: ORA-01898: too many precision specifiersSummary: Error message: ORA-01898: too many precision specifiers Content (please ensure you mask any confidential information): Hi, we have run the SQL query I attached,…Barile Alberto 302 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…
-
OTBI for Model Profile vs Person Profile Competency Gap AnalysisSummary: Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to pull Person Talent Profile Competencies ratings and Model…
-
BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actualSummary BIP Data Model Error: ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4445, maximum: 4000)Content Hi, Can anyone please suggest a…Manisha Chakraborty 127 views 10 comments 0 points Most recent by Viswanadh Reporting and Analytics for HCM
-
need sql query / table name to get system ip and host name Against transactionsSummary: i need to get system details against each transaction. ex: some one created 1 transaction then need to know through which system it got created (system ID , hos…Eswaraiah.chikkala 45 views 1 comment 0 points Most recent by Alexandru Dicu-Oracle Fusion Applications Administration
-
Release 12 HCM OTBI Subject Area descriptionsSummary List of Release 12 HCM OTBI Subject AreasContent This spreadsheet provides the list of HCM OTBI R12 subject areas with descriptions, business questions answered …Raghavendra Raghunath-Oracle 945 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …Shanna Oppenheim 114 views 19 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM