Unable To Create Customer Using FBDI Templates
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.
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
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms