Tip
Discussion List
-
Data Persistency in Oracle Cloud - how long will Request Ids, Output/log files be available?Summary: is there any time period for which the request ids, output/log files of Oracle ERP Cloud Process/Job/ESS requests are made available? Or Will these be available… -
Calculate revenue % distribution for each project with in Business unitSummary: We have the below requirement Project1 Revenue amount-20 project2 Revenue amount-30 project3 revenue amount-16 Total BU revenue amount 66 (this is achieved by e…
-
How to fix envelope section in the first page when there are more than one page output in RTF?Summary: How to fix envelope section in the first page when there are more than one page output in RTF? Content (required): We have a requirement to fix the bottom secti…Abhilash K - Deloitte USI 32 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Setup dynamic column from analysis in subject line of email sent using AgentSummary: Setup dynamic column from analysis in subject line of email sent using Agent For ex: Email subject should include " Project Name: needs renewal" Any inputs on …Santhi Sree 103 views 11 comments 0 points Most recent by Santhi Sree Reporting and Analytics for ERP
-
Ability to create a Analysis report in OTBI from Manage External fileSummary: Hi How can we implement a process where a third party stores/sends/puts a file in a designated place, and we pull data from that file to create an OTBI report? …
-
Unable to pull data from FA_BALANCES_REP_GT table in the seeded Reserve Summary reportSummary Unable to pull data from FA_BALANCES_REP_GT table in Reserve Summary report due to this in an Oracle only internal reportContent I'm trying to find a table/table…User_2025-01-30-23-52-10-842 157 views 2 comments 0 points Most recent by Mirela Tomoiu-Oracle Reporting and Analytics for ERP -
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…El1a 42 views 6 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
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…
-
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…
-
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…
-
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…Soumya Prakash Parhi 91 views 6 comments 2 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
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, SoumyaSoumya Prakash Parhi 108 views 4 comments 1 point Most recent by Soumya Prakash Parhi 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 308 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 62 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Ability to do a SQL Query with Oracle Visual Builder Excel Add-in ?Summary: Hello, I would like to know if it is feasible to pass a SQL Query through the Oracle Visual Builder Excel Add in Content (required): There are not REST API to r…
-
How can we get the Ess job 'Approval Groups Report' output files as attachments on email?Summary: We were trying to run the ess job on ERP cloud called 'Approval Groups Report' and get the output files on mail as attachments. But we were not able to see the …sunny.k.singh 86 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Conditional Columns based on ParameterSummary Report Layout change based on ParameterContent Hi , I am using the "Receivables - Payment Schedules Real Time" subject area I want to have a parameter of Entered…Soumya Prakash Parhi 44 views 3 comments 4 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP
-
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …
-
Has anyone use SplashBi or Orbit Analytics before?Summary: We are reviewing some external vendor tools to work with Oracle EBS and want to know if anyone has used this before and can make some recommendations. Content (…michael.cordova 112 views 0 comments 0 points Started by michael.cordova Reporting and Analytics for ERP
-
Schedule BI Report > Schedule tab > UTC Time ZoneSummary: Schedule BI Report > Schedule tab > UTC Time Zone Content (required): Hello All, When we schedule a BI Report from the Schedule tab: it seems the Time Zone of t…Bernard T 22 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Unable to suppress columns in Smart View retrieveSummary: Apologies if this is the wrong forum on which to ask this - I have created a Smart View retrieve to extract data from ERP, however in Smart View -> Options -> D…Danny Emmerton 191 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Need a query to get negotiation approver list in oracle fusionSummary: Content (required): Hello everyone, I need a query to get negotiation approver list in oracle fusion.Please advise! BR, Sushan Peiris Version (include the versi…Sushan Peiris 258 views 1 comment 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Period name taken as a parameter tag display in a wrong format in excel outputSummary: Content (required): Hello Everyone, I recently created a BIP report using excel with the "xls" format and using the xml exported, I ,created the report in an ex…Sushan Peiris 146 views 3 comments 0 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Calculate difference between previous and current amountSummary: How to add a column for calculating the difference between yesterdays closing amount and todays opening amount Content (required): We have built a simple OTBI r…Stefan pettersson 46 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
How to send and unsend a report based on its content in oracle BISummary: How to send and unsend a report based on its content in oracle BI Content (required): Hi everyone, There's a requirement to have a certain report output mailed …Sushan Peiris 42 views 3 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
After a refresh from Prod to Test (P2T), is there a list of recommended processes to run?Summary: After a refresh from Prod to Test (P2T), no data is showing on neither the inquire on detail balances screen nor the budgetary control dashboard. Content (requi…Ed R. 592 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
Oracle Fusion BI Catalog Folder ControlSummary: Oracle Fusion BI Catalog Folder Control Content (required): We have encountered multiple times where users have accidently moved or made changes to BI Catalog F…Rihan Jameel 63 views 4 comments 0 points Most recent by Rihan Jameel Reporting and Analytics for ERP -
How to send BI Publisher reports to FTP folder from ESS jobSummary: How to send BI Publisher reports to FTP folder from ESS job Content (required): Hello All, I will appreciate your support in the following: When I schedule the …Bernard T 742 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Unable to locate Direct SQL option after upgrade 19ASummary Unable to locate Direct SQL option after upgrade 19AContent HI, I'm not able to location the Direct SQL option after upgrade the 19A. Can anybody suggest where w…Suresh Kumarasamy-Oracle 86 views 10 comments 2 points Most recent by Shyam Patel Reporting and Analytics for ERP