SQL
Discussion List
-
Requirement to have a report that provides details of changes made to UDTSummary: We have a requirement to have a report that provides details of changes made to User defined tables. can anyone please help us on this requirement? Content (ple…Jagadesh S 22 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
Bringing the latest record of the person instead of all records in the OTBI reportHi, I have an Analysis report that contains employee background information, and an employee may log in and leave work more than once, and all records of this person com…Cansel Karasoy 45 views 10 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
SQL to get current and proposed assignment DFF values for notifiationSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Krishna Manoj-Oracle 33 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Worksheet Proration ReportSummary: Worksheet Proration Report Content (please ensure you mask any confidential information): Hi All, Greetings! This is about the reporting requirement including c…Parag Hiremath 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to use a dashboard prompt in Case When query for a fieldSummary: Content (please ensure you mask any confidential information): We have a custom field in OTBI report that uses Person Number as a prompt on a dashboard. Below i…Giuseppe Cannova 33 views 1 comment 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Is it possible to authorize manager-based reports?We added the SQL reports we prepared to the spring board screen and we want to make an authorization here. But is it possible to make it manager-based rather than person…Cansel Karasoy 14 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 121 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM
-
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report …
-
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 15 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
job history reporthi Experts, From the below table I am able to get only the history of past one month. Does anyone now the table names to get the report for more than month ? fusion_ora_…Nivya Mathire 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query for Person Security Profile ReportHi team, we need a person security profile report. can someone help me to provide the query of this if anyone has already gone through this type of requirenment. Thanks!Pushpendra Patle 14 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Extract Development Goal Learning and join with employee goal report (SQL Query)Summary: 21D new learning section - Extract Development Goal Learning and join with employee dev goal report Content (required): Dear All, Would like to know, how to ext…Saadh Abi Vakas 191 views 4 comments 0 points Most recent by Gyanesh Purohit Reporting and Analytics for HCM
-
How to get distinct record for Dimension field in OTBI just like SQL?Summary: Any DISTINCT function that can be used in OTBI to get distinct Dimension record just like SQL ? Content (please ensure you mask any confidential information): A…Pradnya_Pampatwar 413 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
previos salary after correctionSummary: Content (please ensure you mask any confidential information): Hi all, I need to fetch current salary and the previous one, when i do it on the regular way - it…Hadassah Friedman 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys…Valerio Curzi 43 views 4 comments 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM -
How to join/merge/combine two sql queries.Dear Experts, Thanks For Looking into this post. Could you please help out me. I have two queries as shown below, we need to join one together. Query1: UDT_LKP query. Qu…Ravindr-Oracle 32 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Formula to prevent deletion of annual absences with Approved status in the system.I prepared a validation formula so that absences with "Approved "status cannot be updated or deleted in the system. The formula for updating is running and an error mess…Cansel Karasoy 52 views 7 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Value set retrieving lookup meaningSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve by value set the CMP_CWB_CUST_COL_46_LIST lookup meaning entered…Valerio Curzi 12 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
"Absence Calendar Direct Reports Current Month" - How does it work 'normally' (but with custom SQL)?Summary: I was editing the logical SQL of a seeded analysis and noticed that while it appears to have custom logical SQL, it still works just like a normal subject area … -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
Compensation Components amount, date and plan name BI TablesSummary: Content (please ensure you mask any confidential information): Hello experts, we cannot find Compensation Plan Components amounts, effective dates and plan name…Valerio Curzi 23 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
How to know from front end which field is available in which back end table in oracle fusion cloudSummary: Creating a Report on Apprenticeship. Content (please ensure you mask any confidential information): Need to find data in the Oracle tables for Apprenticeship. H…Pradnya_Pampatwar 474 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Bi Publisher - Scheduled Job Failure DetailsSummary Additional detail to ess_request_historyContent Hello, Is it possible to access the log message details for a failed job? I'm familiar with the ess_request_histo…
-
Salary with Currency Euros and not local currencySummary Is there a salary with two currency example local currency and salary in euroContent Hello, I want to view a salary of employee in OTBI in 2 currency. By default…User_I6AXL 60 views 2 comments 0 points Most recent by Neysan Mohajer Reporting and Analytics for HCM -
identifying OTBI reports based on keyword along with the usage historySummary: identifying OTBI reports based on keyword along with the usage history Content (please ensure you mask any confidential information): Hi Team, Greetings! We are…Parag Hiremath 25 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
per_availability_details.get_availability_detailsTeam, We have a requirement to get scheduled hours from work schedules for all the assignments which falls in the period passed in parameter time period start date (:TC_…
-
Chetana Pawar 18 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Manage Legal Reporting Unit Registrations ReportSummary: Manage Legal Reporting Unit Registrations Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I se…Parag Hiremath 2 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Manage Legal Reporting Unit HCM Information ReportSummary: Manage Legal Reporting Unit HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I …Parag Hiremath 11 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM