Category 129
Discussion List
-
Two basic BI Report QuestionsSummary: Hi - I am using a custom data model which contains a mandatory parameter. I have defined the report output to default to Excel. I have 2 questions - please see … -
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend… -
Need to perform YTD calculation over ap_checks_all for reportSummary: Hi Forum: my customer would like to insert a YTD column right after Payment_Amount (SQL is over ap_checks_all) but there is no seeded YTD in ap_checks_all table…
-
Unable to see Creation date of Project Enterprise Resources in any subject areasSummary: We have below requirements:- Report to be sent to resource pool manager when a resource with back dated date is entered (for ex: Resource is created with date 0…
-
In Cloud Data Model, is combining multiple Select using "With" Statement with trailing joins allowedSummary: Hi R&A forum: In a Data Model for Cloud ERP or Cloud HCM, is SQL beginning "WITH ( as " allowed ? See Code snippet. Thank you, Content (required): In a Data Mod…
-
ESS job for IICS web serviceSummary: IICS related ESS job in Oracle fusion Content (required): I have a requirement where I created an ESS with Webservice DM and created an ESS job. When submitted,…
-
Can you please help me to join AOR to ORC tables.Summary: Can you please help me to join AOR to ORC tables. Actually we are fetching HRBP and HR Administrator names based Legal employer, Country, Location and Organizat…User_2025-03-07-21-19-21-057 25 views 0 comments 0 points Started by User_2025-03-07-21-19-21-057 Reporting and Analytics for ERP
-
Delete BI Folder with permission set to OpenSummary: Delete option Enabled even when permission is set to Open Content (required): With admin user we created the following folder structure Shared Folders>Custom>Cu…Sahil_Makhiza 65 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
Any AP standard dash boardSummary: Hi, We are looking for any standard AP dash board for information like AP Aging, Supplier spending which can be enabled Content (required): Version (include the…
-
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
Send Report to Employee That Have a Certain RoleSummary: Our finance team is interested in scheduling a report to be sent to any employee who has a particular role. The report should have parameters set to filter for …David Rabalais 93 views 5 comments 0 points Most recent by David Rabalais Reporting and Analytics for ERP -
Smart view - OBIEE - ExcelSummary: When working with multible excel workbooks and connected to OBIEE in one of them, when shifting to another workbook the OBIEE extension tab always open. Content…johannoli 44 views 1 comment 1 point Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Is it possible to create a tile which will open a BI report?Summary: Is it possible to create a tile which will open a BI report? Content (required): Hello We would like to add a tile to the Procurement tab, that when you open th…Helen Thomas 358 views 3 comments 0 points Most recent by Helen Thomas Reporting and Analytics for ERP
-
AP Invoice Productivity ReportSummary: Hello, we are wanting to create a report that shows the productivity of our AP Specialists and wondered if anyone else has done something similar. The current s…hannah_barry 74 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
How to encrypt the bip report response with SOAP web serviceSummary: Hi Experts Currently the response from the SOAP web service returns the BIP report data in base64 encoded format but I want to encrypt the response in some othe…
-
How to send large attachments in BIP email deliverySummary: How to send large attachments in BIP email delivery Content (required): Email delivery failed in BIP for large report output. Below is the error, 'emailOutbox r…Ananya Sadhukhan 164 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
How do i make a report which i created via OTBI available to be submitted via Scheduled processesHow do i make a report which i created via OTBI available to be submitted via Scheduled processes ? Version (include the version you are using, if applicable): 22A (11.1…
-
Fixed assets OTBI cross-subject area reportingI have created a dashboard based on the Subject Area Fixed Assets - Asset Depreciation Real Time. My colleague is asking me to filter the records based on the asset stat…MaartenDIF 113 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Unable to view xml tags in RTF templateSummary: Content (required): Hello all, I'm facing difficulty in editing old custom reports and seeded reports since the XML tags are not visible as they should be. For …Sushan Peiris 324 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…Cesar Saveedra 65 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Fusion UI personalization not reflected immediatelySummary: Fusion UI personalization not reflected immediately Content (required): Hi Experts, We created one DFF for GST number and this field should be mandatory when th…
-
Need recommendation for Printer Model for Label Printing for a Manufacturing ClientSummary: Hi Team, we are trying to find recommendation for Printer Model for Label Printing for a Manufacturing Client. Any help you can provide would be really helpful.…Abhilash K - Deloitte USI 13 views 0 comments 0 points Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Would anyone with experience with OTBI be willing to serve on a panel with OATUG ERP CLoud SIG?Summary: I am the VP of the OATUG ERP Cloud SIG who is hosting a panel in September called " ERP / HCM Cloud: OTBI, Third Party – lessons learned / improvement opportuni…Jeff Hare CPA CISA CIA 32 views 0 comments 0 points Started by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Oracle ERP Cloud Financials and Oracle HCM Cloud seeded reports does not show up for usersSummary: We recently created a new user account for Oracle ERP Cloud 23A. The user can log in When the user goes to the Reports and Analytics tab and clicks the Browse C…Ram Shankar 64 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
BIP Data format on group-sumSummary: Content (required): I'm trying to create a report in BIP (in a RTF file). So I have used table wizard to create a for each on the values I need. In the actuals …Nicolas Vahman 47 views 4 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for ERP
-
Privilege required to get data for OTBI reports from General Ledger - Transactional Balance RealTimeSummary: Content (required): Hi, What is the privilege or duty role required to obtain data from General Ledger - Transactional Balance Real Time subject area for users …
-
Project Manager project reportSummary: We would like to build an OTBI report parameter that defaults to the current user as a prompt. Content (required): If i am signed in, I would like the report to… -
Cross Receivable Subject Areas in OTBISummary: Cross Receivable Domain in OTBI Content (required): Hi, I would like to know if there is a way to link the domain "Receivables - Standard Receipts Application D…Antoine.Kaiber 92 views 1 comment 0 points Most recent by Antoine.Kaiber Reporting and Analytics for ERP -
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 316 views 3 comments 0 points Most recent by Catherine Myrand Reporting and Analytics for ERP
-
No data in subject area Project Management - Task Management Real TimeSummary: Content (required): I cant see data in the OTBI subject area Project Management - Task Management Real time. Despite I can see the milestones the application. I…Nicolas Vahman 26 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP