1. Using the Oracle ERP Cloud Adapter with Oracle Integration Generation 2
  2. Add the Oracle ERP Cloud Adapter Connection to an Integration
  3. Invoke Operations Page

Invoke Operations Page

Enter the Oracle ERP Cloud invoke operation values for your integration.

See the appropriate section based on your selection on the Actions page:

Query, Create, Update, or Delete Information

If you selected Query, Create, Update, or Delete Information on the Actions page, select the business object or service and the operation to perform on the selected business object or service.

Element Description

Browse by

Select to browse by business object or service. There is a one-to-one correspondence between the business object and service. The service acts on the business document.

  • Business Objects: Select to browse a list of available business objects.

  • Services: Select to browse a list of available services.

  • Business (REST) Resource: Select to browse a list of available Oracle Fusion Applications REST API resources. This option is only available if you specified an interface catalog URL in the Interface Catalog URL field on the Connection Properties page when configuring the Oracle ERP Cloud Adapter.

Filter by object name

(displayed if Business Objects is selected)

Type the initial letters to filter the display of business objects or select a specific category:

  • All

  • Active

  • Custom

  • Deprecated

  • Standard

Select a Business Object

(displayed if Business Objects is selected)

Select the business object to use.

Filter by service name

(displayed if Services is selected)

Type the initial letters to filter the display of services.

Select a Service

(displayed if Services is selected)

Select the service to use.

Select the Operation to Perform on the Business Object/Resource or Service

(displayed if Services or Business Objects is selected)

Select the operation to perform on the selected business object or service.

Select the operation to perform on the selected resource

(displayed if Business (REST) Resource is selected)

Select the operation to perform on the selected resource.

Note: If you select get, only the following query parameters are supported:
  • expand
  • fields
  • onlyData

Select a Service Application

(displayed if Business (REST) Resources is selected)

Select the service application to see the business resources defined in the application.

Select a Business Resource

(displayed if Business (REST) Resources is selected)

Select the parent business resource to use. You can then click Browse and configure a child resource to select the corresponding child business resources of that parent to use.

Note: Existing integrations created prior to the introduction of this feature can be edited to select parent business resources and their corresponding child business resources.

Browse and configure a child response
Click to access a page to select the following:

  • The parent and child business resources of the selected parent business resource

  • The operation to perform on the parent and child business resources

After you click Ok, the link name changes to View and edit the configuration of a child resource.

Both the parent and child business resources are displayed on the Summary page.

To reset to your original selections, click this link, then click Reset.

Life Cycle

Displays the state of the selected business object or service. Deprecated indicates the business document is nearing the end of use and must be used with caution.

Name

Displays the name of the selected business object or service.

Description

Displays the description of the selected business object or service.

Import Bulk Data into Oracle ERP Cloud

If you selected Import Bulk Data into Oracle ERP Cloud on the Actions page, select the job name to import, the job property name, and the type of log data for Oracle ERP Cloud to extract. See External Data Integration Services for Oracle Cloud: Overview.
Element Description

Select Bulk Data Import Process

Select the job name to import. Import jobs are the background jobs that run on Oracle ERP Cloud to perform data upload operations. The job name you select is used to import data. The list of import jobs is obtained by invoking ErpIcsIntegrationService in the service catalog service WSDL.

The following information is obtained with each job:

  • Interface ID: The import job key.

  • UCM account: The account with which to upload the file. 

  • Import job name and package name: To be displayed in the user interface.

  • Description: The bulk data import process description.

Note:

If import jobs do not appear in the list, there may be several causes. See Jobs Not Appearing in the Import Jobs List on the Operations Page.

Reuse job property file uploaded separately in respective UCM account

Select this check box, then enter the job property file name (without an extension) that Oracle ERP Cloud can obtain from the respective UCM account.
Job Property File Enter the job property file name (without the extension) that Oracle ERP Cloud gets from the UCM account.

Extract File
Select the type of log data for Oracle ERP Cloud to extract while processing the data file:

  • All: All failed records with supporting load and import process files.

  • Error: Records that failed to load and import.

  • Log: Log files for load and import processes.

  • Out: Output files for load and import processes.

  • None: None.

Send Files to ERP Cloud

If you selected Send Files to ERP Cloud on the Actions page, select the security group and doc account required for uploading the file.

Element Description

Security Group

Select the security group in which to upload the file. A security group is a set of files grouped under a unique name. Every file in the content server repository belongs to a security group. Access to security groups is controlled by permissions assigned to roles on the content server. Roles are assigned to users where they are maintained in Oracle Fusion Applications. The default security group in Fusion Applications is FAFusionImportExport.

Doc Account

Select the doc account to assign to the file. In Fusion Applications, every content item has an account assigned to it. You must have the appropriate permission to the account such as read and/or write. The access to the document is the intersection between account permissions and security group permissions. There are several Fusion Applications accounts.

Encrypt the File

Select this checkbox to encrypt the file before upload to UCM. To select this checkbox, you must have selected to encrypt the file when configuring the Oracle ERP Cloud Adapter connection on the Connections page. See Configure Connection Security.

See Understanding Security and User Access of Administering Oracle WebCenter Content.