My Oracle Support Banner

EAM9.2:AMAS2210 (Asset List By Asset ID) SQR Report Does Not Print A Line For Each Fund Code (Doc ID 2618938.1)

Last updated on DECEMBER 12, 2019

Applies to:

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


Asset List by Asset ID (AMAS2210) SQR report does not print a line for each Fund Code.

When an asset has a COST row for multiple funds, AMAS2210 only returns one detail row from COST, although multiple rows are selected by the main select
statement.  The line will only be printed if the Asset ID or Cost Type changes.  This results in only one line printing for the Asset, giving an
inaccurate amount for Net Book Value and other amounts in the report.

Steps to replicate:

1.  Identify an asset with split funding (more than one Cost row due to more than one Fund Code).
2.  Navigate to Asset Management > Financial Reports > Asset Details > By Location.
     For run control parameters, enter Business Unit, Book, and Date Range.
3.  Run AMAS2210 (Asset List By Asset ID) SQR Report




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.