Category 81
Discussion List
-
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… -
SQL query will not return an expected row in larger reportSummary: I have a report that returns employees who were referred and by whom, connected to their application and based on the referral to a specific job. There is an od… -
What table holds the future incumbents details?I am trying to pull the person number of a future incumbents but i'm not sure what table holds that info. Does anyone know? TIA. 😊Michael Angelo Lucena 21 views 6 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to put image as a background and create a birthday report?Summary: How to create a birthday card which need to put image as a background and make it staff name and birth date appear on top of the image?
-
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 76 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 14 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 …
-
Birthday alert with Background imageSummary: i have a birthday alert requirement and whenever i try to put the image as background using watermark option, rtf file size is getting increased and getting bel…
-
OTL - Workforce Management - Reported Time Cards Real Time subject area missing entriesSummary: The subject area Workforce Management - Reported Time Cards Real Time does not return accurate time entries when we try to query the custom attributes from the …
-
How to show amount of times a report has been run?Summary: The 'OTBI usage real time' subject area can't show usage of reports - how to report on this? Content (please ensure you mask any confidential information): We h… -
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…
-
How Do I get access to the WebCenter Content serverSummary: I have SQL provided by Oracle that give me the Content Server URL. When I click it, I get directed to the Content Server, but I do not have access to the file. …Al Darabaris 66 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to set a Presentation Variable in a Dashboard Prompt as a DateSummary: How to set a Presentation Variable in a Dashboard Prompt as a Date Content (please ensure you mask any confidential information): Hi, we created a Dashboard, wh…Barile Alberto 36 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
How can we pass date parameters into the List of values to fetch the data based on the date rangeHow can we pass date parameters into the List of values to fetch the data based on the date range? Based on the dates the recoded should get refreshed in the parameter n…Shanmukhi 158 views 2 comments 0 points Most recent by Vaishnavi Katiyar Reporting and Analytics for HCM
-
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 625 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…
-
Workforce Management - Worker Assignment Realtime, Work Assignment, FTE returns >1 incorrectlySummary: The attached analysis returns an FTE value greater than 1 for 49 records. We believe the calculation for FTE should be FTE = ((standard hours * headcount) / nor…David Boudreau 42 views 5 comments 0 points Most recent by Dan_Hinsley Reporting and Analytics for HCM
-
EEO-4 Category table nameSummary: Hi, everyone. would like know where I can found this columns. Regulatory Response Ethnicity - TEXT → I can't found the string data data type. EEO-4 Category → E…
-
24C Worker Sensitive Informationhttps://docs.oracle.com/en/cloud/saas/readiness/hcm/24c/hure-24c/24C-hr-wn-F34150.htm#hure-24c-f34150 I am testing the Secure Reporting on Worker Sensitive Information f…UyEm001 42 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 43 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 187 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Accessing worker details in learning report by learning specialistDear Community, We have the BIP report request from user which required to show worker name, worker number and department information in the report. While the users are … -
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 2 views 1 comment 0 points Most recent by Deaconu Constantin Valentin-Oracle Human Capital Management
-
Learning assignment alert delivery reportSummary: We have a requirement to report on the delivery of compliance assigned training alerts for audit purposes. Content (please ensure you mask any confidential info… -
Need a standard SQL query documentation?Can someone please share a Oracle standard SQL query documentation?Gowri Perumal 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 148 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
Per_Periods_Of_Service Not adding a Row for Voluntary Termination ActionsWe have been noticing that certain termination actions are NOT hitting the per_periods_of_service table. For example, if I submit a retirement for myself and it goes to …
-
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 123 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM