ELA: Received Error Message When Loading Lease With Asset Data Via RE_LS_IMPORT_CI Excel To CI (Doc ID 2619380.1)

Last updated on DECEMBER 15, 2023

Applies to:

Symptoms

Received Error Message when trying to load lease with asset data via the RE_LS_IMPORT_CI Excel to CI template.  Utilized the RE_LS_IMPORT_CI Excel to CI template to load leases.  Without populating the asset info, it loads fine. But received error message (see below) when adding asset data in the Excel to CI template.  Received the exact same error message when trying to supplement asset data online via the "Review Lease interface" page.  

Error Message:
Invalid SQLExec update for this type of PeopleCode program. (2,146)
RE_UTILITIES.KeyGenerator.OnExecute  Name:RestoreEntity  PCPC:4931  Statement:80
Called from:RE_UTILITIES.KeyGenerator.OnExecute  Name:GenerateKey  Statement:10
Called from:RE_COMPONENTS.LEASE_IMPORT.LeaseImportErrorHandler.OnExecute  Name:ValidateAssetDetail  Statement:1851
Called from:RE_COMPONENTS.LEASE_IMPORT.LeaseImportErrorHandler.OnExecute  Name:SaveEdit  Statement:572
Called from:FS_OBJ_FRAMEWORK.CONTROLLERS.ServiceHandler.OnExe

SQLExec commands with UPDATE, INSERT, or DELETE statements are only allowed in SavePreChange, SavePostChange, and Workflow type PeopleCode programs.

It is expected that the entity name RE_LS_ASSET will be automatically inserted into the RE_ENTITY_DEFN table by the batch or online system.

Steps to Replicate:
1) Populate RE_LS_IMPORT_CI Excel to CI template with asset data
2) Interface RE_LS_IMPORT_CI Excel to CI template.
3) Navigate to Lease Administration > Integrations > Lease Imports > Review Lease Interface.
4) Populate the Lease Other Details tab with Leased Asset data.
5) Submit the Process Lease Interface run control.

Cause

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