Load Customer Product Aliases ExceltoCI Not Available (Doc ID 2146292.1)

Last updated on JANUARY 23, 2020

Applies to:

Symptoms

In the PeopleSoft Enterprise Order to Cash Common Information Peoplebook, the following statements appear:

You can also use these customer Component Interfaces to load data in the component tables:

  CUSTOMER_MAIN_CI: Loads main customer information, customer teams, addresses.

  CUSTOMER_BILLTO_CI: Loads bill-to related information such as bill-to options, customer correspondence, customer credit.

  CUSTOMER_SOLDTO_CI: Loads sold-to related information such as sold to options, product catalogs, customer hierarchy, customer product aliases, brokers.

  CUSTOMER_SHIPTO_CI: Loads ship-to related information such as ship-to options, customer exception calendars, carrier account information, indirect customers.

  CUSTOMER_MISC_CI: Loads miscellaneous information such customer group, standard industry codes, VAT information, notes, attachments, messages.

  CUSTOMER_REGION_CI: Loads region codes.

Note that CUSTOMER_SOLDTO_CI is listed as being used to load customer product aliases. However, when the template is build in Excel for this component, there are no columns that correspond to that information. The records listed in the template are CUST_BROKER, CUST_SHIPTO, CUST_BILLTO, and CUST_SOLDTO_OPT. CUST_PROD_ALIAS fields are not placed in the template.

What is the approved process for loading Customer Product Alias information?

Changes

Not applicable. 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.