SQL
Discussion List
-
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 281 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 181 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 176 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 167 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 32 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 555 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.6K 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 61 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 322 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 493 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 …Milan_Mohanty 1.5K 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 101 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 1.1K 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 81 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 321 views 1 comment 0 points Most recent by Fazal Subhan Reporting and Analytics for HCM
-
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 151 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 41 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 943 views 11 comments 10 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM