My Oracle Support Banner

FA:SCM:INV:Rejected - Error on Table INV_TRANSACTIONS_INTERFACE for the Load Interface File for Import (Doc ID 2662427.1)

Last updated on OCTOBER 23, 2023

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.19.10.0 and later
Oracle Fusion Inventory Management - Version 11.12.1.0.0 and later
Oracle Maintenance Cloud Service - Version 11.13.21.01.0 to 11.13.21.01.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

When loading inventory transaction file data with INV_TRANSACTIONS_INTERFACE.TRANSACTION_DATE = NULL to interface table, then the Load File to Interface failed with warning. The log shows:
Record 1: Rejected - Error on table INV_TRANSACTIONS_INTERFACE.
ORA-01400: cannot insert NULL into (???)

step:

  1. set data in InventoryTransactionImportTemplate.xlsm file
  2. upload the zip file to UCM
  3. Run Load Interface File for Import
     Load File to Interface failed with warning.

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


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