OTBI
Discussion List
-
How to delete an asset with Change in Cost Bonus rule tagged to the asset?Summary How to delete an asset with Change in Cost Bonus rule tagged to the asset?Content Hi Experts, Any suggestions on "How to delete an asset with Change in Cost Bonu… -
'Import Projects' ESS job is not coming in Search ResultsSummary 'Import Projects' ESS job is not coming in Search ResultsContent HI TYeam, We are importing Budgets using FBDI File for which we need to submit 'Import Projects'…
-
Folder permissions in OTBIContent Hi there, Does anyone have any documentation to summarise each of the folder permissions in OTBI (Full Control, Modify, Open, Traverse, No Access, Custom) and wh…JosieAppleby 325 views 5 comments 0 points Most recent by JosieAppleby Reporting and Analytics for HCM
-
Cloud Financials on Macbook / Mac OSSummary Is Oracle Cloud Financials supported on Macbooks/MacOS?Content Hi, I'm posting to find out what level of support is offered for Cloud Financials on Macbooks/MacO…Rehan Yusuf 89 views 1 comment 0 points Most recent by James McBride Reporting and Analytics for ERP -
Unable to see data correctly after combining multiple subject areas in OTBIContent I have combined 2 subject areas and from the Advanced Tab and clicked on dimensionality and applied SQL. But the data is not showing up correctly.Vatsala Bharadwaj-Oracle 28 views 1 comment 1 point Most recent by Krushna Sahoo-Oracle Supply Chain Planning and Collaboration -
OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysSummary OTBI - Worker Current and Previous Assignment and Salary Changes - 30 DaysContent Hi Friends, I have been working on this report and finally get it working now. …Mansur Khalil 89 views 7 comments 2 points Most recent by Janine Dorongon Reporting and Analytics for HCM -
Sample OTBI Dashboards and Reports - Supporting VideosSummary 4 videos to explain how to get the most value from the sample contentContent For anyone new to OTBI or familiar with the sample pack of dashboards and reports th…Caroline Gladwin-Oracle 996 views 23 comments 9 points Most recent by Anita Reporting and Analytics for HCM -
Employee Hierarchy - Fixed Hierarchy Level is always zeroContent We have loaded employees' and managers' data populated in the resource object and running the ESS job to populate the employee hierarchy. I see manager hierarchy…Srinivas Malyala-Oracle 38 views 2 comments 0 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 292 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Download or Export Item Pricing per CustomerSummary Customers need to know their pricing ahead of time, and it must be a physical copyContent I have a requirement to be able to export a price list for any specific…
-
In which tables can I find the budget balances?Content Hi, I need to know which tables Review Budgetary Control Balances uses, or in which tables I can find the following information: Tables I have already reviewed, …Edisson Gabriel López 71 views 2 comments 1 point Most recent by Edisson Gabriel López Budgetary Control
-
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a…
-
What-If analysis report calculating the new depreciation wrongly for NBV methodSummary What-If analysis report calculating the new depreciation wrongly for NBV methodContent Hi Experts, I ran the What-if analysis report for the given asset. Asset C…
-
Do we have any Subject Area to capture Available Quantity to ReserveSummary Do we have any Subject Area to capture Available Quantity to ReserveContent Hi Experts, Do we have any Subject Area to capture Available Quantity to Reserve , I …Ghanshyam M-Oracle 51 views 6 comments 0 points Most recent by Ghanshyam M-Oracle Inventory Management -
Query to find Ship to Contact Method on Header and Line level of Sales OrderSummary Query to find Ship to Contact Method on Header and Line level of Sales OrderContent Hi Guru's Can you please help me to find Ship to Contact Method on Header and…User_2025-02-11-07-07-59-045 433 views 4 comments 1 point Most recent by User_2025-02-11-07-07-59-045 Order Management
-
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…Lauren Owen 31 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Fixed Asset Summary ReportSummary FA Balance Summary Report for QTD and YTD by Asset CategoryContent Hello, We have a requirement of a Fixed Asset Summary report which shows the trial balances by… -
Statement of EarningsSummary Subject area for creating an Analysis in OTBIContent I would like to create an analysis using much of the information from the Statement of Earnings but adding m…Annette M 17 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
After GL Budget Data loaded, how can we refresh OTBI / Cube?Content Hi, We have loaded data into GL_BUDGET_BALANCES table using FBDI from here: https://docs.oracle.com/en/cloud/saas/financials/21b/oefbf/general-ledger.html#import…
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 33 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM