1. Integrating Sales with Oracle E-Business Suite, Release 12.1.3
  2. Connect Oracle CX Sales to Oracle E-Business Suite

Connect Oracle CX Sales to Oracle E-Business Suite

You use the Integration Configuration page to allow Oracle CX Sales to exchange data with Oracle E-Business Suite.

Note: The provided reference integration content and the associated Groovy script artifacts use EBS_12.1.3 as the name of the Oracle E-Business Suite instance. You can change this value to your own preferred value (such as EBS_12.2, or myEBSsystem, or any other value) by changing the value of the RemoteSystemID entry in the O_INT_EBS_GetSysParam.groovy file to your preferred value, and by substituting your preferred value with the Remote System values listed in the following table.

To connect Oracle CX Sales to Oracle E-Business Suite do the following:

  1. Navigate to Tools, and then Integration Configuration.

  2. On the Integration Configuration page, click the Create icon.

  3. On the Create Integration page, enter the information for the first key-value pair in the following table, and then click Save and Close.

  4. Repeat the previous steps for the remaining key-value pairs in the following tables.

Remote System

Key

Value

EBS_12.1.3

host

Host name of your Oracle E-Business Suite instance, for example: myEBS_server.example.com

EBS_12.1.3

port

HTTPS port of your Oracle E-Business Suite instance, for example: 443

EBS_12.1.3

protocol

https

EBS_12.1.3

TCA_NLS_LANGUAGE

American

EBS_12.1.3

QOT_NLS_LANGUAGE

American

EBS_12.1.3

ORG_ID

Organization ID for your Oracle E-Business Suite instance, for example: 204

EBS_12.1.3

CUST_MATCH_RULE_ID

62

EBS_12.1.3

PRICE_LIST_ID

Price list ID for your Oracle E-Business Suite instance, which can be found by running the following SQL query:select list_header_id from qp_list_headers_tl where name like '<Price List Name>%' and language = 'US';

When a quote is created from an Oracle CX Sales opportunity, an attempt is made to map opportunity revenue line items to quote line items in Oracle E-Business Suite. This saves the user from having to re-create line items manually in the quote.

The price list ID is used as the default in the mapping and quote creation process, and drives the pricing that appears in the generated quote in Oracle E-Business Suite.

After the quote has been generated with the default values, the user can make any necessary changes to the quote, such as the pricing.