My Oracle Support Banner

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

Last updated on MAY 06, 2022

Applies to:

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


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:

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:

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

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.


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

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