Category 81
Discussion List
-
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 21 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 81 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 43 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 161 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 671 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 52 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 51 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 223 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 1 view 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 21 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 151 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 121 views 9 comments 1 point Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Subject Area (or Table) for Regional General Preferences?Summary: Are the General Preferences: Regional reportable in OTBI/BIP? Content (please ensure you mask any confidential information): Hello everyone, Asking if it is cur…Tom John Bontoyan 21 views 2 comments 0 points Most recent by Anusha B S Reporting and Analytics for HCM -
Seeded Head Count Reports Not WorkingSummary: We have been trying to run the seeded Head Count reports for our client but none of them have been rendering data. Content (please ensure you mask any confident…Vibha Pandey - Oracle 42 views 3 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Location Based Access Control (LBAC) and it's Impact on Linkedin IntegrationSummary: Hi All, We are implementing LBAC in our Fusion Application. For 3rd party applications we are whitelisting their IP address and making Roles Public. But we have…Prashant Kumar - 2103 31 views 2 comments 0 points Most recent by Anil Rout-Oracle Applications Security -
Scheduled classes not available in Learning Calendar Summary dashboard?Archived Learning Calendar Dashboard from Oracle demo instance. and unarchived dashboard in our instance. Data is displaying like this but, in oracle demo instance it is…YAMINI DANTOORI 22 views 1 comment 0 points Most recent by AmyLopesNF Reporting and Analytics for HCM -
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. -
How to suppress values in OTBI?I've created an analysis under User System Usage subject area. I'd like to suppress the values like on what I've drawn below: Though I've already configured it to the co…