Global HR
Discussion List
-
Hi experts , is there any SQL query to get policies, privileges, and application of a user roleSummary: Need assistance to build a SQL query to get security console details of a user role. Content (please ensure you mask any confidential information): Version (inc…Tharushi Sathsarani 61 views 1 comment 1 point Most recent by Kishore Padala-Support-Oracle Applications Security -
Fusion HCM Table Column to fetch "New Hire Status"Please guide us with Table.Column to fetch "New Hire Status" information for an employee. PFA image for UI screenshot.Ranganatha_CV 45 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
How-to get a complete view of AOR Security person level accessSummary: I need updated version of general query for AOR that have all AOR scope possibilities so I will pass the employee number and responsibility type then the query …
-
Specializations not pulling in Enrollment typeSummary: I pulled a report for Learning Assignments (To match the Learning Assignments Screen that summarizes a Team Members Learning Assignments) The screen shows the s…THawkins_LGI 22 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
In BI Report we have date parameters when we apply morethan one year we get time exceeds errorSummary: Hi Team, Hope all are doing great! In Onbaording BI Report we have date parameters when we apply more than one year we get time exceeds error if we apply less t…AjayKumar Maddipati 73 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
We developed BI reports in English but user wants based on local Language how to show data ?Summary: HI We developed BI reports in English Language but user wants based on local Language need to show data ? if user from arbic from need to show arbic and if user…AjayKumar Maddipati 3 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Column Properties Data format First Name Last NameSummary: The current format is Last Name, First Name - is there a way to switch this with below Data Format? Content (please ensure you mask any confidential information…THawkins_LGI 22 views 8 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Is there a way to give Delegations for Reporting?Summary: We would like a manager to allow an employee to pull reports for her direct reports We tried Role delegation and Approval Delegations but none of them help with…THawkins_LGI 22 views 6 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Seniority date - Legal Entity Hire Date or Rehire dateSummary: Requirement to identify the Lenth of Service based on Rehire date Content (please ensure you mask any confidential information): We have requirement to accrue t…
-
https://community.oracle.com/customerconnectHow can I get employee's dependent detail and emergency contact number in OTBI reportAnup Karmankar 13 views 2 comments 0 points Most recent by Sarma Yeddanapudy-Oracle Reporting and Analytics for HCM
-
Worker Assignment Event history - job title / position title as of assignment effective dateSummary: When we are running OTBI analyses with the Worker Assignment Event subject area, we need to be able to see what the associated position name/ job code names are…Hunter Kennedy 44 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Hide seeded HCM cloud OTBI Dashboards from Dashboard MenuSummary: Business does not want to see HCM cloud product seeded OTBI Dashboards from Dashboard Menu Content (please ensure you mask any confidential information): Versio…Sambasivarao Manam 68 views 3 comments 0 points Most recent by Sambasivarao Manam Reporting and Analytics for HCM
-
How to see scheduled processes submitted by others?Summary: How to see scheduled processes submitted by others? Content (please ensure you mask any confidential information): If I (admin) submit a process my colleagues (…Stefano_Mazzocca 93 views 2 comments 0 points Most recent by ES-Oracle Reporting and Analytics for HCM -
What will I be able to do if I activate a user?What will I be able to do if I activate a user? Please let me know. Thanks, MayukoMayuko-Oracle 13 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
FTP server setup for BIP - Save or Test connection not availableHi Team, I am trying to add FTP server setup. I can enter all the details but I do not see Save or Test connection. I should be a complete administrator, but seems I hav…SM_EP 14 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
HCM Table to fetch Saved SearchHello, I'd like to create a BI report to see whether employees have created their own Saved Searches on Document Record page. Do you know which HCM table store this piec… -
How to Create a BI report for BPM worklist fields in addition to TXN action and action Reason.Summary I have created a BI report for BPM worklist, along with action and action reaction from TXN header table which is and extract from XML_data_cache filed, but it i…
-
Formula for "Begins with"Summary: How to write a Formula that says If Department Begins with 3 THEN "Division1" I know how to write the standard formula using CASE(IF) but not sure what function…THawkins_LGI 13 views 4 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM
-
Where in UI in Talent Management can we see the the below codes?Summary: Code 1 Document Status: SELECT distinct HRA_EVALUATIONS.STATUS_CODE FROM HRA_EVALUATIONS ,HRA_TMPL_PERIODS_VL WHERE HRA_TMPL_PERIODS_VL.TMPL_PERIOD_ID = HRA_EVA… -
Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES?Summary: As stated in the question title: Is it possible to encrypt BIP report with PBE HMAC-SHA256-512 and AES-256 or PBE with MD5 and DES? We know that PGP Encryption … -
EIT Field value is not displaying in OTBI-AnalysisContent Hello Community, We have created an Analysis in OTBI, with simple fields from the "Workforce Management - Worker Assignment Real Time" subject area, which work v…User_2025-02-05-16-57-43-236 43 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Infolets - hide 'Edit Titles and Views' buttonIn the Analytics/Infolets section on the HCM homepage, employees have access to a button in the top right of each infolet to either 'Edit Title and Views' or 'Hide'. Is …Edward_Cowne 6 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve…Shanna Oppenheim 22 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
V3 Seniority Dates in OTBISummary How to report on V3 dates in OTBIContent Hello, We're migrating to the V3 seniority dates with the release of 20B, but we're running into a number of reporting i…Whitney Van Way 93 views 8 comments 1 point Most recent by THawkins_LGI Reporting and Analytics for HCM
-
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Duplicate data for employees Worker Assignment Real Time & Employment Contract Real TimeSummary: We have an analysis to fetch the full staff list. Recently, we have updated some position with new departments and parent positions due to organization restruct…
-
How to handle "Personnel File Request" in Oracle HCMSummary: Hello, Per Personnel Records Review Act, Current and Former employees can request their Personnel File information from the employer. I would like to know the f…Deepa Kannan 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
send alert to employee department headwe need to Alert notification to employee department Head, could you please assist on this
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 76 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…