Category 81
Discussion List
-
OTBI report is erroring outSummary: An OTBI report is giving error. Would appreciate if anyone can share your inputs. Content (please ensure you mask any confidential information): Version (includ…Global Support Desk 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI report for compensation plan is giving errorSummary: An OTBI report developed for a compensation plan is giving below error for few users. For other users, it says there is no data. But in edit mode, the report is…Swetha Kesireddy 10 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Oracle criteria to identify OTBI reports with specific column in itHi All, We are migrating to V3 Seniority Date from V1 Seniority dates. This migration is impacting our OTBI reports which are using ‘Enterprise Seniority Date’ column. S…Manikya H M 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Fusion table for Employee Vacation and Delegation rulesWe want to develop a custom BI Report for Employee Vacation and Delegation rules. However, we are currently facing some challenges in identifying the correct tables that…Srikanth Nakka 65 views 2 comments 0 points Most recent by Eric-Oracle Reporting and Analytics for HCM -
Role assignment historySummary We have a requirement from the customer to track the history of changes on a user roles. Ex, If a user has been assigned a role on 01-Jan then that user was term…Srihari Manian 11 views 2 comments 0 points Most recent by Srihari Manian Reporting and Analytics for HCM -
How to add oracle cloud url in RTF templateSummary: Am trying to add login url( oracle cloud url) from ask_deployed_domains table. when we click on link it is throwing error. {COLUMN_NAME} using this in address o… -
OTBI report prompt to display only direct reports for Line managersSummary: We have created an OTBI report using the subject area - 'Workforce Learning - Learning Management Real time'. We have created a prompt which displays all the Em…Sovan Mishra-Oracle 534 views 10 comments 0 points Most recent by User_E783Q Reporting and Analytics for HCM -
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t… -
I am looking for a report to validate or find missing goals in PerformanceSummary: I am looking for a report where it has Employee number, Name, Performance Document Name, Goal Period Name, manager, and Goals Status(Has goals or No goals ) Con… -
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 7 views 1 comment 0 points Most recent by NamrataPhukan Reporting and Analytics for HCM -
Saved but not submitted Promotability assessment questionnaire responses from Talent assessmentWe are trying to report on 'saved but not yet submitted' Talent Assessment Manager evaluation responses, using multiple avenues but not getting intended results. Subject… -
Absence Plan: Monthly Accrual That Expires at Month-EndHi, I want to create an absence plan where each employee receives 1 day of leave every month (this part is clear for me). The requirement is that if the employee does no… -
Populate if an employee is a Manager in HCM OTBISummary: I'm trying to create a report in OTBI with the subject area Worker Assignment Real. And in the Worker Assignment folder there is Manager Flag. However all our p… -
"Taken Absences" field in "Front-Loaded Plan" shows not-yet-taken as well as taken absencesSummary: We have front-loaded accrual plans for annual leave and have a requirement to report on taken absences at the end of each month. The "Taken Absences" data item …Michelle Hughes 5 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
How to Generate a Unique Reference Number for Each Report in Oracle Fusion HCMHello Oracle Community, We have a requirement to generate a unique reference number for each report generated in Oracle Fusion HCM, specifically for documents like lette… -
SQl query to find Default and Override Formula in HCM Compensation planSummary: SQl query to find Default and Override Formula in HCM Compensation plan Content (please ensure you mask any confidential information): Version (include the vers…Annam Rama Krishna 4 views 0 comments 0 points Started by Annam Rama Krishna Reporting and Analytics for HCM -
How to create custom employee role that only gives read-only access to payroll documents of record?Summary: We have a requirement, for a specific group of employees, to create a custom employee role that solely gives read-only access to payroll Documents of Record (th…Michelle Hughes 9 views 2 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM -
Convert Double Data Type to Words in OTBISummary: I am trying to build a report (OTBI analysis) where a double data type field (the Amount column) needs to be displayed in words. For example, if the amount is 3…Nur Anisa Zulkhairi 27 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I …Pablo Calizo 136 views 5 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM -
Logical SQL not returning dataSummary: I have built a report using logical SQL is not returning expected data - possible subquery issue Content (please ensure you mask any confidential information): …Helen Thomas 44 views 13 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM -
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
Can you help me with sql query to fetch performance feedback comments ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…VenuJayanth_21 9 views 2 comments 0 points Most recent by VenuJayanth_21 Reporting and Analytics for HCM -
Unable to show the image file from UCM server in BIP report in pdf output (in html its comming )Summary: We are storing signatures in Document of records and we need to pull these signatures in the report output which is in pdf format. Content (please ensure you ma… -
The value is not falling in the backend tables for Extra Withholding column in calculation card.There is a requirement to fetch Federal Tax form details from My Workforce > Payroll > Calculation Card > Tax Withholding. In this section, there is a specific column na…SameekshaShrivastava 5 views 0 comments 0 points Started by SameekshaShrivastava Reporting and Analytics for HCM -
Tables for Helpdesk Service Request to capture Journey assignedSummary: Hi All, We recently implemented Journey's integration with Next gen helpdesk in which agents can assign journeys to end users. We have used Journeys to send a h…VishalDhane_HCM 19 views 3 comments 0 points Most recent by VishalDhane_HCM Reporting and Analytics for HCM -
How to Restrict Modification of Certain Contexts in Person EIT Information Using EFF SecuritySummary: Hello, We are currently working with Extensible Flexfields (EFF) on Person EIT Information. Our requirement is to restrict modification of certain contexts whil… -
[Sharing_BIP Report]: Redwood Profile Option Code listSummary: Extract list of Redwood Profile OptionCodes with value Content (please ensure you mask any confidential information): Some customers ask if there is any report …Sandy Suo-Oracle 289 views 9 comments 8 points Most recent by Sandy Suo-Oracle Reporting and Analytics for HCM -
Buyer Assignment Rules OTBI ReportGood Day Experts, Is there a way to create an OTBI report to show details and information for Buyer Assignment Rules? Screenshot below is the view from Fusion Applicatio… -
can we add element entry section under hire an employee, change assignment page in redwood VBSSummary: Hi , Can we add element entry selection into Hire an employee, change assignment, Convert Pending Worker ,Local and Global Transfer, Promote and Transfer pages …KanchamMaheswar 30 views 4 comments 0 points Most recent by KanchamMaheswar Human Capital Management -
OTBI report created using the subject area "WFM - Document of Records Real Time" is not showing dataSummary: I have created an OTBI report using the subject area "WFM - Document of Records Real Time" which is not showing all the data, no filters applied still only one …Elavarasan S 35 views 10 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM