Category 81
Discussion List
-
To remove NULL row occurring due to CASE statementThrough OTBI report, trying to pull element entries having input value as STI Target %, Percentage only. So, put the following formula in the case statement: CASE WHEN "… -
Overall Summary and Rating in Document of RecordsSummary: Does anybody tried to bring the Overall Summary and Rating details from Performance to a Document of Record? Is it feasible to add those in a DFF? Content (plea…GeorgianaB. 1 view 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 33 views 2 comments 0 points Most recent by User_VB3A0 Reporting and Analytics for HCM
-
SYSTEM_PERSON_TYPE not updated to CANCELED_HIRE after Cancellation of work relationshipSummary: We used to get the employees whose work relationship is cancelled after Hire (from Pending Worker to Employee conversion) by querying the 'per_person_type_usage…Sujay Bhowmick 65 views 6 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Multi Language update to existing OTBI reportsSummary: Multi-Language: How would you create or update existing reports to pull in any language? Is there a way to update all reports simultaneously with the option to …
-
Subject Area for Exit interview survey Responses --> Which Subject area to use ?Subject Area for Exit interview survey Responses --> Which Subject area to use ?
-
Guidance on OTBI Report for Transaction Summary by RegionSummary: OTBI Report for Transaction Summary by Region Content (please ensure you mask any confidential information): Hello Experts, We have a requirement to extract tra…Vasanthakumar Ravi 3 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Reporting for Workers CompGood morning. I am in need to find a report that will show rates and also a worker's comp audit report. Has anyone had success with these types of reports.?Tisha Negrete 52 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 142 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM -
Fast Formulas for Candidate Selection ProcessesWe have requirement to candidate selection process. After the final interview, once one candidate is moved to the "selected" phase, other candidates should have to be au… -
Im trying to change the eligible start date of an element and trying to load using the HCM Data LoadSummary: I need to change the eligible start date and percentage values . Content (please ensure you mask any confidential information): This was the dat filr I'm using …User_7W2IP 11 views 1 comment 0 points Most recent by Madalina Danis-Support-Oracle HCM Data Loader (HDL)
-
Based on the parameter year i should get the data based on that year i should get the data.lets say the paramter is audit_year = '31-12-2021' the requirement is something that we should get the data based on the parameter i.e i should get the person record bas…
-
How to have a report send email that report is ready to be viewed in checklist?Summary: We would like to have a report send notification that the report is ready to be viewed in checklist. But, we do not wish to attach the report output to that ema… -
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
Report dashboard prompt showing error - ACIOA5LNSummary: Report dashboard prompt showing error - ACIOA5LN Content (required): One of the working BI report which uses dashboard prompt, suddenly stopped working and show…Swati U 3K views 17 comments 1 point Most recent by Aaron Epstein-261578 Reporting and Analytics for HCM
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…MDge 2 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
For OTBI Analysis not getting data in correct formatSummary: I am trying to built a analysis bases on 2 Subject areas Project Billing Revenue real time and Project costing Actual cost Real Time, this issue is like I am tr…
-
Chetana Pawar 768 views 2 comments 0 points Most recent by Maheswar Reddy Reporting and Analytics for HCM
-
How to disable "Allow worker to update key attributes"Hi to all, on goal management module, as a manager, when I try to add a goal on the employee's goal plan it is a checkbox "Allow worker to update key attributes", I know…
-
OTBI Added formula column and filter stopped workingSummary: I added a column from the Subject Area Recruiting - Recruiting Events Real Time of: CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition Histor…Kristin Montoya TWU 24 views 4 comments 0 points Most recent by Kristin Montoya TWU Reporting and Analytics for HCM
-
Case Statement error on Task Completion DateSummary: Hello, I need help to check if this case statement is correct. My case is if the "Step Completion Status" is 'Completed', it returns the "Step Completion Date";…
-
notification received is Redwood Users Delegation RolesSummary: Content (please ensure you mask any confidential information): The notification received is Redwood Users Delegation Roles. I need to know the OTBI path for thi… -
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Object Validation Rule for Salary Adjustment Percentage not supporting as expected.Summary: Object validation rule for Salary business object is triggering for conditions where Salary.Adjustment Percentage should generate error message. Condition is se…Gaurav Bhagwandas Bhojwani 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 22 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics for HCM
-
Can any one please tell what is column name which stores Auto approval by system in OTL ModuleWe have a requirement to find the list of records for those time cards which is automatically approved by system. Please let me know if there is any feasibility to achie…vpandian16 11 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management
-
Performance tile is showing an error when I'm in edit view but working when added to compound layoutSummary: I'm experiencing an issue where I have a few different Performance Tiles to highlight active, completed and total courses within the 'Learning Records Real Time…Stephanie McInnes 41 views 5 comments 0 points Most recent by Stephanie McInnes Reporting and Analytics for HCM -
Learning items with learning outcomes assigned are not displayedLearning items with learning outcomes assigned are not displayed. In the front we can see data according to this but not in OTBI. Using the "Workforce Learning - Learnin…User_DA2EL 13 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Report to identify Users when Clicked on Learning Tile under My Client GroupsSummary: Report to identify Users when Clicked on Learning Tile under My Client Groups Content (please ensure you mask any confidential information): I am looking to see…Thulasi Ram 11 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM -
Can't access report and analyticsSummary: Content (required): All the users can't access to Reports and analytics even in admin User. The error massage is Insufficient permissions You do not have suffic…LiorZiv 574 views 10 comments 0 points Most recent by Parth Trivedi-Oracle Reporting and Analytics for HCM