Apart from creating Data Set based on Database query, there are other option as well to get data from other sources. Soap Web Service is one of them.Note: Web Service as data source may be deprecated as data source in upcoming Oracle Fusion ERP Versions. First step is to create Data Source for the web … Read more Call Web Service From Fusion BI Report
You may need to update or query data where quote character comes in between string values. To query or update columns, there are two ways to achieve: Alternative Quote Operator ( q'[Text containing Quote e.g. Invoice Id‘s]’ ) to escape quote symbol in SQL. update xx_ap_invoices set attribute1 = q'[Test’s]’ where invoice_id = 123; select … Read more How to escape single quote in Oracle SQL
This is an Oracle Fusion Payables seeded report for Remittance advice output format against Supplier’s AP invoice payment. Although Oracle provides this standard seeded report which can be used but many a times based on particular client requirement the format of the report needs to be changed.Note: Only RTF format can be customized for this … Read more Customize Oracle Disbursement Separate Remittance Advice Formats Report
You may get above error message when you to edit Oracle BI RTF which uses xslt tags in Windows word. By default, BI Publisher is compatible with XSLT 1.0. But If you wish to use XSLT and XPath 2.0 features in your template you must disable XSLT 1.0 compatibility. This configuration is performed at the … Read more You are creating a template in xslt 1.0, but this template has been built in xslt 2.0 before
This is a seeded report for the Remittance advice output format against Supplier’s AP invoice payment. The delivery of the this report output can be configured to send to supplier which is a another set up altogether. You can customize this seeded report to change the layout. But you will not find any Data Model … Read more Oracle Fusion xml data source file for Disbursement Separate Remittance Advice Formats Report
After Oracle BI desktop is installed, you may get above error when you load XML source file and preview the report in any particular format. This happens usually if required Java version is not correctly installed or Java Home path is not set correctly for BI Publisher Setting. Open the rtf file and go to … Read more Oracle BI Desktop Error: Java version has value ‘1.8’, but ‘1.7’
RTF template for Oracle report contains XML data tag which maps to the data source tag value (XML tags). Sometime these xml data tags automatically changes to <?ref:xdoXXXX> format when opened in RTF. This is because of fields compatibility (BI Desktop version) with MS Word. This issue can be fixed by changing BI Publisher Setting. … Read more Oracle BI Desktop RTF tag shows value ref:xdoXXXX
DECLARE l_return_status varchar2(1); p_count NUMBER; l_msg_count number; l_msg_data varchar2(2000); l_batch_id number; l_cnt number := 0; l_batch_source_rec ar_invoice_api_pub.batch_source_rec_type; l_trx_header_tbl ar_invoice_api_pub.trx_header_tbl_type; l_trx_lines_tbl ar_invoice_api_pub.trx_line_tbl_type; l_trx_dist_tbl ar_invoice_api_pub.trx_dist_tbl_type; l_trx_salescredits_tbl ar_invoice_api_pub.trx_salescredits_tbl_type; l_customer_trx_id number; cnt number; v_context varchar2(100); Cursor list_errors IS Select TRX_HEADER_ID, ERROR_MESSAGE from ar_trx_errors_gt; /* Cursor to get the user id information based on the input user name / CURSOR … Read more Script for Creating a Credit Memo (AR)
Oracle launched Oracle Integration Cloud (OIC) mainly to help developer: Integrate SaaS application with on premise and vice-versa (Integration). This got widely popular amongst companies using Oracle Fusion SaaS ERP as using Integration one can exchange data with SaaS ERP and other systems like On-premise EBS, any Database, SAP, Workday and many other existing Cloud … Read more Create Oracle OIC instance in OCI
Error From RFC 2068 Hypertext Transfer Protocol — HTTP/1.1 When you click on Browse Catalog to access BI service for reporting, you get below error: Also you get error if you try to connect analytics using /xmlpserver or /analytics https://<hostname.domain>/oraclecloud.com/analytics/ or https://<hostname.domain>/oraclecloud.com/xmlpserver/ This error occurs when there is conflict in GUID of BI Catalog and … Read more Oracle Fusion BI Error 500–Internal Server