Category 129
Discussion List
-
Report to have budget transfers (Control budget)Summary: Content (required): We have a requirement to have a report to include the Budget transfers. We tried to get it from the standard reports however, there is no re… -
how to create a non-sso bi userSummary: how can I create a non-sso bi user Content (required): n/a Version (include the version you are using, if applicable):23A Code Snippet (add any code snippets th…
-
How to modify a seeded dashboard?Summary: Hi. We need to modify some elements of a seeded dashboard according to client requirements. Grateful if someone could provide standard procedures for modifying …ShailenS 97 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
how to viewing oracle saas BIP report history based on job id parameterHi Team, When we select the Schedule and submit the BIP report (after entering the job name) from catalog section , Currently the History the Report has Job name , owner…User_2025-07-18-07-26-59-885 290 views 4 comments 0 points Most recent by User_2025-07-18-07-26-59-885 Reporting and Analytics for ERP
-
OTBI Data Security - AssetsDo all Oracle saas ERP modules follow data access/role security for access to data. I have a user who has assets data availabiilty but does not have an assets role. Than…erpexpert03 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
Is it possible to set up automated reports splitting data by cost centre or spare 1 field?Summary: Business has the requirement of splitting a report by cost centre or spare 1 field and sending to different receipts based on the cost centre. This is to send a…
-
When we reassign an account to different collector - tasks do not moveWe are implementing advanced collection and noticing that when we reassign an account - to a different collector , strategy tasks do NOT MOVE to the new collector - they…Dhruvjoshi23 61 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
AP_Invoices joins for Supplier Detail where vendor_id is negativeSummary: Sql question, I am looking for ap_invoices_all joins where vendor_id is negative, for the following scenarios; - expense (vendor id = -10016), one time supplier…Robert of STAU 787 views 8 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Identify customer from ar_statement_deliverySummary: How to identify the customer from the ar_statement_delivery table Content (required): I have written a sql in order to identify the customer_name, account_numbe…
-
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…
-
Can we get the dynamic url in BI Publisher email notifications?Summary: When we schedule a custom BIP report, and once it is completed then system is sending an email notification with the status. In the email notification there is …
-
Give access of OTBI report to usersSummary: Hi We have build an OTBI report from a user who has BI Author role. And we need to give access of this report to other users. we have used Permissions in the OT…CS_Giri 112 views 2 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
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…
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A…Gene Garcia 1.6K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP
-
Does OTBI report follow Data Security enabled for usersSummary: Does OTBI subject areas enforce the Data Security Context values that have been assigned to users. For example, a user has been assigned one BU and One ledger, …
-
Extend SQL Query Timeout Interval for BIP Data ModelsSummary: Extend SQL Query Timeout Interval for BIP Data Models Content (required): We would like to understand if the "Server Value" for "SQL Query Timeout" parameter ma…ks1075 796 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Copying personal custom Dashboard to Shared Folder > Custom > Dashboards throws Error Codes: QM3V3HSummary: Moving a personal dashboard to shared folder throws error Content (required): User has a custom Dashboard created in My Folder >Dashboards They want other users…Service Desk Claremont 33 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 246 views 7 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
How quickly does Oracle make updates to federal reports?Summary: When the federal government makes changes to a federal form, such as the Federal Financial Report (FFR), how quickly does Oracle make this change to the report …
-
What are the steps to enable & implement SAML authentication in Oracle fusion & also at client sideSummary: We are using SOAP APIs host://idcws/GenericSoapPort operations - GET_FILE, GET_SEARCH_RESULTS, UPDATE_DOCINFO for consuming data from UCM that is extracted via …
-
How to move up one node in my xmlSummary: Getting data from one node up of xml Content (required): I have a template that gets the data from node . I need to also display columns from which is one leve…CKleu 11 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 32 views 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Open FRS report using a URL link from BI Tile or similar?Summary: Fusion Financials: How to open a FRS report via a URL link from a BI reporting tile or similar? Content (required): Is there any way to open a FRS report via a …Robert of STAU 81 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP
-
Historical Depreciation & Total Accumulated Depreciation from Depreciation Real time Subject areaSummary: I am trying to calculated the Historical Depreciation & Total Accumulated Depreciation from " Fixed Assets - Depreciation Real Time" subject area. There seem to…
-
Using Oracle Database Cloud Schema Service to access Oracle Fusion DatabaseSummary: Using Oracle Database Cloud Schema Service to access Oracle Fusion Database Content (required): in MOS article 1910762.1 it states "If the SaaS / Fusion service…Jeff Hainsworth 32 views 3 comments 1 point Most recent by Aaron Leggett Reporting and Analytics for ERP
-
update on subtemplateSummary: 1- i update on Award Approval Notification Report. 2- has template AwardApprovalNotificationBodyReport.rtf. 3- in this template i have multiple subtemplate like…
-
SQL query to generate Fiscal Classification Code on customer profile & site levelSummary: Need help in determining SQL query to retrieve fiscal classifcation code from customer profile & site level. Content (required): Hi all, What SQL query should I…
-
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…Sharas Vitalapuram 84 views 2 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP
-
How to download SSH Private Key uploaded in Upload Center?Summary: We need to download the SSH Private Key which was uploaded in the Upload Center of BI Administration. How to download it? Content (required): We need to downloa…Mohamed Iqbal Jahangeer 212 views 1 comment 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for ERP
-
How to send the BIP Report Output to Customer without Scheduling Cloud BIP ReportWe need to send BIP Report output to a mail id which is passed as parameter. We have enabled the Bursting it is working. But customer is not accepting to schedule the Re…Muthukrishnan-Oracle 83 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP