EAM:Wrong Number of Rows When Search Asset Page
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.
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.
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