1. Import file-based data to Oracle Fusion Cloud Enterprise Resource Planning
  2. Prepare to connect to the ERP application

Prepare to connect to the ERP application

To connect to the Oracle Cloud ERP application, you must:

  • Satisfy certain prerequisites
  • Obtain the WSDL or event catalog URL
  • Assign required roles to a user
  • Configure Oracle Cloud ERP for event subscriptions
  • Review the procedure for uploading files

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the Oracle Cloud ERP Adapter.

Prerequisite Description
Subscribe to Oracle Cloud ERP This action enables you to create an Oracle Cloud ERP user account with the correct privileges. You specify this user account when creating an Oracle Cloud ERP connection on the Connections page.
Obtain the necessary Oracle Cloud ERP service catalog service WSDL URL or event catalog URL You must specify a mandatory Oracle Cloud ERP service catalog service WSDL (for accessing business objects) and optionally an event catalog URL (for subscribing to events).
Assign roles to the user Ensure that the Oracle Fusion Cloud Applications user has the required roles. These roles are required for enabling event subscriptions or selecting business objects.
Subscribe to events in Oracle Cloud ERP To subscribe to Oracle Cloud ERP events in an integration, you must create a CSF key. Create the CSF key from the Oracle SOA Composer instance located in the Oracle Fusion Cloud Supply Chain & Manufacturing (SCM) domain.
Upload files in bulk and insert data into Oracle Cloud ERP application tables

The Oracle Cloud ERP Adapter supports the loading of bulk data into Oracle Cloud ERP through integration with Oracle WebCenter Content. Oracle WebCenter Content enables you to perform bulk upload of files and insertion of data into Oracle Cloud ERP application tables.

Upload files to Oracle WebCenter Content

 The Oracle Cloud ERP Adapter supports the loading of files to Oracle WebCenter Content.

Obtain the Oracle Cloud ERP Service WSDL

You must obtain the Oracle Cloud ERP service catalog WSDL for accessing and configuring the inbound and outbound adapter to use either business objects or business services.

To configure the Oracle Cloud ERP Adapter, you need the serviceCatalog WSDL. The serviceCatalog WSDL is a catalog of all the services exposed by the Oracle Cloud ERP instance. The catalog exposes services from all the products, such as finance, project management, order management, inventory management, and so on.

For Oracle Cloud ERP, the service catalog WSDL URL is: 

https://ERP_Host_Name.fs.<data center>.oraclecloud.com/fscmService/ServiceCatalogService?WSDL

Assign Required Roles to an Integration User

To use the Oracle Cloud ERP Adapter in an integration, you must assign specific roles to an integration user.

Use the Security Console to manage application security such as roles, users, certificates, and administration tasks. Access to the Security Console is provided by the predefined Security Manager role. Access the Security Console as follows:

  • Use the Manage Job Roles or Manage Duties tasks in the Setup and Maintenance work area.

  • From the Navigator menu, select Tools.

    Select Security Console.

Configure Oracle Cloud ERP for Event Subscriptions

You must create a CSF key to subscribe to events in Oracle Cloud ERP. This key is required by the event handler framework when it invokes the integration. The credentials of the integration are managed by the CSF key. Create the CSF key in Oracle SOA Composer.

Ensure that you specify the following information correctly when creating the CSF key:

  • Create the CSF key name. The name must be a combination of the Oracle Identity Cloud Service ID and the name of the integration instance.

    1. In the upper right corner of Oracle Integration, click username menu, then click About.

    2. Copy the Identity Domain value (for example, idcs-638a2ce020e60c2881) and the Service Instance value (for example, oic1575).

    3. Assemble the CSF key value with the identity domain first and the service instance second (no space in between): idcs-638a2ce020e60c2881oic1575.

  • Create the CSF key with the Oracle Integration user account with which you sign in to Oracle Integration and not the username created when you subscribed to Oracle Cloud ERP.

  • Ensure that the CSF key password has not expired.

Configure Oracle Cloud ERP:

  1. Log in to Oracle SOA Composer with a user that has the SOA administrator role. Obtain the hostname and port from your administrator.
    For example, the SOA Composer URL is: 
     https://ERP_instance_name.fa.data center.oraclecloud.com/soa/composer
  2. Click Manage Security.
  3. Add the CSF key name.
  4. Provide the username and password that you enter to sign in to Oracle Integration.
    Don't enter the username and password created when you subscribed to Oracle Cloud ERP. The Oracle Integration user must exist in Oracle Integration and must be assigned the ServiceUser role. The CSF key entry in the Oracle Cloud ERP infrastructure stores the Oracle Integration credentials used by Oracle Cloud ERP. When Oracle Fusion Cloud Applications sends outbound requests to Oracle Integration (at runtime), it sends the credentials (username and password) of this account for authentication.
  5. Click Register.

Upload Files in Bulk and Insert Data into Oracle Cloud ERP Application Tables

You must satisfy the following prerequisites upload files in bulk and then insert data into Oracle Cloud ERP application tables.

  1. Create a user similar to the ERP Cloud Adapter connection user in the My Service Page. This user is linked to the Oracle Integration WebLogic security realm. The username must exactly match the Oracle Cloud ERP username. The password and email address can be anything. Ensure that you select the correct roles for the Oracle Cloud ERP user in the Oracle Cloud ERP application. The user must have the SOAOperator and Integration roles.
  2. Import the necessary certificates. In your browser, enter the Service Catalog WSDL URL:
    • The WSDL URL is:
      https://hostname:port/fscmService/ServiceCatalogService?WSDL
  3. In the WSDL, navigate to the X509 certificates section, found within the <dsig:x509Data> element. The following is an example:
    </wsdl:binding>
    <wsdl:service name="ErpIntegrationService"
        <wsdl:port name="ErpIntegrationServiceSoapHttpPort" binding="tns:ErpIntegrationServiceSoapHttpPort"/>
            <soap:address location="https://hostname:port/fscmService/ErpIntegrationService"/>
            <wsa:EndpointReference xmlns:wsa="http://www.w3.org/2005/08/addressing">
            <wsa:Address xmlna:wsa="http://www.w3.org/2005/08/addressing">
                https://hostname:port/fscmService/ErpIntegrationService
            <wsa:Address>
            <wsid:Identity xmlns:wsis="http://schemas.xmlsoap.org/ws/2006/02/addressingidentity">
                <dsig:KeyInfo xmlns:dsig="http://www.w3.org/2000/09/xmldsig#">
                    <dsig:X509Data>
                        <dsig:X509Certificate>
                        //Copy certificate 1
                        djfhisjfjkjs4637rYiucy4r84378495847ydfiu678ww7789474re873477HSsfyGkwe3847qdi378TY
                        </dsig:X509Certificate>
                        <dsig:X509IssuerSerial>
                            <dsig:X509IssuerName>CN=Cloud9CA-2, DC=cloud, DC=oracle, DC=com</dsig:X509IssuerName>
                            <dsig:X509IssuerSerialNumber>45631179900002566</dsig:X509IssuerSerialNumber>
                        </dsig:X509IssuerSerial>
                        <dsig:X509SubjectName>CN=FAEncryption, DC=cloud, DC=oracle, DC=com</dsig:X509SubjectName>
                        <dsig:X509SKI>aKdfjjkrueTY46372NeiHJ</dsig:X509SKI>
                        <dsig:X509Certificate>
                        //Copy certificate 2
                        jhKIp9845eiseroi4d9Jl094osie9r9w309cw0890w4809589348f958985e098siHDD985983558KJj9
                        </dsig:X509Certificate>
                  </dsig:X509Data>
               </dsig:KeyInfo>
             </wsid:Identity>
           </wsa:EndpointReference>
         </wsdl:port>
       </wsdl:service>
    </wsdl:definitions>
  4. Copy the first and second certificate string to two separate files. For example, erp_cert1.cer and erp_cert2.cer.
  5. In the Upload Certificate dialog, in Oracle Integration, import both certificates as Message Protection Certificate types and enter unique alias names.
  6. Satisfy the following manifest file recommendations (that is, the properties file in the ZIP file that must be uploaded to Oracle WebCenter Content for the bulk upload of files and the insertion of data into Oracle Cloud ERP application tables. This step is only required for an ERP Cloud callback upon job completion.

    • The manifest file expects import process details in the following format:

      job package name,job def name,manifest file name,job parameters (comma separated)

      For example:

      oracle/apps/ess/financials/payables/invoices/transactions,APXIIMPT,AP,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,#NULL,INVOICE

    • The manifest file name should be a prefix of the actual ZIP file name if it contains _. Otherwise, it should just be the name. For example, if the ZIP filename is AP_301.zip, the manifest file name should be AP.properties and the third value in the manifest should be the manifest filename. If the ZIP file name is AP.zip, the manifest filename should be AP.properties and the third value in the manifest should be the manifest filename.

    • Only one job is supported per invoke action. You can have multiple entries in the manifest property file to import data from the interface table to the applications tables in batches of up to 10 for sequential or up to 5 for parallel processing. For example, the journal import data file has records of 10 ledgers. The property file has 10 entries with the unique ledger name as a parameter. After the data file is loaded in the interface table, the import process has 10 subprocesses for each ledger.

  7. Satisfy the following prerequisites to configure the integration that uses the bulk import feature:
    Map the following parameters to the Oracle Cloud ERP Adapter:

    • Map parameter ICSFileReference to the File Reference parameter from the other adapter (for example, the FTP Adapter, the REST Adapter, or whichever adapter you used that has the ICSFileReference parameter).

    • Map the FileName parameter from the source schema to the target schema (the target schema is the Oracle Cloud ERP bulk import schema). The FileName must be unique for every request.