EAM:Wrong Number of Rows When Search Asset Page

(Doc ID 2326097.1)

Last updated on NOVEMBER 08, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Looks like when you select ONLY the cost information is display. If you select the acquisition in-addition to the cost there will be more rows with the same info.


1-Cost information is checked only  there are 2 lines.
2-Acquisition information is checked only ¿ there are 2 lines  NOTICE THE COST on the 2nd line
3- click on both cost information and acquisition information .2ND scrolling over .3rd scrolling over

The sql that combines these 2 tables might not joining by all keys it also appears to be dups because displaying the COST BAL information and not the ACQ information.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms