My Oracle Support Banner

EAM92: Error In Asset Disposal Worksheet When Chartfield Security Is Turned On (Doc ID 2166921.1)

Last updated on NOVEMBER 23, 2019

Applies to:

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


With Chartfield Security turned on, a Fatal PeopleCode SQL error occurs when retrieving assets using the From In Service Date and To In Service Date criteria. This is due to coding that gives an alias to the PS_BOOK table as "BOOK" and the criteria

A fatal PeopleCode SQL error occurred. Please consult your system log for details.
caused by:
SQL error. Function: CreateSQL Error Position: 0 Return: 8603 - [Microsoft][SQL Server Native Client 11.0]
[SQL Server]The multi-part identifier "BOOK.BUSINESS_UNIT" could not be bound.
[Microsoft][SQL Server Native Client 11.0][SQL Server]The multi-part identifier "BOOK.ASSET_ID" could not be bound.

ErrorReturn-> 279 - SQL error in DescribeCol. (2, 279) AM_LOOKUP_WRK.SEARCH.FieldFormula Name:cost_only_cfsec PCPC:34919 Statement:604
  Called from:AM_LOOKUP_WRK.SEARCH.FieldFormula Name:retrieve_items Statement:631
  Called from:AM_LOOKUP_WRK.SEARCH.FieldChange Name:get_first_chunk Statement:6
  Called from:AM_LOOKUP_WRK.SEARCH.FieldChange Statement:74

The issue can be reproduced at will with the following steps:
1. Turn on User ID Chartfield Security for Department
2. Added VP1 (the test ID) to the Associate Users list in Chartfield Security > Maintain Security Rules > Define Security Rules
3. Go to Asset Management Disposal Worksheet - Enter an In-Service Date and To In-Service Date (Unit and Book were defaulted). Click Retrieve - see fatal error

The issue has the following business impact:
Due to this issue, users cannot populate the Disposal Worksheet using the From In Service Date / To In Service Date criteria


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.