API Accounts Data Insert Null Check To Be Added For EQUITY_OUT_AMT And EQUITY_IN_AMT Columns (Doc ID 2823914.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
For API Accounts data insert , Null check to be added for EQUITY_OUT_AMT and EQUITY_IN_AMT columns.

While inserting data into accounts table null check need to be added for ACC_EQUITY_OUT_AMT and ACC_EQUITY_IN_AMT columns. Due to this customer is facing an issue,while posting the trade transaction  even trade gets successful , the equity out values getting reset to NULL. Similar Null check is already present In the web service call.

EXPECTED BEHAVIOR
-----------------------
During API Account data insert system should insert valid data into equity columns of account table with event trade getting created successfully.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Not mentioned.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have the equity values in account table instead will have NULL values.

Cause

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