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

Last updated on JULY 29, 2016

Applies to:

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

Symptoms

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


ERROR
-----------------------
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


STEPS
-----------------------
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

BUSINESS IMPACT
-----------------------
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

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