My Oracle Support Banner

ELA: Post Migration Reports Showing Wrong Results (Doc ID 2494791.1)

Last updated on OCTOBER 21, 2019

Applies to:

PeopleSoft Enterprise FIN Lease Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

 

On : 9.2 version, 

ACTUAL BEHAVIOR

---------------

 

The numbers provided on these reports are confusing. We need an accurate way of validating the conversion. We have 152 existing financial leases but I cannot tell if these were all converted properly. Furthermore, the migration document (Oracle_Red_Paper_-_Transitioning_to_Lease_Accounting_Standards_ASC_842_and_IFRS_16) does not provide combinations of Asset Status and Lease Status that I am seeing on our report.

EXPECTED BEHAVIOR

-----------------------

Need to have correct results in the report after post migration.

STEPS

-----------------------

The issue can be reproduced at will with the following steps:

 

Migrate the leases to the new environment.

After migration, run the reports to validate the number of leases.

BUSINESS IMPACT

-----------------------

The issue has the following business impact:

Due to this issue, users cannot have correct results in the report.

 

Changes

 Issue is due to the SQLs behind the records used in the Post Migration report of  Leases which are not including Business Unit condition in the where-clause.

This is explained in the following bug:

Bug 28659937 - ELA: INFO: REQUIRE CLARIFICATION ON THE DATA PROVIDED ON THE POST MIGRATION

 

 

 

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.