SQL
Discussion List
-
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 262 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 37 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 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 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 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 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 506 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 291 views 2 comments 0 points Most recent by Bonnie Lafferty 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 22 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 65 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…
-
Delegation Approval Query /TableSummary Delegation Approval Query /TableContent HI , i have a requirement to create BI/OTBI report for delegation approvals. Can any one please share the table/query whi…
-
Handling Invalid Dates in a CASE statement in OTBISummary: How do you replace 00--0 with an actual date in OTBI? Getting error with CASE statement below Content (required): My CASE statement is coming back with an error…
-
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 76 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 31 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to use FND Archive tables to get all HCM Transaction details of WorkflowSummary Need to report, both active , recent completed and histroical Workflow transaction details.Content Hi I am currently using this tables to get Active and recently…User_2025-01-30-23-14-03-928 1.4K views 4 comments 0 points Most recent by User_X6V3T Reporting and Analytics for HCM -
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…minati_behera-Oracle 51 views 3 comments 0 points Most recent by minati_behera-Oracle Reporting and Analytics for HCM
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard…Valerio Curzi 61 views 9 comments 0 points Most recent by DavidBlake Reporting and Analytics for HCM