My Oracle Support Banner

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

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.18.05.0 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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