Import Value Set Values to Oracle Applications Cloud

This example demonstrates how to use the information in the Developer Connect portal to import value set values to Oracle Applications Cloud.

Suppose a fictional partner application wants to extend it with certain functionality available in another application. Instead of creating the required business objects and attributes in this application, you can import them using a web service. Before you proceed with the import process, enable the access permissions for the web service and review the information in the Developer Connect portal:

• Synchronize the web services information

• Review the web service details

• Update the request payload

Synchronizing Web Services Information

You must synchronize the Developer Connect portal with your Oracle Applications Cloud instance to get the latest web service information. Follow these steps:

1. From the Navigator menu, select Tools > Developer Connect.

2. Click Synchronize.

   Note: The Last Refreshed date indicates when the Developer Connect portal was last synchronized with your cloud instance.

Searching And Reviewing Web Service Information

On the Web Services overview page, you can enter Manage File Import and Export in the Find field. You can also use Advanced Search option to find web service names that contain import, and select the relevant service from the search results.

To review the information:

1. On the Web Services overview page, select Manage File Import and Export Service. The Summary panel shows information such as the display name, business object that the service defines, life cycle status, QName, security policy used, and a brief overview of the service.

2. Click the Operations tab to view the operations supported by the web service.

3. Click the uploadFiletoUCM operation and review the result parameter in the response payload. This parameter holds the file ID in the WebCenter Content repository from which the value set values are imported.

4. Click the valueSetValuesDataLoader operation and review the fileIdAtRepository parameter in the request payload. This parameter holds the file ID in the WebCenter Content repository.

5. Click WSDL File link of the service to download the web service information.

Updating Request Payload

To add a sample payload to import the value set values:

1. Click the Sample Payloads tab and then click Add Sample Payload.

2. Select uploadFiletoUCM from the operation name list.

3. Enter a brief description of the payload in the description text box.

4. Add the payload to get the file ID from the WebCenter Content repository:

   <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Body>
    <ns1:uploadFiletoUCM 
   xmlns:ns1="http://xmlns.oracle.com/oracle/apps/fnd/applcore/webservices/types/"
     ns2="http://xmlns.oracle.com/oracle/apps/fnd/applcore/webservices/" 
   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
   
     <ns1:document xsi:type="ns2:DocumentDetails">
     <ns2:fileName>VS123.txt</ns2:fileName>
     <ns2:contentType>plain/text</ns2:contentType> <ns2:content>
   VmFsdWVTZXRDb2RlfEluZGVwZW5kZW50VmFsdWV8SW5kZXBlbmRlbnRWYWx1ZU51bWJlcnxJbmRlcGVuZGVudFZhbHVl
   RGF0ZXxJbmRlcGVuZGVudFZhbHVlVGltZXN0YW1wfFZhbHVlfFZhbHVlTnVtYmVyfFZhbHVlRGF0ZXxWYWx1ZVRpbWVz
   dGFtcHxUcmFuc2xhdGVkVmFsdWV8RGVzY3JpcHRpb258RW5hYmxlZEZsYWd8U3RhcnREYXRlQWN0aXZlfEVuZERhdGVB
   Y3RpdmV8U29ydE9yZGVyfFN1bW1hcnlGbGFnfEZsZXhWYWx1ZUF0dHJpYnV0ZTF8RmxleFZhbHVlQXR0cmlidXRlMnxG
   bGV4VmFsdWVBdHRyaWJ1dGUzfEZsZXhWYWx1ZUF0dHJpYnV0ZTR8RmxleFZhbHVlQXR0cmlidXRlNXxGbGV4VmFsdWVB
   dHRyaWJ1dGU2fEZsZXhWYWx1ZUF0dHJpYnV0ZTd8RmxleFZhbHVlQXR0cmlidXRlOHxGbGV4VmFsdWVBdHRyaWJ1dGU5
   fEZsZXhWYWx1ZUF0dHJpYnV0ZTEwfEZsZXhWYWx1ZUF0dHJpYnV0ZTExfEZsZXhWYWx1ZUF0dHJpYnV0ZTEyfEZsZXhW
   YWx1ZUF0dHJpYnV0ZTEzfEZsZXhWYWx1ZUF0dHJpYnV0ZTE0fEZsZXhWYWx1ZUF0dHJpYnV0ZTE1fEZsZXhWYWx1ZUF0
   dHJpYnV0ZTE2fEZsZXhWYWx1ZUF0dHJpYnV0ZTE3fEZsZXhWYWx1ZUF0dHJpYnV0ZTE4fEZsZXhWYWx1ZUF0dHJpYnV0
   ZTE5fEZsZXhWYWx1ZUF0dHJpYnV0ZTIwfEN1c3RvbVZhbHVlQXR0cmlidXRlMXxDdXN0b21WYWx1ZUF0dHJpYnV0ZTJ8
   Q3VzdG9tVmFsdWVBdHRyaWJ1dGUzfEN1c3RvbVZhbHVl QX R0cmlidXRlNH xDdXN0b21WYWx1ZUF0dHJpYnV0ZTV8Q
   3VzdG9tVmFsdWVBdHRyaWJ1dGU2fEN1c3RvbVZhbHVlQXR0cmlidXRlN3xDdXN0b21WYWx1ZUF0dHJpYnV0ZTh8Q3Vzd
   G9tVmFsdWVBdHRyaWJ1dGU5fEN1c3RvbVZhbHVlQXR0cmlidXRlMTAKUkVMN19CNl9WU19DSEFSX0lORF9URVhUX01MM
   jB8fHx8fFRyZWVzV1N8fHx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NHxOfDIwMDAtMTAtMDF8MjAwMC0xMC0zMHwxf
   Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fApSRUw3X0I2X1ZTX0NIQVJfSU5EX1RFWFRfTUwyMHx8fHx8Rmxle
   FdTfHx8fHxUZXN0aW5nIGZvciBCdWcgMTczNzU2ODR8WXwyMDExLTEwLTAxfHwyfHx8fHx8fHx8fHx8fHx8fHx8fHx8f
   Hx8fHx8fHx8fApSRUw3X0I2X1ZTX0NIQVJfREVQX1RFWFRfTUwyMHxGbGV4V1N8fHx8S0ZGV1N8fHx8fFRlc3RpbmcgZ
   m9yIEJ1ZyAxNzM3NTY4NCB1cGRhdGVkfE58MjAwMC0wMS0xMXwyMDAwLTAxLTIyfDF8fHx8fHx8fHx8fHx8fHx8fHx8f
   Hx8fHx8fHx8fHx8ClJFTDdfQjZfVlNfQ0hBUl9ERVBfVEVYVF9NTDIwfEZsZXhXU3x8fHxERkZXU3x8fHx8VGVzdGluZ
   yBmb3IgQnVnIDE3Mzc1Njg0fFl8MjAwMC0wMS0wMXwyMDAwLTAxLTMwfDJ8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8f
   Hx8fHx8ClJFTDdfQjZfVlNfTlVNX0lORHx8fHx8MTAwMHwxMDAwfHx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NHxZf
   Hx8MXx8fHx8fHx8fHx8fHx8fHx8fHx8f Hx 8fHx8fHx8fHw K UkVMN19CNl9WU19OVU1fSU5EfHx8fHwyMDAwfHx8f
   HxUZXN0aW5nIGZvciBCdWcgMTczNzU2ODR8WXwyMDExLTEwLTAxfDIwMTItMTAtMzB8Mnx8fHx8fHx8fHx8fHx8fHx8f
   Hx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU19OVU1fREVQfDEwMDB8MTAwMHx8fDEwMDAwfDEwMDAwfHx8fFRlc3RpbmcgZ
   m9yIEJ1ZyAxNzM3NTY4NHxZfHx8MXx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU19OVU1fR
   EVQfDIwMDB8fHx8MjAwMDB8fHx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NHxZfDIwMTEtMTAtMDF8MjAxMi0xMS0zM
   HwyfHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fApSRUw3X0I2X1ZTX0NIQVJfSU5EX1RURVhUX01MMjB8fHx8f
   FRyZWVzMVdTfHx8fFRyZWVzMSBUTFdTfFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NHxOfDIwMTMtMTAtMTF8MjAxMy0xM
   C0zMHwxfHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fApSRUw3X0I2X1ZTX0NIQVJfSU5EX1RURVhUX01MMjB8f
   Hx8fEF0dGFjaG1lbnQxV1N8fHx8QXR0YWNobWVudDEgVExXU3xUZXN0aW5nIGZvciBCdWcgMTczNzU2ODR8WXwyMDEzL
   TEwLTAxfDIwMTMtMTAtMzB8Mnx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU19EQVRFX0lOR
   Hx8fHx8MjAzMC0wMS0wMXx8MjAzMC0wMS0wMXx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NHxZfDIwMTEtMTAtMDF8M
   jAxMi0xMC0zMHwxfHx8fHx 8f Hx8fHx8fHx8f H x8fHx8fHx8fHx8fHx8fApSRUw3X0I2X1ZTX0RBVEVfSU5EfHx8f
   Hx8fDIwMzAtMDEtMDJ8fHxUZXN0aW5nIGZvciBCdWcgMTczNzU2ODQtMXxZfDIwMTEtMTAtMDV8MjAxMi0xMC0zMHwyf
   Hx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fApSRUw3X0I2X1ZTX0RBVEVfREVQfDIwMzAtMDEtMDF8fDIwMzAtM
   DEtMDF8fDIwMzAtMDEtMTF8fDIwMzAtMDEtMTF8fHxUZXN0aW5nIGZvciBCdWcgMTczNzU2ODR8WXwyMDExLTEwLTAxf
   DIwMTItMTAtMzB8MXx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU19EQVRFX0RFUHwyMDMwL
   TAxLTAxfHx8fDIwMzAtMDEtMjJ8fHx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4NC0xfE58MjAxMS0xMC0wNXwyMDEyL
   TEwLTMwfHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU19EQVRFVElNRV9JTkR8fHx8fDIwM
   zEtMDMtMDEgMDE6MDA6MDAuMDB8fHwyMDMxLTAzLTAxIDAxOjAwOjAwLjAwfHxUZXN0aW5nIGZvciBCdWcgMTczNzU2O
   DR8WXwyMDExLTAxLTAxfDIwMTItMDEtMzB8MXx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU
   19EQVRFVElNRV9JTkR8fHx8fDIwMzEtMDMtMDEgMDI6MDA6MDAuMDB8fHx8fFRlc3RpbmcgZm9yIEJ1ZyAxNzM3NTY4N
   C0xfE58MjAxMS0xMC0wMnwyMDEyLTEwLTMwfDJ8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8ClJFTDdfQjZfV
   lNfREFURVRJT UV fREVQfDIwMzE t MDMtMDEgMDE6MDA6MDAuMDB8fHwyMDMxLTAzLTAxIDAxOjAwOjAwLjAwfDIwM
   zEtMDMtMDEgMDE6MDE6MDAuMDB8fHwyMDMxLTAzLTAxIDAxOjAxOjAwLjAwfHxUZXN0aW5nIGZvciBCdWcgMTczNzU2O
   DR8WXwyMDExLTAxLTAxfDIwMTItMDEtMzB8NHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHx8fHwKUkVMN19CNl9WU
   19EQVRFVElNRV9ERVB8MjAzMS0wMy0wMSAwMTowMDowMC4wMHx8fHwyMDMxLTAzLTAxIDAxOjAyOjAwLjAwfHx8fHxUZ
   XN0aW5nIGZvciBCdWcgMTczNzU2ODR8WXwyMDExLTAxLTAxfDIwMTItMDEtMzB8NHx8fHx8fHx8fHx8fHx8fHx8fHx8f
   Hx8fHx8fHx8fHwK
      </ns1:content>
     <ns2:documentAccount>fin$/tax$/import$</ns2:documentAccount>
     <ns2:documentTitle>VS</ns2:documentTitle>
    </ns2:document>
    </ns1:uploadFiletoUCM>
    </soap:Body>
   </soap:Envelope>

5. Click OK.

6. Select valueSetValuesDataLoader from the operation name list.

7. Enter a brief description of the payload in the description text box.

8. Add the payload to read the contents from the file and import the value set values:

   <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Body>
    <ns1:valueSetValuesDataLoader 
   xmlns:ns1="http://xmlns.oracle.com/oracle/apps/fnd/applcore/webservices/types/">
    <ns1:fileIdAtRepository>1234</ns1:fileIdAtRepository>
    </ns1:valueSetValuesDataLoader>
    </soap:Body>
   </soap:Envelope>