Global HR
Discussion List
-
What audit reports are available for HCM configuration?Summary: We would like to know the types of audit reports available for HCM modules (ORC, Core HR, Compensation, and Talent) that are configuration and not employee leve… -
Need suggestions / opinions for sending termed records for xx days in reports and extracts.Summary: Hi Experts, we have a requirement to send all active records and termed records that were termed in the last 10 days. please note this is problem encountered pr…Jithin Mathews 21 views 4 comments 0 points Most recent by Jithin Mathews Reporting and Analytics for HCM
-
OTBI : Line Managers not retrieved in Workforce Management - Workforce Trend Real Time Subject AreaSummary: We are creating a dashboard which shows attrition rate based on different aspects like country, departments, etc. We were fetching the query from OTBI analysis …Rohankumar Patel 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not able to extract the 'Overtime Status' - Exempt or Non-exempt from systemSummary: This is regarding HCM Job legislative info not reflecting in the backend tables in Dev7 (also noticed in Test instance). While working on a requirement that nee…
-
Facing the issue in below BI report query error is single row subquery returns more than one rowSummary: HI Team, We have report I'm facing the issue when i run the report or scheduled the report i'm getting below error but I'm unable to find the issue ? ERROR : OR…AjayKumar Maddipati 41 views 7 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
Creating a Report in OTBI for New Hires, Name changes, LOAs, and TerminationsSummary: Hello, I need to create a report in OTBI for New Hires, Name changes, LOAs, and Terminations but I am unsure if this can all be on one report or if I would need…Latia 72 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify a merged person record in the Oracle Fusion HCM Cloud databaseSummary: When querying the database for person records, I want to exclude merged records from the output. How do I identify merged records in the table? Content (require…
-
We need department and cost center details with effective state date in BI or OTBISummary: Hi Team, we need department and cost center details with effective state date. i tried in worker assignemnet real time but no effective start date. only two clo…AjayKumar Maddipati 31 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to get values entered in termination transaction details?Summary: How to get values entered in termination transaction details? Content (required): Hi Team, Greetings! Termination transaction initiated by the manager or HR Sup…Parag Hiremath 262 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to identify when a Job Code was last assignedSummary: We are working on cleaning up job codes. There are many active job codes and we don't want to inactivate them until we know when the last time the job was assig…
-
Correct sorting of report in sql queryHi, I want to sort the numbered numbers in the sql query I wrote. but when I want it to be sorted as 1,2,3.., it is sorted like 1,10,11. I'm having trouble with two-digi…Cansel Karasoy 22 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Is there a way to report on changes made an employee makes to their address or number?Summary: Is there a way to report on changes an employee made makes to their address or number? Content (required): Is there a way to report on changes an employee makes…PrJohns-Oracle 21 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Query to get Transactional dataSummary: Hi Everyone, Currently, I'm working on a report, the requirement of this report is to pull the employee's current and proposed data. like the employee transferr…
-
Full-Time equivalent is not working within USING clause of a FILTER operator in OTBII have created an OTBI report using Subject area - Workforce Management - Employee Assignment real time and Full-Time equivalent i am fetching from the "Worker Assignmen…Utkarsh M 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Management - Worker Assignment Real Time - position Management Business UnitSummary: Which fusion table can provide value for OTBI field "Workforce Management - Worker Assignment Real Time - position Management Business Unit" ? Need to create a …Rishita 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to use "Replace" function in BIP Report Excel TemplateSummary How to use "Replace" function in BIP Report Excel TemplateContent Hi Experts, How to use "Replace" function in BIP Report Excel Template. Could you please sugges…Bala Kasineedi 308 views 11 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
Embed BIP report on Employment Info Responsive UISummary: Embed BIP report on Employment Info Responsive UI Content (required): Developed a BIP report and used Assignment_id as parameter. We have placed it as Hyperlink…Kammasavala Ramadevi 101 views 3 comments 0 points Most recent by Kammasavala Ramadevi Reporting and Analytics for HCM
-
NULL value creating duplicates in UNION queryAfter adding NULL value to some columns , it is showing Duplicates in UNION query. Like: AUTHORIZATIONCODE, JOBDESCRIPTIONDATE, JOBEVALUATIONDATE.Dona Das-Oracle 11 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
How to call a BI report when email id is created?Summary: How to call a BI report when email id is created? Content (required): Hi All, We got a requirement to send notifications to new joiners when their work email is…Venkatesan 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Reporting the termination screenHi, When I terminate the employee from the My Client Groups>>Termination>> screen, I want to report the part that opens in the screenshot below. I need a sql query for t…Cansel Karasoy 21 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
Report to pull out the date since a position is vacantI have a business requirement to pull out the date since when a position is vacant. Is there a way to pull this out or does someone have a report that i can plug and pla…Girish Bhatia 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get the position level of a position from the top using OTBISummary: We have a requirement to get the position level of a position from the top. eg: CEO is the top position and should be at level 1, 2 directors reporting to CEO s… -
Entity Relationship Diagram between ALL PVOs in Fusion HCM ModulesSummary: Entity Relationship Diagram between ALL PVOs in Fusion HCM Modules Content (required): Dear all - can we get ERDs for All PVOs from different HCM Modules from O…Nilanjan Biswas-Oracle 827 views 2 comments 4 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM -
Unable to restrict results with workschedule filters when it is blank or non primarySummary: Issue: There are multiple subject areas combined together to generate results which is embedded in dashboard. A new change has been requested to include employe…Sowdha Murugan 31 views 7 comments 0 points Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How to get - when the employee was created in the applicationSummary: Hi Everyone! Is there any way via (BIP/OTBI) to fetch when the employee was created in the application ? Version (include the version you are using, if applicab…ShawShankk 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Error when Combine 2 Subject AreasSummary: Hi All, I am trying to create an OTBI analysis by merging 2 Subject Areas: Worker Assignment Real Time and Person Real Time. The report will display employee wo… -
Tables to find workflow attachmentsSummary: Content (required): Hi All, how to find the workflow attachments. I used the below query but not getting any result. SELECT wat.* FROM Fusion.Hrc_Txn_Header txn…Venkatesan 151 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How to send attachments from BI publisher?Summary: How to send attachments from BI publisher? Content (required): Hi All, We got a requirement to send a onboarding notifications for the new hired employees with …Venkatesan 21 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Serial numbering in the reportHello, In a notification I prepared, I would like to give a serial number to the document that will be sent to the people in that month. For example, document no;01 docu…Sinem Kara 22 views 1 comment 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM
-
Need SQL Query to fetch the Advanced Mode Absence Duration in Absence RecordsHi Experts, Could you please help me on SQL Query to fetch the Advanced Mode Absence Duration in Absence Records. Thanks, Nagaraju.Naga raju Ibba 303 views 4 comments 0 points Most recent by Sayali Pawar-Oracle Reporting and Analytics for HCM