My Oracle Support Banner

EDM: Able To Double Sell On A Deal Without Receiving Data Integrity Error (Doc ID 2515359.1)

Last updated on JANUARY 16, 2020

Applies to:

PeopleSoft Enterprise FIN Deal Management - Version 9.2 and later
Information in this document applies to any platform.

Symptoms



ISSUE:

Able to sell equity deal twice if open in sales window on 2 screens. No data integrity error received. Partial sale has each sale generate a new residual open deal with shares based on the master less sold shares. This was discovered by luck however there is the risk for two users to process a sell event at the same time and cause this issue.



STEPS:


Steps to recreate in the Demo Region of FSCM 9.2 Image 19

Re-create:
-Navigate to Deal Management>Equities>Equity Definition
-Search for Ticker = ORCL
-Open new tab/window and follow same navigation as above to get to another Equity Definition page for the same Equity ID

On one of the open pages:
-Click Sell hyperlink
-Fill in Sales Details on one of the open Sale Details pages:
Sale price = 123.45
Sale date = 01/08/2018
Shares to sell = 142 (on the line in grid pertaining to deal 000000000358 with 10000 # of shares)
Total shares to sell = 142
-Click Calculate Sale Proceeds
Sale Counterparty = UKBNK
Our Settlement Bank = TRBNK
Our Settlement Account = CHCK
Click OK and Save

-Go to other open Equity Definition tab/window and click the Sell hyperlink

-fill in sale details again, as above, entering shares to sell on the line in grid pertaining to deal 000000000358 with 10000 # of shares
-Click Ok then save to complete this sale as well

See in Events section of Equity definition that Sale of deal 000000000358

Two Open status residual deals are generated as a result of stock sell with 9858 shares (10000-142) and the master deal being the original deal ID 000000000358.

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.