To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver… -
Database connection in FRS reporting studioSummary: New COA is not available when trying to create new database connection FRS reporting studio Please advise Content (required): Version (include the version you a…
-
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…
-
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…
-
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…
-
Dynamic recipient email to be picked from OTBI analysis columnsSummary: We prepared an OTBI report where tasks to be started on the current date, task owner, task owner email, and project manager email is displayed. We need to sched…
-
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 …
-
Oracle Fusion Cloud - Fields/recordsSummary: Hi, I am new to using Oracle Fusion Cloud and coming from Peoplesoft. Is there any kind of view or extension on a page in Fusion where I can find field names an…
-
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 … -
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…
-
What is the equivalent role of "EBS Workflow Administrator" in Cloud Fusion?Summary: What is the equivalent role of "EBS Workflow Administrator" in Cloud Fusion? Which role can be used in Cloud Fusion for you to see workflow notifications like f… -
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…
-
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…
-
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…
-
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…
-
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_B
-
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… -
A fresh environment with no dataSummary: A fresh environment with no data Content (required): Dear all, I would like to ask if a test or production instance can be refreshed, but not as p2t or t2t, so … -
Provision a Vision Demo Instance for Customer WorkshopSummary: We are going to conduct the initial round of the requirement gathering workshop for a customer. Can I know if there is option for us to provision a Vision demo …
-
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, Soumya -
How to add dynamic logo to a BI Report ?Summary BI Publisher : Dynamic LogoContent Good People, How to add dynamic image from an URL / website to RTF template ? Or we need to have it fixed always ? Thanks, Sou…
-
Can we write PLSQL in BI Data Model ?Summary Is PLSQL supported in ERP Cloud ?Content Good people, Can we use PLSQL in BI Data Model ? If so is there any documentation on the same ? Thanks, Soumya
-
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 …