Global HR
Discussion List
-
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 -
How to Remove Duplicate Rows from Pivot table in OTBISummary: In excel - once you add the data to the row it makes it one to one - in OTBI how would I ensure there are no duplicated rows of data? Content (please ensure you…THawkins_LGI 55 views 6 comments 0 points Most recent by THawkins_LGI 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 26 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
-
Attachments - Deeplink in OTBIHi, Is it possible to have a deep link for attachments in OTBI so that the person accessing the report can view the respective attachments, such as PDFs, highlighted in …Saurav R-Oracle 27 views 1 comment 0 points Most recent by Julian Challenger-Oracle Human Capital Management
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 253 views 6 comments 4 points Most recent by Julian Challenger-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 21 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 31 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 15 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 17 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_RVZRJ 35 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Profile BIP_CLIENT_REFRESH_TIME_HCM is not working as ExpectedStep1 Manage Administrator Profile Values Search for Profile :BIP_CLIENT_REFRESH_TIME_HCM Profile Value is 1440 Step2 we updated the profile value to 15 at Site level Sa…Rama Krishna Annam 182 views 1 comment 0 points Most recent by RWMATTHE-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
-
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 85 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 1 view 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 67 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Overdue Task Report in Journey ChecklistsSummary: Overdue Task Report in Journey Checklists Content (required): Hi All, Greetings! we are trying to check the exact data for the terminated employees with checkli…Parag Hiremath 94 views 10 comments 0 points Most recent by Tammy Hemmingson 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…