OIC - How to Download a Used Schema from an OIC Integration

Introduction

While working on an Oracle Integration (OIC) integration, there may be situations where we need to retrieve the XSD schema that is already being used by an adapter or action.

Instead of creating the schema again, OIC provides an easy way to view and copy the schema directly from the integration configuration.

Use Case

Suppose an existing OIC integration is using an XSD through an adapter or an action, and we need the same schema for:

• Reference or documentation
• Creating another integration
• Troubleshooting
• Mapping or validation
• Reusing the schema in another integration

Solution

We can retrieve the schema directly from the Adapter Configuration – Summary page.

Steps

Step 1: Open the OIC Integration

Open the required integration and click Edit.

Step 2: Open the required Adapter/Action

Navigate to the adapter or action where the schema is being used.

For example:

• REST Adapter
• SOAP Adapter
• Stage File action
• Other actions where an XSD/schema is configured

Step 3: Navigate to the last configuration page

Complete/navigate through the adapter configuration until you reach the Summary page.

Step 4: Open the Schema field

On the Summary page, locate the Schema field.

Click on the schema name/field.

OIC opens a pop-up displaying the XSD content used by that configuration.

Step 5: Copy the XSD

From the pop-up, select and copy the complete XSD code.

You can then save it as an .xsd file or reuse the schema wherever required.

Example

For a Stage File action, navigate to the schema configuration and proceed to the final Summary page.

Click the Schema field.

OIC displays the XSD definition in a pop-up window.

Simply copy the complete XSD content and save it as:

Employee.xsd

Key Point

You do not need to recreate or upload the schema just to obtain the XSD being used by an existing OIC configuration.

Adapter/Action → Configuration → Summary → Schema → View XSD → Copy

Conclusion

This is a simple way to recover or reuse an XSD that is already configured in an OIC integration, especially when the original schema file is no longer available.

ERP- Generate PGP Key Pair in Oracle Fusion Using Advanced Create

Introduction

In Oracle Fusion, a PGP key pair can be generated from Manage Transmission Configuration using the Advanced Create option.

The generated key pair consists of:

• Private Key – securely maintained in Oracle Fusion.
• Public Key – generated by Fusion and made available in UCM.

The public key can be downloaded from UCM and subsequently used in Oracle Integration Cloud (OIC) for PGP-based encryption or other applicable security requirements.

This blog explains the complete process using Advanced Create.

Use Case

The objective is to generate a PGP key pair in Oracle Fusion and make the public key available in OIC.

High-Level Flow

Oracle Fusion

     |

Manage Transmission Configuration

     |

Advanced Create

     |

Generate PGP Key pair( private & Public)                   |   

Export to UCM

     |

 Download  keys to use in oic.

                         

Step 1: Go to Manage Transmission Configurations

Log in to the Oracle Fusion application >> Navigate to My Enterprise >> Setup and Maintenance >> Search >> Search with Manage Transmission Configurations >> click to open Manage Transmission Configuration

Step 2: Create PGP Key pair.

Select "Secure File Transfer protocol for static file names >> add a configuration name >> Provide PGP Private key password >>click on the dropdown list for PGP private Signing Key field >> select Advanced create option >>Select the PGP Key attributes as per required.

A typical configuration can include:

Key Type       : RSA

Key Size       : 2048 / 3072 / 4096

Expiration Date   : As per project requirement

Encryption Algorithm     : AES128/AES192/AES256

Hash Algorithm : SHA256/SHA384

Compression    : BZIP2/ZIP/ZLIB

Step 3: Export the PGP key pair.

Step4: Download keys from UCM

Go to fusion UCM : https://<fusion hostname>/cs > search with key name prefix and click actions >> info > click to download the file.

Step 5: Configure the Public Key in OIC

The downloaded Fusion public key can now be configured in OIC according to the integration requirement.

Public Key vs Private Key

Understanding the purpose of each key is important.

Public Key : The public key can be distributed to the system that needs to encrypt information for the private-key owner.

Private Key: The private key must be protected and should not be distributed unnecessarily.

It is used for operations such as:

• Decryption
• Digital signing

Conclusion

Using Advanced Create in Oracle Fusion's Manage Transmission Configuration provides a controlled way to generate a PGP key pair with the required cryptographic parameters.