Download Oracle FLEXCUBE Wealth Management Interface User Manual

26. The notification code used by FCUBS to communicate the change in the customer balances
would be “NOTIFY_AC_BAL”.
27. On account balance notification, the PMS_PORTFOLIO_HOLDING table is populated with
the Market_Value and Total_Acq_Cost columns based on the balances received in the
notification message.
FCPB Column Name
Description
FCUBS Element Name (as per
the XML)
SUB_PORTFOLIO_ID
(PMS_PORTFOLIO_HO
LDING)
CASA Account no
CUST_AC_NO
Client_id
(PMS_PORTFOLIO_HO
LDING)
CIF ID
CUSTNO
INSTRUMENT_CCY
(PMS_PORTFOLIO_HO
LDING)
Currency of the CASA Account
CCY
VALUE_DATE
(PMS_PORTFOLIO_HO
LDING)
The date of receipt of the
balances
Since it is online notification, the
XML would be received as and
when the balances are updated.
So the date of receipt of the XML
notification would be populated as
value_date
TOTAL_ACQ_COST
(PMS_PORTFOLIO_HO
LDING)
Actual Balance including
unclear balances
ACBALANCE
MARKET_VALUE
(PMS_PORTFOLIO_HO
LDING)
Balance available to be spent
ACAVLBAL
HOLD_AMOUNT
(PMS_PORTFOLIO_HO
LDING)
The current balance minus
available balance would give
the blocked/hold amount
ACBALANCE- ACAVLBAL
3.4.7 CASA Closure/Modification
The details of Customer CASA Closure/Modification Notifications are given below:
3.4.7.1 Process Flow
The following steps are involved in the process:
3-13