OTBI
Discussion List
-
Need a report to get retirement accumulated depreciation.Summary: Content (required): Need an asset retirement detail report including the "Accumulated Depreciation" of retirement. The resort is needed category wise. Any idea … -
Unarchive ErrorSummary: I am unable to unarchive the BIP report to BIP and getting the below error. Tried in different browsers by clearing the cache, but still the same issue. Content…Satyanarayana M-Oracle 31 views 2 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Manager Filter and Direct Reports To FilterSummary Manager Filter to display the dashboard with direct and indirect reporting associates, and "Direct Reports to" filter Drive from Manager filterContent We have re…Prabhu Krishnamoorthy 73 views 8 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM -
Talent Review Prior and Latest N-Box AnalysisSummary: I am trying to capture the 2021 n-box and 2022 n-box of employees on Talent Review to find out if anyone has a change in the n-box. I created analysis but when … -
'Payroll - Element Entries Real Time' subject area does not display any data for Line ManagersSummary: I have built a OTBI Report using ‘Payroll - Element Entries Real Time’ subject area for line Managers to see who has Skills Allowance. I have deployed this repo…Vijay Gorania 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on Business Day2Summary: Need to schedule a BI Publisher report to run on Business Day2 Content (required): How to schedule a BI Publisher report to run on Business Day2 from schedule p…User_2025-02-11-23-30-56-074 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri General Ledger & Intercompany -
Is there a way in OTBI and/or BIP to automatically push a scheduled report to SharePoint?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Nigel Wiltshire-Oracle 51 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Calculated Field in OTBIHi, I have created OTBI report based on custom object in which I have field called Start Date and Number of months. I need to display calculated field called End Date wh…Mohammed Rafi 112 views 11 comments 6 points Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales -
Workforce Succession Management - Talent Pools Real Time Subject AreaSummary Reporting on Talent Pools through OTBIContent Has anyone had any luck reporting on Talent Pools through this subject area? I have been unable to get any results.…User_2025-01-28-08-47-04-905 34 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Payables to Ledger ReconSummary: Payables to Ledger Recon Content (required): Are there any improvement in this report, for, instance to add approvers or reviewers. How to treat differences ari…CraigX 11 views 1 comment 0 points Most recent by Alexandra Leanca-Oracle Payables, Payments & Cash Management -
Replicate Data in FusionSummary: We are looking for a tool or an app that can help us extract data from Oracle Fusion (Financials/SCM). Content (required): We currently create BIP reports to ex…sanjam1130 11 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM -
The new year budget is fewer COA segments from the last year budgetSummary Is there any problem when The new year budget is fewer COA segments from the last year budget,Content is there any problem when The new year budget is fewer COA …Yasmin Kennedy 35 views 6 comments 1 point Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany -
Need help on Logical SQL with Inner JoinSummary Need help on Logical SQL with Inner JoinContent Hi Experts, Does any one has a sample logical sql where inner join has been used.Sreedharan-Oracle 42 views 6 comments 0 points Most recent by User_2025-02-12-14-08-01-540 Reporting and Analytics for HCM -
Filters on multiple SA are not workingSummary: We are trying to create a new OTBI analysis, where we have a requirement to pull both the Worker assignment details and the person VISA details. So we used Work… -
previous Phase/State - recruitmentSummary: Is there a way of creating a OTBI analysis to show current Phase/State and previous Phase/State Content (required): We would like to create a report which shows…Mitch_123456 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
on-going resignations report - reporting on approvalsHello, could somebody please tell me how to extract this information from Fusion HCM, either as an OTBI or a BIP report? The business requirements: - we are using the jo…Geraud Andreux 61 views 4 comments 0 points Most recent by Geraud Andreux Reporting and Analytics for HCM -
General Questions on Reports Data SecuritySummary: Content (required): Also, I need to know if a user has 2 Roles: 1. HR Specialist Custom Job Role assigned to 'View all people' data security profile 2. HR Analy…Walid Hamdy 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report used in another ReportContent I have built a report that pulls a list of employee numbers based on a specific set of filters. I then have another report that pulls data based on the employees… -
Absence Attachment in Report OutputSummary Absence Attachment in Report OutputContent Hi All, I have a requirement in which i have to display absence attachment content in report output for each employee.…nitin Sharma 67 views 5 comments 2 points Most recent by Gretchen_Atienza Reporting and Analytics for HCM -
From where to get (table name) the value of Candidate Type When Applying field.Summary: From where to get the value of Candidate Type When Applying field.Content (required): Version (include the version you are using, if applicable): Code Snippet (…Awadhendra Tripathi 1.5K views 2 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM -
How to Add Sort Order to Table or GraphContent This document explains how to •Add a ‘sort order’ column to an OTBI report•Add the ‘sort order’ column to Table or Graph view•Hide the ‘sort order’ column on a P…User720640-Oracle 113 views 5 comments 10 points Most recent by Tsubasa Kokubu-Oracle Reporting and Analytics for HCM -
Does the Supplier Transaction Reports Dashboard can be generated for all SuppliersSummary: Does the Supplier Transaction Reports Dashboard can be generated for all Suppliers Content (required): Hello The procurement manager wants to review the perform…Cesar Saveedra 21 views 2 comments 0 points Most recent by martingabriel Kinovisques Supplier Management -
Cash Advance ApproverSummary: I need to add in the Approver for a Cash Advance into a custom report. Please can someone advise where in the database I might get it and wondered if anyone mig… -
Concat string values in OTBI/BI AnswersSummary: Concat string values in OTBI/BI Answers Content (required): Is there a possibility to have a function like listagg for strings in OTBI/BI Answers?Yves Chassein 433 views 4 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Learning Records Real Time Report cannot add Hire Date field without rendering an errorSummary: Content (required): Since the Learning Management - Learning Real Time Assignment Subject area has been deprecated, we've been directed to use 'Learning Records…Ivy__Valverde 11 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM