Category 81
Discussion List
-
what is the diffrence between reports and extracts where we can we the extractsSummary: Hi Team, what is the diffrence between reports and extracts where we can we the extracts ? How can we learn, i'm new to extracts. Thanks, Ajay Content (please e…AjayKumar Maddipati 26 views 6 comments 0 points Most recent by VijayKumar R Reporting and Analytics for HCM -
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 112 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM -
Which tables stores the information for Manage Benefit ProvidersSummary: Which tables stores the information for Manage Benefits Provider Content (please ensure you mask any confidential information): Which tables stores the informat…
-
Tracking relatives in the same companySummary: I'm interested to know if anyone has tracked relatives or other relationships of employees working in the same company. We want to avoid having relatives workin…Rose_BOH 22 views 6 comments 0 points Most recent by Anna Klapisz-Oracle Reporting and Analytics for HCM -
Looking to Create a Reports Landing Page for HR Users in OTBILooking to create a Landing Page for HR users when they land in OTBI, to allow them to see Developed Standard Reports curated by the business. Would like to have links t…Patrick Scally 32 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
INFORMATION_TYPE is not unique IN PER_JOB_EXTRA_INFO_F table for same job title.Summary: Integration is failing due to sql not returning data for INFORMATION_TYPE ='EIT'. In BIP report INFORMATION_TYPE is coded 'BMC Grade Details' How the INFORMATIO…Ankush_Jadhav 12 views 2 comments 0 points Most recent by Ankush_Jadhav Reporting and Analytics for HCM
-
How to automate the distribution of reports weekly to specific roles within the specific department?We need an automated system to distribute reports on a weekly basis to all users holding the Line Manager role within the Head Office department. How would I do that? Th…
-
Average salary by compensation zone (getting sum instead of average)Summary: I am trying to create a report that will show Minimum, Average and Max salary for each compensation zone (Market A,B,C,D) using Compensation - Salary Details Re…Ameya_J 42 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…Deepak Bhatt 21 views 1 comment 0 points Most recent by Asmita Barman Reporting and Analytics for HCM -
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 23 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Dynamic Date parameter in OTBISummary: I have a requirement to get output depending on date parameter user will provide from prompt . how can i achieve this in OTBI report Content (required): Version…Sudipta007 555 views 8 comments 0 points Most recent by Hassan El Bouihi-Oracle 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…Thulasi Ram 439 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to extract employee grade ladder in the assignment pageSummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query to retrieve the employee current grade ladder. Howeve…Valerio Curzi 389 views 3 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
How to pull only one field for Person Legislative Information > CountrySummary: I am attempting to pull an employee file that includes which country an employee lives in. I am using the subject area "Workforce Management - Person Real Time"…joshvanlaan 21 views 4 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Logic to calcuate LOP days including the public holidays and weeklyoffsHi , I able to find of the absent days of employee for a month. Now i need help in deriving the logic to include weekly off and holiday if these days falls in between 2 …
-
Need help with SQL query for Time and LaborI have a query which times out with a single view, even after creating a report with it and scheduling it. When I raised this with Oracle support, I got to know that its…
-
Disable and Migrating BI Publisher JobsGood Day, For OTBI Agents, we can set it to disable if we do not want it to run. How about for BI Publisher Jobs? Is there a way to disable it? I cannot find any option …
-
Records for Cancel Workrelationship and Reverse Termination scenarios in new subject area in 24AIn 24A , oracle have introduced new subject area - Assignment Action Occurrence Real Time , allows you to report on all HR Actions and reasons associated with the worker…Manisha Singh 246 views 31 comments 0 points Most recent by Melissa Shropshire Reporting and Analytics for HCM
-
OTBI agent monitoringSummary: We have scheduled OTBI agents, We cannot able to find a way to monitor the agent status - whether its active? - Whether its still running? - how long its runnin…Prabhu Krishnamoorthy 125 views 7 comments 5 points Most recent by Louis K.Emezina Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 82 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How to combine multiple max formula criteria in OTBISummary: I'm having trouble pulling in all employees latest Seniority Dates. It seems I need to pull in 2 criteria: 1. LATEST Seniority Change Start Date & LATEST Senior…
-
SQL unexpected token errorI have the below section as part of a long query that keep spitting out the error code: Encountered unexpected token: "(" "(" at line 188, column 13. Was expecting one o…alliebaker 45 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
SQL with statement window function errorHello! I am trying to run a window function to rank the rows in order to remove any duplicates (code below). I am getting the error "ORA-00923: FROM keyword not found wh…alliebaker 13 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for HCM
-
How to report on worker attachments and correlate to the Performance Document they were uploaded in?Summary: Hi all, My organization has our workers uploaded attachments as part of their annual performance reviews. In attempt to properly maintain full performance recor…kdt8672 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Information about who rejected the rejected absence recordsHi, I need to add information about who rejected the rejected absence records to my report. When I use the 'fa_fusion_soainfra.wftask table', I cannot access it for reje…Cansel Karasoy 13 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM -
We need to create one OTBI analysis to display current and previous year calendar for Learning.Summary: We need to create one OTBI analysis to display current and previous year calendar for Learning . How can we achieve this? Content (please ensure you mask any co…Piyal Basak 35 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
report about changes the employee has madeSummary: Content (required): Good morning, Is it possible to have a report about changes the employee has made to Personal details, Additional personal details, and Bank…
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Is there a way to restrict access in shared report foldersSummary: My colleague and I would like to be able to share reports with eachother but we don't want to others in the business being able to see or use them. Is there any…