SQL
Discussion List
-
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 154 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Fast formula - Oracle functionsContent Hi guys, I need to export a value from lookup tables through fast formula. Usually, I used the get_lookup_meaning function but this time I don't need the meaning…User_2025-01-28-21-18-09-074 115 views 1 comment 0 points Most recent by Pragati-Oracle Reporting and Analytics for HCM -
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 36 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM
-
Unable to get the BIP DataModel With DataCache References in Diagnostics ResultsContent Hello All, As per the oracle KM note 'Fusion Global HR: BIP DataModel With DataCache References Diagnostics Resulting Failure: null (Doc ID 2754842.1)', i tried …Janardhana Kondaveeti 32 views 12 comments 2 points Most recent by Peng Yang Reporting and Analytics for HCM -
Schedule Event Trigger in Data Model Errors immediately when ScheduledSummary: I have created an event trigger in a data model, which I have done before without issue, but for this one as soon as I schedule the report that uses this data m… -
workforce structure change reporttrying to build a report that captures changes on the department table. We maintain history on our departments, but would like to be able to report on it. If we do the r…Mike Borghoff 81 views 4 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM -
Subject Area - Department Hierarchy(Department Levels) coming up as blank columnsSummary: Subject Area - Department Hierarchy(Department Levels) coming up as blank columns Content (required): Hi! I'm trying to create a subject area analysis that disp…User_2025-02-11-21-40-21-159 147 views 5 comments 1 point Most recent by User_2025-02-11-21-40-21-159 Reporting and Analytics for HCM
-
How to use one or the other parameter in a SQL querySummary: I have a query that I built that is supposed to either pull in the list of terminated employees based on the date range entered OR a list of terminated employee…User_2025-02-04-08-51-08-912 56 views 3 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
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 90 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 204 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 581 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 93 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 100 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 45 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 23 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 241 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 13 views 3 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM