Oracleshare

OIC Error CASDK-009: Unable to parse the resource javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: : unable to find valid certification path

HandshakeException error in OIC is thrown when new connection is created. This occurs because OIC expects valid certificate for the end point URL. Download…

Unable to Archive or Unarchive BI report in Oracle Fusion BI

When you login to Oracle Fusion, you do not get option to archive or unarchive reports. This is because the user does not has…

Call Web Service From Fusion BI Report

Apart from creating Data Set based on Database query, there are other option as well to get data from other sources. Soap Web Service…

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…

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…

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…

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…

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…

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…

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…