Global HR
Discussion List
-
Line Manager Dashboard custom with Manager Name HeadcountSummary: Hello, I made a custom OTBI dashboard from the vanila Line Manager Dashboard. In that dashboard we added one prompt Manager Name that is prompted. So when we se…Ilzura Ismailhodjaeva 63 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Absence Daily BreakdownWe have a daily absence breakdown report built using the subject area Workforce Management - Absence Calendar Details Real Time. SQL code attached. There are a number of…
-
Oracle HCM Value Sets Rest APIHi, I want to create a record for value set using Oracle Rest Api information.I found this API for this How should I use the ValueSets_Id information, which is the param… -
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Looking for System Usage MetricsSummary Reporting on who/when/how/what users are accessing in HCMContent Need to report on system usage and adoption rates for our HCM system with a focus on Employee an…Becky Stalsby 230 views 13 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch SourceRef values loaded via hdl?Summary: We are loading some source reference values while loading allocated checklist to employees. However I am not sure how to fetch this values in an OTBI and BI rep… -
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 59 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
We need fetech the status of Exist survey report how can i get in OTBI May I know subject area?Summary: Hi Team, We need fetech the status of Exist survey report how can i get in OTBI May I know subject area? Thanks, ajay Content (please ensure you mask any confid…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
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 63 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 41 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 21 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 1 view 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 21 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 21 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 11 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 41 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 61 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 118 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 11 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 12 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 11 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 40 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 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM