Reports
Discussion List
-
Workforce Management - Accrual Real Time/Worker Assignment Event Real TimeSummary Issue when combining subject areasContent Hi! Really hoping someone can help with my query. I would like to show the annual leave absences taken by month for a p… -
Learning Hours ReportContent Hi, Has anyone created or come across a report showing the actual or attempted start and stop time of a learning class/course? Thank you!Dishti Malhotra-Oracle 47 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Competency ReportSummary developing a competency report using otbiContent Dear All, Which work area is suitable to create a report to check the competency name, the target competency, th…Michael Nega Gebrehawariyat 41 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
HCM – Product Office Hour: OTBI, 30 September 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the HCM – Product Office Hour: OTBI, September 2020 session to have them answered during the live event. Post your questions by posting…Heather Hagedorn- Cloud HCM-Oracle 40 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis not workingSummary Report has stopped workingContent Hi, One of our most popular reports has stopped running all of the sudden - it seems like I'm the only person who can still run…User_2025-02-05-22-44-35-842 46 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Unable to un-deploy the SDM template post renaming the Entity dimension nameSummary Unable to un-deploy the SDM template post renaming the Entity dimension nameContent Hi, I have renamed the Entity dimension name from JPPL to ENT_01. Post refres…Pradeep Kumar-230381 24 views 2 comments 0 points Most recent by Pradeep Kumar-230381 Tax Reporting (Direct Tax)
-
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
Max Scheduled Reports RowsContent I've found this post from a long time ago that discussed 25k as a max for scheduled reports. I'm still encountering this even with csv. Is this the limit on sche…User_2025-01-31-00-25-12-234 27 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Latest Start DateSummary Is there a latest start date field in OTBI? Need length of service in current assignmentContent Hi, I have a report that calculates the Time in Service of employ…User_2025-02-05-22-44-35-842 44 views 20 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Custom Member ListSummary FCC Custom List in Financial ReportingContent Hi - I am new to FCC and trying to find out is FCC support creating Custom Member list or function ? Thanks KrishnaKrishna Srinivasan 35 views 2 comments 0 points Most recent by Krishna Srinivasan Financial Consolidation and Close
-
Pivot self-assessed tax amount from a column to a row in an OTBI ReportSummary Pivot self-assessed tax amount from a column to a row in an OTBI ReportContent Currently, we have an OTBI report using the subject area “Payables Invoices – Tran…James Cusson 35 views 0 comments 0 points Most recent by James Cusson Reporting and Analytics for ERP
-
NRA Year to date EarningsSummary Trying to find the NRA YTD 8233 Earnings for an employeeContent Can you please suggest how to get this balance in Subject area. Please see the below Navigation: …
-
Calculated cloumn is not having value with decimals (Expected value --> 383/12 = 31.9 but current vaSummary Using TIMESTAMPDIFF function getting total months between two dates(Ex: 383 Months) when dividing 383 with 12 (383/12) current value coming as 31.0(383/12 =31.0)…User_2025-01-30-17-37-30-647 35 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
How can we have a Notification when an employee becomes a line manager ?Summary How can we have a Notification when an employee becomes a line manager ?Content Hello, We would like to have a notification that will trigger when a user is assi…Revital Mefano 45 views 2 comments 0 points Most recent by Abhishek Nigam Reporting and Analytics for HCM -
Latest Hire Date in OTBI without using Seniority DatesContent Hi All, We have a requirement at our project where we need to get the “Latest Hire Date” for any Person in OTBI. The challenge is Seniority dates are not exposed…User_F89L9 149 views 2 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Management Reporting Functions to Include Multiple UDAs of the Same DimensionSummary Multiple UDA's on a Member referenced by the Property Function in Management Reporting Returns Bad InformationContent Currently, in Management Reporting, there i…
-
How can i find BI Tables easily?Summary How can i find BI Tables easily?Content How can I find BI tables where specific data is stored, I spend so many times trying to map and also get a table I want f…Michael Nega Gebrehawariyat 85 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…Elisa Fernandez 52 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Tuning a rolling 12 Months turnover reportSummary How to performance tune a trend based report when using Ago and Rolling PeriodContent Hello Experts! In my ongoing saga of working with the trends subject area t…Rob F 154 views 4 comments 0 points Most recent by Abhishek Dixit-Oracle Reporting and Analytics for HCM -
How can I get assignment manager list details when subject area doesn't have themSummary Subject area doesn't contain assignment manager listContent Hi I am trying to adapt a report for direct reports to a line manager only. However I've noticed some…LynneLBL 19 views 3 comments 0 points Most recent by Virginia M. Calvi Reporting and Analytics for HCM -
Absence balance reportContent I am trying to create an absence balance report for each accrual plan by employee. The report would look like the attached using the "Employee Plan Participation…Annette M 128 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Missing direct deposit or personal payment end dateContent We are finding that we are deep into payroll processing before we recognize an employee forgot to enter their direct deposit information and a paper check is a r…
-
Unable to apply decimals precision to Workforce OWP_Basic Salary (Out of Box member) column in WorkfSummary The precision for dollar values of Salary is not working despite of setting it to Min/Max 0Content Hello Experts, We have created a data form from Workforce Repo…
-
Infolet for line managers visible to all employeesSummary Issue with none manager workers viewing Line manager's InfoletContent Hi, I am new to creating Infolet's and I have been able to create an Infolet for our manage…User_2025-01-30-03-54-32-528 147 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Agents for scheduling reportsSummary Can I move a live agent to a different folder?Content Hi, I want to tidy up some folders and would like to move several agents that are currently active (in use)…User_2025-02-05-22-44-35-842 22 views 2 comments 1 point Most recent by User_2025-02-05-22-44-35-842 Reporting and Analytics for HCM
-
How to get Request Id at runtime for the BI-Publisher ReportSummary How to get Request Id at runtime for the BI-Publisher ReportContent In the custom reports, the business users are expecting to capture the Request-Id/Report-Job-…
-
Dashboard with auto refreshSummary Need to know if there is a possibility to auto refresh dashboard to show 'live' view when it's openContent Hello, I was wondering if it is possible to auto refre…User_2025-01-28-05-11-13-165 100 views 5 comments 7 points Most recent by Max Prestes Reporting and Analytics for HCM
-
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 35 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to Fetch the Direct reports of Line Manager as of specific dateSummary How to Fetch the Direct reports of Line Manager as of specific dateContent Hi Team, PFA catalog of analysis. We have created an analysis which we use to pull the…
-
Query help needed to determine duration in job code, title, pay gradeSummary Query generates a list of the job code, title and paygrade combinations for an employee with start and end datesContent Hi All, I have seen several queries regar…User_2025-02-04-08-51-08-912 24 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM