Category 81
Discussion List
-
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 21 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 591 views 8 comments 0 points Most recent by Hassan El Bouihi-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 521 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, https://us.v-cdn.net/6…
-
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 251 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 121 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 101 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 51 views 5 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
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 11 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 21 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 11 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 31 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 21 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…
-
Is it possible get a output in text format from bip report oracle fusionSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Nagendra Chitra-Oracle 201 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
SQL query needed to fetch "Calculate Payroll", "Make EFT Payments" process and employee detailsSummary: We want to create a BIP report in Oracle Fusion cloud to get the "Payroll Flow" name for "Calculate Payroll" and "Make EFT Payments" i.e. to get the payroll flo…
-
Why does Terminated user access not revoked for reportsSummary: Hi, When we assign add User to any reports/report folder under permission, and that User get inactivated, this user access doesn't get revoked automatically. Do…Namrata_20 11 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
query to get the location based country and restrict the country based on the regionSummary: query to get the location based country and restrict the country based on the region Content (please ensure you mask any confidential information): For ex Regio…Sravanthi Kamatham 181 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Report showing below error when we open through edit and result viewSummary: Hi Team, we have OTBI report but that report when we open through edit and in result view getting below error but when we open directly open button no error com…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Advantages and Disadvantages of OTBI seeded dashboardsI'd like to know how the seeded Line Manager Dashboard works when it was copied to the Custom folder. If Oracle made some changes on the seeded Line Manager Dashboard, d… -
offer approval notification template to include Requistion Approval History, Candidate CV etc.Summary: We have requirement to Include Links to Requisition Approval History, Candidate CV and Interview Feedback within the Offer Approval Notification template. Is it…
-
How can we pull data of all staff employed between a financial year in OTBISummary: Date Range would be - 1 April 2023 - 31st March 2024 Content (please ensure you mask any confidential information): Version (include the version you are using, …
-
OTBI Data as of yesterdaySummary: Hi there, I am trying to use the historical reporting capability of OTBI by inputting the logical SQL prefix of SET VARIABLE PARAM_EFFECTIVE_DATE='xxxx-xx-xx'; …Ruby Hui 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to align Prompt labelsI am trying to align the Date Between Prompt Labels as the ‘Please select dates’ and ‘Between’ labels not aligned at runtime. Prompt created based on Calendar date: the …