SQL
Discussion List
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal… -
SQL for Payroll Element Calculation FactorsSummary: Hi all, does anyone have any SQL that extracts element calculation factors? Element Name, Calculation Step, Calculation Value Definition, Range Values etc… Than…Jon Taylor 114 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 21 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
BIP Report Assistance - Transaction Console with Approvers (Job Requisition)Summary: Looking for assistance with creating a BIP report to audit pending actions from the Transaction Console. I found most of the information needed in the following…
-
HR_GENERAL.DECODE_LOOKUP not returning valueSummary: HR_GENERAL.DECODE_LOOKUP function is used in the BIP report to fetch the meaning of the lookup code passed. Content (required): HR_GENERAL.DECODE_LOOKUP functio…Meenakshi K 1.3K views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
We have long service award OTBI Report but need to show in performance tile viewSummary: Hi team, we have long service award OTBI Report but need to show in performance tile view chart by if we click the 5 years then need to show 5 years completed c…AjayKumar Maddipati 81 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to get the self service url from course numberSummary: I have requirement to fetch "Self Service URL" which pops when we click Course Number in the Course Page. Sample URL : "https://fa-xxxx-dev3-saasfaprod1.fa.ocs.…Amrita_Pritam_Nayak 11 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
We are taken the backup of BI report before cloning but now unable to edit the reportSummary: Hi Team, We are taken the backup of BI report before cloning but now unable to edit the report and I'm able to get below error ? PFA. Thanks, Ajay Content (plea…AjayKumar Maddipati 11 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to edit the NewHireReport data model to include the SecurityFinal tableSummary: In the AssignmentChangeReport datamodel (EmploymentUpdateProcess), there is a table called "SecruityFinal". This table provides the following data (see below) o…
-
Looking for query to fatch the specific security profileSummary: Content (required): Hi Expert, We are looking for a SQL query to get the list of roles that are attached with a specific security profile like a document securi… -
Report to get active staff as end of actual month vs their situation in the previous monthSummary: I want to create a BI Publisher report each month that allows me to track the situation of each employee if there is any changes between end of actual month vs … -
How to connect Person Table with Audit table - HWM_TM_AUDITSSummary: Hi, I am trying to create a Timecard Audit BI report. Need to connect Person table Per_all_people_f with HWM_TM_AUDITS table. Not finding a common ground betwee…Abhishek Bhaskar 81 views 2 comments 0 points Most recent by Abhishek Bhaskar Reporting and Analytics for HCM -
Can we change the Date format to Text in OTBISummary Can we change the Date format to Text in OTBIContent Hi I would like to know to know if we can use any of the functions in OTBI to change the date format to Text…User_2025-01-30-21-52-52-008 285 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
REQUISITION_POSTED State Code Giving Strange ResultsHello, I have a need to find the most recent date a requisition was posted and unposted. For compliance purposes, we need to ensure our jobs are being posted for a minim… -
New/Pending approval/requires approval goals in the tableContent Hi Team, We were able to get the details of the new/pending approval/requires approval from the table HRG_GOALS . In 20B we are not able to find the same. Is the…Nivya Mathire 145 views 8 comments 0 points Most recent by HasnatHRT Reporting and Analytics for HCM -
Aor QuerySummary: Hi Expert, I have to add an AoR query in my almost five different BI reports. As of now, it shows all data, however, we need to reduce the results based on the …
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 32 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM
-
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th… -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 585 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…alliebaker 61 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
SQL with statement window function errorHello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found wh…alliebaker 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
Information about who rejected the rejected absence recordsHi, I need to add information about who rejected the rejected absence records to my report. When I use the 'fa_fusion_soainfra.wftask table', I cannot access it for reje…Cansel Karasoy 11 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
need a query to fetch negotiation response details with price break informationSummary: Need a sql query to pull negotiation response details with price break information Content (please ensure you mask any confidential information): Version (inclu…SoumyaMukherjee03 432 views 1 comment 0 points Most recent by SoumyaMukherjee03 Reporting and Analytics for SCM
-
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Any one help me on department change report old and new departmentsSummary: HI Team, could you please help me on we need old and new changed department report. Thanks, Ajay Content (please ensure you mask any confidential information): …AjayKumar Maddipati 101 views 20 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM