OTBI
Discussion List
-
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…User_2025-01-28-20-11-21-100 779 views 3 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
OTBI project costing assets subject area filtering on in-service date results in no recordsI created an OTBI analysis using the project costing assets subject area. See fields in the screenshot below. The analysis returns correct results. However, when I filte… -
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the …Cindi Jacobsen 11 views 3 comments 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP
-
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…User_2025-03-07-18-57-57-349 801 views 3 comments 2 points Most recent by KashifRaza Reporting and Analytics for ERP
-
can we get the amount/numaric value in words in Polish language for OTBI ReportsGenerally we uses the function iby_amount_in_words.get_amount_in_words to display the amount/numaric value in words in English language for OTBI Reports. I would like to…Yugandhar2249 11 views 3 comments 1 point Most recent by Yugandhar2249 Reporting and Analytics for ERP
-
Connect Oracle Database Actions to Oracle Fusion ERPSummary: Connect Oracle Database Actions (SQL Developer Web) to Oracle Fusion ERP Content (please ensure you mask any confidential information): Are we able to connect t…
-
Which subject area can I use for procurement contract agreement deliverablesSummary: Which subject area can I use for procurement contract agreement deliverables? Content (please ensure you mask any confidential information): Version (include th…Cindi Jacobsen 21 views 2 comments 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP
-
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…
-
LSQL print first valueSummary: Moved to SCM Reporting and analyticsVDM_IM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for ERP -
Purchase Order Reports not showing line quantityWe have an OTBI (BIP) report for Purchase Order details using Procurement - Purchasing real time. The Quantity field for Quantity based POs is not populating, are any fe…Andy McIlroy 31 views 4 comments 0 points Most recent by Andy McIlroy Reporting and Analytics for ERP -
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 81 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management
-
Hello, I need help with SQL query joining 3 subject areasSummary: Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performan…
-
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
What table store approval rules configuration in FusionSummary: We are looking tables name for approval rule configuration. Navigation: Tools>Transaction Console>Approval Rules Content (please ensure you mask any confidentia…
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.2K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Enable All or Multiple selections from a Pivot Table prompt in OTBISummary The Pivot Table prompt should allow the selection of all or multiple items.Content We have a requirement to allow the selection of All or multiple items from the…User_2025-02-10-09-42-00-128 288 views 7 comments 0 points Most recent by P G Reporting and Analytics for ERP
-
Procure-to-Pay RT subject area - approver nameSummary Procure-to-Pay RT subject area - approver nameContent I am attempting to update my existing P-to-P reports to leverage the P-to-P RT subject area; this subject a… -
UCM Bursting not working for Fixed Assets Seeded ReportSummary: Issue in UCM Bursting for Seeded FA report Content (required): Hi, We are trying to create bursting for seeded FA What-If Depreciation Analysis Report to push o…Vaigu_27 51 views 1 comment 1 point Most recent by Dinesh Krishna Mamilla Reporting and Analytics for ERP
-
Can anyone please share OTBI dashboards for procurement?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
I have to create a actual vs budget amount report for revenue and expense accounts in OTBI.Summary: I have to create a actual vs budget amount report for revenue and expense accounts in OTBI. I have used GL balances real time subject area. The columns selected…
-
Validation Status from AP InvoiceSummary: I am creating the Data Model of our BIP Report and I need to find out which field from what table should I use as Validation Status. Content (please ensure you …
-
OTBI reportOTBI reportVineet Srivastava Graviton 21 views 1 comment 0 points Most recent by Erick.B Reporting and Analytics for ERP
-
SQL query to display Purchase Category hierarchySummary: SQL query to display Purchase Category hierarchy Content (required): For anyone who might find this useful, I've written a SQL to pull the Purchase Category hie… -
Convert this filter to SQLSummary: Convert this filter to SQL does not function Content (please ensure you mask any confidential information): I try to using 'Convert this filter to SQL' function…
-
Logged in User display on OTBI reportHi Team, Both below do not generate the logged-on user at filter condition on OTBI once moved into 24A even if a person's security profile is active on view employee's o…Sudha Gopal 181 views 1 comment 0 points Most recent by Catalina Soare-Oracle BI Publisher Learning Center
-
Import Oracle Fusion Data Extensions for Transactional Business Intelligence having an impact.Summary: There's an issue with HCM Reports having said that some columns were not available and the root cause of it was when Import Oracle Fusion Data Extensions for Tr… -
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…Alan-Oracle 879 views 14 comments 16 points Most recent by Mohamed Attia-Allah Reporting and Analytics for ERP -
How to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real TimeHow to pass last 2 quarters as period parameters in General Ledger-Transactional Balances Real Time We are trying to create a Analysis report based on General Ledger-Tra…Pradeep1947 1 view 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
How can i get currency report to show currencies and the exchange rate against a currency in OTBIIgnore- Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Supplier Registration DFFs after Next-Gen Supplier Self-service Registration ImplementedSummary: After implementing the Security Policies against Value-sets linked to Supplier Registration Descriptive Flexfields, these flexfields are no longer available in …