Global HR
Discussion List
-
View the results in the Absence Calendar Real Time Entry ReportI have followed guidance from the 22B document to 'Generate Daily Breakdown of Absence Details Process' and the outcome of this process is to 'View the results in the Ab… -
Looking for Last Contacted field for a candidate in Recruitment Module for reporting purposeSummary: Looking for Last Contacted field for a candidate in Recruitment Module for reporting purpose (Hiring à Candidate Search à Details à Key Highlights Content (requ… -
OTBI analysis - Bar graph in OTBI analysis for acquiring the headcount trend for the past years on mSummary: We want to create a Bar graph in OTBI analysis for acquiring the headcount trend for the past years on monthly basis. For which we need to get active headcount …Shreya Datir 51 views 15 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
How to return only the max ID grouped by selected column (SQL)?Summary: Content (please ensure you mask any confidential information): I am working on an OTBI report that uses Advanced SQL to create the analysis. The reason for usin…Giuseppe_Cannova 21 views 4 comments 0 points Most recent by Giuseppe_Cannova Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 70 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Inhibition of downloading a specific reportSummary: Hi all, we would like to know if it is possible to inhibit the ability to download a report. Also, it would be helpful to know whether this functionality can be…Alessandro Nesi 21 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…
-
which table can store the information about user's parent & child relationship roles in fusion hcmHi All, Thanks for looking into this issue. I am looking for table, which can store the current logged user parent -child roles(for Ex: One big role have more number of …Ravindr-Oracle 83 views 10 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 21 views 6 comments 0 points Most recent by AlyssiaKing Reporting and Analytics for HCM -
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 32 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 717 views 13 comments 0 points Most recent by Trupthi Reporting and Analytics for HCM
-
How to get Journey Survey Responses?Summary: How do I report the responses from Journey Surveys to the LMs or HR? Can anyone suggest table names for BI reports or Subject areas for OTBI? Content (required)…
-
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 109 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL Query to get HRBP assigned to an employee (when AOR uses organization hierarchy)Summary: We need a query to find HRBP assigned to an employee when Organization hierarchy has been used to assign the AOR(area of responsibility). It doesn't include any…Aloka Bhattacharya 1K views 3 comments 0 points Most recent by Vibha Pandey - 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 96 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Multiple External Identifiers in OTBI would like in separate columns and to include null valuesContent Our organization has multiple External Person Identifier Types that we need to report off of (Taleo ID and Oracle Transportation Management Number). As opposed t…Kayla Malecki 75 views 7 comments 0 points Most recent by User_U5JXC 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 any work around to get audit detail of External application identifier using BIPSummary: As we don't have audit table for External application Identifier (PER_EXT_APP_IDENTIFIERS) Is there any work around to get audit detail of External application …ManjunathaKD 27 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
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 5 views 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 232 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 71 views 11 comments 0 points Most recent by Chris Carloff Reporting and Analytics for HCM