SQL
Discussion List
-
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 13 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 11 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 193 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 428 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 1 view 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 42 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 33 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 11 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 21 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 478 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 21 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 25 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 1 view 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 12 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Tables with employee cost center, manager, assignment, and job title historySummary: We need to write a query to report on employee cost center, manager, assignment, and job title history. So far we're not finding the data we need in the tables …nmdp-andrew 492 views 3 comments 2 points Most recent by nmdp-andrew Reporting and Analytics for HCM -
Onboarding Report Jobs failingSummary: we have 15days and 30days reports but when we schedule the report it failing and even self also failed . we are used data parameters duration of 16 months . Det…AjayKumar Maddipati 35 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Formatting issues in excel template for BIP report (formatted as number in data model but is text)Summary: So, we have a BIP report which details the amount for various pay elements, the element name is hard coded in sub select clauses so we can control the column or…
-
OPSS Audit Report BIP TablesSummary: What are the Tables used in the Oracle Platform Security Services (OPSS) Audit Reports? Need for a BIP Report Content (required): Hello everyone, I have a repor…Tom John Bontoyan 33 views 2 comments 1 point Most recent by Adrian Dogeanu-Support-Oracle Reporting and Analytics for HCM
-
I need to retrieve previous year performance ratings , which tables can I useSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…PranayBhargava13 1 view 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Logical SQL with NULL resultsSummary: I'd like a Performance Tile based on a Logical SQL query to show Zero when no results are found i.e. there is a null result Content (please ensure you mask any …Richard Kemp-Eyre 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM