Category 81
Discussion List
-
Report Worker Details at Payroll Period End DateSummary: Is there a way that I can return the worker assignment details at the pay date of payroll period end date Content (required): I am building an OTBI report using…Sharon Harper 42 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Analyzing Skills and Competencies asked on Job DescriptionsSummary: We are looking for a Reporting or a Tool to expedite the following request from our VP Talent. Content (required): Is there some way we can pull a bunch of job …Alvaro Couto 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Publisher versionSummary: Need inputs to find the BI Publisher version in Fusion. Content (required): Need steps/sql query to find the BI Publisher version in Fusion. Version (include th…
-
Incorrectly formatted phone number in OTBI tableSummary: Content (required): Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two d… -
May I know use of below to screen hots of archive and unarchive of reportsSummary: Hi Team, May I know use of below to screen hots of archive and unarchive of report catalogue. from archive we have two options that is Keep Permissions and Keep…AjayKumar Maddipati 34 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
I can still see some of the factory folders even after removing the associated rolesHello, after applying Oracle method of hiding shipped folders in the catalog we still have some remaining that refuse to be hidden hehe. as seen below I logged in as a u…
-
when I open the PDF format output of Bi publisher report its not downloaded automaticallySummary: Hi Team, when I open the PDF format output of Bi publisher report its not downloaded automatically. any option to set the download the automatically when i open…AjayKumar Maddipati 60 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is there any way to automatically download the data and upload to FusionSummary: Is there any way to automatically download the data using BI Report and upload it back to Fusion Content (required): We have a requirement to generate some data…Dharmendra Shukla 54 views 2 comments 0 points Most recent by Bhaskar Konar 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… -
Is there any sql query for pulling BIP reports location/path?Summary: Is there any sql query for pulling BIP reports location/path? Content (required): BIP Report properties Version (include the version you are using, if applicabl…User_2025-02-05-14-11-28-072 400 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Job Agent Sending to Removed RecipientSummary: Job Agent Sending to Removed Recipient Content (required): I had an OTBI report job agent and needed to change the recipient list, however, after saving the new…
-
Narrow Chart Down to Top 10Summary: We are trying to create a bar graph of the top 10 jobs that termed for the year. Is there a way to only show the top 10 rather than all the jobs?Rebekah Gilday 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Add New Column Based on Days Between Two Dates ResultI'm using the Subject Area Workforce Management - Work Relationship Real Time. Below is a formula that calculates the number of days between Termination Notification Dat…
-
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…
-
Termination Bar Chart by MonthSummary: We are trying to make a Bar Chart to show # of term by Calendar Month but the format of the month looks strange. Is there a way to list Calendar month with name…Rebekah Gilday 2 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Last Day of the Previous Month Active HeadcountSummary: SQL for Period Start Active Headcount minus 24 hours Content: We are looking for a SQL formula that takes the delivered measure Period Start Active Headcount mi…Rebekah Gilday 22 views 2 comments 0 points Most recent by Rebekah Gilday Reporting and Analytics for HCM
-
Multiple keywords in single OTBI column filterSummary: Hello everyone, The client is building some OTBI reports and would like to include multiple keywords in one column filter by typing the text in and not selectin…PriyaPenugonda-SC 42 views 4 comments 0 points Most recent by PriyaPenugonda-SC Reporting and Analytics for HCM -
How to connect a course with specialization in OTBIHi Team, Can you please tell me How can we connect a course with specialization and how can we get the learning outcome of a person from the respective course. Thanks
-
HeadCount OTBI reportSummary: Hi all I added these subject areas in my otbi reports:- Workforce Management – Worker Assignment Real-Time Compensation – Salary Details Real Time Workforce Man…Deepak Bhatt 32 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
TemplateSummary: Hi all, Problem statement: I created the attached template in RTF-> linked to the report -> export the output in pdf but now client wants to have the output in … -
DFFs no longer available in applicable Subject AreasSummary: Production Report Errors - DFFs no longer available in applicable Subject Areas Content (required): Has anyone had issues with DFFs in Analyses? Beginning the a… -
Combine 2 Analysis Outputs in on AnalysisSummary: Content (required): I have requirement to report on the number of starters by user person type and leavers by user person type in the previous month and email t… -
Need help to find the oracle table name of columns in Payroll Employee deduction report using BISummary: In the BI report, I have the requirement to add these Columns in my report Columns 1) Period 2) Pay Period Start Date 3) Pay Period End Date 4) Deduction Amount…Deepak Bhatt 34 views 7 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Performance Rating- Self review Rating not populatingI am trying to pull a report with Employee calculated rating after worker self evaluation task is completed. The report was running last year with rating populated , how…Anita 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 43 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Is it possible to use Crystal Reports with Oracle HCM data?Summary: Is it possible to use Crystal Reports with Oracle HCM data? Content (required): I have had many years of experience with Crystal Reports in multiple HCM systems…Donna Valentine 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
How do I set an OTBI agent to only Email if there is data returned in analysis?Summary: How do I set an OTBI agent to only Email if there is data returned in analysis? Content (required): Hello I am trying to set up an agent but I only want to it t…Helen Thomas 22 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
Ethnicity- Multi resulting in errorSummary: I am trying to decode the multiple option selected in the race condition used: COUNT(DISTINCT "Worker"."Employee Ethnicity Code" by "Worker"."Person Number") > …Anita 52 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…VivekHCM 45 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
LSQL with Prompts inputs not workingSummary: I've got a combined subject area LSQL which looks at 3 possible input prompt which can be blank or filled with values by end users. I'm passing the prompt input…Rohan Fernandes 24 views 2 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM