EAM92: Error In Asset Disposal Worksheet When Chartfield Security Is Turned On
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.
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.
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
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