EAM: SQL Error When Searching Assets with Cost Information, Acquisition Information, and Non Capital Asset Switches (Doc ID 1486078.1)

Last updated on APRIL 25, 2016

Applies to:

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

Symptoms

When searching for an asset with the following options checked - Cost Information, Acquisition Information and Non Capital Asset switches, the page returns results as well as a SQL error and PeopleCode error.

ERROR
---------
Error in PeopleCode ScrollSelect processing. (2,213) AM_LOOKUP_WRK.FETCH_ASSETS.FieldFormula Name:retrieve_items PCPC:39155 Statement:662
Called from:AM_LOOKUP_WRK.FETCH_ASSETS.FieldChange Statement:6

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