SQL
Discussion List
-
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 15 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL? -
"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 … -
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 19 views 1 comment 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM -
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 22 views 3 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM -
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…
-
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…
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 19 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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 26 views 7 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Can I add a response button to BIP bursting emails?Summary: We need to send emails to external candidates and get their responses. Is it possible to add a response button to emails? TYIA
-
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…
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 18 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…Jaeyshree Kumaran Kalpana 836 views 9 comments 1 point Most recent by Srividhya Ramamurthy Reporting and Analytics for HCM
-
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… -
OTBI - Calculate age in years and monthsSummary How to calculate the age in years and months?Content Hi, In OTBI I want to create a column which present the full age of the employee, for example 43.12 (means 4…
-
Information of the logged in userCan I detect which operating system or device the user logging in to the system is using?
-
Displaying different sections in mobile app and web app on dashboardHello, in the dashboard I have prepared, I want some sections to appear only in the web application. I want some of them to appear only in the mobile application. Is thi…
-
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle 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 15 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i… -
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 14 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 …
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 54 views 8 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 23 views 0 comments 1 point Started by Parag Hiremath Reporting and Analytics for HCM
-
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 24 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Resource mapping Report: feasibility to append the Job Requisition URL with external Site detailsIs there any feasibility to append the Job Requisition URL with the external site name details for tracking the candidate flow from the source website.(E.G; LinkedIn, In…Suneetha Narisipuram 11 views 0 comments 0 points Started by Suneetha Narisipuram Reporting and Analytics for HCM
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…