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
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
Fusion UCM server URL : https://podDomainName/cs/ Replace podDomainName with your Fusion URL and append “/cs/”. If you have proper role access for UCM you would find UCM server login as below Once logged in successfully, you can see UCM search screen You can search for ESS job in Title using text as – ESS%100% , … Read more What is Fusion UCM server URL
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
When you login to Oracle Fusion, you do not get option to archive or unarchive reports. This is because the user does not has access to BI related roles. You need to to create custom job role for BI and then assign it to users. Go to Tools > Security Console > Create RoleIf you … Read more Unable to Archive or Unarchive BI report in Oracle Fusion BI
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