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 certificate for the end point URL. You can use Firefox browser to open WSDL. Click on security icon beside URL to download certificate and then upload certificate in OIC. Click Connection … Read more 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

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

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