Category 81
Discussion List
-
Employee Dates History ReportSummary: I have been asked to build a report showing an employees employment dates history; showing hire date, rehire date (if applicable), term date, and 2nd or 3rd ter… -
Manager Self Service ReportingQuestion: For MSS, did you enable self service dashboard reporting via OTBI? How did you reference trend analysis? Thank you.Clare Murtagh 13 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How do I re-enable download functionality of BI Publisher output when using Firefox?Summary: After Firefox updated to version 123 yesterday, Feb 20, 2024, we can no longer download BI Publisher output anymore. Content (please ensure you mask any confide…BeachDreamer 14 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
query to get the vendor email id by vender id in publish report..?Summary: query to get the vendor email id by vender id in publish report..? Content (please ensure you mask any confidential information): Version (include the version y… -
RTF Template creates incorrect word wrapping in output to PDFSummary: We have a company policy document that needs employees signature. We have an RTF template that contains all the verbiage and signature sections. When we output …Brian W 33 views 2 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM OTBI: OTBI Report Calculations IssueHi, I am facing an issue in OTBI which involves calculations. Please see the below example Column 1: SUM(Distinct TIMESTAMPDIFF(sql_tsi_month, "Worker"."Person Start Dat…Chaitra Lakshmi Krishna 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll ReportSummary: Hi, We are trying to find an easy way to run a Payroll Register report from OTBI. I found this seeded Payroll Register report but it has parameters that I am un…
-
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …AjayKumar Maddipati 3 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
can you append the sysdate to the file name while delivering the report through agents'Summary: can you append the sysdate to the file name while delivering the report through agents' Content (please ensure you mask any confidential information): Version (…SUSAN SANDIFER 14 views 3 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 22 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
Count Time Cards Approved by WorkerSummary: Trying to determine how many timecards there are for a worker that make up the Processed Time Cards.Processed Hours from the Workforce Management - Processed Ti…Jason Snipes 22 views 4 comments 0 points Most recent by Jason Snipes Reporting and Analytics for HCM -
otbi performance issuesSummary: we are using an OTBI reporting dashboard to get Worker Emergency contact details reported to a manager. After 24A upgrade, report is giving below error in one o…Surya_Meduri 54 views 4 comments 0 points Most recent by Surya_Meduri Reporting and Analytics for HCM
-
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate…SUSAN SANDIFER 46 views 5 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM
-
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 32 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
How to get the 'Plan Period Start Date' in absence plan balances?I am creating a report that would output each plan's balances by year. But this one sample, for 2023, its calculation started from 2022, it's a bit complex I think. For …notautomni9 325 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Annualized Full Time Salary not in Compensation TablesSummary: Looking for a workaround for CMP_SALARY table not reflecting the actual salary information ()Doc ID 2403581.1) Content (please ensure you mask any confidential … -
hr_org_unit_classifications_fSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…VarunMittal01 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Unable to access BI report using REST serviceHi, When I try to access BI report from postman it returns as 400 Bad Request Thanks -
How to fix legislation code in table per_person_names_f_v?Summary: The following query gives two different legislation codes for the same Employee due to which the extract doesnt pull the gender information for that employee: p…Shilpa Varghese 218 views 1 comment 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM
-
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 610 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie
-
Issue with converting UTC time to BRT timeSummary: When I run below SQL to convert time from UTC to BRT (America/Sao_Paulo), output is not correct. There is a difference of 1 hour in the output. I read somewhere… -
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …Sneha815353 32 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 13 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM
-
Can we call external application from BIP ReportSummary: 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 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Total Compensation Statement - AnalyticsSummary: Hi All, We have completed generating the Total Compensation Statements for our employees. However; we would like to know if is there any way to get the analytic…Santhosh Bachu 11 views 2 comments 0 points Most recent by Santhosh Bachu Reporting and Analytics for HCM -
ActivityAttemptNumber - QuestionsSummary: We are loading Learning Record V3 business object where we have ORA_COURSE and ORA_SPECIALIZATION as the Learning Item Type. We ran the query and found that the…P_SNG 70 views 2 comments 0 points Most recent by Sunder.Velagala-Oracle Reporting and Analytics for HCM
-
Validate employee and Manager hierarchy analysis - How to write?Summary: I am trying to write an analysis in OTBI which would provide an output of Employee and a Managers Level 2,3,4,5 Department. The aim of the analysis is to use as…Scott_Turner_ 32 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM