Global HR
Discussion List
-
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 1 view 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 161 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 415 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 51 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 425 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…Dinesh Jaini 83 views 2 comments 0 points Most recent by Dinesh Jaini Reporting and Analytics for HCM
-
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 1 view 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 141 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 226 views 3 comments 11 points Most recent by Shyam Patel Reporting and Analytics for HCM -
Report showing working days per person for a period based on work schedule assignedSummary: Trying to report on working days for people based on Work schedule. Content (please ensure you mask any confidential information): I am trying to create an OTBI…
-
Extracting the absence durationSummary: Hi, I need to extract the absence duration of employees for a report need. I thought I could use the GET_PAY_AVAILABILITY function for this, but it didn't work.…Barış Ergün 41 views 2 comments 0 points Most recent by Omnia-Oracle Reporting and Analytics for HCM -
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom…
-
How to increase the specific BIP report's runtime or timeout limit?The Query Time Out that has been configured within the Data Model>Properties was set to 36000. However, during running the report, I'm still getting this kind of error: … -
How To Update the Position Effective Start Date in HCM?Summary: We have HCM integration with our legacy payroll system (Chris21). Position data was loaded via Oracle HDL format at implementation time. The position effective …
-
OTBI Report not showing all the data thats in HCMSummary: Customised report not showing data for all employees but its in HCM Content (required): Hi We have a customised configuration for our DBS details. Up until last… -
How long will the logging within the Audit Reports continue to show the historical data(old values)?Summary: Hi, We would like to know how long the data as retrieved via the Audit Reports is available to us. For the moment it seems as if we can insert any possible Date…
-
Manage Legal Entity HCM Information ReportSummary: Manage Legal Entity HCM Information Report Content (please ensure you mask any confidential information): Hi All, Greetings! May be this is something I seem to …Parag Hiremath 1 view 4 comments 0 points Most recent by PrashanthGanji Reporting and Analytics for HCM -
Report on how many interactions the Guided Journey receivesSummary: Abilities available in OTBI to report on Guided Journeys Content (required): Hi All, Since most Guided Journey tasks are "read-only" tasks and Guided Journeys a…
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 940 views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM -
Seeded Line Manager Role cannot view Future-Dated Hire Events in OTBIContent Hi, We have a report on a Line Manager Dashboard that looks at future-dated hires. For this, we are using the "Workforce Management - Worker Assignment Event Rea… -
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
A HCM BI Report is giving extra duplicate pages but the output is valid (the o/p is 1 page gives 2)Summary: A HCM BI Report is giving extra duplicate pages but the output is valid. If the output is 1 page it gives 2 pages of same data only in production environment. I…Chandan M-Oracle 1 view 0 comments 0 points Started by Chandan M-Oracle Reporting and Analytics for HCM
-
History Limit in ESS_REQUEST_HISTORY Table?Is there a limit to the history stored in the ESS_REQUEST_HISTORY table? I can see transactions in the report history in the front en, but I'm unable to find related rec…
-
Reporting "Additional Address Attribute 1" on OTBISummary Fields don't appear on the relevant subject areaContent Hi. I have aligned my country's geography and i have several address elements that i save on the fields: …BenZionP 114 views 10 comments 1 point Most recent by Andrew Nainggolan Reporting and Analytics for HCM