FA: SCM: OM: Importing Orders Using FBDI Fails - How to Troubleshoot
(Doc ID 2197329.1)
Last updated on SEPTEMBER 05, 2023
Applies to:
Oracle Fusion Order Management Cloud Service - Version 11.1.11.1.0 and laterInformation in this document applies to any platform.
Symptoms
An error is reported when importing Sales Orders using a spreadsheet. The spreadsheet has been uploaded using the - Load File to Interface - Scheduled Process (ESS), this populates the Order Management Interface tables. The Scheduled Process used to import the orders from the interface tables - Import Sales Orders - has reported an error. The Order has not been created.
Examples of errors reported are:
Request Id: 65735
Batch Name: 10810
Source System: null
Order Number: null
Allow Auto Purge: Y
Order PMC_IMP_161208_002 will not be imported due to the following error: An order was not created because no matching row for attribute ProductNumber with the value AS54888777 was found for the source order with the following details: source order PMC_IMP_161208_002, source order line 1, source order schedule 11. Check the attribute value, and resubmit the order..
Number of orders that were imported: 0. Check the run time user interface for processing status.
Number of orders that did not pass validation: 1. Some of these orders may be available in the order entry user interface.
Overall Result : ERROR
Batch Name: 10810
Source System: null
Order Number: null
Allow Auto Purge: Y
Order PMC_IMP_161208_002 will not be imported due to the following error: An order was not created because no matching row for attribute ProductNumber with the value AS54888777 was found for the source order with the following details: source order PMC_IMP_161208_002, source order line 1, source order schedule 11. Check the attribute value, and resubmit the order..
Number of orders that were imported: 0. Check the run time user interface for processing status.
Number of orders that did not pass validation: 1. Some of these orders may be available in the order entry user interface.
Overall Result : ERROR
Request Id: 65699
Batch Name: 10810
Source System: null
Order Number: null
Allow Auto Purge: Y
Order PMC_IMP_161208_001 will not be imported due to the following error: An order was not created because the value 300,000,001,469,001,777 provided for the attribute SOLD_TO_PARTY_ID is invalid for the source order with the following details: source order PMC_IMP_161208_001. Check the attribute value, and resubmit the order..
Number of orders that were imported: 0. Check the run time user interface for processing status.
Number of orders that did not pass validation: 1. Some of these orders may be available in the order entry user interface.
Overall Result : ERROR
Batch Name: 10810
Source System: null
Order Number: null
Allow Auto Purge: Y
Order PMC_IMP_161208_001 will not be imported due to the following error: An order was not created because the value 300,000,001,469,001,777 provided for the attribute SOLD_TO_PARTY_ID is invalid for the source order with the following details: source order PMC_IMP_161208_001. Check the attribute value, and resubmit the order..
Number of orders that were imported: 0. Check the run time user interface for processing status.
Number of orders that did not pass validation: 1. Some of these orders may be available in the order entry user interface.
Overall Result : ERROR
Changes
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 |
Changes |
Cause |
Solution |
References |