SQL
Discussion List
-
Need the logic to convert English to Chinese language in SQLSummary Need the logic to convert English to Chinese language in SQLContent Hi Team, I have a BI(SQL) report and some of the fields like 'Legal Entity, BU, some EIT fiel…User_2025-02-01-03-43-13-079 96 views 4 comments 0 points Most recent by User_2025-02-01-03-43-13-079 Reporting and Analytics for HCM -
Table in Data Source: AuditViewDB where it contains the names and employee number of employees.Summary I'm currently using the Data Source: AuditViewDB for some audit purpose. I need the table from that data source that contains the names and employee number of em…Mark kristan De los Reyes 39 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Convert UCM image into base64Content Hi, Can someone tell me how to convert UCM image to base64 in Fusion? or how do I call the UCM image into rtf template? Reference : Oracle Fusion BI Publisher: H…Nivya Mathire 206 views 4 comments 1 point Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Anniversary ReportSummary Anniversary ReportContent Hi ALL, Need help in creating a report which populate employee who will complete there 1 year anniversary with company tomorrow. ex. Em…User_2025-02-07-19-03-14-525 103 views 16 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
End date for scheduled processSummary Need to be able to report on end date used when process scheduledContent Hi, I need to create a report that will show the end date of the schedule created for a … -
Report for overtime hours and regular hoursContent We have a requirement to develop a SQL report based on Over Time hours and Regular hours capturing from a third party device. Suppose we are not creating any pay…User_2025-01-28-21-18-43-496 206 views 3 comments 0 points Most recent by Sudakar Babu Sunkesula Reporting and Analytics for HCM
-
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar…
-
Calculation Card Details - Table InformationSummary Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_FContent Hello, I was looking into fetching the Pension Auto Enrollment information from…
-
Multi-selection parameter is not working for more than 1000 LOVsContent Hi All, I am using position name as parameter in my BI report. Syntax for using multi-selection parameter is- POS.NAME IN (:P_POSITION) OR 'All' IN (:P_POSITION …User_2025-02-06-14-37-05-233 58 views 8 comments 1 point Most recent by MaartenDIF Reporting and Analytics for HCM
-
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My… -
Report for MFA Multi factor authenticationSummary Report to identify which employees have activated Multi factor authenticationContent Hi Do you know if there is any subject area or database table where I can se…Rogelio H 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Logical SQL Reports and Report HeadingsSummary Logical SQL Reports and Report HeadingsContent Hi, I have created a report using Logical SQL and was wondering if it is possible to include a user friendly Colum…Karen Waddell 32 views 7 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 39 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…User_2025-02-07-19-03-14-525 61 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
OTBI Agent Email Analysis Run As Of Date Derived by SQLSummary Trying to setup existing 'Point in Time' analysis with AsOfDate Parameter as automated agent that uses SQL to derive the last day of the prior month at runtimeCo…James Hoffmann 85 views 13 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
How can I filter on column and not a measures in OTBISummary Filter in a sample column and not a measures how can i do it??????Content Hello, I want to transform a simple column in otbi into a measures to create a filter :…User_I6AXL 39 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fusion HCM OTBI/BI report usage analytics?Summary How to get OTBI/BI report usage analytics?Content Is it possible to get OTBI or BI report usage analytics? VIZ., input - Report Name Output - list of users who r…User_2025-01-25-04-02-13-126 326 views 24 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Non Prod Last refresh (P2T) dateSummary Non Prod Last refresh (P2T) dateContent Hello All, Is there any way we can find the Non Prod environment last refresh (P2T) date by using a query/table or profil… -
Question marks in attributes causing filtering troubleContent Hello Experts, We've encountered a situation where a course has been setup in our learning module with a question mark at the end. We've found that when we try t…Rob F 12 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I get Job Change Date?Summary Sending data to LMS need to send Date a job changesContent Hello Everyone, I am having a business case where we as a company need to send Job start date and when…User_2025-02-10-15-06-52-222 69 views 4 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …User_2025-02-10-16-28-01-402 665 views 2 comments 0 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna 53 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…User_2025-02-10-16-28-01-402 1K views 2 comments 0 points Most recent by User_2025-02-06-20-13-56-572 Reporting and Analytics for HCM
-
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 115 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
How to exctract the AddressId in OTBI (PersonAddress)?Content Hello experts, is there a way to extract the Person Address Id in OTBI? In case, do you have the SQL Query to extract the AddressId? Thanks in advance for your t…Valerio Curzi 34 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 99 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Is it possible to write a validation query against excel/csv data source in data model?Content I have created 2 data sets using excel and csv as data source. I want to write basic query to validate data from these files. Is it possible to validate excel da…Samir Patro 40 views 4 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Duplicate Manager Data Integrity ReportSummary Duplicate Manager Data Integrity Report not workingContent Hi All, We have a data integrity report that we would like some help troubleshooting. This report is i…User_2025-02-07-16-42-37-187 31 views 4 comments 0 points Most recent by User_2025-02-07-16-42-37-187 Reporting and Analytics for HCM