Global HR
Discussion List
-
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… -
SQL Query to get Absence Qualified Entitlements for an EmployeeSummary Need an SQL query to build a BIP report similar to what is available on the Absence Records UI which provides details of qualified entitlementsContent I'm not ge…User_UM4C6 1.1K views 6 comments 0 points Most recent by Rohini Rayavaram Reporting and Analytics for HCM
-
How to extract deleted records from HCM cloud?Summary: Extract deleted records from HCM Cloud for PaaS for SaaS integration Content (required): We are trying to build a framework, where different business objects in…BhaskarMukherjee-Oracle 299 views 6 comments 0 points Most recent by Niraj Reporting and Analytics for HCM
-
Counting duplicate in ETEXTSummary I have two record coming from XML , I want to restrict it in ETEXTContent Example - In XML - Employee - 1 has record A1 and Record B1 Employee - 2 has record A2 …
-
While running HDL to delete status processing rule from element i am getting below errorSummary: While running HDL to delete status processing rule from element i am getting below error METADATA|StatusProcessingRule|EffectiveStartDate|StatusProcessingRuleId…
-
Can we send notification to bell icon in Fusion HCM using the BI Publisher reports?Content Is there a way to send the notifications to the bell icon in the Fusion HCM by running the BI reports. Please provide your inputs on this. Thanks and Regards, Am…Amrit 141 views 8 comments 0 points Most recent by Bharadwaj Pisipati Reporting and Analytics for HCM -
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 35 views 7 comments 0 points Most recent by Ganesh Aithandal Muralidhar Reporting and Analytics for HCM
-
RTF template: hide empty column in pivotGood day, I created a custom RTF template that displays a pivot table. The field "BASE_ELEMENT_NAME" lists different elements but it's empty for some employees and, as a…
-
how to personalize / customize all Oracle HCM notifications - my changes are not showingSummary: Customer requirement is to personalize all HCM notifications for users. The requested changes are the following: - place their logo in all HCM workflow notifica…Katarina Bartova-Oracle 130 views 2 comments 0 points Most recent by InaNotra-Oracle Reporting and Analytics for HCM
-
User is unable to access job profileSummary: When the user is trying to access "Job profile & OPS dashboard", they are unable to access the Job profiles dashboard. The role is restricting the users to not …SivaNallagatla 5 views 0 comments 0 points Started by SivaNallagatla Reporting and Analytics for HCM
-
Cost centres report in OTBISummary: Hi, I am wondering if anyone has a way of reporting on cost centres along with HR employee data in the same report. So far i have seen that Payroll costing setu…BillM 388 views 7 comments 0 points Most recent by Ignacio Velando-Oracle Reporting and Analytics for HCM
-
Report to identify employees with corruption in "PER_PERSON_NAMES_F" tableSummary: Hello, We are looking for a report to pull all employees with corrupted "PER_PERSON_NAMES_F" table. We had several employees with this corruption that caused er…
-
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 396 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How can we give view only(Read only) access to Personal Details page in HCMSummary: How can we create custom Data Security Policies to give view only access to Personal Details(Redwood page) page PII information? Or we can give the access throu…
-
How to bulk update location namesSummary: Need to bulk change location names and location codes. We have thousands of records but have not found an effective way to make these updates. Content (please e…
-
How to find Legal Full Name in OTBISummary: Hi Team, we have Legal Full Name column in person details page but unable to find out in person real time ad worker real time. Please help me any one . Thanks, …AjayKumar Maddipati 16 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Restrict insertion of salary records with no changesSummary: Whenever we do transfers, promotions, and local/global transfers that do not have any changes to salary, salary records get inserted and the inserted record app…
-
Understanding of columns in PER_SENIORITY_DATES_SETUP for the setup Configure Seniority Date RulesSummary: Hi Team, We need to understand the purpose and use of these TRIGGERING_FIELD_TYPE, SOURCE_FIELD, OBJECT columns under the table PER_SENIORITY_DATES_SETUP for th…
-
"Last Logged on" Audit clarificationContent (please ensure you mask any confidential information): Summary: Wanting to understand where the "last logged on" value is derived from in the audit tables. For e…Emma Long 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Name of the table that stores the 'Location Based Access' infoSummary: Hi, I'm trying to figure out the table name that stores the 'Location Based Access' info. Navigation: FA → Tools → Security Console → Administration → Location …ganapathysundaramd-Oracle 22 views 3 comments 0 points Most recent by Jun Ye-Support-Oracle Applications Security -
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 454 views 13 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to identify who removed a role for a specific userSummary: How to identify who removed a role for a specific user Content (required): Which table holds the details of who and when a specific user role is revoked for a p…Vinothkumar Somasundaram 282 views 2 comments 0 points Most recent by User_FPR9R Reporting and Analytics for HCM
-
Birthday reportSummary Birthday report worked exampleContent Hi there I have a requirement to create a birthday report, that can run two weeks before the employee birthday month. This …User_2025-02-04-15-07-59-505 452 views 22 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this.
-
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Remove deep link and suggestions from the bot responseSummary: I want to remove deep link and suggestions for specific users from the response coming from the custom components provided by oracle for HCM Skill. From the ima…
-
Female turnover rates of DashboardI'd like to ask that if I select the Female as the Gender, how is the female turnover rates calculated? Is the denominator of the ratio in relation to all employees or o…Chen, Reyna 22 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
I have developed custom resource alert using workers api but it's not trigger notification for HRSummary: I have developed custom resource alert using workers api to trigger notification to HR if any employee return from maternity leave but it's not trigger notifica…