ECM: A Fatal PeopleCode SQL Error On Approving Multiple Participant Transactions
Last updated on MARCH 02, 2018
Applies to:PeopleSoft Enterprise FIN Cash Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The following errors are received on approving multiple participant transactions for a pool with an Interest Type of "Percentage in Pool" with no "Distribute Shares" or "Share Price"
"A fatal PeopleCode SQL error occurred. Please consult your system log for details."
"SQL error in Exec. (2,280) TR_CASH.InvestmentPools.Pool.OnExecute Name:addPoolPosition PCPC:8847 Statement:99
Called from:TR_CASH.InvestmentPools.Pool.OnExecute Name:addPoolParticipantPosition Statement:3
Called from:TRP_TXN_APPR.GBL.SavePreChange Statement:8
During the execution of SQL, an error occurred in the Exec subroutine. The preceding message should have described the SQL being executed."
1. Add Pool with an Interest Type of "Percentage in Pool"
2. Add 2 participants
3. Add participant transactions in the following dates:
two transactions on 06/14/2016 and two on 06/16/2016
4. Approve transactions
5. After getting the error the transactions show as approved, but when re-searching for them, they are still pending.
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