Last updated on JUNE 09, 2015
Applies to:PeopleSoft Enterprise FIN Asset Management - Version 9.1 and later
Information in this document applies to any platform.
When attempting to perform a Transfer or Recategorizing or any other transactions on this asset and save. Fatal SQL error is seen
the following error occurs.
SQl error in Exec. (2,280) FUNCLIB_AM.EDIT_EFFDT_FIELDS.FieldFormula Name:Validate_CHARTFIELD PCPC:1399 Statement 8
Called from : FUNCLIB_AM.EDIT_EFFDT_FIELDS.FieldFormula Name: Validate_AM_EFFDT_I2_Scroll Statement: 144
Called from: ADJUST_WRK.ACCOUNTING_DT.SaveEdit Statement: 23
The issue can be reproduced at will with the following steps:
1. Create an asset in PC having the chart field values of business_unit,project_id,activity_id and send it to AM thru PC_AM
2. Load the asset in AM using AMIF1000 process.
3. Perform a Transfer or Recategorizing or any other transactions on this asset and save. Fatal SQL error is seen.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms