Global HR
Discussion List
-
Terminated employee still visible as incumbents in position, how to free the vacant positionSummary: Terminated employee still visible as incumbents in position, how to free the vacant position Content (please ensure you mask any confidential information): Vers…Abdelhafid Rhofir 171 views 12 comments 0 points Most recent by User_VCD7M Reporting and Analytics for HCM -
Sql query listing transactions with 'Pending' status with transaction tablesI want display_name and person_number information of records in 'Pending' status from transaction tables.Is there a sample query you can share?Cansel Karasoy 694 views 6 comments 0 points Most recent by Nitin Kashiv-Oracle Reporting and Analytics for HCM -
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…User_2025-01-30-17-58-41-867 546 views 4 comments 0 points Most recent by User_S04WZ Reporting and Analytics for HCM -
Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absenceSummary Workforce Management-Absence Realtime -Assignment Absence Details not picking all records of absence ONLY for 1 employeeContent Hello Dear SME's, Employee applie…C.R.Balaji 82 views 5 comments 3 points Most recent by Akhilesh_Singh-Oracle Reporting and Analytics for HCM -
OTBI Need subject areas with Representative Name to be pulled into reportContent Hi Team, We have captured HRBP in the representative section of Manage Employment. Now I want to capture that information in my OTBI report. But I am not able to…
-
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 71 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 111 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 161 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 31 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 11 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 21 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.1K 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 303 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 138 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 31 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 135 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 …
-
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 392 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…