Category 81
Discussion List
-
How to add Days to Worker Hire Date in HCM Alert TemplateDear Team, Need help in rectifying below expression. ${AlertUtils.addDays(workers.workRelationships.StartDate, 10)} I need this add 10 days to hire date of an employee t… -
Want to fetch row values based on another column's value.I want to print mid salary values which are highlighted in screenshot, based on columns "overtime" and "grade rate name".Raja Subramanian-Oracle 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
how to fetch top 10 otbi reports that users access frequentlySummary: The request is to fetch the top 10 OTBI reports that users access frequently on their dashboard Content (please ensure you mask any confidential information): R…SivaNallagatla 38 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Facing issues with Users setup for AORSummary: I want to segregate users based on Departments for Time and Labor reports but the same users when associated with Departments are restricted on the Learning sid…
-
Reports under Workforce Compensation planSummary: Hello experts, Please let me know where can I find the details of delivered reports available under Workforce Compensation and related data models. Thanks, Cont…Vaishnavi Agrawal 25 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Report or SQL Query to Identify Unused Departments in Department TreeHi Team, We’re looking to generate a report that identifies unused departments within our department tree. Specifically, we’d like to find departments that: Have no asso…Mahendra Y 2 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM
-
OTBI Report shows wrong annualized salary and annualized full-time salaryOTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensation - Sal…Kiran Devraj-Oracle 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Access to customize reports in Publisher greyed outHi all, Hoping someone could assist with an issue regarding access to customize reports in Publisher. The user has BI Author and BI Admin. The folder permissions for the…G. Class-Peters 22 views 0 comments 0 points Started by G. Class-Peters Reporting and Analytics for HCM -
NETWORKDAYS Logic In BI ReportHi , As a Business requirement we want to get the Working days between 2 days. I tried to get this using below query. But getting 0 as output. (select count(*) from tabl…GaneshSKulkarni 3 views 0 comments 0 points Started by GaneshSKulkarni Reporting and Analytics for HCM
-
Generate Employment Letter from Employee Self ServiceSummary: Hello Experts, We have a requirement to develop the Employment Letter from the system from the employee self service. We have checked in the delivered Document …Jaydeep.More 13 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Not able to view seeded template at the seeded path after customising the reportI have customized the seeded template for the US Payslip report and it is present at the custom path:/shared/Custom/Human Capital Management/Payroll/Payment Distribution…Aditya Jadhav 24 views 4 comments 0 points Most recent by Aditya Jadhav Reporting and Analytics for HCM
-
Exit Interview - ReportingSummary: Can we report exit interview responses on a terminated employee Content (please ensure you mask any confidential information): Hi, We plan to use exit interview…Vijay Mamilla 194 views 3 comments 0 points Most recent by Nazila Dabestani Reporting and Analytics for HCM -
How To Edit Payroll flow report as it is seeded Gross to Net ReportThe data model and report are both seeded for Gross to Net Report. Can you please let us know if the Payroll Flow can be altered to call custom reports as we would like …Srujanya Dodda 39 views 3 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM
-
Individual Compensation plan data not populating on a reportSummary: our Division Admins can see Additional pay amounts for ICP's on the compensation screens but when they run a report no data displays for the ICP for them. We ar…
-
OTBI/BIP catalog/folder last update date differenceHI Team, After a refresh/upgrade/patch getting applied does the folder last modified date change for each folder. We could see some folders have different last modified … -
query object permissionswe are looking for the physical tables or BI publisher SQL that will allow us to see the permissions for the objects in our catalogs (data models, report templates, prom…
-
Need to get the OTBI Schedule Agent Information Report Jobs.Summary: Content (please ensure you mask any confidential information): We need to the details of OTBI agent schedule report jobs when the report was run details, who ra…VishnuVardhan Raju 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to restrict the data in OTBI report based on AOR (Area of Responsibility)We have created HCM reports from the Absence module, Goals and performance, etc. and we need to restrict the data based on AOR. Is it possible to restrict the data in th…Vikas V. Kamat 186 views 7 comments 0 points Most recent by GPOtimization Reporting and Analytics for HCM
-
Need inputs to restrict OTBI reports only based on the AOR roleSummary: Need inputs to restrict OTBI reports only based on the AOR role for users that have both AOR and Line Manager data access roles. Content (required): We have cre…Sakthi priyanka B-Oracle 231 views 3 comments 1 point Most recent by GPOtimization Reporting and Analytics for HCM
-
OTBI Worker Attributes Changed After Redwood EnablementSummary: Our reports stopped working in Production after migrating to Core HR Redwood. We’ve observed changes in OTBI column attributes when comparing Redwood and non-Re…Josel Pleyto 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?Summary: Hello team! I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you …Claudia Linares L 97 views 13 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…
-
Absence calendar seeded report does not show any dataSummary: Absence calendar report does not show any data Content (please ensure you mask any confidential information): Could someone advise why does the data does not po…Nancy Dsouza 5 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Document of Record Drill to Document DetailsSummary: This report uses Deep Links for Document Records to navigate directly to the worker's DOR from the report results without additional clicks or navigation. Conte…Melanie Mahon-Oracle 193 views 4 comments 7 points Most recent by Samantha Collins Reporting and Analytics for HCM -
Need to calculate month on month attrition percentageWe need to calculate month on month attrition percentage on the basis of formula = (Attrition count of that month *100)/(Average of (Headcount as of first day of month a…Shaarif_Hussain 36 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Create an alert or mail delivery system for a sequence in OACI have a sequence in OAC. The sequence has multiple data flows present. I need to setup some sort of alert so that I get an alert in case a data flow fails. How to get t…
-
In Help Desk SRs, what is the time frame for a Resolved SR to transition to Completed/Closed statusSummary: Hi, In Oracle HCM Help Desk, what is the time frame for a Service Request in Resolved status to automatically transition to Completed/Closed status? Could someo…Prasad Singamaneni-Oracle 13 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
The label 'Time and Absences' needs to be updated to 'Time and Any Time Away'Summary: The label 'Time and Absences' under the navigation path Me >> Time and Absences (Tile) needs to be updated to 'Time and Any Time Away' Current Behavior The labe…Rama Krishna_Annam 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to fetch the physical address of Geo coordinates that we have in Time records?Summary: On the OTL page, we can view the latitude and longitude of the geo-location from which an employee submits their timesheet. Additionally, there is a button that…ManikandanRajagopalan 27 views 4 comments 0 points Most recent by ManikandanRajagopalan Reporting and Analytics for HCM
-
How to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F tableHow to link ANC_ABS_USAGE_RULES_F and ANC_ABSENCE_TYPES_F table select * from ANC_ABS_USAGE_RULES_F usage_rules where ABS_USAGE_RULE_ID =300000134481566 -- ABSENCE_TYPE_…Rama Krishna_Annam 12 views 1 comment 0 points Most recent by Carl Bequilla-Oracle Reporting and Analytics for HCM