SQL
Discussion List
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 242 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
Report to fetch Hire Dates in a letterSummary Not able to compare among three date in BI PublisherContent I have developed a BI Report to extract salary of a person. And after this developed RTF template in …User_2025-01-29-18-45-19-617 39 views 2 comments 0 points Most recent by User_2025-01-29-18-45-19-617 Reporting and Analytics for HCM -
How does per_ldap_users table get populated?Summary How does per_ldap_users table get populated?Content Two user accounts were created manually and assigned roles. I see that both of them are available in PER_USER…User_2025-01-25-04-02-13-126 113 views 3 comments 1 point Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Query to get non person account detailsSummary Query to get non person account detailsContent Using the below query to get the non person account details but for few users the first name, lastname and email a…SuryaMuralidharan 96 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
As-of-Date Doesn't work anymoreSummary As of date variable in OTBI doesn't workContent Hi, Since the last release, the feature of putting variable in OTBI analysis for effective date doesn't work. The…
-
Identify ALPHABETS in STRINGS in OTBIContent Hi All, We have an report where we need to identify ALPHABETS from a values coming up in the report as a filter criteria. For examples, pick all the Account numb…Vibha Pandey - Oracle 33 views 4 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
Unable to identify manage element screen under settlement date column in element entry tableSummary Unable to identify manage element screen under settlement date column in element entry tableContent Attached application screen shot from Manage element entry an…
-
Query to get active and active uses in the systemSummary Query to get active and active uses in the systemContent Query to get active and active uses in the system.We have Crosse verified the per_users table but didt g…Koteswararao Yenikepalli 78 views 3 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Query/Table to view BPM commentsSummary Query/Table to view BPM commentsContent Hello All, We have requirement to capture the Approver comments in a report. Let us know if you are aware of table/query … -
BI Publisher GUI Outer Join QueryContent Hi, We have created a query which is comprised of 3 data sets.They are joined by the elements within the data models. Background: We used to have this pending ap…User_KOLMZ 36 views 3 comments 0 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM -
Pixel perfect PDF reportsSummary Pixel perfect PDF reportsContent We need some inputs on best practices / recommendations for developing pixel perfect PDF reports. Context: The implementation sc…Mirza Nasir Beg -Oracle 43 views 0 comments 0 points Most recent by Mirza Nasir Beg -Oracle Reporting and Analytics for SCM
-
Percentage of columnSummary Need to calculate a percentage off Median salary by various attributesContent Attached sample. I can get the first 4 columns. However, I can't come up with the r…Mike Borghoff 59 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculations - level downContent I need to build three charts that hinge off one another: 1. Average or Median salary by Gender/BU/Management level. 2. From the chart above, I need to just get a…Mike Borghoff 41 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
BIP report and sql injectionContent Hello Experts, While creating BIP reports in the Oracle fusion environment , do we need to consider Sql injection? If we have a BIP report that takes input value…User_2025-01-30-00-14-06-021 88 views 2 comments 2 points Most recent by User_2025-01-22-18-30-18-571 Reporting and Analytics for HCM
-
OTBI - Manager person number as the main keySummary Is it possible to refer the manager person number as the primary key in OTBIContent Hi, Can I make a report in OTBI so all the fields (assignment status, job, de…Yaniv 67 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BIP Report to view the UCM file and its contentsSummary BIP Report to view the UCM file and its contentsContent Hello, In PROD we can't give UCM access to developers due to SOX compliance. Is there any way we can acce…
-
HR_LOOKUPS vs HCM_LOOKUPS ViewSummary Need to know the difference between HR Lookup and HCM Lookup viewContent Can anyone let me know the difference between HR Lookup and HCM Lookup view. From view S…Parthiban Vaithiyanathan 228 views 1 comment 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
BI Publisher model to find stuck transactions in HCMSummary Has anyone a data model that will find stuck transactions within the HCM moduleContent Has anyone developed a data model that will find all of the stuck transact… -
Audit Report using BIPSummary Looking for a custom BIP report query for Audit purpose. #AuditContent Hi, We enabled the Audit for multiple products using the task 'Manage Audit Policies' and …MadhuVitta 240 views 2 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM
-
Customization on the AP invoiceSummary Customization on the AP invoiceContent Is it possible to do a customization on the AP invoice to validate certain fields and making some fields required based on…Mohammad Alhindawi 46 views 1 comment 2 points Most recent by User_2025-02-04-07-16-12-621 Reporting and Analytics for SCM
-
Error when consulting a report with parameters of start date and end dateSummary Error when consulting a report with parameters of start date and end dateContent Hi everyone, I have created a report that must show information according to two…Cesar Tepetla Corte 20 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
TopicSummary Ora TestContent Testing topic commVictor Modoran 30 views 1 comment 0 points Most recent by Mihai Uruc Reporting and Analytics for HCM
-
Drill back using SQL query from GL_JE_LINES to PAY_COSTS tableContent We are building a report to get the related Pay Cost data from the GL Journals that gets created after transferred to GL. We have few documents for EBS which men…Satish Kumar-21650 69 views 0 comments 0 points Most recent by Satish Kumar-21650 Reporting and Analytics for HCM -
SQL to get Level 1,2,3,4... for an employee?Content What is the SQL (Not analysis) to get the different department levels for an employee?King Jack 40 views 3 comments 1 point Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Using Max function for bank account highest process orderSummary Issue with using MAX for selecting highest processing order (Priority) within PAY_PERSON_PAY_METHODS_FContent Hi, We are setting up an extract of bank accounts w…User_2025-01-30-03-54-32-528 47 views 7 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
probation confirmation Letter automation in oracle fusion HCMSummary Probation Confirmation letter Automation in Oracle fusion HCMContent Hi Team, I have to create the bursting report, in which whenever probation status for an emp…nitin Sharma 596 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Significance of default Data Source 'AuditDB' in BI PublisherContent Hello What is the Significance of default Data Source 'AuditDB' in BI Publisher while creating the new data set. My Oracle Cloud Application is: 19A (11.13.19.01…Janardhana Kondaveeti 20 views 6 comments 1 point Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Row disappearing in the output of RTF when the XML group tag is not thereContent Hi All, I have built one RTF template and have 5 fixed absence plans. If any of the plans is not there then the row is not appearing in the output file. My requi…