Unable To Upload .csv File To Import Asset Lease (Doc ID 2454531.1)

Last updated on OCTOBER 10, 2023

Applies to:

Goal

Why are the following errors coming in the lease import on the .csv file?

Record 1: Rejected - Error on table FA_LEASE_SCH_INT, column ASSET_SCHEDULE_NUM.
ORA-01722: invalid number

Record 2: Rejected - Error on table FA_LEASE_SCH_INT, column LEASE_SCH_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."FA_INTERFACE_MAPS"."ALTERNATE_ID1")
ORA-06512: at "FUSION.FA_INTERFACE_UTILS_PKG", line 143
..
Record 3: Rejected - Error on table FA_LEASE_SCH_INT, column LEASE_SCH_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."FA_INTERFACE_MAPS"."ALTERNATE_ID1")
ORA-06512: at "FUSION.FA_INTERFACE_UTILS_PKG", line 143

Record 4: Rejected - Error on table FA_LEASE_SCH_INT, column LEASE_SCH_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."FA_INTERFACE_MAPS"."ALTERNATE_ID1")
ORA-06512: at "FUSION.FA_INTERFACE_UTILS_PKG", line 143

Record 5: Rejected - Error on table FA_LEASE_SCH_INT, column LEASE_SCH_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."FA_INTERFACE_MAPS"."ALTERNATE_ID1")
ORA-06512: at "FUSION.FA_INTERFACE_UTILS_PKG", line 143

Record 6: Rejected - Error on table FA_LEASE_SCH_INT, column LEASE_SCH_INTERFACE_ID.
ORA-01400: cannot insert NULL into ("FUSION"."FA_INTERFACE_MAPS"."ALTERNATE_ID1")
ORA-06512: at "FUSION.FA_INTERFACE_UTILS_PKG", line 143
 

Solution

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