Unable To Upload Transfer Order Template In Order To Create Transfer Orders
Last updated on FEBRUARY 10, 2018
Applies to:Oracle Fusion Inventory Management Cloud Service - Version 18.104.22.168.0 and later
Oracle Fusion Inventory Management - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
When attempting to import transfer order using SupplyOrderImportTemplate.csv, the following error occurs.
Record 1: Rejected - Error on table "DOS_DISTRIBUTION_DETAILS_INT", column LINE_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."DOS_DISTRIBUTION_DETAILS_INT"."LINE_INTERFACE_ID")
Record 1: Rejected - Error on table "DOS_SUPPLY_LINES_INT", column UOM_CODE.
ORA-20010: The unit of measure information for UOM Ea was not found. The UOM does not exist.
ORA-06512: at "FUSION.DOS_SUPPLY_INTERFACE_UTIL", line 872
The issue can be reproduced at will with the following steps:
1. File used : SupplyOrderImportTemplate .xlsm (Attached)
2. CSV file uploaded in File Import and Export option 'SCM/SupplyOrder/Import' path
3. Ess Program Ran: 'Load Interface File for Load'
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