Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the Oracle NetSuite Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    WSDL URL Enter the Oracle NetSuite WSDL URL; for example, https://webservices.netsuite.com/wsdl/v2023_1_0/netsuite.wsdl. See Configure Oracle NetSuite.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Token Based Authentication.
    Consumer Key Enter the consumer key of the integration record in Oracle NetSuite. See Create an Integration Record for Oracle Integration in Using the Oracle NetSuite Adapter with Oracle Integration 3.
    Consumer Secret Enter the consumer secret of the integration record in Oracle NetSuite.
    Token Enter the token ID provided by Oracle NetSuite. See Create an Access Token for the User Account in Using the Oracle NetSuite Adapter with Oracle Integration 3.
    Token Secret Enter the token secret provided by Oracle NetSuite.
    Account ID Enter your Oracle NetSuite account identifier. See Make a Note of the NetSuite Account ID in Using the Oracle NetSuite Adapter with Oracle Integration 3.

    Note:

    You must enter this information in capital letters.
  4. Click Save. If prompted, click Save again.
  5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  6. To return to the project workspace, click Go back Back icon.

Configure the QuickBooks Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    QuickBooks Environment Select Production.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Client id Enter the Client ID obtained when you configured QuickBooks. See Configure QuickBooks.
    Client secret Enter the Client Secret obtained when you configured QuickBooks.
  4. Click Save. If prompted, click Save again.
  5. Click Provide Consent.
  6. In the resulting Sign in dialog, enter your Oracle Integration user name and password, and click Sign in.
    You'll now be redirected to the QuickBooks sign in page.
  7. Enter your QuickBooks account credentials.
    A page is displayed asking for permission to interact with the account.
  8. Click Yes.
    You're informed that access is allowed. You can now switch back to the QuickBooks Connection window of Oracle Integration to test your connection.
  9. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.
    A message confirms if your test is successful.
  10. To return to the project workspace, click Go back Back icon.

Configure the Lookup Table

Edit the NS_CUSTOMCONFIG lookup table to configure the custom script ID.

  1. In the Lookups section, click the lookup name.
  2. Enter the value for the following key.
    Key Value
    CustomScriptId custbody_qb_sync_status
  3. Click Save. If prompted, click Save again.
  4. To return to the project workspace, click Go back Back icon.