SQL
Discussion List
-
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 152 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Direct Report Headcount in OTBI?Summary Are there any fields in OTBI which can pull a manager's direct reports / headcount, or otherwise indicate that they are a manager?Content Are there any fields in…Monica Fundak 51 views 3 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 56 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM
-
Table for Attachments under position profileContent Hi, Can someone help me with the table contains the attachment information under position profile? Regards, NivyaNivya Mathire 88 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
CONVERT FF to UDT creationContent hello Experts, I would like to ask for your assistance in converting fast formula - XX_RECOMMENDED_MAX_QUARTILE_FF to a user defined table. This FF is used in BP…
-
Delegated Roles TableSummary Delegated Roles TableContent Hi All, Is there any other table which stores delegated roles details? I am able to find the table PER_DELEGATED_ROLES but this repo…nitin Sharma 12 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM
-
Latest Assignment ChangeContent Hello, I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've u…User_2025-01-31-00-25-12-234 131 views 8 comments 0 points Most recent by Ahmed AZA Reporting and Analytics for HCM
-
Performance goals report - which should iclude all stages of goal details (Approved,Saved,Sumitted)Summary Need to develop a BI report for the Goal Plan Goals which are in saved state and submitted state and approved state.Content When employee runs the report , the r…User_2025-01-30-17-37-30-647 81 views 5 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
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 219 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 213 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 63 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 87 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 324 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