Global HR
Discussion List
-
SQL Query to fetch value set details with respect to modulSummary: Hi All, I want to fetch the value set details with respect to module, can anyone help me with table name or query? Version (include the version you are using, i…ShawShankk 185 views 1 comment 0 points Most recent by Deepak Deenadayalan Reporting and Analytics for HCM -
Seniority Dates V2 to V3 TransitionContent Hi all - my search skills are seriously lacking, or there is just no information out there ... what work is involved in transitioning from V2 to V3 for the new s… -
OTBI report for finding position wise incumbants including candidates with Job offersSummary: We are looking for an OTBI report to fetch all incumbents of a given position along with candidates with active Job offers already given. This report will help …Pavan Kumar Thummalapalli 76 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Timing issue for an SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built a query to retrieve the organization manager assignment id for a specific… -
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …User_2025-01-30-23-59-27-880 1.7K views 11 comments 1 point Most recent by Simi_SS Reporting and Analytics for HCM -
Person Costing Page Not Updating with Hire Date ChangesSummary: We recently updated an employee's hire date using 'Employment Start Dates' quick action from October 21, 2024, to November 25, 2024. The assignment page reflect…Madhuja Bhaumik 17 views 0 comments 0 points Started by Madhuja Bhaumik Payroll and Global Payroll Interface (GPI)
-
Task Type in Subject Area Workforce Management - Checklist Real Time - Checklist Task TemplateSummary: 1- Looking for the Task Type in the Subject Area Workforce Management - Checklist Real Time. This is to pull the configured task type for various tasks in the j… -
How do I write a number in full in the report?Summary: I need to write the salary amount in full, for example, R$ 1,000.00 (one thousand dollars). I know it's possible using a PL/SQL function, but I couldn't do it i…Simiao Oliveira 12 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
We are trying to send a static (fix)pdf attachment to all newly created candidatesSummary: We are trying to send a static (fix)pdf attachment to all newly created candidates, for that we tried below query . Have uploaded a pdf doc to content server as…Awadhendra Tripathi 31 views 3 comments 0 points Most recent by Manikanta Reddy S Reporting and Analytics for HCM
-
In-app FYI notifications Error -The transaction details are no longer availableGetting Below Error in In-app FYI notifications The transaction details are no longer available here because the approval process is complete. Please find my below obser…Rama Krishna Annam 68 views 2 comments 0 points Most recent by Sowmiya Velusamy Human Capital Management
-
Embedded OTBI Analysis Refresh IssueHi, I'm using an embedded OTBI Analysis within Fusion HCM on Candidate Submission Profile. I'm running into a cache issue where if the report is viewed before the result…
-
DocumentsOfRecordEO psValue Meaning/ MappingSummary: Mapping/ Meaning for DocumentsOfRecordEO psValue Content: Support doc https://support.oracle.com/epmos/faces/DocumentDisplay?id=2692905.1 refers to different fu…Jan Barz ACN 41 views 1 comment 1 point Most recent by Ravinder Namsani-Oracle Human Capital Management
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 227 views 11 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Active department not found in reportHi, We are using the department level to differentiate between departments (divisions, sections, units). We have created a new tree version based on the new requirements…Catherine Abi Samra 11 views 2 comments 0 points Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
Need to report on Employees work schedules and patternsContent Hello, We need to be able to report on employees work schedules and patterns so we can create a report that looks like a calendar and show the days that employee…
-
Extract Rollback using SOAP serviceSummary: Unable to rollback extract using Flow Action Service Content (please ensure you mask any confidential information): Hi, I am using Flow Action Service With Perf…Shanmugaraja_Karunamoorthy 2 views 0 comments 1 point Started by Shanmugaraja_Karunamoorthy HCM Extract
-
OTBI Vacancy ReportSummary: Is there a way to report using Subject Area(s) all current employees and any requisitions and vacancies so we have one entire list? For example a report that sh…JHaden3 164 views 13 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 401 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 56 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…User_2025-01-23-22-36-48-692 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
retrieving timestamp is not giving correct date and timestamp from Table PER_EXT_APP_IDENTIFIERSSummary: retrieving timestamp is not giving correct date and timestamp from Table per_ext_app_identifiers Content (please ensure you mask any confidential information): …
-
SQL query to retrieve Division Name and Manager division display nameSummary: Content (please ensure you mask any confidential information): Hello experts, I need to extract the Manager Division full name field and the Division name as we…Valerio Curzi 390 views 4 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.6K views 11 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…
-
How to get the Top-Down Manager Hierarchy in OTBI expect CEO,remining Top down 3 Manager hierarchy.Summary: Currently we are looking to fetch top down manager hierarchy in one of our OTBI reports like from CEO to employee Top level manager hierarchy to fetch in to the…challa praveen 1K views 29 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Get firstname lastname of user without person recordSummary: Requirement to get firstname, lastname of a user record which doesnt have a person record. since its ERP project, HCM part would not have been configured. PER_L…Jaeyshree K K 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPMSummary: Notifications are disappearing from bell icon under "Assigned To Me / All" Tabs but showing in BPM worklist Content (required): Version (include the version you…pparamesh 134 views 3 comments 0 points Most recent by Walid Hamdy87 Reporting and Analytics for HCM
-
Identifying the Main Legal Reporting Unit via BISummary: Identifying the Main Legal Reporting Unit via a SQL query. Content (required): Hello experts, We have multiple LRUs, and TRUs, setup for our implementation, and…
-
Information: Query to get last P2T/T2T Refresh DateSummary: In order to get last refresh date from backend, below SQL can be used: select * from ask_deployed_provision_configs last_update_date column in this table gives …MandeepGupta 218 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM