My Oracle Support Banner

EAM:Wrong Number of Rows When Search Asset Page (Doc ID 2326097.1)

Last updated on OCTOBER 12, 2020

Applies to:

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


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.




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

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