Category 81
Discussion List
-
Offer Accepted Date and Offered Date returns an errorSummary: When we try to add the fields to our OTBI report Offer Accepted Date and Offered Date we received an error. We have tried to apply what the following post says … -
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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
-
How to obtain a drill down OTBI bar chartSummary: How to obtain a drill down OTBI bar chart Content (please ensure you mask any confidential information): Hi, we created a dashboard based on a OTBI Report. The …Barile Alberto 37 views 3 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 15 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Human Capital Management
-
Is it possible to use an EFF in a case statement in OTBI?Summary: I am working on a report trying to calculate days between LOA End Date and the Estimated RTW Date (EFF) in the system. The case statement is producing an error,…
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
BI Publisher Sending a report to FTP Server with SSHSummary: How do I schedule a report to be delivered to a destination configured with SSH authentication? Content (please ensure you mask any confidential information): H…
-
Issue with formatting totals in OTBI Analysis TableSummary: I have a simple analysis coming out of the Benefits - Enrollments Real Time Subject Area. I have set the Department Name as a Table Selection. I have formatted …Jason Snipes 22 views 7 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…Fatima Claire Benito 31 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
Drill Down in the OTBI does not work correctlySummary: Drill Down in the OTBI does not work correctly Content (please ensure you mask any confidential information): Hi, we created an OTBI report. The extracted data …Barile Alberto 22 views 3 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Benefits Override Eligibility reportSummary: Is there a way to report on the employees and benefits that have been Overridden using the Override Eligibility in Benefits please. Content (please ensure you m…OsborneT 4 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
How to get the assignment name for an OTBI analysis?Summary: I need to know which subject area and fields I need to use, to get the employee assignment name for an OTBI analysis. Content (required): Assignment name Versio…Ayesha Iroshani 69 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 -
People Leaders Workbench DocumentationSummary: Hello, A team member was at Oracle Cloud World and asked me to research how to get more information related to the People Leaders Workbench (see screenshot). I'…Karen Florig 379 views 4 comments 0 points Most recent by Durga Prasad Tavva 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… -
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 22 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 49 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 13 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 59 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 22 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM