My Oracle Support Banner

ELA: Length Of PS_RE_LS.SPACE_UOM Differs From Record Layout For RE_LS_SBR Causing LA Conv Abend (Doc ID 2467576.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.

Symptoms

When running LA Data Migration Process RE_CONV_AMLS, the following abend occurs:

The length of PS_RE_LS.SPACE_UOM differs from the Record Layout for RE_LS_SBR Causing the abend above.

ERROR
-----------
value too large for column "SYSADM"."PS_RE_LS"."SPACE_UOM" (actual: 3, maximum: 1)

Steps
----------
This issue can be replicated by performing the following steps:

1) Submit job RE_CONV_AMLS from the LA Data Migration guide.


Business Impact
---------------------
While waiting for the fix for Bug 28172580  - ELA:  NEGATIVE NUMBER ASSIGNED TO AN UNSIGNED FIELD: RE_UI_WRK.PVLP_TO_AFV_PCT. to be delivered, the customer applied the recommended workaround for that bug (see below) and then reran job RE_CONV_AMLS. As a result, of receiving this abend, they are unable to continue with the data migration.


From development:

For the migration process failure issue, we are handling through the bug – 28172580 ELA: NEGATIVE NUMBER ASSIGNED TO AN UNSIGNED FIELD: RE_UI_WRK.PVLP_TO_AFV_PCT.
Till the fix is available, you can follow the instructions from the Bug 28257430 - ELA: INFO - WHERE TO SET UP AUTO NUMBERING OF LEASES).

Instructions:

PS_RE_ENTITY_DEFN is the record which decides the auto-numbering. There is no online page for setting up the data in this table. We have to update  the data through back end only.   If you have no lease at all then you can update the value to 0 for all the fields.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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