Fusion RCV: Load Interface File For Import Rejects Receipt Data (Doc ID 1965302.1)

Last updated on JANUARY 19, 2016

Applies to:

Oracle Fusion Receiving - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.8.0.0 version, Manage Inbound Logistics-Manage Receipts

'Load Interface File For Import' program rejects receipt interface data when trying to load using CSV file generated using seeded FBDI template.

ERROR
-----------------------
value used for ROWS parameter changed from 64 to 7
Record 1: Rejected - Error on table RCV_TRANSACTIONS_INTERFACE, column TRANSACTION_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Record 2: Rejected - Error on table RCV_TRANSACTIONS_INTERFACE, column TRANSACTION_DATE.
ORA-01841: (full) year must be between -4713 and +9999, and not be 0

 

Steps To Reproduce
-----------------------

  1. Download FBDI template for Receiving Interface from OER
  2. Populate data in the XLSM file
  3. Generate CSV & ZIP file
  4. Upload the ZIP file to UCM via File Import / Export
  5. Try to load data into receiving interface tables via 'Load Interface File For Import'
  6. See error in log file

Cause

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