Global HR
Discussion List
-
SQL query to retrieve a common lookup description at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, we created a custom common lookup. We need to extract at the employee level the lo…Valerio Curzi 194 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
HCM Position HierarchySummary: Hello, I created an OTBI using Position Real Time subject area but I am not able to get the desired results. Example, I have below position hierarchy Position1 …HetalVaghela 21 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
SQL query of Fast Formula retrieving manager+1 and manager+2Summary: Content (please ensure you mask any confidential information): Hello experts, do you have an SQL query or fast formula to retrieve the employee manager+1 and ma…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
HCM Reporting/Extracts usage recommendationsSummary Out of plane vanilla sustainable reporting ideas for HCMContent Disclaimer: following post expresses personal opinion of author based on many years and many rele…Valeriy Gorbunov-80491 66 views 8 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Canada's Employment Equity Questionnaire (Legislative Requirement)Summary: Hi Team, I would like to ask for your thoughts if you have configured or added this legislative requirement of Canada to the system? It's like a set of question…KarenA 11 views 1 comment 0 points Most recent by IoanaNatalia-Oracle Reporting and Analytics for HCM
-
Personalization of help desk requests page in redwoodSummary: We have requirements to personalize help desk requests page to split category field to category and sub-category, noting that the page is redwood and personaliz…
-
BIP encryption with UTF-8 encoded csv fileHi Team, Can you please help me know how to generate a UTF-8 encoded csv file with encrypted pgp extension file. I am using etext template. Thanks.SM_EP 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Where to find/add Brazil Job Details attribute values ?Summary: I am not able to find this Brazil Job Details values in Job Details/Jobs page. I believe its an attribute under a delivered DFF attribute (as shown in the Desig…Anshuman Chatterjee 47 views 5 comments 0 points Most recent by Anshuman Chatterjee Reporting and Analytics for HCM
-
Sample query to retrieve employee DivisionSummary: Content (please ensure you mask any confidential information): Hello experts, we need to retrieve the employee division name. Do you have a sample query to do i…Valerio Curzi 392 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Which table store user password and Password expiration DateSummary: Hi , Please let us know Which table stores the user password and Password expiration Date under User definition. Navigation : Tools-> Security Console-> User At…
-
Report of edited termination datesSummary: To assist with researching retroactive payroll scenarios, we would like to report on employees who have edited/corrected termination dates. We would like to sho…awheel09 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Impossible to cancel work relationshion because already terminatedSummary: We have a work relationship that needs to be cancelled but is already terminated, we can't reverse the termination because the employee has a second work relati…margherita bonfiglio 11 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
AAP Promotions ReportSummary: We have a requirement to report on employee promotions. This report should export on one line what their previous job/position was, and what their new/current p…Henry Imgrund 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Making All value selectable in date parameter definitionI have an absence start date parameter in the report and its definition is as seen in the screenshot below. It works like this: First, the registry number is selected, a…Cansel Karasoy 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I get the Home Address from the Person Management\Person area on a ReportSummary: I have the mailing address, but need the home address. Content (please ensure you mask any confidential information): Version (include the version you are using… -
HCM Experience Design Studio ReportSummary HCM Experience Design Studio ReportContent Does anyone know if there is a Subject Area or Table that contains the Rules created in the HCM Experience Design Stud…User_2025-01-23-21-24-21-434 79 views 9 comments 4 points Most recent by HRIS_EC Reporting and Analytics for HCM -
Are there agreed standards used by the community when reporting dates?We have adopted the US format for all reporting with users then setting preferences at an account level. Are there any standards which are adopted by customers as best p…Clare Murtagh 1 view 2 comments 1 point Most recent by Clare Murtagh Reporting and Analytics for HCM -
BI Impersonator roleSummary: We are trying to connect OTBI through OAC. To implement this, we need to know what privileges should 'BI Impersonator' have. As of now BI Impersonator role not …Muralidhar Manchikanti-Oracle 52 views 0 comments 0 points Started by Muralidhar Manchikanti-Oracle Reporting and Analytics for HCM
-
Subject Areas for Employee dataSummary: I am trying to create a report of the employees in Fusion (we don't use HCM), but I can't get the data out of the system. I can see the worker's name and primar…Jeroen VW 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Job description report to add inactive and active job codesSummary: We are trying to add inactive and draft job codes in the job description report through SQL, we added the flags Active, Inactive and Draft in the SQL, still we …
-
Multiple Proficiency Level records per Competency HCMSummary: We have multiple Proficiency Level rows per Competency. It is not clear which proficiency level in the report is the correct one. We expect the report to show o…
-
query to fetch global transfer employees in fusion hcmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…VenubabuValeti 553 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Error while updating Demographic InformationSummary: We're getting this error for some employees. Can somebody please tell me why this is popping up. I checked the Lookups, but there was nothing wrong with it. Con…
-
24C Worker Sensitive InformationI am testing the Secure Reporting on Worker Sensitive Information feature in 24C. I followed the steps for both Person Legislative Information and Person Ethnicity. I wa…UyEm001 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to fetch Reason value from ORC in BI reportSummary: Hello Experts, Need your help in pulling a field called reason found in ORC module. PFA the screenshot of the field i want pulled. I am aware this field is pres…Jithin Mathews 42 views 4 comments 0 points Most recent by Nimisha Nirmal QC Reporting and Analytics for HCM
-
Ability to burst output file from BIP Report to OCI object storageWe have a requirement to burst output files of BIP reports to the OCI object storage buckets. Currently we don't see any delivery option in bursting that supports this. …Phaneendra Vallapu 157 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
A HR rep user should access all active emp of USA, except Partner and Managing Partner jobs in OTBIPrevious access rights: all employees in USA New access rights to be given: all employees in USA, except Partner and Managing Partner jobs The active employees report is…Shouvika 1 view 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
HR benchmarking data - best practicesHello All We have recently been requested to pull HR bench-marking data, so we can do some analysis on KPIs and metrics that represent the typical performance within our…Clare Murtagh 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how can I get multiple seniority dates on the same row in OTBIContent (required): I am reporting from assignment real time, person real time, and person seniority real time. When I have Seniority Date showing, there is one row with…Monique Dias 121 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM