ECM: Wrong Calculation In The Investment Pool After Update Pool Position (Doc ID 2224936.1)

Last updated on JANUARY 19, 2017

Applies to:

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

Symptoms

Upon changing the market value for the investment pool, the system generates the correct rate and income value, however, it performs the value distribution incorrectly among the members of the pool.

STEPS

1. Navigate to Cash Management > Investment Pools > Pool Information, and create investment pool (initial share price = 30.42)

2. Navigate to Cash Management > Investment Pools > Participant Information, and create 2 participants

3. Navigate to Cash Management > Investment Pools > Participant Transactions, and create participant transactions (1,000,000 and 500,000)

4. Navigate to Cash Management > Investment Pools > Approve Transactions, and approve the transactions

5. Navigate to Cash Management > Investment Pools > Pool Position, and click Update Pool Position (Market Value Amount = 1,500,791.60)

The system generated a Market value entry for the first participant in the value of 517.60, however, the correct value would be 527.73, per the below calculation:
Participant value/current rate * new rate = participant value
1,000,000.00 / 30.42 * 30.436053648 = 527.73

6. Navigate to Cash Management > Investment Pools > Participant Transactions, and review the Participant transactions

The same happens with participant 2: The system generated a Market value entry in the value of 274,01, however, the correct value would be 263.87, per the below calculation:
Participant value/current rate * new rate = participant value
500,000.00 / 30.42 * 30.436053648 = 263.87

However, in the next Market change the system already performs the correct calculation

7. Update Pool Position to 1,501,276.22

The values for each participant: Now the system got it right, since it generated a difference of 323.08 for participant 1 which would be the first income in the value of 527.73 ¿ the second income, in the value of 880.81

For participant 2, it generated a difference of 161.54 which would be the first income in the value of 263.83 ¿ the second income, in the value of 425.37



Changes

 

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