Category 129
Discussion List
-
BIP output calling an external webserviceSummary: BIP output calling an external webservice Content (required): We have a report that we'd like to export the data to a third party, but to improve integration, w…Luis Gustavo 31 views 4 comments 0 points Most recent by Luis Gustavo Reporting and Analytics for ERP -
Privileges required to view output on a custom version of a seeded reportSummary: Privileges required to view the output of the Import Project Budget report when a custom copy of the seeded report has been created (relevant to any seeded repo…LawrenceKillick 131 views 3 comments 2 points Most recent by LawrenceKillick Reporting and Analytics for ERP -
Is there any query to get the outstanding invoices for the specified monthSummary: Query to get the outstanding invoices for the specified month Content (required): We need to send a csv report to a customer which contains the outstanding invo…sunny.k.singh 573 views 4 comments 0 points Most recent by sunny.k.singh Reporting and Analytics for ERP
-
BICC costs to extract PVO from other serviceHi, As I am not sure on how particularly Oracle handles this area, I am trying to figure out the following scenario: we are trying to extract some data from Fusion using… -
Bank Payment File FormatSummary: Bank Payment File Format Content (required): Hi All, We got a requirement from the bank to modify the Payment file format . Currently the format is, R|DEBIT_ACC…
-
Unable to Deploy to BIP using Oracle SOAP ServicesSummary: Unable to use /analystics-ws SOAP Service to deploy a BIP Report (catalog file). Content (required): We use pasteItem2 operation of https:///analytics-ws/saw.dl…Shrujal Patel 51 views 2 comments 0 points Most recent by Shrujal Patel Reporting and Analytics for ERP
-
Secure access to Copy/Move and Paste for a report by rolesSummary: Separation of access for users based on report execution and access to copy and move reports Content (required): Our client has a requirement where they want us…
-
Need help in DataModelInSession SOAP ServiceSummary: Can someone share working payload of DataModel In Session SOAP Service to call Data model dynamically in Fusion? Content (required): Version (include the versio…sailesh_cloudare 41 views 0 comments 0 points Started by sailesh_cloudare Reporting and Analytics for ERP -
How to create actual vs budget and variance report?Summary: Hi, We have loaded our budget on budgetary control. We are now trying to build a report with budget vs actual amounts and variance between the two. However, ora…ShailenS 934 views 4 comments 0 points Most recent by Linda Wong-Oracle Reporting and Analytics for ERP
-
How to add new Column in seeded Subject area Receivables - Transactions Real TimeSummary: I need to add column as Ready for XML (select READY_FOR_XML_DELIVERY_FLAG from RA_CUSTOMER_TRX_ALL ) Content (required): Version (include the version you are us…Amol Pachpande 31 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 71 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
What data security policies are required for each financial Transaction Analysis Duty?Summary: I am trying to create a custom role that allows the user to run a custom OTBI report but I don't know what data security policies are required for the report. I…
-
How can we limit access to reports residing in delivered (out of the box) folders?Summary: How can we limit access to reports residing in delivered folders? Most of the users have access to BI roles (Consumer/Author/Admin) inherited through other role…Dibyanshu_Shekhar 41 views 2 comments 0 points Most recent by Dibyanshu_Shekhar Reporting and Analytics for ERP
-
Does exist a Job to update data in OTBI ?Summary: Does exist a Job to update data in OTBI ? Content (required): Dear All, we need to know if exist a Job to update data in OTBI. Thanks, Elisa Version (include th… -
Is there a lag period before OTBI displays new invoices/data?Summary: Hi everyone, I am running the Payable Withholding Tax report from Reports and Analytics. Navigation: Shared Folders/Financials/Payables/Income Tax and Withholdi…
-
How to remove ability to Create Shortcut in Reports & Analytics pageSummary: Within the Reports & Analytics page, we do not want users to be able to create shortcuts. How can we remove this ability from users? Content (required): Is ther…Akbar Ahmed 91 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Can custom PL SQL TABLE type in Fusion DB be createdSummary: Need custom PL SQL TABLE type in Fusion DB to use in BI report with Data Set Type as Procedural Call Content (required): In Fusion BI Report some complex valida…
-
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 101 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 313 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 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 119 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.8K views 13 comments 0 points Most recent by Agnes.Ramos Reporting and Analytics for ERP