Import Supplier Returns A Data Error When Trying To Load Excel File For Suppliers Import (Doc ID 2201572.1)

Last updated on DECEMBER 09, 2016

Applies to:

Oracle Fusion Supplier Model Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Supplier Model - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal


Import Supplier

Import Supplier errors when trying to load Excel file for Suppliers Import

Error:
3 Rows not loaded due to data errors.

value used for ROWS parameter changed from 64 to 6
Record 1: Rejected - Error on table POZ_SUPPLIERS_INT, column IMPORT_ACTION.
ORA-12899: value too large for column "FUSION"."POZ_SUPPLIERS_INT"."IMPORT_ACTION" (actual: 12, maximum: 10)

Record 2: Rejected - Error on table POZ_SUPPLIERS_INT, column IMPORT_ACTION.
ORA-12899: value too large for column "FUSION"."POZ_SUPPLIERS_INT"."IMPORT_ACTION" (actual: 29, maximum: 10)

Record 3: Rejected - Error on table POZ_SUPPLIERS_INT, column IMPORT_ACTION.
ORA-01400: cannot insert NULL into ("FUSION"."POZ_SUPPLIERS_INT"."IMPORT_ACTION")
 

Solution

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