My Oracle Support Banner

EAM: Fatal SQL Error At Performing Transactions To An Asset Having Chartfield Values In The PS_COST Table (Doc ID 1599222.1)

Last updated on SEPTEMBER 24, 2021

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

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.





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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.