Oracle Fusion list of seeded reports

If you want to know what are the list of seeded or standard reports which are prebuilt in Fusion application, follow below section. Navigate to Oracle Docs website (https://docs.oracle.com)Search for specific module, e.g. Financials Click Analyze and Report and then click View Financials analyses and reports. This will download excel report which has list of … Read more Oracle Fusion list of seeded reports

OIC BASE64Decoder: Error in encoded stream

This error is encountered when one tries to map opaque element for Write File operation in stage file Action to any non base64 decoded reference. This can be due to mapping to string reference or any file content reference. Error Message:BASE64Decoder: Error in encoded stream: needed 4 valid base64 characters but only got 3 before … Read more OIC BASE64Decoder: Error in encoded stream

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