OTBI
Discussion List
-
How to get the PO number from AP Distributions in OTBI?Summary: We are creating an analysis using "Payables Invoices - Transactions Real Time" and when trying to get Purchase Order number from Invoice Lines, it appears blank…Arshad Hanif 91 views 3 comments 0 points Most recent by Raj Rathor Payables, Payments & Cash Management -
Query to fetch departments with cost centre and cost centre managersSummary: Hi, i need a query with departments assigned to cost centre and cost centre managers. Please help Content (please ensure you mask any confidential information):…
-
Custom lovSummary: How to incorporate custom lov Content (please ensure you mask any confidential information): I have an existing audit report which has two prompts. 1. Employee …
-
Training Suppliers Details OTBI report not providing all the data in the UIHi, I have created the Training Supplier Details OTBI report from Workforce Learning - Learning Management real time subject area. However the records retrieved through …
-
How to Hide/Show Analysis in Dashboard Based on a Parameter ValueHello everyone, I’m working on an OTBI dashboard and need some guidance. The dashboard contains multiple analyses, and I would like one specific analysis to display only…Andriampeno Odilon 12 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Why does the contact owner field unavailable in CRM-OTBI?Hello, I need a report that requires contact details that were not associated to any accounts. I am using the Sales - CRM Contacts Subject Area. However, all I can get i…Ivony Ann Paula Salango 1 view 2 comments 0 points Most recent by Ivony Ann Paula Salango Reporting & Analytics for Sales
-
Learning Initiative not using most recent version of analysisHi, We have had an issue with initiative assignments based on analyses not running correctly since our golive in June 2024. Today we did a large batch training assignmen…
-
Best practice to implement technical bulletin?Summary: Our client currently has an alert/notification process for alerts to technicians when there is a change or notice which needs to be dispatched to maintenance te…
-
How to create custom filters and infolets in redwood screenSummary: How to create custom filters and dashboard in redwood Content (please ensure you mask any confidential information): We are looking to create several other filt…Abhishek Kumar Ranjan 7 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Maintenance
-
Display Department Title on all levels of Department Hierarchy OTBISummary: Need to pull a report of all levels of our Functional Department Hierarchy with Department level 1,2,3,4 Name, and Associated Department Title. Content (please …
-
Credit Limit not seen on the Hierarchy members of the Organization in CDMSummary: As per the below image on the documentation https://docs.oracle.com/en/cloud/saas/financials/26a/faofc/how-the-credit-limit-is-derived-in-a-party-hierarchy.html…
-
Requesting details on FDIHi Team, We are planning to implement FDI module ( Reporting ); and I am unable to get much details on FDI on CCC as well as on HelpCenter. Can you kindly assist on the …MDge 32 views 2 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
SQL query to fetch public holiday according to the work schedule of an employee.Summary: need a SQL query that fetches public holiday according to the work schedule of an employee. Content (please ensure you mask any confidential information): I nee…
-
Restrict BI Author Role to only create OTBI Reports, they should not have ability to edit BI ReportsHow to restrict the user having BI Author Role to only create & access OTBI ORC Subject areas reports only. Not having access & edit BI Reports for other work area like …Twinkle Dudani 71 views 9 comments 0 points Most recent by Surjith Kumar Reporting and Analytics for HCM
-
Create OTBI report with manager types other than Line ManagerSummary: We created a manager type for Time Keepers that we need to be able to report on for our time keeping system. We have only been able to find Manager Type = Line …Chelsea Holden 535 views 6 comments 0 points Most recent by Niru - Startek Reporting and Analytics for HCM -
OTBI Analysis - DFF Throwing ErrorSummary: I'm building an OTBI Analysis on the Product Management - Item Catalog Category Hierarchy Real Time subject area and pulling several DFFs under the Category fol…
-
Learning Subject Area and Organisation Structure Reporting PerformanceSummary: Hi, we have an issue where trying to filter on Org Structure for Learning reporting results in the reports either timing out or taking 10+ minutes to run for a …Kevin Robertson 1 view 0 comments 0 points Started by Kevin Robertson Reporting and Analytics for HCM
-
Assets - The following segment labels have misspelled BI Object Name setSummary: Hi What are correct spelled BI Object Name set for Assets. I have hit the following error: Regards, Bo Content (please ensure you mask any confidential informat…Bo Tøpgaard 92 views 4 comments 0 points Most recent by Santhosh_Krishnan123 Reporting and Analytics for ERP
-
Report on Parent Position's Current Incumbent when Position is vacantContent We need a way to report on the parent position's current incumbent when the position itself is vacant. The report that we created shows the incumbent name for bo…Joanne Chung 486 views 14 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
OTBI Analysis - Create Action Link for Workspace Activity SubtabSummary: Hi All, In Oracle Sales Cloud we have a workspace tab and we have a Activities subtab. I have an analysis report from OTBI where there is an Activity Title fiel…
-
Error While Customizing “Global Subledger Detail Journal Report” – Invalid Table Name IssueSummary We are trying to customize the Oracle seeded report “Global Subledger Detail Journal Report” located in: /shared/Financials/Fusion Accounting Hub. We created a c…
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Is there an easy way to add the infolets from classic Inventory Management page to Redwood page?We are going through the process of enabling Redwood pages for Inventory Management. We have enabled the Redwood Inventory Management landing page but noticed that the i…Francisco Carrillo-Robles 129 views 11 comments 0 points Most recent by Francisco Carrillo-Robles Inventory Management
-
Organization Calendar Events with Coverage Area Data Extraction QuerySummary: Query to extract Organization Calendar Events with Coverage Area (Geography) Content (please ensure you mask any confidential information): Hi, We have a requir…Vasanthakumar Ravi 1 view 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
Court Orders - Report on field called 'Order Reference'Hi all, I'm hoping this is a quick and easy question. I'm building a report to report on Court Orders and they've asked us to include the value from the field front end …
-
Salary not populating for some termed employees in Workforce Assignment Salary History Real TimeSummary: I am using Compensation - Workforce Assignment Salary History Real Time subject area and trying to build a report to populate all termed employees and their las…S. Johnson 11 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
I’m unable to see the LOT DFFs on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin We need to query items using the Maintain …