Reports
Discussion List
-
FRS General Ledger Financial ReportingSummary Combing Accounts and or Parents in FRS ReportContent Hello - does anyone know why we can't combine multiple accounts or multiple parents into one line on an FRS …User_2025-02-10-13-18-41-347 78 views 1 comment 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP -
GL reports on multiple ledgersContent Our client has close to 40 million journal lines across ledgers for a single period. They want a BIP report where they will only pass the ledger set and choose a…saravana maneeian subhramaniun 95 views 2 comments 0 points Most recent by CLAZAR-Oracle Reporting and Analytics for ERP -
FRS Report, calculation does not equal report TotalSummary A calculated value of four columns is off by less than $1 from the Report Total of those same four columnsContent Company 1 Company 2 Company 3 Company 4 Sum Rep…Dave Pucetas 32 views 1 comment 1 point Most recent by CLAZAR-Oracle Reporting and Analytics for ERP
-
How to create a Report with trend and costing dff details?Summary How to create a Report with trend and costing dff details?Content Hello , In reports OTBI type , the purpose was to get the cost trend details and also the cost …Revital Mefano 21 views 7 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Cross posting this idea in HCM Reporting and Analytics forum - ability to Audit OTBI report configuSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 718 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Custom OTBI content that we did not createSummary Why is there report objects under custom folder after install of OTBI that we did not createContent After our new POD was brought up I went into OTBI and I'm fin… -
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 34 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 156 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 20 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…