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 JULY 21, 2020
Applies to:PeopleSoft Enterprise FIN Lease Administration - Version 9.2 and later
Information in this document applies to any platform.
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.
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
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.
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