1. Using the Oracle NetSuite Adapter with Oracle Integration 3
  2. Create an Oracle NetSuite Adapter Connection
  3. General Prerequisites for Creating a Connection

General Prerequisites for Creating a Connection

To successfully connect to an Oracle NetSuite instance from Oracle Integration, you must fulfill certain prerequisites. This section details the common prerequisites that apply to all types of connections you create with Oracle NetSuite from Oracle Integration.

In addition to these general prerequisites, there are prerequisites specific to each security-policy option available to connect to Oracle NetSuite, which are detailed in the later sections.

Topics:

Register with Oracle NetSuite and Enable Features

To connect to Oracle NetSuite, you must have registered with Oracle NetSuite and enabled key features (such as SOAP and REST web services) on your Oracle NetSuite instance.

If you haven't registered with Oracle NetSuite, follow the steps provided here to create an account and enable the required features.
  1. Visit http://www.netsuite.com to register with Oracle NetSuite. Ensure that you obtain an account with administrator privileges.
  2. Enable connection-related features on your Oracle NetSuite instance.
    1. On your NetSuite home page, select Setup, then Company, and then Enable Features.
    2. Click the SuiteCloud subtab.
    3. In the SuiteScript section, check the following boxes:
      1. CLIENT SUITESCRIPT. Click I Agree on the SuiteCloud Terms of Service page.
      2. SERVER SUITESCRIPT. Click I Agree on the SuiteCloud Terms of Service page.
    4. In the SuiteTalk section, check the following boxes:
      1. SOAP WEB SERVICES. Click I Agree on the SuiteCloud Terms of Service page.
      2. REST WEB SERVICES. Click I Agree on the SuiteCloud Terms of Service page.
    5. In the Manage Authentication section, check the TOKEN-BASED AUTHENTICATION box. Click I Agree on the SuiteCloud Terms of Service page.
      You must enable the TBA feature if you want to use the token-based authentication policy to connect to Oracle NetSuite from external applications.
    6. Click Save.

Assemble the Oracle NetSuite WSDL URL

To create an Oracle NetSuite connection in Oracle Integration, you must have the URL of the Oracle NetSuite's web services description language (WSDL) file.

The general syntax of the Oracle NetSuite WSDL URL is: https://webservices.netsuite.com/wsdl/<OracleNetSuite_application_version>/netsuite.wsdl.

Find the version of your Oracle NetSuite instance and assemble the URL corresponding to your instance.

  1. On your NetSuite home page, scroll to the bottom of the page to find the version of your Oracle NetSuite instance.
  2. Insert the version information into the URL syntax provided earlier.
    If the version of your instance is 2019.1, your WSDL URL is:

    https://webservices.netsuite.com/wsdl/v2019_1_0/netsuite.wsdl

    For additional information, see NetSuite Versioning and WSDL Versioning Overview.

    Note:

    To access the Oracle NetSuite Help Center, you must have an Oracle NetSuite account. Once inside the application, you can also access the Oracle NetSuite Help Center by clicking the Help link in the upper-right corner of any page.

Create Custom Fields and Records

If you require custom field types and custom record types in Oracle NetSuite for your integration, you must create them in advance in the Oracle NetSuite instance.

For the procedures to create custom field and record types, see Creating a Custom Field and Creating Custom Record Types.

Creation of custom field and record types is a one-time task. After you create them, they are available for selection on the Operations page of the Adapter Endpoint Configuration Wizard.

Prerequisites for Using Complex-Type Custom Fields in an Integration

If you want to use a complex-type custom field of Oracle NetSuite in your integration, you must obtain one of the NetSuite Internal IDs associated with the complex field.

You'll require to pass the Internal ID value associated with the field in the data mapper while designing an integration.

Note:

You are not required to pass internal ID values in the data mapper if you're using simple-type custom fields of Oracle NetSuite in your integration flow.
As a reference, here is an example procedure that demonstrates how to find the internal ID values of the constituent list members of an Oracle NetSuite single select or multiselect custom field.
  1. On the NetSuite home page, select Customization, then Lists, Records, & Fields, then Lists.
  2. On the Custom Lists page, click a link under the LIST column to open a custom list.

    For this example, as shown in the following image, the Advertising Preferences custom list is selected. Any of the four values in the Internal ID column can be passed to the named custom field's internalId element in the mapper.

    Description of netsuite_application.png follows
    Description of the illustration netsuite_application.png

Note:

If you want to use an Oracle NetSuite Adapter connection created prior to the release of support for custom fields, you must first select Refresh Metadata from the Actions menu Actions menu on the Connections page for the connection to use in the integration. See Refresh Integration Metadata. This task is not required for new Oracle NetSuite Adapter connections.