My Oracle Support Banner

Unable To Create Customer Using FBDI Templates (Doc ID 2409130.1)

Last updated on JUNE 09, 2018

Applies to:

Oracle Supply Planning Cloud Service - Version 11.13.18.02.0 and later
Information in this document applies to any platform.

Symptoms

Unable to create Customer using FBDI templates.
CustomerSite and Customer .csv files together are zipped and uploaded successfully.

When the MSC_ST_TRADING_PARTNER_SITES staging table was checked the following ERROR_TEXT is seen:

ERROR
The value provided for the attribute PARTNER_NAME is invalid. The value provided for the attribute LOCATION is invalid.


Also the process id for the Customer Load Entity shows completed in Warning.
When the log file is reviewed the following error is seen:

ERROR
Record 1: Rejected - Error on table MSC_ST_GLOBAL_TRADING_PARTNERS, column STATUS.
ORA-01722: invalid number


STEPS TO REPRODUCE
1. Use the ScpCustomerImportTemplate.xlsm template to populate the Customer and CustomerSite data.
2. Click the Generate CSV button to create the CSV files for Customer and CustomerSites.
3. Zip the files.
4. Upload the zip file to the UCM Server using the File Import and Export tool.
5. Then from a SCM work area run the Load Planning Data from Flat Files process.
6. Hit the errors.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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