OTBI
Discussion List
-
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 21 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 6 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 12 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 21 views 2 comments 0 points Most recent by Tammy Hemmingson 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 55 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 44 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
-
Req staffing agent fields in OBISummary There are no equivalent fields to this in OBI so how can I report on this using the new Recruiting universe?Content I was asked to build a report showing our ope…User_2025-01-23-20-17-41-106 61 views 2 comments 0 points Most recent by FuriousSS 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 719 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
-
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 338 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
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 42 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 11 views 1 comment 0 points Most recent by Tammy Hemmingson 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 -
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_ 35 views 4 comments 0 points Most recent by Scott_Turner_ Reporting and Analytics for HCM -
{ELE_NAME} in FND_MESSAGES_TLWe have a requirement to display Message Name and Message Text in Payroll Message Report. We are getting these values from FND_MESSAGES_TL table. Now our client wants th…
-
BIP password change all extracts are failing - Need Solution or workaroundSummary: BIP reports password change all extracts are failing - Need Solution or workaround please Content (please ensure you mask any confidential information): Version…Ankusham Rakesh 22 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
How to limit values prompt values when using choice list values from SQL ResultsSummary How to limit values prompt values when using choice list values from SQL ResultsContent Hi All, In a dashboard Prompt we are using column prompts we want to limi…
-
how to fetch the direct report of the manager in otbiSummary: I am creating a journey and performance report in OTBI in which if a manger logs in then he need to see only his direct reporties. Content (please ensure you ma…Sindhuja Neerasa-Oracle 135 views 2 comments 0 points Most recent by Sindhuja Neerasa-Oracle Reporting and Analytics for HCM
-
Strange OTBI Error:[nQSError: 27046] Inaccessible columnSummary: Strange Behavior, getting the below error however respective Job Role/ Duty roles are assigned to the user but still users are getting the below error (Screensh…
-
How to Create a OTBI Analysis Based on Simple Logical SQLSummary How to Create a OTBI Analysis Based on Simple Logical SQLContent Hi Experts, I was trying to 'Create a OTBI Analysis based on simple logical SQL' While I was hop…AshishERPCloud 707 views 12 comments 2 points Most recent by Scott Leong Reporting and Analytics for HCM -
Eligibility tables for data modelSummary Eligibility tables for data modelContent I am having some difficulty creating a data model that i need for the report bursting. I want to create a report that wi…User_2025-01-22-19-28-29-985 98 views 6 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM
-
Convert Rows to Columns in OTBI from multiple subject areasSummary: Hi All, We recently went live with oracle HCM implementation. I have a OTBI report requirement where I need to convert fields containing multiple rows to separa…Ameya_J 159 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll Transfer statusContent Hi All, We are trying to display "Payroll Transfer Status" in OTBI and we are referring "Workforce Management - processed Time Cards Real Time" "Processed Time E…
-
Calendar Quarter column formatSummary: Hello, Could you please let me know how to change the format of column "Time"."Calendar Quarter" in OTBI subject area "Workforce Management - Workforce Trend Re… -
Column Formula to get bi-weekly salarySummary: I need to get the bi-weekly salary of the employees, dividing the annual salary by 26 ( pay periods). Content (please ensure you mask any confidential informati…Ayesha Iroshani 24 views 2 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM
-
How do you compare columns in a formula when the columns are in two different subject areas?Summary: Specifically, we are trying to compare the resident state (from Person Real Time) to the Worked State (from Calculation Cards Real Time - Location). I'm able to…
-
SQL Report Filter for Previous_MonthSummary: I am trying to create a filter in my OTBI report that will return Pay Date results from the Previous month. Any suggestions? Content (please ensure you mask any…