How to escape single quote in Oracle SQL

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

Customize Oracle Disbursement Separate Remittance Advice Formats Report

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 are creating a template in xslt 1.0, but this template has been built in xslt 2.0 before

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

Oracle Fusion xml data source file for Disbursement Separate Remittance Advice Formats Report

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

Oracle BI Desktop Error: Java version has value ‘1.8’, but ‘1.7’

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’

Oracle BI Desktop RTF tag shows value ref:xdoXXXX

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

Script for Creating a Credit Memo (AR)

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)

Create Oracle OIC instance in OCI

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

Oracle Fusion BI Error 500–Internal Server

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