SQL
Discussion List
-
How to obtain a query between the user and the roles associated with itSummary: Roles associated with a user Content (required): Hi team, We need to obtain the list of users and the associated roles. I have reviewed some tables but I cannot…SERGIO BARRETO 122 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Create analysis using logical SQL error?Summary: Invalid SQL Identifier: fusion.per_allocated_checklists ac. error Content (required): Hi All, We are looking at building OTBI analyses for identifying allocated…William_Johnson 176 views 3 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 56 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Manager ID population logic using Peoplesoft PS_JOB dataSummary: Hi team, We have a Oracle DWH built using Peoplesoft as a source system. One of the key requirement is to populate Manager Lev1, Manager Lev2, Manager Lev3 usin…Shaik Gousimiya-Oracle 43 views 4 comments 1 point Most recent by Shaik Gousimiya-Oracle Reporting and Analytics for HCM -
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 818 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
How to fetch Contract Type Description into OTBI Analysis (Work Assignment Real Time)?Summary: We have different analysis based on subject area Workforce Management -Work Assignment Real Time, and we need to add an analysis per contract type Description. … -
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the…
-
Inability to view the National ID information in the report by the employee,how should we proceed?I have an excel report that I prepared with BI publisher, and this report contains the National ID information I got from the PER_NATIONAL_IDENTIFIERS table. But the use…Cansel Karasoy 288 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Getting an error while running a report.Summary: Hi Team, I am getting an error while running a report, please see the attached screenshot. Could you please let me know the rout causes. Thank you Content (requ…
-
how to report on job offers that are pending for approvals using workflow tablesSummary: we need to cover and track all job offers that are pending for approvals and who is the next approvers! I need to create a report covering this topic.. for the …Ayoub AFRASS 94 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 202 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
Report to get the list of employees with multiple active relationshipsSummary: Report to get the list of employees with multiple active relationships Content (required): Hi Team, Greetings! With Global Transfer- there are some cases observ…Parag Hiremath 273 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula …User_2025-02-01-07-38-26-148 163 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM -
Bursting Query table from the reportsSummary: Bursting Query table from the reports Content (required): Hi Team, Greetings! Is there any table(s) which holds the queries included in the bursting query in th…Parag Hiremath 334 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
Best practice for reporting on incomplete allocated checklists?Summary: Hi All, Does anyone have any "best practices" for reporting on incomplete allocated checklists? We have a business case to report on number of incomplete checkl…William_Johnson 62 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Extract information about the Job Board eQuest in ORCSummary: Content (required): Hello everyone, We are having problems extracting information regarding the publication of a job requisition. In particular, in addition to …Gerardo Peluso 14 views 0 comments 0 points Started by Gerardo Peluso Reporting and Analytics for HCM
-
CAGR(Compound Annual Growth Rate) Calculation in OTBISummary: Creating an OTBI analysis to calculate CAGR of the joiners in my org in last 3 years. Content (required): I am trying to calculate CAGR of the joiners in my org…Dinky Dudeja 52 views 2 comments 0 points Most recent by Dinky Dudeja Reporting and Analytics for HCM
-
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega…Valerio Curzi 52 views 6 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …Valerio Curzi 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Function to convert accented characters to their plain ascii equivalents in BI reportSummary: Function to convert accented characters to their plain ascii equivalents in BI report Content (required): Function to convert accented characters to their plain…
-
Error Code U9KP7Q94Summary: Path not found - Check input path entered Error Codes: U9KP7Q94 Content (required): Hi All, Has anyone run into this problem before? We archived and unarchived …William_Johnson 235 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Reading SQL Error CodesSummary: Hi All, Does anyone have any documentation/point me in the direction of resources that would help us read standard SQL error codes when working in OTBI? Include…William_Johnson 33 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
From which table can I check the scheduled report job?Hi, Which hcm table can I query to view the history of my scheduled report? I want to get the last run date of the report job from this table. I will be grateful if you …Cansel Karasoy 793 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 52 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
SQL prefix for 'As of' Date getting ADFS errorContent Hello, I have a sql prefix set as SET VARIABLE PARAM_EFFECTIVE_DATE = '@{AsOfDate}'; I'm all of a sudden getting this error: State: HY000. Code: 77031. [nQSError…Susan Anderson 51 views 2 comments 0 points Most recent by Harpreet Shergill Oracle Reporting and Analytics for HCM -
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 103 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate automatically incremented check numbers for "Generate Check Payments" processExperts, Request your help here. Can we add custom parameters in a flow pattern copied from "Generate Check Payments"? We need to retrieve the last generated check numbe…Aloka Bhattacharya 42 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
How to link custom button in homepage to BI ReportSummary: Content (required): Hello experts, I've created a custom button in homepage under My Client Groups tab. This button should be linked to a custom BI Report saved…