Setup/Administration
Discussion List
-
Query to extract second manager level (under top manager) for all employeesSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample query to retrieve for each employee the second level manager …Valerio Curzi 299 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …Sneha815353 53 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Table(s) contain POD Version and Last Refreshed DateContent Hi... I am looking for a SQL query to derive the last refresh date for a POD and latest patch level (ie 12A, 12C, etc). Thanks in advance for any tips. JRJoe Roberts-Oracle 889 views 15 comments 1 point Most recent by DhirajRathi Reporting and Analytics for HCM -
Privileges/Roles to access the Reports and Analytics Work areaSummary: Content (please ensure you mask any confidential information): Hi experts, I'm working with a custom job role that should be able to access the Reports and Anal…Elena_Panniello98 246 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
BI Publisher Bursting with Multiple Templates , Multiple Data setsSummary BI Publisher Bursting with Multiple Templates , Multiple Data setsContent Hi Friends We have a requirement where we need to burst BIP reports. Now i have 2 diffe…Mansur Khalil 333 views 4 comments 0 points Most recent by Alon Hadar Tamir Reporting and Analytics for HCM -
User-Defined tables name in Oracle HCM BISummary: Content (please ensure you mask any confidential information): Hello experts, do you know the BI table to extract user-defined tables? Thanks in advance for you…Valerio Curzi 28 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
What is the OUTPUT CHARACTER SET can support German umlauts in etext templateSummary: What is the OUTPUT CHARACTER SET can support German umlauts in etext template. Could anyone please provide any information about this. Content (please ensure yo…mohityagyik 111 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM -
RTF holding on the empty space if the condition is not satisfiedHi, I facing an issue with rtf template where if the condition is not fulfilled it shows blank space and then the next text in the report like below picture Is there som…chpriyanka 271 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
OTBI-Dashboard promt values not showing in Dashboard after added the new oneSummary: HI Team, We have new enhancement requirement in old dashboard that is needed to change the check task name from HR Questionnaire First 2-weeks check into Onboar…AjayKumar Maddipati 33 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Audit of BIP Report ChangesSummary: Audit of BIP Report Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there any available feature to track or audit …Parag Hiremath 44 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Pivot Table > Sorting Date in Ascending Order Not WorkingSummary: Pivot Table > Sorting Date in Ascending Order Not Working Content (please ensure you mask any confidential information): Hello, We want to display the time card… -
Issue with line manager dashboardSummary: Content (please ensure you mask any confidential information): Hello experts, in all delivered dashboards, in my case compensation plan, line manager can look f…Valerio Curzi 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Combine Two or more subject areasSummary: I tried to add a new subject area to my report - all I need from the below subject area is the Employees Name which is not in the first subject area for Payroll…THawkins_LGI 251 views 19 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Subject text update of standard notificationSummary: Subject of standard notification update Content (please ensure you mask any confidential information): Hello experts, does anyone know how to change the subject… -
How is Audit Table of HCM different from events captured in hrc_evt_source_objectsSummary: How is Audit Table of HCM different from events captured in hrc_evt_source_objects and which one should be used when Content (please ensure you mask any confide…Amod Kulkarni 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Goal approval request notification template non editableSummary: Goal approval request notification template non editable Content (please ensure you mask any confidential information): Hello experts, we have enabled the appro… -
HCM Extracts - How to do Conditional Replacement?Summary HCM Extracts - How to do Conditional Replacement?Content Hi All i was trying to replicate nvl function in HCM Extracts using the Conditional Replacement option a… -
Add Custom Text to Workflow NotificationSummary: I would like to be able to add custom text to the workflow notifications that would show up conditionally - only when the approve/reject links are shown on the …Kyle Norris 41 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher ReportsSummary: Analytics > Administration > Manage Sessions > Ability to Trace Sessions for BI Publisher Reports Content (please ensure you mask any confidential information):…Bernard T 64 views 1 comment 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM -
Oracle BI tables to retrieve Talent RatingsSummary: Content (please ensure you mask any confidential information): Hello experts, which tables allows to extract Talent Ratings as that one attached? Thanks in adva…Valerio Curzi 13 views 1 comment 0 points Most recent by Joe Dorrian Reporting and Analytics for HCM -
Performance Issue in Extract in HCM CloudSummary: Hi Folks, We're facing the performance issue in the extract even after the increase of Chunk size and thread size using payroll process configuration. I've trie…Sowmiya Velusamy 52 views 5 comments 0 points Most recent by Ram Manoj Reddy Bala-Oracle HCM Extract -
What is the DBI for getting the latest payroll frequency start dateSummary: What is the DBI for getting the latest payroll frequency start date Content (required): Hi Team, Greetings! What is the DBI for getting the latest payroll frequ… -
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 72 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
BIP Schedule ReportSummary: BIP Schedule Report Content (please ensure you mask any confidential information): Hi Team, Greetings! There are multiple BIP Reports scheduled at the different…Parag Hiremath 52 views 5 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to modify the alignment in the PO Terms and condition setupSummary: Term and condition pulling from the purchasing setup in PO PDF report but We needs to do the alignment changes as per the business requirement. Please let us kn…Thanigainathan R 14 views 2 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for SCM -
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
How do we track bypass Approval Rules - Bypass TrackingSummary: Need Audit record of Approval Rules - Bypass Tracking Content (required): Hi Team, We got a requirement from customer that we need to get the Audit details when…ankit.j.kumar-Oracle 143 views 2 comments 1 point Most recent by Sowdha Murugan Reporting and Analytics for HCM -
How to get "Person Type" and Assignment Details from Fusion TablesSummary: Hi All, We are seeing a difference between the "Users license Usage" numbers in the Usage reports for HCM Base cloud Licenses and number of "actual user report … -
how to send a custom email when employee submits resignationwe have a requirement to send an email to employee when he submits resignation and also we need to send another email as resigantion approved to employee with the custom…Dara Nagasai 11 views 2 comments 0 points Most recent by Dara Nagasai Reporting and Analytics for HCM -
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM