Error In Pool Invesment - Negative Shares - BRAZIL LOCALIZATION (Doc ID 2235765.1)

Last updated on MARCH 08, 2017

Applies to:

PeopleSoft Enterprise FIN Cash Management Brazil - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

DESCRIPTION
===========
AP - 91 - BRAZIL - Error in Pool Investment - Negative Shares

REPLICATION STEPS
=================
Creates and approve Deposits in the following way

01/10 -100
02/10 - 200
03/10 - 250
----------------------total amount 550

Create and approve a withdraw
04/10 - 1,000 - it's important that this withdraw is bigger than the total
amount above.

Creates deposit and approves 05/10 - 100
Creates withdraw and approve 06/10 - 100
Creates withdraw with past date 04/10 (same date of the withdraw of
1,000) - 120
Creates a deposit 07/10 - 200

Tries to approve - error bellow happens

Negative number assigned to an unsigned field: TRP_POOL_POS.NO_OF_SHARES.
(2,121) TR_CASH.InvestmentPools.Pool.OnExecute Name:addPoolPosition PCPC:4863
Statement:58

Called from:TR_CASH.InvestmentPools.Pool.OnExecute

Name:addPoolParticipantPosition Statement:3

Called from:TRP_TXN_APPR.GBL.SavePreChange Statement:8

The specified field is an unsigned field and a negative value is being assigned to it.

Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed.

But if you need the print screens of the transactions I will provide. And the error that pops up is because the NO_OiF_SHARES is negative if you follow this steps, but I will send it the trace if it is a must.

 

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