Category 129
Discussion List
-
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 323 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 32 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 63 views 1 comment 0 points Most recent by Dhruvjoshi23 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 126 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.9K 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 932 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 31 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 266 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 31 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 84 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 43 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 81 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 262 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 87 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with…Anders W. Langholm 21 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
How to put current financial year filter to date columnSummary: hi we are developing an Otbi report to find out the revenue recognition amount for the current financial period, can any one suggest us, how to put the filter o…
-
Having issues with BI Report. Wont pass multiple selections on ParametersSummary: I have the following attached report where when attempting to select multiple parameters such as Expense Status or departments I encounter the ORA-00909 error. …RRR RRR 83 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
Bi Publisher - How to read the content of an attachment using sql script in data modelHi, We have a requirement in BI Report, to check for the attachment at Supplier Profile and if the attachment is present then we need to read the content of the attachme…Nepal Bhumireddy 509 views 8 comments 0 points Most recent by Nepal Bhumireddy Reporting and Analytics for ERP