FA: SCM: GOP: Importing Demand Class Using FBDI Fails With :- There were no valid data files found in the '.zip' file . Only comma separated files like '.csv' are accepted for data files.
(Doc ID 2164011.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Oracle Fusion Order Management Cloud Service - Version 11.1.10.0.0 and laterOracle Fusion Global Order Promising - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
Symptoms
When importing demand classes using File Based Import (FBDI), the process completes with an error and does not load any records.
The issue can be reproduced with the following steps:
1. Generated the csv file using the "DemandClassImportTemplate.xlsm" template
2. Navigator > File Import and Export > upload the csv file to account 'scm/planningDataLoader/import'
3. Navigator > Schedule Processes > run the 'Load Planning Data from Flat Files' process
4. This spawned a child process 'Download Planning Data Files' which completed successfully
5. Next the 'Monitor Data Load to Staging Tables' process is spawned. This process remains in Wait status.
The process log file shows:
There were no valid data files found in the '.zip' file . Only comma separated files like '.csv' are accepted for data files.
In 'Monitor Data Load to Staging Tables'. Loader Jobs will be launched for each csv file.
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 |