EAM9.1: Error when Trying to Update an Asset to Parent with Different Language from Base Language - Brazilian Localization (Doc ID 2005050.1)

Last updated on SEPTEMBER 15, 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

On : 9.1 version, Global

When attempting to update an asset to parent with logging different language from base language
the following error occurs.

ERROR
-----------------------
A fatal PeopleCode SQL error occurred. Please consult your system log for details.
  
Erro de SQL na Exec. (2,280) ADD_WRK.DEFAULT_PB.SavePreChange Name:Add_Parent PCPC:16847 Statement:295
Called from:ADD_WRK.PARENT_CHILD_FLAG.SavePreChange Name:ASSIGN_PARENT_ID Statement:4
Called from:ADD_WRK.PARENT_CHILD_FLAG.SavePreChange Statement:8
  


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. login in PeopleSoft with language different from base language (ex: Portuguese)
2. go to Asset Management > Asset Transactions > Owned Assets > Basic Add, update the asset to Parent
3. save




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