Global HR
Discussion List
-
How to get employee's co-worker-style contactsSummary: How to get employee's co-worker-style contacts Content (please ensure you mask any confidential information): Hi Experts, Is there any query/tables to get emplo… -
How to identify Overdue Onboarding TasksSummary: I'm writing an analyses using the subject area Workforce Management - Checklist Real Time. I can see tasks that are incomplete, but I need to report only on tas…JHaden3 72 views 5 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well…Cheryl Burwell 112 views 7 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Query to fetch legal reporting unit mapped to a legal entitySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Issue occurring that seems to double values in certain fields e.g. FTE and SalaryContent We're experiencing an issue whereby assignment information in certain fields is multiplying; giving us inaccurate data. It's not occurring in the majority of cas… -
How to display OTBI report in Journey task "report"Summary: Hi Team, I have a OTBI report and I want to display in journeys where employee can see the data and esign. I am using advanced task and but report is not coming…AvinashP 182 views 15 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
More details in the access Log in Oracle HCMAs administrators, we regularly download access logs to monitor user activity in Oracle. These logs provide a basic summary of successful and failed login attempts While…Annapia Penta 36 views 2 comments 1 point Most recent by Annapia Penta Reporting and Analytics for HCM -
Usage of "Employment Start Date" quick action and "Work Relationship" quick action.Summary: Some of the Oracle document suggest using 'Work Relationship' quick action (instead of 'Employment Start Dates' quick action) to correct the start date of the p… -
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 20 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
BI Report to get the previous and present records of job, salary amount, department and grade.Hi Team, I need a working sql query to get the previous and present records of job, salary amount, department and grade in BI Reports. Parameters: - Action Code, from da…Support 26 views 2 comments 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM -
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any … -
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 1.2K views 2 comments 1 point Most recent by NERU Reporting and Analytics for HCM -
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.2K 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 319 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 139 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 33 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 172 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 4 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 409 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 500 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 13 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…