SQL
Discussion List
-
HCM Extract schedule SQLSummary: Need SQL to get HCM Extract schedule end date Content (required): Need SQL to get HCM Extract schedule end date Version (include the version you are using, if a… -
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 103 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
RestAPI -for HCMSummary: I have to extract organization information from HCM using RestAPI but I struggle to find the "organization tree" Could someone tell me how to get an overview of… -
Reporting on Guided Learning UsageContent Hello, This might be a long shot, but our business is trying to report on how often employee's are using guided learning. Are there any tables that store the usa…User_2025-01-31-00-25-12-234 26 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Position Details with Grade Minimum and MaximumSummary: I am trying to get a report of all active positions, their grades and pull in grade min and max. I don't want to base this off of worker assignment since I want…Jennifer Wiggs 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Invoice Line DFFsSummary: How to associate invoice line dff fields back to the invoice line via sql Content (required): The table PJB_BILLING_EVENTS holds attribute_number1 field for inv…dwright 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Summary How to Display BIP Report Output file with Date stamp like (XXTest_26-JUN-21.txt)Content Hi Experts, How to Display BIP Report Output file with Data stamp. Examp…Bala Kasineedi 83 views 6 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for HCM
-
How to fetch 'Y' for Managers having direct reportee and 'N' for Managers not h'ing direct reportsSummary: Sql to get 'Y' for the Managers having direct reportee and 'N' for the Managers not having direct reportees in oracle fusion hcm. Please suggest. Content (requi…User_ENPUR 201 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL help needed to get the effective start date of employee's assignment status changeSummary SQL help for determining effective start dateContent Hi All, Really hoping someone can help me out. I got really close on my query but I am missing something whe…User_2025-02-04-08-51-08-912 563 views 2 comments 0 points Most recent by User_XHDBT Reporting and Analytics for HCM
-
SQL query for balance groups and definitionsContent Hi, I need to write a SQL query to extract balance groups and the balance definitions contained within each group. I can see the balance groups are held in PAY_B…
-
Use TIMESTAMPADD in SQL PrefixSummary What is the correct syntax for using TIMESTAMPADD in a SQL prefix without using a presentation variable prompt?Content Hello - I am creating an analysis that wil…User_2025-02-08-04-27-03-855 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in HContent Hello, I am trying to use OTBI to look at an employee's assignment history and derive new calculated fields for the following: * Grade Effective Start Date and t…RebeccaAult1799 90 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 97 views 5 comments 0 points Most recent by Sandeep19rm Reporting and Analytics for HCM
-
SQL - Job Table historySummary We want to pull all rows from the job code table and have the following SQL. The query pulls several rows for the same effective start date. Any suggestions? Tha…Mike Borghoff 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Please share SQL to return only employee person type whose termination approvals has been acceptedSummary Please share SQL to return only employee person type whose termination approvals has been acceptedContent Hi All, Please share SQL to return only employee person… -
Add 45 day to Benefit Program Date in OTBI AnalysisSummary Add 45 days to Benefit Program Date in in OTBI Analysis filterContent Hello, I need to add a filter to the OTBI analysis. The filter should add 45 days to the Be…GauravGupta39 22 views 6 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM
-
NEW HIRE(FAST,PRESENT,FUTURE DATED EMPLOYEES) ANNOUNCEMENTSummary Developed BIP Report on ORACLE FUSION HCM we are getting data for current hire employees only, Unable to get future dated employeesContent Hi ALL, I have develop…
-
Create a report that shows the actual date when the assignment status changed with the Action ReasonSummary Actual date and reason when an assignment status changesContent Hi All, I hope someone is able to help me with a SQL that I am trying to build. I have several re…User_2025-02-04-08-51-08-912 229 views 5 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Dashboard prompts using sql querySummary Need to create dashboard prompts using sql query as the relevant subject areas for prompt data is not availableContent Hi Experts, I have a requirement to have p…Anirudh Udupa 9 views 3 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM
-
Need help on Logical SQL with UnionContent Hi Experts, I am trying to identify the New Hire's/ Exits and TEC changes using Logical SQL. Both parts of the sql works , but when UNION is applied it breaks. A…User_2025-01-30-00-14-06-021 109 views 3 comments 0 points Most recent by SM-Oracle Reporting and Analytics for HCM
-
How to replace DATA_CACHE columns in 21B with XML_DATa_CACHESummary How to replace DATA_CACHE columns in 21B with XML_DATa_CACHEContent Hello, Can anyone help me replace DATA_CACHE columns in 21B with XML_DATa_CACHE, in BI report…Varkey George-Oracle 41 views 4 comments 0 points Most recent by VibhaSorte Reporting and Analytics for HCM
-
Report that pulls out the extract runSummary Do you have a report ready?Content Hello, I need to develop a report that pulls out the extract run in a specific date. Do you have something ready? Thanks Nicol…
-
LTRIM Function in eText templateSummary LTRIM Function in eText templateContent Hi ExpertsSelect LTRIM('0012345', '0') from dual; is working as expected and result '12345' in BI Publisher Data Model. B… -
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 27 views 0 comments 0 points Most recent by Pavel Buynitsky-Oracle Reporting and Analytics for HCM
-
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 89 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 48 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 461 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106 Reporting and Analytics for HCM
-
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing…User_2025-02-04-08-51-08-912 1.1K views 6 comments 3 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM