SQL
Discussion List
-
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 101 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 211 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 361 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 176 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 431 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 61 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 11 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 51 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 51 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 1 view 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 283 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 41 views 3 comments 0 points Most recent by Bhaskar Konar 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 51 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 50 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 101 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 41 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…
-
Need a list of all the BPM Approval Workflows from oracle fusionSummary: Content (required): Do we have any report or query or any front end screen which exports the list of all the BPM Approval Workflows from Oracle Fusion? Version …Vinay Gharge 541 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Report Error - PGA limit (MB) exceededSummary: Report Error - PGA limit (MB) exceeded Content (required): Hi Team, Greetings! We have been getting the error as per the attached file for the report in Product…Parag Hiremath 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio… -
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 61 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
How to fetch the manager and assignment for a userSummary: Hi Experts I'm looking to create a BIP report in Fusion cloud where I can pass the users email address and fetch the manager email address and assignment detail…
-
Prompt does not work in dashboard for different analysis using different subject areasSummary: Content (required): I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real …Maria Xydopoulou 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Changing Fetch First 250001 Rows Only to another valueSummary: How do you change the Fetch First 250001 Rows Only to another value or remove it entirely. Content (required): I need to remove the Fetch First 250001 Rows Only…
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom…