Global HR
Discussion List
-
What is the diffrence between Date start and Orginal_Date_of_hire in PER_PERIODS_OF_SERVICESummary: Hi Team, we have to two columns for Hire_Date in PER_PERIODS_OF_SERVICE table what is difference between. if not why two columns given. Thanks, Ajay Content (pl…AjayKumar Maddipati 21 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Need to identify the tables that hold sensitive information using Oracle Cloud RecruitingSummary: I need to identify the any tables that hold sensitive information (PII). We have started using Oracle Cloud Recruiting and want to identify tables that have thi… -
we would need a report with the previous and new cost center OTBI ?Summary: Hi Team, Hope all doing well ! we would need a report with the previous and the new cost center ? Could you please help me on ? Thanks, Ajay Content (please ens…AjayKumar Maddipati 31 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Logical SQL join condition for Recruitment and Transaction ConsoleHi, I have a report where I am using below tables for fetching recruitment and postion details like JobRequisitionNumber, RecruiterFullName,DepartmentName,RecruitingType…
-
Query to pull the failed transactions from transaction consoleSummary Query to pull the failed transactions from Transaction ConsoleContent Hi Experts, Good Day!! We have the requirement to pull the failed transactions from transac…Charan Kollipara 931 views 13 comments 0 points Most recent by Trupthi Reporting and Analytics for HCM
-
How to enable audit for any personalization changes that are done via a sandbox in Oracle HCMSummary: We have a requirement to capture any personalization changes that are done via a sandbox in Oracle HCM application. Kindly let us know how to enable and track t…
-
Employee Names in Local LanguageSummary Employee Names in Local LanguageContent Hi All I need to display the Employee Names (Example: First, Middle and Last) in local Language (i.e. Arabic) I entered t…Shabrawi 120 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Subject Area for Organization AttributesSummary Subject Area to display attributes from hr_all_organization_unitsContent We deployed few attributes at PER_ORGANIZATION_UNIT_DFF under Manage Organization Struct…Amitabha 180 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Report created using AS OF DATE presentation variable gives multiple records.Hi, OTBI Report created using AS OF DATE presentation variable gives multiple records when we use the "Veteran Self-Identification status" value from the person real-tim…Mohan_Chin 51 views 6 comments 0 points Most recent by Chris Borsh-Oracle Reporting and Analytics for HCM
-
Is there any possibility to extract the emp image in JPG or PNG format from oracle through Report.If not from reports what is the possibility of extracting the image from Oracle Fusion HCM?YAMINI DANTOORI 1 view 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can we use case when condition in Parameter 1(To email address) while using burstingSummary: Can we use case when condition in Parameter 1 (To -email address) while bursting. Content (required): I need to deliver report to different email address as per…
-
Is there an option to redact information, including PII data, in Cloud attachments?Summary: We have a requirement to redact information, including but not limited to PII data, in attachments that may be requested by outside sources. Are there any capab…AshleyT 5 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
etext issue for multiple child tag printing with master record multiple timesSummary: Hi All, Need your suggestions on how to solve the below requirement: We have a created HCM Extract to deliver data to a third party Benefits provider The XML st…Prashant Prabhakar Fusion 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 237 views 8 comments 2 points Most recent by Unknown Reporting and Analytics for HCM
-
Is there any table that stores the transaction of the Transfer Direct Reports transaction?Summary: Which table stores the transaction or transaction history of the Transfer Direct Reports transaction in Fusion? Need to pull the one who initiated or do the Tra…James Leborn 1 view 1 comment 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM
-
LRU Registration ReportSummary: LRU Registration Report Content (required): Hi Team, Greetings! We have the details for LRU (Legal Reporting Unit) Registration defined under "Manager Legal Rep…Parag Hiremath 75 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM -
How Can We Identify Whether The User Is Logged In Via SSO OR Native LoginHi Team, We have enabled both SSO and Native login for our pod and wanted to know how the users are logging into the system. Is it by SSO or Native login. Please suggest…Sudarshan Uppara 34 views 2 comments 0 points Most recent by Sudarshan Uppara Reporting and Analytics for HCM
-
Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleSummary Unable to access Recruiting - Recruiting Real-Time OTBI report using the custom roleContent Getting below error while accessing Recruiting - Recruiting Real-Time…Venkatraman G 172 views 10 comments 0 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportSummary How to get Phone number, Email Address, Home Address and Bank details old values using BIP ReportContent Hi Team, We are creating new HCM BIP Report to Fetch the…User_2025-02-01-06-07-07-886 828 views 7 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
How to remove Blank Rows in a report?Summary: Once we export the report there are a few Blank rows at the bottom, is there a way to remove them? Content (please ensure you mask any confidential information)…THawkins_LGI 75 views 8 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
How to report on proxies setupSummary: We have a requirement to report on the proxies information setup (Set Preferences > Proxies). Is there any seeded report or information on building custom repor…
-
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi…Amy Wilson 752 views 7 comments 0 points Most recent by Stefan v. Glabbeek Reporting and Analytics for HCM -
Reporting Prior Month Data SQLSummary: Can we add SQL to the formula to look at the Prior Month data? So tell it to look at the System date - 1(for prior month) and pull 1st to last date of that prio…THawkins_LGI 42 views 12 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
What table is storing Change working hoursHi Team, Which table is storing change working hours information? Any sample will be helpful.
-
Unable to get the proper count for Assignment Count when I am using two subject AreasSummary: Hi Team, we have requirement to get the count for Nationality to get this column we are using 'Person Real time' Subject Area. and we also have to filter this c…Ashok Dhara 12 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Termination category field causes blank rows for OTBISummary: Termination category field causes blank rows for OTBI Content (please ensure you mask any confidential information): Hello experts, we are building a custom OTB…Oriana L. 12 views 1 comment 0 points Most recent by Mihnea Savu-Oracle Reporting and Analytics for HCM -
'Signer Address' column in Checklist Real Time Subject AreaSummary 'Signer Address' column in Checklist Real Time Subject AreaContent We are trying to leverage Checklist Real Time subject area to develop reports on the onboardin…User_2025-03-07-21-34-36-848 44 views 5 comments 1 point Most recent by Marcy Hart Reporting and Analytics for HCM
-
Subject area/database table for historical manager hierarchySubject area/database table for historical manager hierarchy Client is interested in building dashboards to show different HR metrics for which historical manager hierar…
-
Any reports or Dashboards available for Fusion Applications Performance monitoring?Summary: How to Monitor Fusion applications performance? We are using FAs in more than 30 countries and there are many processes/ integrations/ reports scheduled to run …MandeepGupta 54 views 6 comments 1 point Most recent by Bala Mahalingam-Oracle Reporting and Analytics for HCM -
OTBI Subject AreaSummary Grade Progression Subject AreaContent Hi, Is it possible to extract Progression Grade Ladder, Grade and Grade step, rates values with an OTBI report? If yes, whi…Catherine Varvaressos 79 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM