Home

Oracle FLEXCUBE Private Banking

1. 3 10 ORACLE Field Description Mandatory Mode Of Operation The user can modify the mode of operation If the user had opted earlier for single held portfolio and wants to modify it either to a joint or either or survivor mode of operation the system will force the user to capture the secondary holder details In case of a vice versa scenario wherein the user had earlier opted for the secondary or the either or survivor mode of operation and now wants to change it to singly held portfolio then the secondary holder details captured earlier will no longer be applicable and the corresponding fields for the secondary holder will get disabled The system also allows the user to modify the nominee details The change in the mode of operation will be applicable only to the orders which will be placed subsequent to the modification The change will not impact the orders which are in open status orders waiting for confirmation from the external interface Y Secondary Holder All the validations applicable at the time of portfolio creation are applicable during modification Similar to the mode of operation any modification done to the joint holder details will be applicable only to the orders that will be placed post the modification The change will not be updated to any of the orders which are in open status Nominee Modified nominee details will only be applicable to the
2. the drop down list By default the system selects the Buy option Field Description Mandator y Customer Details Portfolio Name Displays the list of the portfolio names for the Y customer Forex Details Currency Pair Display the currency pair name based on Y Commodity Currency and Terms Currency selected in Search Icon Popup Base Currency Based on the FX ID selected display information of Y base currency in view mode Terms Currency Based on the FX ID selected display information of Y terms currency in view mode Last Exchange Rate Displays the value of Last Exchange Rate Y Order Details Deal Type Enables the user to select the option with values like Y NDF and DFO Transaction Type Enables the user to select the transaction type from Y 5 137 ORACLE Field Description Mandator y Trade Date By default display the current system date or Y business date whichever is later but user can modify the trade date FX Settlement Date Displays the Date keyed in is considered as Y Expiry Maturity Settlement date for a given deal type This value is stored as Sub portfolio ID at holding level For forex subportfolio id should be Dealtype_Settlement date Terms In Days Displays the total number of days to settlement N Order Type Enables the user to select the appropriate order type Y from the drop down list By default the system selects the Market Type o
3. TER ORACLE Field Description Mandatory Portfolio Name Displays the list of the portfolio names for the customer Y in the drop down list Source Code Displays the Source Code for the banker who has Y sourced the transaction Lead Generation code Displays the Lead Generation Code for the banker who Y has provided the lead for the transaction Instrument Details Scheme Name Enables the user to select the appropriate Scheme Y Name by clicking on the search icon Insurer Name Displays the Insurer Name for the selected scheme name Once the user selects the Scheme Name system auto populates this field Scheme Type Displays the Scheme Type for the selected Scheme Name Once the user selects the Scheme Name system auto populates this field Currency Displays the Currency for the selected Scheme Name Once the user selects the Scheme Name system auto populates this field Counterparty Enables the user to select the appropriate counterparty using the search icon Personal Details Same as Enables the user to select whether the Insured person Customer Other is customer or some other person If the Other option is selected the system allows the user to enter the appropriate details Name of the Insured If the user selects the Same as Customer option above Y then system populates the Name of the Insured field If the Other option is selected enables the user to enter the appropr
4. Field Description Mandator y Holding Face Amount Displays the Current Nominal Amount value Y M Security Account Displays the sub portfolio id as the Security Y Account no Insurance Insurance is defined as the equitable transfer of the risk of a loss from one entity to another in exchange for a premium The company that sells the insurance is called the insurer Screen oe ORACLE Insurance Details RM Managed Name ccy Policy Number Next Premium Effective Date Annual Premium Premium Paid Fund Value Surrender Value Total INR POLS84 POL58 886 250 00 20 000 00 916 500 00 Figure 3 11 Insurance Valuation Screen Field Description Mandatory Name All the policies in the chosen instrument type Display Insurance and portfolio are displayed Each policy only in the tab is displayed with a hyper link Click on the hyper link to view all the transactions in the policy Currency This field displays the policy currency Display only Policy Number The insurance policy number is displayed in this Display field only Effective Date This field displays the policy enforcement date Display User has the flexibility to enter backdated only purchases Next Premium Premium is the payment or one of the periodic Display Date payments that a policy holder makes to an insurer only in exchange for the insurer s obligation to pay benefits upon the occurrence of the contractua
5. Instrument Name Enables the user to select the appropriate commodity Y name by clicking on the search icon available next to the Instrument Name field Security Code Displays the Security Code of the selected security It displays the Security Code based on the Field Access Controller Instrument Currency Displays the currency for the selected instrument Y name Once the Bond Name is selected system auto populates this field Settlement Currency Displays the settlement currency for the selected Y bond instrument maintained in the bond master Measured Units Displays the appropriate measured units It displays measured units selection as per the selected instrument It indicates the base for price computation of the commodity instruments Last Traded Price Displays the Last Traded Price defined in the Price Master table Order Details Transaction Date Enables the user to enter the appropriate Transaction Y Date Settlement Date Enables the user to enter the appropriate Settlement Y Date Transaction Displays the order type in the drop down list whether Y Buy or Sell Order Type Specifies the Price condition of the order for the Y selected instrument Time Condition Specifies the validity of order with respect to time Y When the Timed order is selected system populates additional field Expiry Date and enables the user to enter the appropriate date and time Quantity Displays the number of the units of the commodity
6. Match With Order The user can match the placed order with this particular transaction Clicking on this button will pop a window from which the required order can be tagged to this transaction 5 85 ORACLE Procedure for Capturing a Transaction Step 1 The system auto populates the name no and default portfolio name of the customer which is already in context Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 The subsequent step is to select the Structured Product The user can select the Structured Product either by directly entering the name of the product or by searching for the product by oF clicking the button The structured product search screen displays only the schemes which are in open status On selecting the structured product the instrument currency settlement currency and the exchange in which the product is listed will be displayed in the corresponding Instrument Currency Settlement Currency and Exchange fields in the screen Step 4 The user then proceeds to capture the purchase details of the holding The first step in this process is to capture the date of purchase The calendar for selecting the date has been provided 3 adjacent to Transaction Date field Click on the icon 3 in order to open the calen
7. Particulars Currency Amount Exchange Rate Amt in INR Portfolio Details BONDS FLOATING INTEREST RATE INR 999 902 000 1 000 999 902 000 Balanced INR 652 914 587 1 000 652 914 587 Commodity linked INR 172 500 000 1 000 172 500 000 Corpus Analysis group INR 999 989 000 1 000 999 989 000 Currency INR 1 799 976 000 1 000 1 799 976 000 Currency usb 199 976 00 52 000 10 398 752 000 Debt INR 9 552 450 100 1 000 9 552 450 100 Debt Short Term INR 143 070 00 1 000 143 070 00 Direct Equity INR 874 125 000 4 000 874 125 000 Direct Equity sGD 500 100 000 36 660 18 333 666 000 ELSS usp 4 520 000 52 000 235 040 00 Equity INR 21 619 233 989 1 000 21 619 233 989 Page 1 of 9 eo ORACLE e Detailed Portfolio Report Detailed Report generated as on 23 August 2012 Networth Sumi Amt in INR 1 171 666 67 ELSS 140 014 65 Global Funds y 25 000 00 436 548 50 339 500 00 30 000 000 00 727 500 000 00 e Transaction Report 9 means new reese ro of 0 000 10 ovearers 1266 00 sears no Bey 21 ormaner3 120400 EA terest 32 orgazm 1204 00 16387 no bey 13 roeaners 126600 16400 ro interest 24 oeaan 126000 16308 Sat 15 s3eacer3 1206 00 CA s 16 13042013 1204 00 16305 Bwy 17 speazor3 1206 00 18057 _ no terest 7 1 Tota no of record s E a 2 2 EJ 5 26 a ea ORACLE e Detailed Historic Por
8. Buy Price The buy price is determined at by using the weighted average cost methodology for each folio number Please note that the weighted average cost methodology is pertinent only for the remaining purchase transactions in the portfolio subsequent to application of the first in first out FIFO rule for all the sale transactions in the particular folio number of the portfolio The average cost requires you to determine the average cost per unit total amount invested divided by the total number of units held A FIFO rule is an accounting methodology wherein if you hold a security of the same class which has been acquired on different dates the security acquired at the earlier time is deemed to be disposed off first For further details on weighted average and FIFO computation please refer to the table on Equity Cash corporate actions dividend payout will not be considered while computing buy price Similar to the stock dividend in case of equity dividend reinvest option in case of mutual funds is deemed to have been acquired on the record date and at nil price Display only Qty The units will be calculated after the application of the FIFO accounting rule for each folio number In addition to the units purchased additional units received due to stock corporate actions will also be considered while determining the units The orders entered for subscription redemption of securi
9. Display only At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency computed as explained in the earlier section As explained earlier on clicking the name of any of the portfolios of the customer in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected portfolio PORTFOLIO DETAILS Field Description Mandatory Name Displays the names of all the securities across Display all the instrument types in the portfolio only Type Displays the instrument type for each of the Display securities in the portfolio only Currency Security currency is displayed Again the Display currency displayed is as captured in the only instrument master table 3 68 ORACLE Field Description Mandatory Account No Displays the account no of the customer for the respective securities Display only Buy Price Buy price for the security is computed by using the weighted average price methodology The weighted average price for a security is computed as gt Qi gt Pi gt Qi where Qi is the units bought in each transaction and Pi is the buy price of that transaction Cash corporate actions for all the types of instrument will not be considered while computing buy price Display only The stock corporate actions for equity viz bonus stock dividends are deemed to have be
10. Buy Screen Screen Navigation After logging in the system select Order Management gt Structured Products The screen will default to the Buy tab aay ORACLE Rules for Commencement of an Order The rules for placing the Structure Product order are Orders can be placed only for customers in active status e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order e The Risk Profile Model of the customer should be created before placing an order Once the user selects the Instrument Name system auto populates this field Field Description Mandator y Customer Details Customer No Enables the user to select the customer by clicking Based on on the search icon available next to the Customer FAC No field Customer Name Displays the Customer Name for the selected Based on Customer No FAC Portfolio Name Displays the list of the portfolio names for the Y customer in the drop down list Source Code Displays the Source Code for the banker who has Based on sourced the transaction FAC Lead Generation code Displays the Lead Generation Code for the banker Based on who has provided the lead for the transaction FAC Instrument Details Instrument Name Enable the user to select the appropriate Instrument Y Name by clicking on the search icon Term Sheet Enables the user to view the instrument details hyperlink available in the gen
11. By Portfolio Screen wass Figure 3 26 Portfolio Analysis By Portfolio Screen Screen Navigation 1 After you login the portfolio analysis screen can be accessed through the Portfolio and Analysis sub menu How to Read the Screen 1 The analysis screen displays four tabs when you arrive at the screen Category Household Portfolio Type and On Balance Sheet Contingent 2 The first tab on the top left corner of the screen is a drop down list displaying the list of different types of views of the holdings available to you Default value will be Portfolio The second tab is a drop down list displaying the list of household members as well as self and also option to have various views at Household level This field will be displayed for only those customers who have household attached to them Default value will be Self or household head name The third tab is a drop down list which displays the list of portfolio types i e Overall Managed by RM amp Managed by Client Boetauit value will be overall The final and fourth tab enables the user to view the On Balance Sheet details or Contingent details if applicable ous ORACLE The user has an option of selecting various combinations and click on la button will display the information on the screen e The three dropdown could be used to select different combinations to extract the specific information Examples are as follows gt Combin
12. a ORACLE 3 2 Performance Measurement Tools One of the defining factors in selection of a portfolio management system is the degree it enables a manager to set and meet performance goals FLEXCUBE Private Banking provides return analytics based on Modified Dietz rate of return Returns are calculated net of fees using the trade date accounting and with accrued interest receivable Simulation Simulation is a powerful tool allowing you to review how specific change in holdings will affect a portfolio s position before any trades are executed Several holdings position can be reviewed simultaneously Portfolio Alerts The alerts facilitate by providing the customer or the Relationship Manager a round up of all the relevant information about their investments Weighted Average Cost As mentioned in the Admin amp Ops User Manual FCPB supports both the calculation methods FIFO First In First Out and WAC Weighted Average Cost The user can decide on the method of calculation based on the flag set at the Bank Parameters If it is set as F it uses FIFO method and if set as W uses WAC method In WAC for any new buy transaction the system adds the buy cost of new transaction to the previous holding buy cost to arrive at new holding buy cost and then divides the total cost by the holding quantity to arrive at Weighted Average Buy Cost WAC On the other hand in case of sell transaction system reduces the holding buy
13. Reminder Figure 3 47 Portfolio Alerts Reminder Screen The fields displayed in the tab have been inscribed in the table below Field Description Mandatory Date Enables the user to select the appropriate date using Y the calendar icon till which the alerts are required to be generated Description Enable the user to enter the appropriate description Y of the alert to be set in the Description text box Delivery Mode Enables the user to select the appropriate delivery Y mode for Reminder alerts Applicability Enables the user to select the appropriate recipients Y for the alerts using the option in the drop down list Track Goals Description Once the goals are linked to portfolios they can be tracked using the Track Goals screen In the screen the portfolios linked to goals are projected to future goal years to determine whether they grow up to the goal value in defined goal year The current RoR of the linked portfolio is used to project the portfolio value in the goal year The screen also displays the appropriate shortage surplus in the goal year which helps the user to understand whether the customer is on right track to meet the defined financial goals User Access levels Customer The screen is also accessible by the customer to track the financial goals 3 128 ORACLE h Current Portiolo Since Inception Cumutative Goal Value Members nas ad Valve Rat Rameatired Corea Voor
14. Click the S icon next to the Lead Generation Code field When the user clicks on the y icon next to the Lead Generation Code field the Banker Lead Code Search window appears Enter the appropriate search criteria in the respective fields to search for the Lead Generation Code Step 4 The subsequent step is to capture the security details For placing the order the user has to select the security and the exchange in which he wants to transact F The user can select the security by using section icon as explained in general characteristics The security search screen displays only the securities which are in active status If the recommended list is getting deviated the system displays the error message as The selected instrument is not recommended for risk profile Do you want to proceed si ORACLE If there is a model portfolio defined for the risk model and if the Instrument selected is outside the model portfolio of the client the system displays an error message as This instrument is outside the Model Portfolio do you wish to continue Yes No If you click on Yes button then you are allowed to tab out and continue with the order The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section On picking a security through the search screen the secur
15. Field Description Mandatory 1st Joint Holder User needs to select the existing customer as N a joint holder from the drop down list User can 2nd Joint Holder select maximum of three joint holders to any portfolio which are existing customers in FCPB 3rd Joint Holder Allow Order Enables the user to grant the rights to place the N Placement Order for selected portfolio NOMINEE Field Description Mandatory 1st Nominee The text box fields have been provided to N capture the nominee details User can add 2nd Nominee maximum of three nominees to the selected portfolio 3rd Nominee 3 8 ORACLE Field Description Mandatory Relationship Three drop down lists have been provided for Mandatory capturing the relationship of each nominee ifa with the account holder nominee name is entered Ownership Three text box fields have been provided for Mandatory capturing ownership of each nominee for ifa the selected portfolio nominee name is entered 3 2 2 Portfolio Maintenance Modify Delete Screen Navigation 1 After the customer logs in the portfolio creation screen can be accessed through the Portfolio and Maintenance sub menu Select the portfolio you want to Modify Delete by checking the radio button Modify Delete i 2 Click on the button in the Portfolio Maintenance screen A customer is not allowed to Modify Delete RM managed or discretionary portfolio This is f Modify Dele
16. The methodology of capturing this data and handling them for the securities under the instrument type Mutual Fund and Structured Products varies to some extent from that of the securities held under the instrument type PMS While adding the securities under the instrument type Mutual Fund or Structured Products the constituents under these instruments will be either received as external data feeds or can be manually put in by the administrator as distinctive securities in the Instrument Master Table For the securities held under the instrument type PMS the constituents of the scheme will be received as external data feed from the issuer of the PMS and will be specific to each customer account However depending on the instrument type of the constituents they will be analyzed further for their sub constituents Consider the case where the customer has a holding ina PMS scheme for which the constituents are IBM Microsoft and Franklin Templeton Mutual Fund While analyzing the holdings of the PMS the system will consider IBM Microsoft and the sub constituents of the Mutual Fund 3 80 ORACLE Field Description Mandatory Consequently on selection of the asset class type of analysis you are provided with the details of not only the direct investments but also the indirect investments in the different asset classes The indirect investments are on account of the holdings in mutual funds PMS and structured p
17. Treasury Total Amount Displays the Treasury Total Amount and is calculated Y as Treasury Price x Quantity x Cap Factor x Face Value 100 Accrued Interest Customer Total Displays the Customer Total Amount and is Y Amount calculated as Customer Price x Quantity x Cap Factor x Face Value 100 Accrued Interest Transaction Fee Profit Flat Displays the Profit in absolute term and is calculated as Spread Amount Transaction Fee Profit Per Year Displays the Profit per year It is calculated as Profit Flat Nominal Amount Total Term 365 System uses the corresponding day count convention to calculate Term and no of days in the year Counterparty Name Enables the user to select the appropriate counter Based on party details FAC 5 56 ORACLE Field Description Mandatory Counterparty Ref No Enables the user to select the appropriate counter Based on party ref no FAC Application No In case of offline bond orders this field provides a N facility to capture the document application number Description Enables the user to capture the transaction details for N the order Payment Details DP ID Client ID Displays the depository trading accounts available for Y the customer depending on the selected Portfolio Name If the Order Type is Sell then it displays only those DP Id Client Ids in drop down against which a Buy transaction was done for the selected portfolio If th
18. Trigger Price If user Order Type selected is Limit Order or Stop Loss order this field is activated to enter the value and it is mandatory field else it is a disabled field and non mandatory If the user enters the Trigger Price more less than X of the LTP then system displays a warning message Y N i ORACLE Field Description Mandatory Time Condition Specifies the validity of order with respect to time Y When the Timed order is selected system populates additional field Expiry Date and enables the user to enter the appropriate date and time Expiry Date This field is enabled only for the Timed Order type Y and enables the user to enter the expiry date By default the system displays the current business date as Expiry Date Accrued Days Displays the No of days for which accrual has taken place Interest Displays the Accrued interest for the order Treasury Price Enables the user to enter trading desk price Treasury Yield Displays the Trading Desk Yield for the order Customer Price Enables the user to enter customer price Y Customer Yield Displays the Customer s Yield for the order Spread It is computed and shown as Treasury Price N Customer Price for Buy Order amp Customer Price Treasury Price for sell orders Transaction Fee The value is defaulted based on the Fee setup done Y Including Taxes and for the IAG Order Type Client or Client segment Surcharge
19. Y Step 2 The subsequent step is to select the fund schemes For placing the order the user has to select the fund scheme in which he wants to transact from the Scheme Name drop down list The fund scheme drop down displays only the schemes which are in open status Step 3 On picking a fund scheme through the search screen all the existing folio number s affiliated to the fund scheme in the portfolio of the selected customer will be displayed in the Folio No dropdown field Please note only the folio s in which the customer currently has holdings will be displayed in the drop down list It is obligatory for the user to select one of the folio numbers displayed in the list Every order initiated through the FCPB will have a unique transaction id associated to it The id would be generated for every customer portfolio order combination FCPB assumes that this identification would be a common interfacing attribute between the external system and the FCPB On selecting the fund scheme and the folio number the currency the current NAV and the dividend option of the scheme will be displayed in the corresponding Currency NAV Counterparty and Dividend fields in the order screen Step 4 Select the appropriate Trade Date and Settlement Date using the calendar icon Step 5 The next field has a radio button adjacent to it The user has the option to opt between units and amount to redeem Thus
20. Fee Amount Displays the fee amount for the corresponding transaction Transaction Date Displays the transaction date of the corresponding transaction Status Displays the status of the corresponding transaction Maker Name Displays the Maker Name Action Displays the group of actions available to be performed on the corresponding transaction Procedure to Modify the Transaction Step 1 From the Portfolio Name drop down list select the appropriate Instrument type Step 2 From the Instrument Type drop down list select the appropriate Instrument type Step 3 Click the a icon next to the Instrument field and select the appropriate Instrument 5 16 Bank A C and Loans Screen User Access levels 5 158 ORACLE Customer The Bank A c and Loans screen will retrieve all held away accounts in editable mode for Assets and Liabilities and also TD Instrument Type For internal non held away accounts retrieval of data is only in Display Only mode and such records cannot be modified by customer Retrieval logic is based on whether the banking product type is an Asset or Liability Held away accounts created by RM or Customer can be modified by the Customer in the future Held away accounts created by Customer can be modified only by Customer and are non modifiable to the RM user The same screen is also invoked in Customer Login from Customer Dashboard gt Networth portlet gt Networth Blowup ico
21. Order capture Rules for Commencement of an Order e Orders can be placed only for customers in active status e For initiating an order the customer should have either a portfolio coupled to his id e The electronic trading account identification of the customer also needs to be updated in the FCPB prior to initiating an order e Similar to the electronic account information the customer also needs to include the particulars of his bank account in the FCPB prior to order initiation Procedure for placing of an Order ra ORACLE Step 1 If the Income Tax ID Required and Risk Profiler Mandatory options are set to Yes in the Instrument Type screen of Admin login and the corresponding details for the selected customers are not updated then the system displays the appropriate messages and will not allow the user to place the order The Portfolio Name is the first field displayed in the Order Capture screen The dropdown list should have all the portfolio names of portfolio type based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Step 2 Click the S icon next to the Source Code field When the user clicks on the a icon next to the Source Code field the Banker Source Code Search window appears Enter the appropriate search criteria in the respective fields to search for the Source Code Step 3
22. e Average Clean Buy Price e Custody Fee e Last Traded Clean Price If the issue start and end date is null or if the issue end date is less than the current system date for the selected instrument then the user should not be allowed to select an Order Type IPO and it should display an error message as Selected instrument is not available for IPO subscription Step 3 Select the appropriate Trade Date using the calendar icon ee ORACLE Step 4 Select the appropriate Settlement Date using the calendar icon Step 5 From the Transaction Type drop down list select the appropriate order type There are two options available for Bonds Order Capture They are Buy and Sell By default Buy option is selected Step 6 Enter the appropriate amount in the Nominal Amount text box If the bond Quotation Method defined is Quantity then it is a display only field and computed as Quantity entered Face Value of the bond Once the user enters the Nominal Amount the system displays the data in the Quantity Accrued Days Interest Treasury Price Treasury Yield Customer Price Customer Yield Spread Profit Flat and Profit Per Year fields If the spread calculated in the order capture is negative or zero and there is no relevant spread master maintained in the system then the system displays the appropriate error message This is applicable for Bonds TD Commodities FX and SP instrument types Step 7 From the
23. e Expiry Date e Instrument Currency sues ORACLE e Settlement Currency The user can select the future instrument either by directly entering the id or by searching for the ra security using icon as explained in general characteristics section The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments Focussed instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Step 4 ra Select the appropriate issuer broker by clicking on the icon next to the Counterparty field Step 5 Select the appropriate transaction option from the Transaction drop down list Step 6 Select the appropriate transaction date Step 7 Enter the appropriate quantity in the Quantity box The quantity entered should be in multiples of regular lot size Step 8 Enter the appropriate price in the Price field Step 9 The amount field gets populated on entering valid Quantity and Price data Step 10 aR ORACLE Enter the transaction description in the Description text box Step 11 Click the Submit button On submitting the holding the system displays a confirmation message on the screen If the user changes decisi
24. open orders Ordered The status of the order is displayed as Ordered when order approval is not required and the user has successfully placed the order Pending Auth The status of the order is displayed as Pending Auth when the order is pending for approval from the authorizer Deleted by Maker The status of the order is displayed as Deleted by Maker when the person initiated the order deletes it Rejected by Auth The status of the order is displayed as Rejected by Auth when the order is rejected during authorization Excp Approval The status of the order is displayed as Excp Approval when the user has received warning messages while placing the order and is pending for approval from the authorizer Inv Spe Approval An investment specialist is an employee of the bank with expertise in handling specific types of investments like realty structured products bonds etc There are certain instruments which need the involvement of investment specialist to complete the execution of transactions In these cases investment specialist negotiates with counterparties to arrive at a deal to get better price The status of the order is displayed as Inv Spc Approval when the Investment Specialist flag is set as Yes in Product Access Level of Employee Maintenance and is pending for approval from Investment Specialist Partially Executed Cancelled The status of the order is displayed as partially executed cancelled when a portion of the ord
25. the user has the flexibility to enter any desired price If a user mentions a price it should be in multiples of the tick size for that particular security and within the day s minimum maximum price range ORACLE For Limit Order also the system should default the Time Condition field to GTC e IPO If the system date is in the range of the selected instrument s New Issue Start Date and New Issue End Date then the instrument qualifies as an IPO Once the instrument selected is classified as an IPO gt Transaction should be defaulted to BUY gt Order Type should be defaulted to IPO gt Time condition should be defaulted to GTC gt All the above fields should be disabled If the issue start and end date is null or if the issue end date is less than the current system date for the selected instrument then the user should not be allowed to place an Order Type IPO and it should display an error message as Selected instrument is not available for IPO subscription Step 9 After selecting the Order Type the user proceeds to enter the quantity for the transaction Quantity mentioned should be in multiples of regular lot size for that security To recap for a sell transaction the user will be restricted to the extent of balance quantity available in the security If the selected instrument does not follow the Model asset allocation for the customer the system displays the message as Model asset allocati
26. which the customer has invested for his equity holding 2 For further analysis of the holdings in each segment of market capital you can click on the hyper link under each segment in the first table An additional tab will appear below which will provide further information and analysis about the securities held in the selected market capital The screens on Analysis By Industry and By Market Capitalization are similar and so are the fields in all the three screens The detailed descriptions of fields are given below Market Capitalization Field Description Mandatory Market Capital All the segments of the market capital in which the Display equity holdings of the selected customer span across only are displayed Each segment in the tab has a hyper link Click on the hyper link to view a tab displaying additional analysis of all the securities in the selected segment Market value Is computed as mentioned in the Asset class Display analysis However only the securities within the only category of equity instrument type are considered for computation of Total Is the percentage composition of the segment of Display market capital under consideration with respect to the only total value of all the segments The sum of the percentages across all the segments would sum up to 100 At the end of the tab the last row displays the sum of all the above fields in the customer pref
27. 1000 TISCO Equity INR 1500 SBI Equity 00 HDFC Bank Equity Reliance Growth Fund MF Figure 3 17 Scheme Details Screen Field Description Mandatory Instrument Name All the names of the constituents of the scheme Display are displayed in this field These constituents only will be received as an external data feed Currency This field displays the constituent s currency Display only Quantity Along with the constituents the external data Display feed is also assumed to constitute the only magnitude of investment in each constituent It is also assumed that this holding information received from time to time as data from external data feed will also constitute the units received as corporate action oo ORACLE 3 3 9 Buy Cost This field indicates the total amount invested by Display the customer in each constituent only Market Value Market value indicates the value of the Display constituent as of the given valuation date only Please note that the updating of the market price of all the constituents falling under the category of equity mutual funds and traded bonds will be similar to the other direct holdings of the customer in these instruments Value Date Indicates the latest date of reception of the Display market price feed only As explained earlier on clicking on any of the securities in this tab displays the entire transaction details of the security in a p
28. 14 Enter the appropriate rate in the Exchange Rate text box Step 15 i ORACLE Select the appropriate option for Asset Transfer In field Step 16 After entering all the fields in accordance to the outline given in the above steps you can proceed to click on the submit Submit _ button On saving the holding you will be displayed with a confirmation message on the screen If you change your decision on updating the holding you have the option to clear the entire details captured earlier by clicking on the button Structured Product s Transaction Management Unwind User Access levels Customer Can capture the unwind transactions only for his her avaliable portfolios ee ORACLE Screen Figure 5 22 SP Transaction Management Unwind Screen Screen Navigation After logging in the system select Txn Management Structured Products The screen defaults to the Buy tab Click on the Unwind tab ig ORACLE Rules for Commencement of a Transaction e Transactions can be updated only for customers in active status e For capturing a holding the customer should have at least one portfolio coupled to his her id and have holdings of an SP instrument type Procedure for Capturing a Transaction Step 1 Pre filled information of the holding is displayed on accessing the screen The screen will display the number and name of the customer Step 2 Select the appropriate portfolio and the instrument from
29. 34 12 2020 CALL 20 0000 INR 1055 10 0000 240 0000 12 000 000 45 0000 00 1 04201 Buy Sell Total INR 252 000 000 254 000 Figure 3 23 Options Valuation Screen Field Description Mandatory Instrument Name The field displays the Futures Instrument type Display only Exp Date The field displays the Exp Date of the Futures Display contract only Opt Type The field displays the appropriate option type Display only Stk Price Strike The field displays the price defined at instrument Display Price creation level This price is displayed in only instrument currency Instrument Currency The field displays the instrument currency Display only P ORACLE Field Description Mandatory Settlement Currency The field displays the currency in which Display settlement took place only Account Number The field displays the Account Number for the Display option only Premium Unit The field displays the premium amount in Display Paid Recd multiples of tick size only No of open The field displays number of the open future Display contracts Long contracts only Short Buy Cost The field displays the price of the option Display Premium Net Margin only Paid Market Price Market Price of the option Display only Margin Amount The field displays margin amount to be paid Display only Market Value Market Value of future Display only Value Date Indicates the latest date of rec
30. After entering all the fields in accordance to the outline given in the above steps you can proceed to click on the Submit button On saving the holding you will be displayed with a confirmation message on the screen If the user changes the decision on updating the holding to clear the entire details captured Clear earlier click on the button 5 7 PMS 5 7 1 Order Management for PMS Please note that though this section of user manual explains order management and capabilities of PMS instrument type but these features of order management UI and processing would be available to the bank only if the bank s license entitles them to the Alternative Investments module and Order Management module PMS Order Capture Buy User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y oo ORACLE Screen WAS Figure 5 23 PMS Order Capture Buy Screen Screen Navigation After logging in the system select Order Management gt PMS gt PMS Order capture Rules for commencement of an Order The rules for placing the PMS order are Orders can be placed only for customer
31. Asset Class Equity and they represents some appropriate Asset Class like Cash or Liquid etc these Instrument types are not displayed in this section At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency Introduction of Household Concept An important aspect of Wealth Management is the ability for the user to track the holdings across the various members of the household in a single window Likewise it is also essential for user to view the analysis of the household holdings in different dimensions in a single window This feature of viewing the analysis of the holdings across the household members was introduced in the Release 1 3 The user can thus view the analysis for the customer or for any individual member of his household or can even observe a consolidated analysis across all the members including the customer one ORACLE 3 5 As per Release 1 2 all the analysis dimensions considered the consolidated holdings of the customer across his her portfolios excluding the analysis dimension Portfolio which considered the holdings of the customer in individual portfolios The Release 1 3 has introduced additional flexibility to the user enabling him her to view the various analysis dimensions for each individual portfolio Let us now proceed to understand the modifications done to the screen in order to accommodate the new functionalities As per our understanding to
32. Customer Name Portfolio Name Displays the list of the portfolio names for the Y customer Instrument Details Bond Name Enables the user to select the appropriate bond Y name by clicking on the search icon available next to the Bond Name field Instrument Currency Displays the instrument currency for the selected bond name Once the Bond Name is selected system auto populates this field Settlement Currency Displays the settlement currency for the selected bond name Once the Bond Name is selected system auto populates this field ae ORACLE Field Description Mandator y Acquisition Details Transaction Type Enables the user to select the appropriate transaction type from the drop down list The transaction types available in the drop down are Buy Sell Asset Transfer In and Asset Transfer Out Settlement Type Enables the user to select the appropriate settlement type from the drop down list For Buy transactions the system displays the settlement types as Receipt Free and Receipt Against Payment For Sell transactions the settlement types are Delivery Free and Delivery versus Payment Transaction Date Enables the user to select the appropriate transaction date using the calendar icon Settlement Date Enables the user to select the appropriate settlement date using the calendar icon The settlement date cannot be less than transaction date it can go beyond system da
33. From the Bank Account No drop down list select the appropriate bank account no Step 19 Click the Submit button Once the user clicks on the Submit button system displays the Exception pop up window stating the conditions that are violated Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 aE ORACLE 5 6 2 Transaction Processing for Structured Products Sricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Alternative Investments Module of FCPB Description Structured Product is generally a pre packaged investment strategy which is based on derivatives such as a single security a basket of securities options indices commodities debt issuances and or foreign currencies and to a lesser extent swaps Combinations of derivatives and financial instruments create structures that have significant risk return and or cost savings profiles that may not be otherwise achievable in the marketplace Structured products are designed to provide investors with highly targeted investments tied to their specific risk profiles return requirements and market expectations These products are created through the process of financial engineering i e by combining underlying like shares bonds indices or commodities with derivatives The value of derivativ
34. Name Once the user selects the Scheme Name following fields are populated with the respective data e Issuer Name e Scheme Type e Currency The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Step 3 Select the appropriate option for the Personal Details category vue ORACLE The options available here are same as Customer and Other If the user selects the same as Customer option the Name of the Insured and DOB fields populate with the appropriate customer data If the user selects the other option then enters the appropriate data for the Name of the Insured and DOB fields Step 4 Enter the appropriate height in the Height text box Step 5 Enter the appropriate weight in the Weight text box Step 6 Enter the appropriate annual income in the Annual Income text box Step 7 Select the appropriate option for the Medical Checkup reqd field The options available are Yes or No By default the No option is selected Step 8 Enter the appropriate application no in the Application No text box Step 9 Enter the appropriate amount in the Sum Insured text box Step 10 Enter the appropriate amount in the Premium Amount text box Step 11 From the Premium Frequency drop down list select the appropriate frequency The options available here are Annua
35. OTHER COLLECTIBLES csccccssessesssseseesssscsseesseesseessecaseessasaseesseeasensaas 5 102 5 8 1 Transaction Processing fOr Othets ccsccesccesceseesseerseeeeeseeseeeeeceeecesecaecuaecsaecaaecsaeeseeeseesaeeeeeeneensees 5 102 O98 WCOMMODINIBS parcie n n AE EEEE 5 108 5 9 1 Order Management for Commodities es osssseseeseeeeeeeeenesesreesrsreerssresrssereesesreerestenreserrreesteeseseeets 5 108 5 9 2 Transaction Processing for Commodities ssssssessessessersenesesreereerreserrerreresreeresrenrerrerrnserrreresrrereseee 5 115 A FUTURES E A E 5 120 5 10 1 Order Management for Futut ES sinisesse iE A NE ENN 5 120 5 40 2 Transaction Processing fOr Futures cissecenasincnisnoiisaia irn a NE 5 124 LL o E E E E 5 127 S 11 1 Order Management for Options cccccccesccescesecsseesseeseeseeseceeesesecesecesecaecsaecaaecaeeeseseseesseeeeeeneeeaees 5 127 5 11 2 Transaction Processing fOr Options ccsccesccesecsceeseenseeseeseeeeeeesecesecesecsaecaecaaecaeeeseeesseeseeeeeeneanaees 5 133 DAD FOREX 2525 Seieas E E E A E T seas ceases ei te nec asses een ty eats 5 136 5 12 1 Order Management for FOrex cccccccsccesceseceecusecneeeseeeseeeceeeeeeeceaeesecaecsaecsaeeaeeeseeeaseesaeenseeeeeaees 5 136 5 12 2 Transaction Processing fOr FOreX cccccccesccesecesecuseenseeseeseeseeeeeeeeecesecesecaecsaecaaecaeessaseaseeseeeaeeneeeaees 5 142 DS GENERIC INSTRUMENTS 25 ic 2 lt scascescusegecstesapuesecnteacengudensdeuttestebusienesegtugag
36. Step 7 Enter the appropriate price per unit in the Price Units field The system then calculates the total amount and displays it in the Amount field Step 8 Enter the appropriate transaction fee in the Fees field Step 9 Enter the appropriate brokerage commission in the Commission field Step 10 aie ORACLE Enter the appropriate amount in the Tax amp Other Charges field Step 11 Enter the appropriate rate in the Exchange Rate text box This field is enabled only if the instrument and settlement currency is different else it is defaulted with value 1 Step 12 Select the appropriate Counterparty name using the search icon If the user enters the Counterparty name the Counterparty Ref No is a mandatory field else the system gives the error message Step 13 Enter the appropriate ref no in the Counterparty Ref No text box If the user enters the Counterparty Ref No the Counterparty name is a mandatory field else the system gives the error message Step 14 Enter the transaction details if any in the Description text box Step 15 Select the appropriate account no from the DP ID Client ID drop down list The system defaults the account no based on the flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Security Account field Step 16 Click the Save button On saving the holding you will be displaye
37. Y Customer Price This field displays the Customer Price per unit of Y Commodity Currency 5 110 ORACLE Field Description Mandatory Fees Fee charged to the customer based on segment Instrument Group IAG of the customer The fee includes Taxes and Charges Y Total Customer Amount It displays the Total Amount charged to customer as per Customer Price i e Customer Price Quantity Fee Counterparty Name Enables the user to search for the appropriate Counterparty Name for the transaction Based on FAC Counterparty Ref No Enables the user to enter the transaction reference number Based on FAC Description Enables the user to capture the transaction details for the order N Account Details DP ID Client ID Displays the depository trading accounts available for the customer depending on the selected Portfolio Name If the Order Type is Sell then it displays only those DP Id Client Ids in drop down against which a Buy transaction was done for the selected portfolio If the Allow Omnibus flag is selected as Y at Instrument Type level the system defaults this drop down to the Omnibus Account No along with the DP ID Client ID Bank Account Enables the user to select the appropriate bank account no from the drop down list Comments Enables the user to capture remarks before saving the order details Y N Procedu
38. a diversified portfolio of high yield bonds will over the long run have only a modest risk of default it is extremely important to understand that for any single bond the high interest rate that generally accompanies a lower rating is a signal or warning of higher risk Understanding Transaction Management of Bonds To reiterate our earlier narrative FCPB assists in maintenance of a full history of executed transactions even for those securities which were not transacted through FCPB In this section we will comprehend the transaction management for the Bond holdings All the transactions for the instruments defined under the category Bonds can be captured by the user into any of the portfolios Though the Bond holdings have not been acquired through the FCPB the consideration for allowing the user to capture his holdings in the RM Managed and Self Managed portfolios is due to the perception that these holdings could have been obtained through any other system within the bank FCPB currently supports transaction management for both the traded and non traded bonds Currently FCPB does not aggregate multiple purchases made into the same holding in a bond ina selected portfolio by a customer Due to this any additional purchases need to be captured as separate security holding or first time purchase vee ORACLE To recap for the traded bonds the market price for the holdings will be received as external feed from data vendors whe
39. amp Operations Only the person designated as Operations or Customer can access this screen The idea behind making the CA questionnaire available to the Operations user was that the Operations person should be able to print the CA questionnaire and send it to clients who are not able to access the internet and once the client faxes bank the responses they should be able to fill the responses on the client s behalf Screen a ORACLE Figure 2 4 Voluntary Corporate Action Screen for Customer Screen Navigation After logging in the system as Customer select My Workspace gt Voluntary Corporate Action from the top menu Field Description Mandatory Y N ID Displays the Voluntary Corporate Action ID N Voluntary Displays the name and type of Voluntary N Corporate Action CA It is displayed with hyperlink on click of Name which the system displays the corresponding CA Questionnaire Instrument Name Displays the name of the instrument for the N given Voluntary CA Portfolio Name Displays the name of the customer portfolio Folio No Displays the Folio No for the given instrument for which the CA has been declared Record Date Displays the record date of voluntary CA Closure Date Displays the closure date for voluntary CA After this date the customer will not be able to view the questionnaire To view the questionnaire click on the desired VCA Name hyperlink Scr
40. and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y ae ORACLE Screen Order Magee Name Porthos Tas Managemmnt Onder Mgmt Toole Raparte My Wertepere Lopes Orem Mgmt gt MP gt Ortar Capture f f Figure 5 5 Mutual Fund Order Capture Redemption Screen Screen Navigation After logging in the system select Order Management gt Mutual Fund gt Redemption The screen will however default the subscription tab Rules for Commencement of Redemption e Redemption orders can be placed only for customers in active status e The bank account information of the customer is mandatory for initiating a redemption order Procedure for Placing of a Redemption Order Though most of the fields for redemption are analogous to subscription for simplicity the particulars of the fields have been repeated again in this section sia ORACLE Step 1 For a customer login the Portfolio Name drop down list defaults to the default portfolio of Portfolio type Self Managed The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to
41. back dated transactions FCPB considers the FX rate based on transaction date and not the latest FX rate aT ORACLE The system puts an additional check on the user from capturing a future transaction date Step 7 Once the transaction date is entered the user can enter the Settlement Date Step 8 In the next step the user has to capture the quantity of holding While there is no restriction on updating the information on a buy transaction the sell transaction is restricted to the extent of balance quantity available for the security in the portfolio of the selected customer Please note that though these transactions are being captured for the holdings in a Held Away portfolio all the holdings in the same equity security held in the same portfolio of a customer will be consolidated Step 9 The next significant step is to capture the net purchase price of the holding Please note that it is this price which will be considered for the purpose of analysis and performance computation and hence it is the responsibility of the user to enter the accurate value This field too is mandatory for entry by the user Once the Quantity and Price is entered the system calculates the total amount and displays it in the Amount field Step 10 Enter the appropriate transaction fee in the Fees text box Step 11 This field indicates the brokerage charged for the transaction The calculation is done by the broker master Enter the appropriate
42. based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen ORACLE gt FLEXCUBE Private Banking User HO HEAD Current Login 27 05 2011 7 06 PM _ Last Login 27 05 2011 6 55 PM Home Customer Financial Planning Order Mgmt Txn Mgmt Reports Tools My Workspace Logout L Txn Mamt gt Structured Products De Buy Customer Details r No 10906 Sanjot Kohli RM Managed M Nominal Amount Transaction Details Transaction Date a Match With Order Submit Clear Figure 5 20 SP amp Alternatives Order Capture Sell Screen Screen Navigation After logging in the system select Order Management gt SP and Alternatives The screen will default to the Buy tab Click the Sell tab ie ORACLE Procedure Step 1 Customer For a customer login the Portfolio Name is the first field displayed on the Order screen The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Step 5 From the Instrument Name drop down list select the appropriate Instrument name Once the user selects the Instrument Name following fields are a
43. be available for the customer to fill Status Indicates the survey status To view the details of the questionnaire click on the appropriate Survey Name hyperlink Screen User Remo Swamy Current Login 03 10 2009 12 48 AM Last Login 03 10 2009 12 48 AM FLEXOUBE PRIVATE BANKING Home Portfolio Txn Management Order Mgmt Tools Reports My Workspace Logout My Workspace gt Survey Questionnaire SURVEY QUESTIONNAIRE Survey4Moumita 1 How often does your RM Communicate with you 2 How long have u been a customer More than 3 years Save Reset Figure 2 13 Survey Questionnaire Once the user clicks on the Save button system displays the message Please note that your responses will be submitted and you cannot change your responses again Do you want to proceed and saves the questionnaire ne ORACLE 3 1 3 Portfolio Management Introduction FCPB portfolio management offers a comprehensive management and administration solution for the customer s entire portfolio The user has the ability to capture investment details in all major asset classes and customer s portfolio has its own investment mandate reflecting his risk profile and asset allocation Oris section explains portfolio management capabilities for all the instrument types supported by FCPB but only those Instrument Types would be available to the bank as per their e
44. before the purchase date The user is also restricted from capturing a future valuation date Step 4 The next field Market value is a display field The market value is computed as the product of the market price and balance units held in the bond Step 5 After entering all the fields in accordance to the outline given in the above steps you can proceed Sa to click on the save button On saving the modification you will be displayed with a confirmation message on the screen If you change your decision on the modification you have the option to clear the entire details o Clear captured earlier by clicking on the button Tal ORACLE 5 4 2 Order Management for Bonds Please note that though this section of user manual explains order management and capabilities of Bonds instrument type but these features of order management UI and processing would be available to the bank only if the bank s license entitles them to the Traded Securities module and Order Management module Bonds Order Capture Buy User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y
45. class debt real estate cash and others the market value would be based on of the asset value on the total value of the fund The number of units as mentioned earlier will be defaulted to 1 of total This is the percentage composition of the asset under consideration with respect to the total value of all the assets The sum of the percentages across all the asset class would sum up to 100 Display only Annual ROR The performance figures computed using Linked Modified Dietz methodology are displayed here The returns computed from the first funding date of the asset class since inception are displayed here Instrument Type Field Description Mandatory Instrument Type Instrument type classification of the holdings at customer or household level is displayed here Display only Market Value The market value for a particular instrument type represents the sum of the market values for all the direct and indirect held securities in customer preferred currency Display only ne ORACLE Field Description Mandatory of total This is the percentage composition of the holdings in an instrument type under consideration with respect to the total value of all the holdings across all the instrument types The sum of the percentages across all the instrument type would sum up to 100 Display only Instrument Group Field Descripti
46. considered for the purpose of analysis Display only Units As mentioned earlier the units considered for are after the application of the FIFO accounting rule In addition to the units purchased additional units received due to stock corporate actions are also taken into consideration while determining the units For the securities purchased under the instrument type insurance PMS SPL Product CASA TD others Futures and Options the units are not displayed by the system Display only Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only Market price The market price for securities defined under the instrument type equity mutual fund traded bonds PMS SPL Product and structured product will come as a feed from external source For the securities under the instrument type insurance others and non traded bonds the price is as per the last manual update For the securities under the instrument type CASA and TD the current balances in the accounts will be considered as their market price Display only 3 74 ORACLE Field Description Mandatory Market value Market value is the product of the market price Display and quantity The system also provides the only hyperlink to the Total Market Value giving the details of Unrealized Realized Gain Loss summary in Portfolio and Client Currency against each instrument wi
47. constituents we are indicating the constituents arising due to the scheme having a Mutual Fund as its constituents Let us understand this with an example ale ORACLE A customer invests in a Portfolio Management Scheme XYZ Consider the constituents of the scheme to be Reliance Industries Infosys Technologies and Franklin India Mutual Fund Thus along with the holdings in Reliance Industries and Infosys Technologies the sub constituents of the Franklin Mutual Fund will also be considered for the purpose of analysis Every new security in FCPB needs to be added to the Instrument Master Table before it may be used in the portfolio records The instrument master table contains the various related data for the security such as the instrument type currency region industry and asset class 4 On selection of a particular instrument type by means of clicking on the hyper link provided under each instrument displays a third tab which illustrates the valuation of each security held in the selected instrument Equity Transaction Details CANARA Transaction Transaction n Settle Currency Exchange Fees in SettleTax amp Chargesin Settlement View Transaction e Ma Type Marration Desc Cate Price Amount AtermateCumrency Rate Currency Settle Currency Amount Advice Slip INR 20 04 2012 Buy Buy 1 000 0000 50 0000 50 000 000 INR 1 000000 Figure 3 3 Equity Transaction Details Window FCPB also enables the user to vie
48. currency computed as explained in the earlier section Time Deposits TD Time deposits TD are deposits that are with the bank for a fixed period and earn a rate of interest during the tenure of investment Standalone TD s are classified as debt and the interest computation is like any other debt instrument such as bonds debentures etc 3 55 ORACLE In FCPB Time deposit will be mapped to instrument type Time Deposit For each currency there will be only one instrument maintained in the Instrument Master Mst_Instrument with any suitable identifiable name like TD in HKD or Time Deposit in USD etc The FCPB system also supports the user to place the orders for Dual Currency deposits A Dual Currency deposit DCD is a Structured product which combines a term deposit with a currency option to provide a higher yield than that is available for a standard deposit TD Instrument scan also be Call Deposits and these would have the Callable flag set to Y in the Admin gt Product Master screen Such Call Deposit type of TD Instruments can be given any suitable name like Call Deposit in HKD Call Deposit in USD etc Once the TD transactions are uploaded from the core banking system the same will reflect in the Portfolio Maintenance screen under the Time Deposit instrument type classification Once the user clicks on further drill down of the TD instrument type details of each TD should be d
49. down list Instrument Type Enables the user to select the appropriate instrument type from the drop down list Instrument Enables the user to select the appropriate Instrument by clicking on the search icon available next to the Instrument field Folio Account No Enables the user to select the appropriate Tax A c Identifier This field is enabled only if the selected Instrument Type is Equity or MF Status Enables the user to select the appropriate status from the drop down list Country of Market Enables the user to select the appropriate Country of Market using Search icon to search for the desired transactions If selected the system displays the transactions for the selected country only Settlement Status Enables the user to select the appropriate Settlement Status to search for the desired transactions ne ORACLE Field Description Mandatory Transaction Type Enables the user to select the appropriate transaction type from the drop down list The system auto populates the Put option in the drop down list if the selected instrument is Putable or Callable Putable Transaction Date From Enables the user to select the appropriate From transaction date using the calendar icon Transaction Date Enables the user to select the appropriate To To transaction date using the calendar icon Transaction Displays the transaction amount Amount
50. e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 5 10 2 Transaction Processing for Futures riase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Alternative Investments Module of FCPB User Access levels Customer Can capture the transactions only for his her portfolios ee ORACLE Screen ape k Figure 5 31 Futures Transaction Capture Screen Navigation After logging into the system select Transaction Management gt Futures Procedure for Placing of a Transaction Step 1 The system auto populates the customer no name and default portfolio name of the customer Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 Click the a icon next to the Futures ID field When the user clicks on the a icon next to the Futures ID field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the Futures ID Once the user selects the Futures ID following fields are automatically get populated e Futures Name
51. enter the appropriate Y exchange rate in the Exchange Rate text box The system defaults this value to 1 if the instrument currency and settlement currency is same Counterparty Name Enables the user to search for the appropriate N Counterparty Name for the transaction Counterparty Ref Enables the user to enter the transaction N No reference number Description Enables the use to enter the transaction details if N any in the Description text box It is a free text box and allows the user to enter maximum 250 characters DP ID Client ID Displays the list of depositories and Client id Y combination available in the drop down list Procedure for placing of an Transaction Step 1 The system auto populates the name no and default portfolio name of the customer which is already in context Step 2 5 117 ORACLE For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 Click the 7 icon next to the Instrument Name field ae J Once the user clicks on the icon Instrument Search pop up window appears Enter the appropriate search criteria in the Name field to search for the Instrument Name Once the user selects the Instrument Name following fields automatically populates e Instrument Currency e Settlement Currency e Measured Units Step 4 From the Transaction Type drop
52. from the drop down list By default the system selects the Market Type option No of Contracts Enables the user to enter the appropriate no of Y contracts Quantity Displays the appropriate quantity in the text box Y once the user enters the no of contracts Trigger Price Enables the user to enter the trigger price if the Y Order Type is selected as Stop Loss or Limit Order from the drop down list else system auto populates the appropriate value Time Condition Enables the user to select appropriate values like Y GTC IOC Timed Order 5 129 ORACLE Field Description Mandator y Expiry Date Enables the user to enter Order Expiry Date Y Counterparty Name Enables the user to enter the Name of the Based on Counterparty for transaction FAC Counterparty Ref No Enables the user to enter the Counterparty Based on Reference Number FAC Quantity Displays the appropriate quantity in the text box Y once the user enters the no of contracts Bank Price Enables the user to enter Option Price for Private Y Bank Total Unitary Displays the Total commission paid by client commission Client Price Enables the user to enter Option price for Client Broker Unitary Displays the Unit Commission per unit to be paid by N commission Broker Private Unitary Displays the Unit Commission per unit to be paid by N commission Bank Total Amount It displays the contract value and is calculated as
53. fund scheme details For capturing the transaction the user has to select the fund scheme for which he wants to capture the transaction The user can select the fund scheme either by directly entering the name of the fund scheme or by searching oD for the fund scheme by clicking the button The fund scheme search screen displays only the schemes which are in open status On selecting the fund scheme name the instrument and settlement currencies will be displayed in the Instrument Currency and Settlement Currency fields respectively Step 4 In the next step the user needs to capture the folio number in which the units were redeemed Please note only the folio s in which the customer currently has holdings will be displayed in the drop down list It is obligatory for the user to select one of the folio numbers displayed in the list On selecting the fund scheme and the folio number the dividend option of the scheme will be displayed in the field Dividend Step 5 Select the appropriate option from Redemption Type drop down list The options available are Regular and SWP Step 6 Select the appropriate option for Asset Transfer Out transaction The user can place Asset Transfer Out transaction through this screen Asset Transfer Out ATO transaction enables the user to transfer the securities from current active portfolio to the desired depository By default No option is selected Step 7 The n
54. gt Futures gt Order capture Field Description Mandator y Customer Details Portfolio Name Displays the list of the portfolio names for the Y customer Futures Details Futures ID Enables the user to select the Futures ID using Y search icon Futures Name Once the user selects the Future ID system auto Y populates the corresponding Future name Expiry Date The system also displays this field on selection of Y Future name Instrument Currency Displays the instrument currency on selection of Y Future name Settlement Currency Displays the settlement currency on selection of Y Future name Counterparty Enables the user to select the appropriate broker or N issuer using the search icon Order Details Transaction Enables the user to select the transaction type from Y the drop down list No of Contracts Enables the user to enter the appropriate no of Y contracts Order Type Enables the user to select the appropriate order type Y from the drop down list Quantity Displays the appropriate quantity in the text box Y once the user enters the no of contracts Price Displays the appropriate price in the text box once Y the user enters the no of contracts It is in multiples of the tick size Amount It displays the contract value and is calculated as Y Quantity Price 5 121 ORACLE Field Description Mandator y Trigger Price Enables the user t
55. in the tab has a hyper link Click on the hyper link to view a tab displaying additional analysis of all the securities in the portfolio The details of this tab have been detailed in the next table At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency computed as explained in section 1 1 2 As explained earlier on clicking any of the instrument types in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected instrument Instrument Type Details Field Description Mandatory Name Displays the names of all the securities in the Display selected instrument type only Currency Security currency is displayed The currency Display displayed is as captured in the instrument only master table in the database ate ORACLE Field Description Mandatory Buy Price Buy price for the security is computed by using the weighted average price methodology The weighted average price for a security is computed as gt Qi gt Pi gt Qi where Qi is the units bought in each transaction and Pi is the buy price of that transaction For the securities under the instrument type CASA and TD the current balances in the accounts will be considered as their buy price For the holdings in the instrument type PMS amp SPL Product the value captured in the field Total Investment will be
56. in GIMS Options Type Once the user selects the Options ID system auto Y populates the corresponding Options type Exercise Style American European Value defined at Instrument Y creation level is displayed Exchange Display the list of exchange values Strike Price This field displays the value defined at the time of Y creation of an Options instrument anne ORACLE Field Description Mandator y Reference Date Displays the Date when the underlying asset price is Y fixed Contract Settlement Displays the Expiry date of a Options ID selected Y Date Instrument Currency Displays the instrument currency on selection of Y Future name Settlement Currency Displays the settlement currency on selection of Y Future name Commodity Currency Displays the commodity currency on selection of N Future name Security Code Displays the Security Code Y Last Traded Price Displays the Last Traded Price from the Instrument Y Price Order Details Trade Date By default display the current system date or Y business date whichever is later but user can modify the trade date Premium Payment Displays the Payment date or date when Premium is Y date received paid Transaction Enables the user to select the transaction type from Y the drop down list By default the system selects the Buy option Order Type Enables the user to select the appropriate order type Y
57. in portfolio maintenance As the instrument price keeps on changing frequently FCPB also enables the user to set up alerts to keep the track of changing market price associated with an instrument These alerts can be set up by clicking on the hyperlink associated with Market Price which directs the user to Portfolio Alerts screen The Portfolio Alerts screen would be defaulted to Instrument Price tab in this case If the logged in client is Proprietor Client Id then system displays different instrument prices in this field as explain earlier in this section Additional assistance is provided to the user by making available an option to view the transaction history of each security This can be done by clicking on the hyperlink provided under each security Securities whose complete holdings are sold will not be displayed in the tab The same principle holds good for the instruments and portfolios Instruments and portfolios with null holding will not be displayed in the tab The fields of each tab have been briefly described below PORTFOLIO SUMMARY Field Description Mandatory di ORACLE Field Description Mandatory Name All the portfolios of the selected customer are displayed Each of the portfolio name is displayed with hyperlink Click on the hyper link to view a tab which displays the valuation of all the instrument types encompassing the complete holdings of the customer in the
58. is cancelled manually The system generates an alert message on CUST dash board two days prior to order expiry date All revisions to the order including the expiry date revision are specified in the order audit trail Orders marked as Executed cannot be modified If the value of secondary market allowed is No in GIMS exchange value is not mandatory If only one exchange is defined in GIMS then the system defaults the value Once the order status is Matched or Settled the system generates transaction advice If the system date is in the range of the selected instrument s New Issue Start Date and New Issue End Date then the system qualifies the instrument as an IPO Once the selected instrument is classified as an IPO the system performs the following on the order capture screen e Defaults Transaction value as BUY e Defaults Order Type value as IPO e Defaults Time condition value as GTC The status of the order is updated as Executed if Partially Executed Order PEI is modified then the modified order quantity is same as Executed quantity Pe ORACLE 3 3 2 Mutual Fund It is a professionally managed form of collective investments that pools money from investors and invests it in stocks bonds short term money market instruments and or other securities te ORACLE Screen MF U tails RM Managed Name Folio ID Links DSP ML TIG
59. link will be enabled only for the non traded bonds Procedure for Modifying a Transaction Tap ORACLE Step 1 Pre filled information of the holding is displayed on accessing the screen The screen will display the name of the customer and the portfolio in which the holding is held The screen will also display the name of the bond the currency and the quantity of bond units held These fields are all non editable Step 2 The next significant step is to capture the market price per unit of the holding To recapitulate it is this value which will be considered for the purpose of analysis and performance computation and hence it is the onus of the user to enter the accurate value It is obligatory for the user to enter a value in this field Please note that it is responsibility of the user to keep revising the market price The system will use the most recent available value from this field from the purpose of valuation analysis and performance computation In the absence of the user providing any data the system will consider the purchase price as the market price for the above mentioned evaluations Step 3 The user then proceeds to capture the valuation date The calendar for selecting the date has been provided adjacent to As on Date field Click on the icon a in order to open the calendar The system validates the date entered against the purchase date The user will be restricted to the extent of capturing a date
60. market value The system also displays the time at which the last NAV was received for determining the market value Display only 3 31 ORACLE Field Description Mandatory Quick Launch This field displays the links to The action Subscribe Redeem STP The links are buttons will available for all the securities in this tab The be disabled field also displays an additional link CA for fora including corporate action related data Customer viewing the On selection of any of the above links the securities system directs the user to the corresponding held ina screens with pre filled information of the RM selected security Managed portfolio The screens associated to these links have been explained in depth in the section on Transaction Management On clicking the Buy Sell hyperlink the user navigates to the Order management or Transaction management screen This depends on the way portfolio type maintenance has been set up Mutual Fund Corporate Action User Access Level CUST A CUST can add modify the details of Corporate Actions announced by the companies institution only in Self managed portfolio Screen ORACLE Fiza ne 2 Figure 3 8 MF Corporate Action Screen Navigation After you login as an CUST user select Portfolio Maintenance gt Mutual Fund and then click on the CA hyperlink The fields in the Mutual Fund Corporate action screen are similar to the Equity Co
61. not been specified then while placing the order if the user selects the date month or year which does not fall on the one of the specified days of Product Master then system display an appropriate an error message Similarly an error message will be displayed if the selected date does not fall on the Investments dates specified in the Product Master Both the frequency and Commencement date are mandatory fields to be captured by the user on opting for SIP payment Also based on the Commencement date and No of transfers the system auto populates the SIP End Date The user will be restricted from initiating an SIP instruction for a date earlier than the current business date Please note that once the instruction is initiated by the user the fund house does not require any further instructions from the user to execute the forthcoming SIP instructions However FCPB would receive updates on the revised quantity of units from the fund house after execution of every SIP instruction Step 12 There should be a gap of one month for the auto generation of orders for SIPs to start This is based on the requirement from most of the AMCs that there should be a gap of a particular number of working days before the SIP auto debit starts The number of days differ from AMC to AMC For example if a customer wants to enroll for an SIP on 10th of every month for Rs 1000 per month for 6 months He she books the order on the 20th of January His her first ord
62. on entering the amount the corresponding value will be displayed in the units field Yes Currency Similar to the name field this field also flips between being enabled or disabled depending upon the type of instrument selected It will be enabled for the securities under the instrument type others And will be disabled and available as a display field for the securities under other instruments types Yes ome ORACLE Field Description Mandatory Region This field performs in similar manner to the currency Yes field Asset Class Asset Class field also behaves in similar manner tothe Yes currency field Industry The field industry is pertinent only for securities under Display only the instrument type Equity This field will display the corresponding industry for the selected security Market Cap Analogous to the field Industry this field is also Display only pertinent only for securities under the instrument type Equity and will display the corresponding market cap for the selected security Screen 3 Additional Information Additional information pop up facilitates the user to view consolidated holdings of the investments in different dimensions i e portfolio exposure asset class wise currency exposure by asset class and geographical exposure by asset class some holdings at customer level i e if customer has equity holdings in Portfolio A but
63. only Profit Loss Is the percentage of the profit loss computed above Display only At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency If the Category is selected as Portfolio then the system displays the details in the portfolio currency in the Gain Loss Summary pop up as explained in the Portfolio Maintenance section 3 70 ORACLE 3 4 2 View Portfolio Analysis By Instrument Type Screen Figure 3 27 Portfolio Analysis By Instrument Type Screen Screen Navigation In Portfolio Analysis screen select the Instrument Type option from the Category drop down list How to read the screen 1 The second table on the left side displays the analysis for the different instruments types held by the customer you have selected across all his portfolios 2 The different instrument types to be used by the bank are identified and maintained by the administrator in the Reference Master Table 3 Similarly every new security in the FLEXCUBE Private Banking system needs to be added to the Instrument Master Table before it can be used in the portfolio records The instrument master table contains the various related data for the security such as the instrument type instrument group currency region industry and asset class 4 Now when the user selects the option By instrument type for analysis all the holdings of the cus
64. results in substantial risk to the invested principal oe ORACLE Screen USmmodity RM Managed Name COMM1 COMM2 Total INR tut Calodatad by FIFO mahod Total Buy Cost Market Price Market Value Buy Price 150 0000 200 0000 10 0000 20 0000 19 000 000 17 000 000 Figure 3 15 Commodity Valuation Screen Value Date Quick Launch Field Description Mandatory Name All the securities in the chosen instrument type Display Commodities of the chosen portfolio are displayed only Each security is displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security CCY This field displays the security currency Display only Currency Sttl CCY This field displays the settlement currency for the Display corresponding instrument only If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details Units The denotation of the quantity is indicated in this field Display only Qty The total balance units as of the current business day Display are displayed here The balance units are derived by only netting the purchase and sale transactions 3 47 ORACLE Field Description Mandatory Buy Price The buy price is determined at by using the averag
65. the sum of the market values for all the direct and indirect held securities in the particular asset denominated in the customer preferred currency For the securities held as direct holdings and falling under the asset type equity commodities and traded bonds the market price will be as received from external data vendors For the other securities under the asset class insurance others metals gems real estate and non traded bonds the price will be as per the last manual update For the accounts held under the instrument type CASA and TD which are categorized under the asset class cash the most recent updated cash balance from these accounts will be considered as the market price Analogous to the direct holdings the indirect holdings in equity and traded bonds will also receive price feeds from the external data vendors However for the other indirect holdings falling under the asset class debt real estate cash and others the market value would be based on of the asset value on the total value of the fund The number of units as mentioned earlier will be defaulted to null Consider the example wherein the fund has invested 2 of the total fund value of 100000 in ICICI Infrastructure Bond The market value of the bond would be displayed as 0 02 x 100000 x 1 2000 of Total This is the percentage composition of the asset under consideration with respect to the total value of all the assets The sum
66. the Search button the details of the selected transaction appears Step 5 Click the Cancel Transaction button a ORACLE 5 4 5 4 1 Bonds Transaction Processing for Bonds Sricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Traded Securities Module of FCPB Description A bond is a debt security When a bond is purchased the owner of the bond is lending money to a government municipality corporation federal agency or other entity known as the issuer In return for the loan the issuer promises to pay the owner a specified rate of interest during the life of the bond and to repay the face value of the bond the principal when it matures or comes due Features of bonds There are a number of key variables to look at when investing in bonds the bond s maturity redemption features credit quality interest rate price yield and tax status Nominal principal or face amount the amount over which the issuer pays interest and which has to be repaid at the end Issue price the price at which investors buy the bonds when they are first issued The net proceeds that the issuer receives are calculated as the issue price less issuance fees times the nominal amount Coupon the interest rate that the issuer pays to the bond holders Usually this rate is fixed throughout the life of the bond It can also vary with a money mar
67. the following time conditions for his order On accessing the screen the field defaults to the Timed Order condition e Timed Order If the order is time bound user needs to enter the date on which the order should expire By default system considers the system date or current business date whichever is later as the order expiry date On the date of order expiry the system lapses the Active Timed Order In this case the expiry date has to be a valid business date i e the user needs to check for holiday master for System Exchange or Currency holiday In case the expiry date falls on any of the holidays the system displays an error message on the screen and next valid business date for order processing is displayed on the screen e IOC An immediate or cancel order allows the user to buy or sell a security as soon as the order is initiated failing which the order will be cancelled by the broker s trading system Partial match is possible for the order and the unmatched portion of the order will be cancelled immediately by the broker system Step 14 The final step before submitting the order is to decide on the trading account details displayed in the drop down lists These lists are displayed in the corresponding fields of the account details section The user needs to pick the DP Id and the bank account number from the list of values displayed in the dropdown of the corresponding fields The Bank Accounts drop down list d
68. the portfolio type RM Managed for accounts received from Core Banking Accounts added by customer from other Banks apart from the Home Bank will be added under Heldaway portfolio type Cash balances will be updated as a end of day process or as and when updated feed is received from the core banking system aoe ORACLE Screen Accounts Heldaway Account Type Total INR A cNo c Available Balance Hold Amount Total Balance 0 000 0 000 0 000 Figure 3 20 CASA Balances Screen As on Date Field Description Mandatory Account type The category of account viz savings or current Display will be displayed in this field only Account Number As the name suggests this field displays the Display account number Please note that each account only will be represented separately in this tab CCY This field displays the currency of the account Display only Available Balance The current balance of the CASA account will Display be displayed in this field This balance amount only is the Market Value which includes Accrued Interest also Hold Amount Hold Amount on the CASA account as provided Display by the Banking System only Total Balance Sum of Available Balance and Hold Amount Display only As on Date Indicates the latest date of reception of the Display account balance only At the end of the tab the last row displays the sum of all the above fields in the portfolio preferred
69. then the system validates the amount with the value entered in Maximum Amount field of SWP Details pop up of Product Master If the amount entered here is greater than the amount set up in Product Master system displays an appropriate error message Please note the units in mutual fund can encompass up to 4 decimal places Step 6 Analogous to subscription FCPB provides two approaches to redeem the holdings in a fund A one time redemption Regular In this type the user redeem over your entire holding Periodic redemptions or this is also referred to as a SWP It is a periodic redemption in a mutual fund At every frequency the user will have will have to commit to redeem fixed amount units The FCPB also facilitates the user to start a new SWP though he has already STP running in the system FCPB offers the user with the flexibility to redeem by both the payment options These options are provided as dropdown in the field Redemption Type Step 7 The subsequent field Frequency gets enabled only for SWP redemptions The user needs to select the frequency monthly quarterly semi annually from the drop down list provided a ORACLE Step 8 Similar to the Frequency field the next field Commencement Date also gets enabled only for SWP redemptions The commencement date is a pre determined date on which the SWP instruction would be executed by the fund house at a frequency defined by the user Both the
70. to utilize the current market trend Structured Product s Transaction Management Buy User Access levels Customer Can capture the transactions only for his her available portfolios ve ORACLE There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios Screen Figure 5 21 SP Transaction Management Buy Screen Screen Navigation After logging in the system select the Transaction Management gt Structured Products Please note that only the purchase transactions of the holdings for the instrument type Structured Products can be captured through this screen Rules for Capturing a Transaction e Transactions can be captured only for customers in active status e For capturing a transaction the customer should have at least one of the portfolios portfolio coupled to his her id Field Description Mandator y Customer Details Customer No Displays the Customer No Customer Name Displays the Customer Name Portfolio Name Displays the list of the portfolio names for the Y customer Instrument Details mee ORACLE Field Description Mandator y Instrument Name Enables the user to select the appropriate instrument Y name by clicking on the search icon available next to the Instrument Name field Security Code Displays the Security Code of the selecte
71. viz RM Managed Self Managed and Overall The RM Managed portfolios include the holdings in the RM Managed and Discretionary portfolios whereas the Self Managed portfolio indicates and includes the holdings in both the Self Managed and Held Away portfolios By opting for the option Overall the user will indicate his preference of viewing the chosen dimension of analysis for the chosen member across the portfolios This field will default to the option Overall These three fields can be used in various permutations to suit the needs of the user Simulator Description The simulator is a scenario planning module which helps Relationship Mangers to accurately assist their customers in analyzing their portfolio by evaluating comparing and illustrating It facilitates mock investments on their portfolios and immediately views the results This offers tremendous advantage as customer can test the efficiency of all investment choices made without actually making the investments FCPB Simulator provides scenario management and simulation technology enabling the user to ORACLE e Visualize analyze and optimize portfolio at individual family member as well as at household level e Predict the future portfolio e Visualize overall portfolio or Managed by RM or Managed by Client Customer The customer can simulate the holdings across all the portfolios including RM Managed Portfolios Screen Screen 1 Display screen graphic
72. will be computed based on the percentage composition of each security as provided in the fact sheet This is explained with an example given below If the customer holds 100 units HSBC Opportunities fund and the fund has ACC as one of its constituents The fact sheet has reported 25 investment of the total fund value of Rs 1 00 000 00 in ACC The number of units for ACC indirect holding would be computed as Assume current NAV 11 00 Indirect holding in ACC 25 of 100 units 25 units Value of the customers ACC holding in the MF 25 11 275 In case of direct holdings for the securities under the asset class equity and bonds commodities the units include the purchased and additional units received on account of stock corporate actions Similar to the indirect holdings for the direct holdings under asset class like insurance metal real estate gems cash and others the units are defaulted to null by the system Under the equity instrument type for a security of the same class the indirect holdings of the customer would be combined with the direct holdings if any 3 84 ORACLE Field Description Mandatory In the above example if the customer already holds 100 shares direct holdings then the entire holdings of the customer in ACC would be displayed as 125 units Let us understand how to calculate the market value at the asset level The market value at the asset level represents
73. 12 Buy PM Sell cA Field Description Mandatory Name All the securities in the chosen instrument type Bonds and portfolio are displayed Each security in the tab is displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security Display only CCY This field displays the security currency Display only Sttl CCY This field displays the settlement currency for the selected instrument If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details Display only Buy Price Buy price is the purchase price per unit of the bond purchased Display only Units The total balance units as of the current business day are displayed here The balance units are derived by netting the purchase and sale transactions Display only Total Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only 3 34 ORACLE Field Description Mandatory Coupon Rate The coupon rate of the bonds is displayed in this field Coupon is the interest rate that the issuer pays to the bond holders The coupon rates are maintained by the administrator in the Bond Master Table For the variable coupon bonds the
74. 20 000 and he she has 10000 in equity 4000 in debt and 4000 in Insurance and 2000 in Gems then to be displayed will be Equity 50 Debt 20 Insurance 20 and Gems 10 under Middle east region Formula to be used will be Asset class holding total holding 100 Yes Currency Exposure Currency Displays all the currency name where customer has holdings Yes owe ORACLE Field Description Mandatory Asset Class Displays all the asset class where customer has some Yes holdings at customer level i e if customer has Equity holdings in Euro but does not have debt in that currency even then equity should be displayed but if customer does not have real estate holdings in any currency then it should not be displayed Display Displays of asset class to total holding in that Yes currency Suppose customer holding in USD currency is 20 000 and he she has 10000 in equity 4000 in debt and 4000 in Insurance and 2000 in Gems then to be displayed will be Equity 50 Debt 20 Insurance 20 and Gems 10 under USD currency Formula to be used will be Asset class holding total holding 100 Screen 4 Model Portfolio Icon Attribute Description Input Object Mandatory Data Field Default Selectab Type Y N Type Validation Values le Size Display m een Model Display Icon Y Display Portfolio Icon model portfolio icon Read only pop up window I
75. 542 4 500 17 640 000 Bonds10 1 Pept Shot Rm2 850 310 INR 300 000 300 000 oas2012 419 13 500 13 230 000 Bonds20 1 Debt Short RM Mi BSD 310 INR 1 000 000 1 000 000 01 01 2012 542 4 500 110 000 00 Term lanaged M B s 1 Bonds20 1 D Shot RMManaged BSD 310 INR 20 000 20 000 16 02 2012 496 5 400 2 200 000 CANARA Equity ba 1 6700 irl 1 000 000 1 000 00 2004 2012 432 50 000 87 091 670 CANARA Equity my newt DP 100 8900 INR 500 000 475 000 2070772012 341 75 160 41 388 540 Page 1 of 7 6 6 ORACLE Portfolio Dividend Report Dividends Report pdf application pdf Object Mozilla Firefox _filei f 10 180 59 223 pm Release 12 0 Reports Dividends Report pdf Instrument Name Folio Account No No Units Shares Dividend Amt DWS Money Plus Fund 2102335689 1 985 8310 41 899 50 HDFC Equity Fund 11254789 35 000 00 132 000 00 Kotak Flexi Debt Weekly 1159425 65 3 505 5300 103 994 65 Reliance Growth Fund 14782147896 54 896 00 156 000 00 Total 433 894 15 e Capital Gains Report The Capital Gains report displays the capital gains for the selected customer in the selected time period The default report displays the net capital gain for each instrument If the customer selects the appropriate options to view the desired details then the capital gains for each transaction is displayed as below the summary in chronologic
76. ACLE e The user can not choose previous three passwords as New Password Field Description Old Password Enables the user to enter the old password New Password Enables the user to enter the new password Confirm Enables the user to enter the new password to confirm the Password same Hint Question Enables the user to enter the hint question Hint Answer Enables the user to enter the hint answer 2 11 Survey Questionnaire Description Once the RM sends the Survey Questionnaire to the customers satisfying the criteria the questionnaires start appearing in My Workspace menu of customer login The same customer may qualify for one or more surveys at a time if he she satisfies each of the survey filter criteria As soon as the survey exceeds the expiry date the system does not allow the customer to view that questionnaire User Access Levels Customer only the Customer can view amp fill the Survey Questionnaire before the Survey Expiry date Screen Figure 2 12 Survey Questionnaire Screen for Customer Screen Navigation After logging in the system as Customer select My Workspace gt Survey Questionnaire from the top menu ile ORACLE Field Description Mandatory Y N Survey Name Displays the survey names with hyperlink that is pending for the logged in customer Closure Date Indicates the survey closure date for the logged in customer after which the survey will no longer
77. DP ID This field displays the DP ID Display Only CCY This field displays the security currency Display only Sttl CCY Displays the settlement currency for the selected instrument Total Buy Cost Displays the total buy cost of the corresponding Display instrument only Market Value Displays the market value of the corresponding instrument Value Date Indicates the latest date and time of reception Display of the market price feed only 3 3 11 CASA Suggests current and savings account The bank has the option to include the accounts held within the bank in this instrument type as part of their portfolio holding The administrator can opt for this option of inclusion through the Banking Product Master table The customer can add all his retail accounts including the ones held outside the bank through the Networth screen Note that the Networth screen can be accessed through Customer login by clicking on the button in the Networth tab on the Customer Dashboard This screen will be editable only for a customer login and hence the provision of adding accounts has been provided only to the customer On adding an account the corresponding data will be displayed along with the other holdings in the portfolio under Portfolio Investments in the networth screen This constituent conveys the total value of the holdings held by the customer across his her portfolios The accounts under CASA type of instrument will be included in
78. E PRIVATE BANKING Exception Messages Popup Microsoft Int f 7 Following Exception s found Approval is Required SELECTED INSTRUMENT IS NOT IN 4PPROVED LIST SELECTED INSTRUMENT IS NOT IN MODEL PORTFOLIO SELECTED INSTRUMENT IS NOT IN RECOMMENDED LIST DEVIATION FROM MODEL ASSET ALLOCATION you want to proceed with these exceptions No Figure 5 2 Equity Exception Popup Window If the user clicks Yes the order goes for exception approval In case any exception having exception level 99999 the system displays the hard error Hence the user will not be able to place the order aN ORACLE Customers can self approve all the exceptions that occur by just clicking Yes as an answer to the question Do you want to proceed with these exceptions on the exception pop up The customer can self approve all the exceptions that occur in the order capture if the error levels are not 99999 5 2 2 Transaction Processing for Equity Please note that transaction capture and processing feature would be available to the bank only if the bank s license entitles them to Traded Securities module Equity Transaction Processing User Access levels Customer Can capture the equity holdings for the available portfolios created either by the customer or by the RM vie ORACLE Screen Geecs i Figure 5 3 Equity Transaction Capture Screen Screen Navigation After logging in the system selec
79. ER MF 12345 Franklin Temp 5456 Eranklin Temp HDFC Dividend scheme HDFC Dividend scheme HDFC Top 500 Total INR co au Buy Price Qty Total Buy Cost Cay MarketValue ValueDate Quick Launch 10 2000 3 1 0000 316 200 100 0000 100 000 ae SD INR 20 0000 100 0000 2 000 000 20 0000 eee cA ANON 1 263 500 20 0000 ra ca SD INR 6 0899 1 827 0577 11 126 570 1 147 0000 Subscibe a SD INR 1 147 0 8718 1 000 000 1 147 0000 1 000 00 ra cA 926 0000 117 500 000 100 5000 Seen AN 382 659 1 222 427 410 476 Figure 3 7 MF Valuation Screen Field Description Mandatory Name All the securities in the chosen instrument type mutual fund and portfolio are displayed Each security name in the tab is displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security Display only Folio ID This field displays the Folio ID Display Only CCY This field displays the security currency Display only Sttl CCY This field displays the settlement currency for the selected instrument If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details Display only 3 29 ORACLE Field Description Mandatory
80. Fact ostrumest 1 instrument tame Analytics Price g Fy si i aw sheet Figure 2 9 Product Search Screen Fee Mandate Description This screen comes up as soon as the customer logs in for the first time Once the customer accepts the terms and conditions the system allows the customer to place orders If the customer declines then he is not allowed to place orders User Access Levels Customer can access the Fee mandate screen Screen one ORACLE jones D RANG 2 PH Tan Mgmt Order Mgmt Home Portfolio Tin Management Order Mgmt Master Took Reports My Workspace Tooks gt Fee Mandate Figure 2 10 Fee Mandate Screen 2 10 Change Password Description Change password helps to change the password for the logged in user This menu is present across different logins User Access Levels Customer can use this screen to change password Screen Figure 2 11 Change Password Screen Screen Navigation After logging in the system select Workspace gt Change password from the top menu On clicking Submit clear the screen the new password is saved in the system Clicking clear button will Password Policy There are certain rules which the user needs to follow while changing the password e The password should consist of minimum of 8 characters and maximum of 15 characters e It should consist of at least one numeric one capital letter one small letter and one special character aos OR
81. Fund value top right hand corner of the will be hyperlinked Networth portlet opens up the On clicking the Statement of Loans and hyperlink the user Liabilities pop up which gives the gets to see the detailed statement of Liability type details of funds of Banking Products under that particular ULIP Alerts System as well as Portfolio Alerts System Alerts gt For e g Birth dates Anniversary Product maturity dates Restriction maturity Premium due date Portfolio Alerts gt For e g Portfolio returns Deviations from benchmark configured for every client Market Watch Gives the various details about the Top losers would financial markets under various tabs Indices Top losers top gainers etc give the top stock losers for the day where as gainers would reflect the top stock gainers for the day etc ORACLE Main Tables Description Features Recommended Asset Allocation Displays the asset allocation which is recommended to the client after assessing the risk appetite and assigning the risk score to the client Option to view the details in the form of graph or table He can also directly view the simulator screen by clicking the simulator icon there The user can also view the multi dimensional model asset allocation recommended to the client Actual Asset Allocation Displays the present asset allocation of the client If the Asset Class Decomposition fl
82. I and processing feature would be available in FCPB only if the bank s license entitles the bank for Mutual Funds and Insurance Module of FCPB Description It is observed that the Others instrument type has few drawbacks It does not support Partial Sale of units To overcome this problem the new instrument type called Generic is introduced Generic Instruments Transaction Processing User Access levels Customer Can capture the Generic instrument holdings for the available portfolios The customer can also enter the back dated Generic Instrument Screen oe ORACLE E Figure 5 37 Generic Instrument Transaction Management Rules for Commencement of a Transaction e Transactions can be updated only for customers in active status e For capturing a holding the customer should have at least one portfolio coupled to his her id ae ORACLE Screen Navigation After logging in the system select Transaction Management gt Generic Instrument the Fees field Field Description Mandator y Customer Details Customer No Displays the customer no Customer Name Displays the Customer Name Portfolio Name Enables the user to select the appropriate portfolio Y from the drop down list Instrument details Name of Instrument Enables the user to select the appropriate instrument Y by clicking on the search icon if it is existing instrument Else enables to enter
83. Information Enables the user to enter the additional information if any Payment Details Payment Type Displays the payment type for selected scheme The Y options available are ECS Cheque and DD Account No Enables the user to enter the appropriate Account No Y from the drop down list MICR Cheque No Enables the user to enter the appropriate Y MICR Cheque No in the text box Nominee Details 5 64 ORACLE Field Description Mandatory Name Displays the name of the nominee DOB Displays the DOB of nominee Relationship Displays the relationship of nominee with the insured person Share Displays the of share allocated to nominee by the insured person Procedure for placing of an Order Step 1 If the Income Tax ID Required and Risk Profiler Mandatory options are set to Yes in the Instrument Type screen of Admin login and the corresponding details for the selected customers are not updated then the system displays the appropriate messages and will not allow the user to place the order Customer For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Step 2 Click the a icon next to the Scheme Name field When the user clicks on the a icon next to the Scheme Name field Scheme Search window appears Enter the appropriate search criteria in the respective fields to search for the Scheme
84. Levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y TH ORACLE Screen bah Order Mgmt gt MF gt Order Capture er No Custom mama reine Fund Details ADDI 9 NAV of the pr eer Ae I a iSO ASEAN re A od SRC GRO Ra Oe a COO RA ROCCE errr rrr reer errr eee rere Figure 5 4 Mutual Fund Order Capture Subscription Screen Screen Navigation Entry to the screen Option 1 1 Select the Order Management option on the main menu gt Mutual Fund The screen will default the subscription tab Rules for commencement of an Order The rules for placing the Mutual Fund order are comparable to those stated for equity e Orders can be placed only for customers in active status e For initiating an order the customer should have portfolio coupled to his her id vie ORACLE e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order Procedure for Placing of an Order Step 1 If the Income Tax ID Required and Risk Profiler Mandatory options are set to Yes in the Instrument Type screen of Admin login and the corr
85. Mid amp Ask price separately And the valuation is done based on the respective Bid Prices of proprietary and customer portfolios Customer The customer can view the valuation details for the RM Managed Self Managed Discretionary and Held Away Portfolios Screen pie ORACLE Figure 3 2 Portfolio Valuation Screen Screen Navigation 1 After you login the portfolio creation screen can be accessed through the Portfolio and Maintenance sub menu How to Read the Screen 1 2 The screen displays a single tab when the user reaches the screen This tab on the top left corner of the screen displays the record of all portfolios along with their market value All the records of the portfolio are presented in their corresponding portfolio currency This tab also comprises of the buttons to add modify delete a portfolio the procedure and information of which are elucidated in the preceding section The valuation of a particular portfolio can be viewed by clicking on the hyperlink provided beneath each name of all the portfolios results in display of an additional tab This tab displays the market value for the different types of instruments These instruments encompass the complete holdings of the selected customer in the particular portfolio being evaluated The system does not display the portfolios with zero buy cost and zero market value that exceeds the number of days specified in the bank parameters and also the p
86. ORACLE Customer Portal Oracle FLEXCUBE Private Banking Release 12 0 2 0 0 Part No E49767 01 September 2013 Customer Portal September 2013 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2013 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the programs including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous application
87. Order Type drop down list select the appropriate option If the Order Type is selected as Stop Loss or Limit Order Trigger Price field is enabled and allows the user to enter the appropriate trigger price Step 8 From the Time Condition drop down list select the appropriate option In case of Timed Orders orders the expiry date has to be a valid business date i e the user needs to check for holiday master for System Exchange or Currency holiday In case the expiry date falls on any of the holidays the system displays an error message on the screen and next valid business date for order processing is displayed on the screen Step 9 sa Select the appropriate Counterparty using the icon next to the Counterparty Name field see ORACLE Step 10 Enter the appropriate no in the Counterparty Ref No text box Step 11 Enter the description if any in the Description text box Step 12 From the DP ID Client ID drop down list select the appropriate option Step 13 From the Bank Account No drop down list select the appropriate option Step 14 Enter the comments if any in the Comments text box Step 15 Click the Submit button Once the user clicks on the Save button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Re
88. Processing for Forex BSricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Alternative Investments Module of FCPB Description The foreign exchange currency or Forex or FX market exists wherever one currency is traded for another It is the largest and most liquid financial market in the world Exchanging currencies can take two basic forms an outright or a swap When two parties exchange one currency for another the transaction is called an outright When two parties agree to exchange and re exchange in future one currency for another it is called a swap oe ORACLE User Access levels Customer Can capture the transactions only for his her portfolios Screen p gt Spare co Figure 5 35 Forex Transaction Capture Screen Navigation After logging in the system select Txn Mgmt gt Forex Field Description Mandator y Customer Details Customer No The customer no is displayed Customer Name The customer name is displayed Portfolio Name Enables the user to select the appropriate portfolio from the drop down list Forex Details Currency Pair Displays the currency pair name based on Commodity Currency and Terms Currency selected in Search Icon Popup Base Currency Displays the information of base currency in view mode based on the FX ID selected Terms Currency Displays the information
89. SD USD 240 00 2 200 00 528 000 00 481 99 1 060 378 00 0 Total USD 528 000 00 1 060 378 00 Note Buy price is calculated based on FIFO method Figure 3 5 Equity Valuation Screen Field Description Mandator y Name All the securities in the chosen instrument type equity Display and portfolio are displayed Each security in the tab is only displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security DP ID This field will display the trading account information Display The rationale for introduction of this field is to support only the new functionality of accounting independently for each trading account through which the customer transacted CCY This field displays the security currency Display only Sttl CCY This field displays the settlement currency for the Display selected instrument only If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details ane ORACLE Field Description Mandator y Buy Price The buy price is determined at by using the weighted Display average cost methodology for each trading account only However the important point to be noted is that the weighted average cost methodology is pertinent only for the remaining pur
90. Sauen Figure 3 48 Track Goals Screen Screen Navigation Login to the system as Customer user and select Portfolio gt Track Goals and click on the E icon located at top right hand side corner of Goals to Portfolio Tracking Current Year chart Goals to Portfolio Tracking As on date and Goals to Portfolio Tracking Goal Years tabular sections with detailed data do not appear simultaneously At any point of time only one table appears by clicking on the respective pop up icons The Goals to Portfolio Tracking Current Year chart displays Linked Portfolio Names on x axis and Cumulative Goal Value Current Year amp Current Portfolio Value on y axis respectively wherein the Goals to Portfolio Tracking Goal Year chart displays Goal Years on x axis and Cumulative Goal Value of Goals maturing at Goal Year amp Projected Portfolio Value on y axis respectively Field Description Mandatory Goals to Portfolio Tracking Current Year Household Member s Displays the name of the Household member Name name selected to track the goals Portfolio Name Displays the name of the portfolio to which goals are linked Goals Linked Displays all the goals linked to the portfolio Y Current Portfolio Value Displays the latest portfolio value Y Since Inception RoR Displays the since inception RoR of the Y portfolio Cumulative Goal Displays the sum total of all CURRENT Y Value Current Year YEAR GOAL VALUES o
91. THR ORACLE FR O D ino Figure 5 13 Bond Order Capture Buy Screen Screen Navigation Entry to the screen Option 1 Select the Order Management option on the main menu gt Bond gt Order capture Option 2 Portfolio Management gt Maintenance gt Select a portfolio except held away discretionary from the list of portfolio gt Select bond from the instrument type table gt BUY SELL Options from the screen Rules for Commencement of an Order The rules for placing the Bonds order are e Orders can be placed only for customers in active status e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order Field Description Mandatory Customer Details ee ORACLE Field Description Mandatory Customer No Displays the Customer No of the customer in Based on context The user can change the customer by FAC clicking on the Change Customer icon Customer Name Displays the Customer Name for the selected Based on Customer No FAC Portfolio Name Displays the list of the portfolio names for the Y customer Source Code Displays the Source Code for the banker who has Based on sourced the transaction FAC Lead Generation Code Displays the Lead Generation Code for the banker Based on who has provided the lead for the transaction FAC Instrument Details Instrument Name Enables the user to sel
92. Type fields Step 3 Mutual fund generally offers two options on dividend payout and reinvestment In the dividend payout option the dividend is given to the investor from time to time whereas in the reinvest option all the dividends declared by the fund are ploughed back into the scheme The next field Dividend provides the user with the option to select either of the options Dividend payout or Dividend reinvest Please note that it is not essential that all the fund schemes provide with both the options on dividend The options will be made available to the user to select based on the alternatives offered under a particular fund scheme These options are maintained in the system in the MF Instrument Master table in the database a ORACLE Step 4 The next field enables the user to select the appropriate exchange name from Exchange drop down list Step 5 Select the appropriate Trade Date and Settlement Date using the calendar icon In case if the user is initiating the order SIP SWP STP post cut off time the system does not allow the user to place the order and displays an appropriate warning message asking the user to place the order for some other date This is applicable only if the commencement date is same as the system date and the cut off time for that Instrument IAG is less than the current time Also the validation is applicable only for first order Step 6 From the Account Type drop down list select th
93. Y Quantity Price Total Revenue Displays the Total Commission received by the Bank Y Description This text box will capture any specific details forthe N order that the user would like to input Account Details DP ID Client ID Enables the user to select the appropriate DP ID Y details of the selected customer Bank Account Enables the user to select the appropriate bank Y account detail of the selected customer Comments Allows to capture user remarks before saving the Y N order details Procedure for Placing of an Order Step 1 For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed 5 130 ORACLE Step 2 Click the a icon next to the Option Name field When the user clicks on the icon next to the Option Name field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the Option instrument The instrument search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Once the user selects the Option ID following fields are aut
94. a particular instrument on the current business day e Instrument Name The customer can filter the orders for a particular instrument by selecting the instrument for which he she wants to see the orders e Order Type The customer also has the flexibility to sort the orders by the type of order By default system displays the order status for all the order types The user can select the desired order type from the Order Type drop down list to view the details ae ORACLE Order Status The customer can be aware of the status of the orders initiated by inspecting the Order Book This field provides the user the option to filter the orders placed on the current business day by their status Portfolio Name The customer has an option to filter the orders by portfolio name as well He can select the portfolio name and click on search for a specific date range and he can see all the orders placed against the selected portfolio name for a specific date range Date Range The user also has the option to view the history of orders for a particular date range The date range can be defined in the From and To fields provided in the screen However this option will be available only after the bank s business hours The calendar for selecting the dates has been provided adjacent to each of these fields Click a on the icon in order to open the calendar and select the suitable dates Please note that the status updates are done by
95. ach task 4 It also describes in detail all system inputs processes outputs and controls and provides background reading reference to supplement training and testing Scope The intention of this User Manual is to provide a comprehensive guide to the Customers of the system It can also be used as a trouble shooting guide Audience The potential readers of this document include but not limited to 1 The Relationship Manager Customers and other users of the system 2 Top and middle management executives 3 Developers database designers of the system for their reference 4 Product and Functional teams Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http Awww oracle com pls topic lookup ctx acc amp id docacc FI ORACLE 1 1 5 Organization of the Document The Manual is organized into the following five chapters Chapter 1 Introduction Helps to understand the purpose and scope to the current user manual along with system overview and capabilities Chapter 2 Customer Related Menu Helps to understand the customer dashboard which is a snapshot of customer related menus Chapter 3 Portfolio Management Helps to understand the portfolio management Chapter 4 Investment Performance Management Helps to understand the investment performance management Chapter 5 Order Management and Transac
96. action buttons will not be available for an instrument for which Order was placed with Schedule Based Drawdown On clicking the Buy Sell hyperlink the user navigates to the Order management or Transaction management screen This depends on the way portfolio type maintenance has been set up At the end of the tab the last row displays the sum of all the above fields in the portfolio preferred currency SP Corporate Action User Access Level CUST The CUST can add modify the details of Corporate Actions announced by the companies institution in Self managed portfolio 3 45 ORACLE 3 3 7 Screen E eo Figure 3 14 Structured Products Corporate Action Screen Navigation After you login as an CUST user select Portfolio Maintenance gt Structured Products and then click on the CA hyperlink The fields in the Structured Product corporate action screen are similar to the Equity Corporate Action screen Additional fields in Structured Product corporate action have been inscribed as below Field Description Mandatory Dividend Coupon Enables the user to enter the Dividend Y Percentage percentage per unit if the selected CA type is Dividend Commodities Commodities have evolved as an asset class with the development of commodity futures indexes and more recently the introduction of investment vehicles that track commodity indexes Almost all commodity speculators trade on margin which
97. ag is set to Yes then this tab displays the Asset Class values after considering sub constituent values The deviation percentage if any will also include the values of sub constituents If the flag is set to No then system does not consider the sub constituent values Portfolio Summary Displays the summary of the portfolios that the client holds The system also displays the inventory position based on value date under the Value Date Positions column If value date is blank then system considers the trade date as value date Details like portfolio currency market values buy cost Value Date Positions Unrealized P L P L and ROR are displayed ORACLE 2 2 Main Tables Description Features Portfolio by Instrument Group Displays the portfolios aggregated based on Instrument analysis group The investor can navigate to Portfolio Analysis screen by clicking the quick link to provided on top right hand side of the section Also the user has an option to view Portfolio by instrument group in a graphical or tabular form Products Gives a list of different products recommended by the bank under various instrument type like Insurance SP Equity etc The View Profile Description The screen enables the user to own profile This is display only screen and the customer cannot modify the details in the screen User Access Levels Customer O
98. ails hyperlink it displays the details of transactions for a particular order Pertioke Inst D tome Tyee Figure 5 40 Bond Transaction Details pop up Screen Navigation After logging in the system select Order Mgmt gt Order Book The pop up displays details of the total executed quantity remaining quantity and Cancelled quantity if any It also displays the Modify hyperlink on click of which the Transaction Modify screen appears to modify the order Customers can modify only those orders which are placed by him her Orders placed by RM cannot be modified by the customers sige ORACLE 5 15 Transaction Search The Transaction Search category under the Transaction Management is used by the customer to search for the transaction by using various parameters He can also modify the transaction by selecting the transaction and then applying the appropriate action Please note that the instrument types seen on this screen will depend on the product license that you are entitled to User Access levels Customer Can modify or view the transaction Pe ORACLE Screen Figure 5 41 Transaction Search Screen Screen Navigation After logging in the system select Transaction Management gt Transaction Search Field Description Mandatory Customer No Displays the customer no Customer Name Displays the customer name Portfolio Name Enables the user to select the appropriate portfolio name from the drop
99. ainst this field The first field has been provided to opt for the various mathematical conditions viz less than lt less than equal to lt greater than gt greater than equal to gt and equal All these options have been provided as list of drop down values for the user to opt The next field has been provided for the user to enter values Please note that the values denote in percentage The value captured in this field denotes the threshold limit for triggering the alert Let us understand this field with an example In the condition field the user opts for lt and captures the value 15 in the percentage field Hence for the defined alert an exposure of less than 15 will trigger the alert Delivery Mode There are three types of Delivery Mode as explained Y above in Portfolio tab i e dashboard e mail and both Applicability Enables the user to select the appropriate recipients for Y the alerts using the option from the drop down list ee ORACLE Instrument Price The fourth tab of Portfolio Alerts is provided to set the alerts for Instrument Price The alerts defined in this category assist the user to track the instrument market price variation on day to day basis xa Pinstrument Price Jt Reminder Instrument Price cto ov Select id Figure 3 46 Portfolio Alerts Instrument Screen If the Portfolio Alerts screen is accessed throu
100. al fee amount charged for the corresponding transaction type Portfolio Analysis Description Portfolio analysis delivers insight into the factors that make the user portfolio move and illustrate how the investment decisions affect portfolio performance FLEXCUBE Private Banking provides expanded information about the user portfolio by Giving both graphical and holdings views of your portfolio Presenting the holdings across the different portfolios in different dimensions like asset class industry currency region market capitalization and instrument type These different dimensions in turn can help the user to investigate the recent trading history of customer portfolio constituents FCPB captures the detailed security level composition of Mutual funds Portfolio Management Schemes and Structured products which is utilized in displaying the aforementioned views of the portfolio This exhaustive classification allows for higher accuracy in aligning portfolios to pre decided investment objectives of the customer Shows household view of the portfolios Detailed Section of every item within each portfolio User Access levels Customer can view the holdings in different dimensions portfolio instrument group asset class industry currency region market capitalization and instrument type The customer can also view the analysis for the RM Managed and Held Away Portfolio aus ORACLE 3 4 1 View Portfolio Analysis
101. al order 6 7 ORACLE Capital Gains Detailed Report Rucha S Customer No 1019 Period 15 03 2011 to 16 03 2012 Customer Name Rucha S Date of Reporting 26 06 2013 For Amount gt 0 Instrument Name FolioNo Currency Buy Price Buyaty BuyCost BuyDate atySold SalePrice p Sa 1 SaleDate stccn itec EQ TOYOTA 1 6700 INR 10 000 1 000 05 40 000 00 010172012 1 000 000 20 000 20 000 000 10 01 2012 10 000 MFKAVRY1 177 INR 10 000 100000 42 000 00 11 2012 4 200 000 50 000 210 000 000 20 01 2012 110 000 Total INR 52 000 000 230 000 000 120 000 o Total Amounts are shown after converting the individual currency balances in instrument currency into the customer currency at the transaction date s exchange rate Page 1 of 1 If you select any other preferred language menu items for Reports will be shown in corresponding preferred language 6 1 1 Reports Repository FCPB generates various reports as mentioned below e Statement of Charges Report e Transaction Advices e Financial Planning Report e Portfolio Reports e Transactions Reports e End of Day Repots same format as Portfolio Reports Reporting repository is a feature that will help in storing or archiving these reports in some repository The system generates some of the reports like portfolio reports etc on the last day of every month and save the same into a rep
102. al point 00 ORACLE 3 4 3 Total Displays the total percentage allocation It should always add up to 100 If Instrument Type MF is Fund of Fund then sub constituent of such scheme will again have exposure to another Fund and the decomposition view of the same will be available by clicking on that scheme name and the pop up page will refresh and will display sub constituent details of that scheme and so on View Portfolio Analysis By Asset Class Screen Figure 3 30 Portfolio Analysis By Asset Class Screen Screen Navigation To view the analysis for Asset Class please ensure that the Asset Class option has been selected from the list of views 1 The second tab on the left side displays the analysis for the different asset classes spanning across the entire holdings of the customer selected across all portfolios The different asset classes to be used by the bank are identified and maintained by the administrator in the Reference Master Table Now when the user selects the option By asset class for your analysis all the holdings of the customer get organized in accordance to the different asset classes and are displayed in the customer preferred currency This sorting of the holdings is done across all the portfolios of the customer Currently the FCPB supports for following Asset classes e equity e debt noe ORACLE e art e real estate e gems e metals
103. al view Figure 3 38 Simulator Screen Graphical View es ORACLE Screen 2 Display screen tabular view es a lt m lt pa nme amy Innate man Sean SS Aoh toim naear 08 00 Teta Market Cap ae Market Crp Market Value Soo Total Leow amma onia mico mamasa merw ores maas 71 06 or mees aowi Totman ionas 200 00 Mote 0 Intan Ponte Captain arabas s ey Tv Easy and not oDer aoet caes Figure3 39 Simulator Screen Tabular View Screen 3 Additional Info To view the additional information click the Additional Info button Z Exposure FLEXCUBE PRIYATE BANKING Microsoft Internet Explorer provided by i flex ASSET ALLOCATION Asset Class Portfolios Real Estate Recommended Allocation 30 00 10 00 5 00 50 00 Core RM 0 8 04 0 91 95 Damien Self 0 0 0 100 00 GEOGRAPHICAL EXPOSURE Asset Class Region Real Estate Australia and NZ 0 E TE Europe 0 9 94 North America 0 6 62 CURRENCY EXPOSURE Asset Class Currency Real Estate Debt 0 747 0 re 0 01 0 0 0 6 10 0 0 0 0 9 94 0 0 0 56 0 0 52 0 3 103 ORACLE Figure 3 40 Asset Allocation Screen Screen 3 Simulate holdings screen E FLEXCUBE PRIVATE BANKING Popup simulator operation Windows Internet Explorer a i wa Portfolio Maintenance gt Simulator Simulate ft f Portfolio Name Instrument Type Name Cu
104. analysis of these different dimensions have been discussed in depth in the section on Portfolio Analysis To recap this exhaustive classification allows for higher accuracy in aligning portfolios to pre decided investment objectives of the customer The user has a flexibility of having different views of his her investments depending on the selection Various combinations supported by the system are gt Household Group to be shown only if the client is the household group head Self Default Household gt Portfolio Type Overall Default Managed by RM Managed by Client For example if the user selects Household and Managed by RM the information shown will be for only the portfolios managed by RM of all the household members Also if group is selected then all simulator views are displayed considering selected portfolios of the group Every access of the screen through the main menu will result in renewal of the analysis with the current market price of the securities To recapitulate the market price for the securities in the instrument type equity traded bonds mutual funds PMS specialized product CASA TD and structured products are received as data feed from external data vendors Whereas all the securities under the remaining instrument types require manual updation of the market price Along with the analysis of the holdings in different dimensions the screen also displays the Model portfolio associated with the
105. ansaction Step 1 The customer needs to navigate to Txn Management gt Others Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 The subsequent step is to enter the Name of the Holding It is a text field and the user can enter the Name or the description of the holding as conveniently interpretable by the user else the customer can select and existing instrument by clicking on the search icon As this screen has been provided with the flexibility to capture all the additional holdings of the customer apart from the ones which can be easily classified into the system defined instrument types equity mutual fund bond structured product and insurance it is impossible for the system to maintain a Master Table for such holdings Due to this the system cannot aggregate multiple purchases into the holding Hence any additional purchases need to be captured as separate security holding or first time purchase Step 4 ae ORACLE The next step is to categorize the holdings into any of the asset classes as provided in the drop down list In order to capture any holding in this instrument category it is mandatory for the user to choose one of asset class To recap holdings which cannot be sorted into any of the defined asset classes cab be categorized into the asset class others If the instrument i
106. are two options available for PMS Order Capture They are Buy and Sell By default Buy option is selected Step 4 Enter the appropriate account no in the Account No text box ie ORACLE Step 5 Enter the appropriate application no in the Application No text box Step 6 Enter the appropriate amount to invest in the Invested Amount text box Step 7 From the Payment Method drop down list select the appropriate option The options available for Payment Method are ECS Cheque and DD Step 8 From the Bank Account No drop down list select the appropriate option Step 9 Enter the appropriate cheque no in the Cheque No text box Step 10 Click the Save button Once the user clicks on the Save button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 If an order is placed for a particular PMS with a particular Account No the subsequent orders for that PMS should be placed with the same Account No PMS Order Capture Sell ee ORACLE User Access levels Customer can place orders for RM Managed Self Managed and Discreti
107. articular instrument the portfolio in which Y the holding is held will be displayed in this field In case the same holding is held by the customer in multiple portfolios the list of the multiple portfolios will be displayed as a drop down list The user can opt for the relevant portfolio for which he she intends to set the alert Returns This field is analogous to the one described for the tab Y Portfolio Delivery Mode There are three types of Delivery Mode as explained above Y in Portfolio tab i e dashboard e mail and both Applicability Enables the user to select the appropriate recipients for the Y alerts using the option from the drop down list Exposure The third tab has been provided to delineate alerts on exposures These alerts can be set and tracked on different dimensions of the customer s holdings viz industry currency region market capitalization and instrument type The alert for a particular exposure will be triggered when the when the percentage of holdings in a particular subordinate dimension meets the set criteria To recap the percentage of holding in a particular subordinate dimension can be deduced by dividing the market value of a particular subordinate dimension under consideration with the total market value of the dimension and then multiplying the value with 100 For example the exposure of the customer s holdings in pharmaceutical industry can be determined by dividing t
108. ate Enables the user to enter appropriate record date Transaction Date Enables the user to enter appropriate transaction date Settlement Date Enables the user to enter appropriate settlement date By default the settlement date is auto populated with transaction date Amount Enables the user to enter the dividend amount per unit if the selected CA type is Dividend Tax Enables the user to enter the appropriate tax for the corresponding corporate action Dividend Percentage Enables the user to enter the Dividend percentage per unit if the selected CA type is Dividend Ratio Enables the user to enter the appropriate Corporate Action ratio for the corresponding instrument This field is enabled only for Stock Dividend and Bonus CA types New Shares Issued Enables the user to enter the appropriate no of new shares issued This field is enabled only for Stock Dividend and Bonus CA types Price Share Enables the user to enter the appropriate price of the share per unit This field is displayed only if CA type Right is selected Rights Bought Enables the user to enter the appropriate rights bought This field is displayed only if CA type Right is selected 3 25 ORACLE Field Description Mandatory Exchange Rate Enables the user to enter the appropriate Y exchange rate This field is enabled only if Instrument and Settlement currency is differe
109. ate is also displayed with expire There is a message displayed below the table informing the users about the expiry of the highlighted alerts and requesting them to click on the hyperlink in order to renew the alert Portfolio Let us now proceed to understand each of the multiple sub tabs displayed in the third tab The first of them and the default one being Portfolio Screen 3 122 ORACLE p a TD CID CID CHIZ Portfolio Performance Figure 3 43 Portfolio Alerts Portfolio Screen The alert defined in this category assists in tracking the performance of the individual portfolios of the customer or of the customer itself The fields displayed in the tab have been elaborately discussed in the table below Field Description Mandatory Alert Type Each category of alert has further various types of alerts Y defined under them The Portfolio performance currently has two types of alerts viz relative performance and absolute performance These types of alerts are displayed as a list of drop down values The screen defaults to absolute type of alert Absolute Alert will be generated if the inception to date performance of the portfolio or overall client performance meets criterion defined in the alert Relative This type of alert compares the inception to date portfolio performance or overall customer performance relative to the defined respective benchmark and if this difference Ac
110. ation 1 Portfolio Self Overall this selection will display the information about all the portfolios of the selected customer portfolio wise The Table name displayed should be Portfolio customer name gt Combination 2 Asset class household member managed by client this selection will display the information regarding the chosen household members client managed portfolio holdings asset class wise The Table name displayed should be Asset Class household member name gt Combination 3 Instrument type Household overall This selection will display the information regarding the holdings of all the members in RM managed portfolios instrument type wise The Table name displayed should be Instrument Type customer name Household e The Columns displayed after selecting the category dropdown depends on the value of the parameter INSTRU_DECOMP_ASSET_CLASS in REF_BANK_PARAMS gt lf INSTRU_DECOMP_ASSET_CLASS N then the columns shown for different category selection are as follows Portfolio Instrument Type Asset Class Buy Cost Market Value Profit Loss Profit Loss of Total Region Currency Industry Market Capitalization Market Value of Total gt lf INSTRU_DECOMP_ASSET_CLASS Y then the columns shown for different category selection are as follows Portfolio Currency Buy Cost Market Value Profit Loss Profit Loss of Total Instrument Type Buy Cost Market Value Pro
111. ation and analysis about the securities held in the selected region ooo ORACLE The detailed descriptions of fields are given below Region Field Description Mandatory Region All the regions in which the holdings of the Display selected customer span across are displayed only Each region is displayed with a hyperlink Click on the hyperlink to view a tab displaying additional analysis of all the securities in the selected region Market value This is computed as mentioned in the Asset Display class analysis only of Total This is the percentage composition of the Display holdings in a region under consideration with Only respect to the total value of all the holdings across all the regions The sum of the percentages across all the regions would sum up to 100 At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency As explained earlier on clicking any of the regions in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected region Region Details Field Description Mandatory Name Displays the names of all the securities direct Display and indirect in the selected region only Currency The currency of the security displayed is as Display captured in the instrument master table in the only database Units Units are computed for the indirect holdings in Display t
112. bled only if the selected instrument is unit based Step 8 Enter the appropriate price in the Customer Price text box This field is a free text box if the selected Order Type is Limit Order and based on the price entered by the user it adjusts it spread and derives the Treasury price and populates the same in Treasury Price text box Once the user enters the Customer Price the system calculates and displays the corresponding YTM in the Customer Yield Step 9 Enter the appropriate spread amount in the Spread text box if the selected instrument is amount based instrument Also if the transaction fee is applicable for the logged in customer system displays it in the Transaction Fee text box Once the Treasury Price Customer Price and Transaction Fee are entered the system calculates and displays the Treasury Total Amount and Customer Total Amount The system also calculates the Profit amount and displays it in the Profit Flat text box In case of amount based instrument the system does not display any value in this text box Step 10 sa Select the appropriate Counterparty using the icon next to the Counterparty Name field ao ORACLE Step 11 Enter the appropriate reference number in the Counterparty Ref No text box Step 12 Enter the appropriate amount in the Commitment Amount text box The Commitment Amount Applicable field is enabled in the screen only if Commitment Amount Applicable field has been set
113. broker commission in the Broker Commission text box if any Step 12 The next field has been provided to capture the tax and other charges paid for obtaining the holding Please note currently these fields are currently not being utilized for any of the valuation analysis or performance computations If the Price to be adjusted field in Bank Parameters is set to Y then the fee tax and brokerage on the transaction is adjusted in the price hence the Original price and Original Amount field shows different values from Price and Amount If it is set to N Original price and Original Amount fields remains same as Amount and Price respectively ala ORACLE Step 13 Enter the appropriate fee in the Security Fee text box if any Step 14 Enter the rate in the Exchange Rate text box This field is enabled only if the instrument and settlement currency is different else it is defaulted with value 1 Step 15 Enter the transaction details if any in the Description text box The user is allowed to enter the details upto 250 characters If the entered details exceed 250 characters system displays the message as Description cannot exceed 250 characters Step 16 Select the appropriate account from the Security Account drop down list The system defaults the account no based on the flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Securi
114. cal depiction of the type of view selected The user has been provided with the flexibility to view the graph either as a pie chart or as a bar chart This can be done by selecting the appropriate type of graph from the drop down list provided in this tab In the bar chart the y axis represents the of total i e composition of holdings in a currency in comparison to the total composition of the customer s holdings across all the currencies This is arrived at by calculating all the associated amounts in the customer preferred currency The x axis names the different currencies across which the holdings of the customer span es ORACLE 2 For further analysis of the holdings in each currency you can click on the hyper link under each region in the second tab An additional tab will appear below the second tab which will provide further information and analysis about the securities held in the selected currency Understanding the Screen Irrespective of the type of login customer or RM the system facilitates to analyze the holdings across all the portfolios A currency in which the customer does not have any holdings will not be displayed in the screen Blank tabs will be displayed if the customer is yet to make any investments The detailed descriptions of fields are given below Currency Field Description Mandatory Currency All the currencies in which the holdings of the selected customer span across are display
115. cation Allows users to have diversified portfolio in many assets Comprehensive reporting Our comprehensive reporting ensures that user is kept informed about the performance User can view the performance reports either separately by portfolio by instrument group and by asset class or in aggregate at customer level Improved Operating Efficiencies Enhances portfolio Management decisions by the usage of portfolio analysis performance and what if simulations A snapshot of the Module True Multi Currency FLEXCUBE Private Banking is a true multi currency portfolio tracking system that provides the flexibility to capture security portfolio customer and bank currency A specific base currency is not required for currency transactions or holdings the FCPB will convert the transaction amounts denominated in the security s currency to the portfolio currency as well as to the customer currency using a currency exchange rate Multi portfolio creation e Supports FIFO and weighted average cost basis e Online revaluation using current market price Extensive Analysis Reporting Capabilities The FLEXCUBE Private Banking is unique in that its analysis capabilities are designed to meet the most demanding requirements With a click of a button analysis based on the composition of the instruments are reported across different dimensions like Portfolio Instrument Group Asset class Industry Currency Region Market Capitalization and Instrument type
116. cation No text box Step 5 Enter the appropriate amount in the Redemption Amount text box Step 6 Click the Save button Once the user clicks on the Save button the system displays the Order Placed Successfully message User Access levels Customer Can capture the commodities holdings for his her available portfolio created either by the customer or by the RM There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios Screen Saks oe ORACLE Figure 5 25 Commodities Transaction Management Screen Screen Navigation After logging into the system select Transaction Management gt Commodities Field Description Mandator y Customer Details Customer No Displays the Customer No field Customer Name Displays the Customer Name Portfolio Name Displays the list of the portfolio names for the Y customer Instrument Details Instrument Name Enables the user to select the appropriate instrument name by clicking on the search icon available next to the Instrument Name field Instrument Currency Displays the instrument currency for the selected Y instrument name Once the Instrument Name is selected system auto populates this field Settlement Currency Displays the settlement currency for the selected Y instrument Measure Units Displays the measure of units for the selected Y instrum
117. chase transactions in the portfolio subsequent to application of the first in first out FIFO rule for all the sale transactions in the particular trading account of the portfolio The average cost requires you to determine the average cost per share total amount invested divided by the total number of shares held Let s say you have bought the following shares 01 01 2007 100 yahoo shares at 10 each 02 01 2007 100 yahoo shares at 20 each The average price in this case would be 200 yahoo shares at 15 each 3 20 ORACLE Field Description Mandator y A FIFO rule is an accounting methodology wherein if the user holds a security of the same class which has been acquired on different dates the security acquired at the earlier time is deemed to be disposed off first In other words it is assumed that for the securities of the same class the securities purchased first are sold first For example Jan 15th bought 1 000 Nestle shares for 1 27 per share Jan28th bought 200 Nestle shares for 1 90 per share Feb 2nd bought 500 Nestle shares for 2 54 per share Feb 15th sold 1 500 Nestle shares for 3 81 per share Sold 1 500 shares for 5715 00 As per FIFO 1 000 1 27 1270 00 200 1 90 380 00 300 2 54 762 00 will be adjusted against the sale Hence the buy price would be of balance shares 200 acquired on Feb 2nd 2 54 per share Now if on Feb 28th additio
118. ck size for that particular security Sale transaction is initiated only for the balance shares available for a particular security ina particular portfolio of a customer For multiple sale orders initiated on the same business day for the same security of a customer s portfolio the system validates the balance quantity considering e The current holding of the customer e The open quantities for all the orders with open and partially executed status in the order book In the Portfolio Maintenance screen the Equity Details section lists of Equities with Customer Holdings If the OMS QUICK LAUNCH check box is checked at Bank Parameters Portfolio and Order Related Tab level then the links for Buy Sell are available under the Quick Launch column ee ORACLE For Customer Login if Can Transact Online check box is unchecked and customer clicks on the corresponding Buy Sell hyperlinks for the equity then the customer will not be allowed to place an order for the same The system then displays an error message as You cannot place an order for this Instrument Please contact your Relationship Manager 6 10 11 12 13 14 15 16 For Timed Orders the expiry date must be valid business date If the expiry date is ona holiday the system displays an error message and displays the next valid business date You can modify the default date if needed The expiry date must be stored in the order book and
119. commended List e Deviation from Model Asset Allocation e Trigger Price more less than x of the LTP where x is the no which is configurable e Spread deviated approval required Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 Bond Order Capture Sell User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y oe ORACLE 5 5 5 5 1 Screen Figure 5 14 Bond Order Capture Screen Sell Screen Navigation Select the Order Management gt Bonds gt Bonds Order capture From the Order Type drop down list select the Sell option To place the Bonds Sell transaction follow the same procedure as explained in Bond Order Capture Buy above The only difference here is that the user needs to select the transaction type as Sell from the Transaction Type drop down list The system allows the user to place the Sell transaction only for those instruments for which the customer has holdings FCPB also handles Put type of transactions similar to Sell transactions for holdings
120. cost by the amount received after multiplying Sell Quantity with Weighted Average Buy Cost and then calculates the new weighted average cost by dividing the new total cost by the holding quantity Weighted Average Cost for back dated transaction The FCPB system also calculates WAC for back dated transactions In this case the system calculates revised WAC based on the back dated Buy transaction and for all subsequent Buy transactions The system also takes care of realized P amp L short term long term capital gain loss for all subsequent sale transactions While doing back dated transaction calculation the system checks the date and time of transaction and accordingly calculates the revised WAC If transaction time is not available it assumes that the back dated transaction as the last transaction for the day transaction date and accordingly calculates revised WAC realized gain loss and short term long term capital gain loss on subsequent sale transactions In case of back dated transaction system re computes AUM and Commission also Portfolio Creation and Maintenance Description a ORACLE A portfolio is required to manage and record all the holdings of a customer FLEXCUBE Private Banking allows the user to maintain the holdings in a portfolio across a range of asset classes as defined in the system The user can create several portfolios under portfolio types Self Managed and Heldaway different currencies or differ
121. cription Mandatory Name All the securities in the chosen instrument type Structured Product and portfolio are displayed Each security in the tab is displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security Display only CCY Currency This field displays the security currency Display only Sttl CCY This field displays the settlement currency for the selected instrument If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details Display only Nominal Amount The stated value of an issued security that remains fixed Display only Buy Price Buy price is the purchase price of the security Display only Qty The total balance units as of the current business day are displayed here The balance units are derived by netting the purchase and sale transactions Display only Total Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only 3 43 ORACLE Field Description Mandatory Market Price The market price for securities will be Display only received as online update from external data vendors In the absence of reception of market price on a business day t
122. curities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen Once the user selects the Forex ID following fields are automatically get populated e Base Currency e Terms Currency e Last Exchange Rate Step 4 Select the appropriate deal from the Deal Type drop down list Step 5 From the Transaction drop down list select the appropriate transaction type There are two options available for Forex Transaction They are Buy and Sell By default Buy option is selected Step 6 Select the appropriate Trade Date By default the system displays the current system date or business date whichever is later but user can modify the trade date Step 7 Select the appropriate FX settlement date Once the settlement date Step 8 From the Order Type drop down list select the appropriate order type If the user selects the Order Type as Stop Loss or Limit Order the Trigger price field is editable and user can enter the desired trigger price else system auto populates the appropriate trigger price aes ORACLE Step 9 Select the appropriate option from Time Condition drop down list Step 10 Enter the appropriate amount in the Amount In Base Currency text box Step 11 Enter the appropriate rate in the Treasury Rate text box The system defaults this value to the last exchange rate Step 12 Enter the appropriate rate in t
123. customer explained in detail in the section on Customer Management Though all the analysis dimensions are represented graphically the user has been provided with the flexibility to alter each depiction to a tabular view Thus you can flip between the graphical and tabular view by clicking on the L amp and C buttons respectively for any of the above mentioned dimensions displayed above in the second screen shot of screen 1 The analysis tabs will be represented blank for those customers who are yet to make provide investment details Similarly the corresponding Model tab will be blank for those customers who are not associated to any model portfolio one ORACLE 2 The second simulator screen for simulating the holdings can be reached by clicking on the Simulate button provided at the bottom of the first screen The Simulator screen displays the holdings in all instrument types across all the portfolios along with their current market value The user has the option to simulate by adding new holdings which is attainable Add by clicking the button The user also has the flexibility to either modify or delete any Modify Delete of the current holdings by clicking on the buttons or You can l l Se Clear List wipe off the entire current holdings of the customer by clicking the button and simulate with completely new holdings After modifying deleting adding the new holdings click on the fotum button in order to scrut
124. d ued ORACLE Step 10 The value in the amount field gets populated on entering the Quantity and Premium Unit field Step 11 Enter the transaction description in the Description text box Step 12 Click the Submit button On submitting the holding the system displays a confirmation message on the screen If the user changes decision on updating the holding can clear the entire details captured earlier a Clear by clicking on the button 5 12 Forex 5 12 1 Order Management for Forex Please note that though this section of user manual explains order management and capabilities of Forex instrument type but these features of order management UI and processing would be available to the bank only if the bank s license entitles them to the Alternative Investments module and Order Management module Forex Order Capture User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y aG ORACLE Screen Bess Figure 5 34 Forex Order Capture Screen Navigation After logging in the system select Order Management gt Forex gt Order capture
125. d s composition The instrument master will be updated as Name Asset Class Holding Tokyo Motor Equity 49 81 Cash Cash 10 19 Others Equity 30 19 Equity Others Others 9 81 Display only Augmenting this further suppose the AIM Japan Report scheme was issued in USD and the currency details of the constituents are given as Tokyo Motor Yen and Cash USD and that the entire equity holdings are in Yen then the instrument master would be updated as Name Asset Class Currency Tokyo Motor Equity Yen Cash Cash USD Others Equity 383 ORACLE Equity Others Others USD Field Description Mandatory Enhancing our comprehension on PM Schemes the actual units held in the constituents in all the instruments types expect Mutual Fund will be considered for the purpose of analysis The deduction of the units in the instrument type Mutual Fund and Structured Products for the purpose of analysis has been elucidated below Please note that the methodology is the same for both holdings held directly in these instrument types or through the PM Schemes With the exception of securities under the asset class equity amp debt for the securities under the other asset classes the holdings composition denominated as number of units will be defaulted to Null In case of equity amp debt the number of units held in each security
126. d instrument Once the Instrument Name is selected system auto populates this field Instrument Group Displays the Instrument Group for the selected Instrument Once the Instrument Name is selected system auto populates this field Instrument Currency Displays the currency for the selected instrument name Once the Instrument Name is selected system auto populates this field Settlement Currency Displays the instrument settlement currency Once the Instrument Name is selected system auto populates this field Transaction Details Transaction Date Enables the user to select the appropriate Y transaction date using the calendar icon Settlement Date Enables the user to select the appropriate settlement Y date using the calendar icon Account Type Enables the user to select the appropriate account type Account Number Enables the user to enter the appropriate account number Nominal Amount Enables the user to enter the nominal amount It is Y the stated value of an issued security which remains fixed Quantity Enables the user to enter the appropriate transaction Y quantity in the Quantity text box Price Enables the user to enter the appropriate price per Y unit for the selected instrument in the Price Unit text box Interest Enables the user to enter the appropriate accrued interest 5 84 ORACLE Field Description Mandator y Field beside Interest Should accept positive numeric values onl
127. d Transaction Capture Transfer Screen Screen Navigation After logging into the system select Transaction Management gt Mutual Fund Click on the Transfer tab The user can also transfer the fund details from one Scheme Name to another Scheme Name by clicking on the Transfer tab Enter the appropriate details in the From section as well as in the To section and click on the Submit button Once the user clicks on the Submit button the system displays the message Transaction placed successfully 5 3 3 MF Sys Plan Cancellation User Access levels Customers can cancel the Systematic Plan Tap ORACLE Screen anes CG senem ACLE Twn Mgmt Order Mamt Home Portfolo Tin Management Order Mgmt Master Tools Reports My Workspace Order Mgmt gt MF gt Systematic Plan Cancellation View riod Scheme lame Transaction Amount FromDate ToDate Frequency Last Pai Date Te Figure 5 10 MF Sys Plan Cancellation Screen Screen Navigation After logging into the system select Order Management gt MF gt Systematic Plan Cancellation Procedure for Systematic Plan Cancellation Step 1 From the Portfolio Name drop down list select the appropriate portfolio for the selected customer Step 2 From the Transaction Type drop down list select the appropriate transaction type Step 3 From the Scheme Name drop down list select the appropriate scheme Step 4 Click the Search button Once the user clicks on
128. d with a confirmation message on the screen ale ORACLE If you change your decision on updating the holding you have the option to clear the entire details a Clear captured earlier by clicking on the button 5 8 Transaction Processing for Other Collectibles 5 8 1 Transaction Processing for Others BSricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Mutual Funds and Insurance Module of FCPB ane ORACLE Description In this section we will comprehend the transaction management for those holdings which cannot be classified into any of the above instrument categories These holdings have been clubbed in to the category Others We have also seen in the earlier sections that securities in FCPB are also categorized in to a range of asset classes Currently the following asset classes have been defined in FCPB namely equity debt art real estate gems metals cash and insurance The different asset classes to be used by the bank can be identified and maintained by the administrator in the Reference Master Table The holdings in equity bonds mutual fund and structured products can be chiefly grouped into the asset classes equity debt and cash Though there are some mutual funds which also invest their corpus into other asset classes like real estate and art The holdings in insurance will invariably fall into the asset class ins
129. dar The user can also select the settlement date using the icon located next to the Settlement Date field As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions The user is also restricted from capturing a future purchase date Step 5 Select the appropriate account type from the Account Type drop down list Step 6 Select the appropriate account number from the Account Number drop down list aon ORACLE The system defaults the Account Number based on the Flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Account Number field Step 7 Enables the user to enter the appropriate amount in the Nominal Amount filed box Once the nominal amount is entered the system displays the quantity calculated using the formula Amount Face Value Step 8 Enter the appropriate price in the Purchase Price field Step 9 Enter the appropriate interest in the Interest field Step 10 Enter the appropriate fee if any in the Fee field Step 11 Enter the appropriate tax and other charges if any in the Tax amp Other Charges field Once the fees and tax are entered system displays the Total Amount Step 12 Select the appropriate Counterparty name using the search icon Step 13 Enter the appropriate ref no in the Counterparty Ref No text box Step
130. datory for the user to capture data in this field Step 10 The user then finally proceeds to capture the bank details This field is a mandatory field for the user The direct credit account provides the fund house with the information on the bank details for crediting the proceeds of the redemption Step 11 After entering all the fields in accordance to the outline given in the above steps you can proceed Submit E to click on the submit button On submitting the order you will be displayed with a confirmation message on the screen If you change your decision on the order you have the option to clear the entire details captured Clear earlier by clicking on the button On the contrary if you are accessing the order screen through the Portfolio Management menu navigation through Option 2 the clear button will clear only the editable fields in the screen On submitting the order the system will validate if the particular fund scheme is open for redemption Error message will be displayed on non compliance of the same The system does not validate the KYC check for Joint Holder while placing the redemption order Existence of restriction instruction for redemption on the particular fund scheme will curtail the user from initiating a redemption order System will display an error message if the user initiates a redemption request for a fund scheme during its lock in period Ore above
131. discretion without consulting the client The fund manager independently manages the funds of each client subject to the overall mandate as given by the client and can be compared with a mutual fund scheme while in the case of a non discretionary fund management service all investment decisions are carried out after consultation with the client Most of the PMS investments are for long term generally over 1 year and are focused towards equities As each of the PMS investments are specifically designed and customized to cater to each customer depending on his her needs the constituents of the PMS investment vary from customer to customer oe ORACLE Screen PMS RM Managed Instrumen t Name HSBC PMS Total SGD 5 000 00 5 000 00 Figure 3 16 PMS Valuation Screen Field Description Mandator y Name All the securities in the chosen instrument type Display Portfolio Management Scheme of the chosen only portfolio are displayed Each security is displayed with a hyperlink Click on the hyperlink to view all the transaction executed in the security CCY This field displays the security currency Display only Account This is a unique customer account number Display number only Investment This field indicates the total amount invested by the Display amount customer in the particular scheme This amount will only be received as a feed from external source System will not roll up the transaction
132. displayed in the search screen Step 4 Select the appropriate transaction option from the Transaction Type drop down list Step 5 Enter the appropriate amount in the Amount In Base Currency text box Step 6 Enter the appropriate rate per unit of Commodity Currency in the Forex Deal Rate text box Once the user enters the Forex Deal Rate system calculates the amount and displays it in Terms Currency Step 7 Enter the appropriate fees in terms currency if any in the Fees text box Step 8 Enter the appropriate tax and other charges in terms currency if any in the Tax amp Other Charges text box Once the Fees and Tax amp Other Charges are entered system calculates the total transaction amount and displays it in the Total Amount text box Step 9 Select the appropriate FX Forward date Step 10 Select the appropriate transaction date Aeae ORACLE 5 13 5 13 1 Step 11 ra Select the appropriate Counterparty Name using the icon Step 12 Enter the appropriate ref no in the Counterparty Ref No text box Step 13 Enter the transaction description in the Description text box Step 14 Click the Submit button On submitting the holding the system displays a confirmation message on the screen If the user changes decision on updating the holding can clear the entire details captured earlier eo Clear by clicking on the button Generic Instruments BSricase note that transaction capture U
133. down list select the appropriate Transaction Type The options available are Buy and Sell Step 5 Click the a icon next to Transaction Date and Settlement Date fields and select the appropriate transaction and settlement dates Step 6 Enter the appropriate quantity in the Quantity field Step 7 Enter the appropriate price per unit in the Price Units field The system then calculates the total amount and displays it in the Amount field Step 8 Enter the appropriate transaction fee in the Fees field unk ORACLE Step 9 Enter the appropriate brokerage commission in the Commission field Step 10 Enter the appropriate amount in the Tax amp Other Charges field Step 11 Enter the appropriate rate in the Exchange Rate text box This field is enabled only if the instrument and settlement currency is different else it is defaulted with value 1 Step 12 Select the appropriate Counterparty name using the search icon If the user enters the Counterparty name the Counterparty Ref No is a mandatory field else the system gives the error message Step 13 Enter the appropriate ref no in the Counterparty Ref No text box If the user enters the Counterparty Ref No the Counterparty name is a mandatory field else the system gives the error message Step 14 Enter the transaction details if any in the Description text box Step 15 Select the appropriate account no from the DP ID Client ID drop down
134. e Allow Omnibus flag is selected as Y at Instrument Type level the system defaults this drop down to the Omnibus Account No along with the DP ID Client ID Bank Account Enables the user to select the appropriate bank Y account no from the drop down list Comments Enables the user to capture remarks before saving Y N the order details oad ORACLE Procedure for Placing of an Order Step 1 For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Step 2 Click the a icon next to the Instrument Name field When the user clicks on the a icon next to the Bond Name field Security Search window appears Enter the appropriate search criteria in the respective fields to search for the Instrument Name The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Once the user selects the Instrument Name following fields are automatically get populated e Security Code e Instrument Currency e Settlement Currency e Security Sub Type e Holding Nominal e Holding Quantity
135. e cost methodology Please note that the average cost methodology is pertinent only for the remaining purchase transactions in the portfolio subsequent to application of the first in first out FIFO rule for all the sale transactions in the portfolio The average cost requires you to determine the average cost per security of a class total amount invested divided by the total number of commodities held A FIFO rule is an accounting methodology wherein if you hold a security of the same class which has been acquired on different dates the security acquired at the earlier time is deemed to be disposed off first Display only Total Buy Cost Buy Cost is the product of the buy price and quantity Display only Market Price The market price for securities will be received as online update from external data vendors In the absence of reception of market price on a business day the system will consider the preceding received price for the function of valuation and analysis The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation The Market Price is hyperlinked on click of which the system directs the user to Portfolio Alerts screen to set up the alerts as per require
136. e securities such as options forwards and swaps is determined by the prices of the underlying securities The benefits of structured products such as principal protected notes can include e Principal protection e Enhanced returns within an investment e Reduced volatility or risk within an investment Apart from Structured Products the other Alternatives instruments like Private Equity Funds Venture Capital Funds or Real Estate Funds are medium to long term funds which invest in equity stakes in potentially high growth unquoted companies Investors specify a minimum commitment amount and commitment period for investing in such funds The actual portion of the capital commitment amount is paid from time to time either based on a mutually agreed drawdown schedule or by an on call drawdown after receiving a drawdown notice Additional commitment from the existing contributors during additional closings is allowed Sale of units is possible only on maturity Usually there will be no public market for the units and subject to certain limited exceptions such units or beneficial interests will not be transferable These products are synthetic investment instruments specially created to meet specific needs that cannot be met from the standardized financial instruments available in the markets Structured products can be used as an alternative to a direct investment as part of the asset allocation process to reduce risk exposure of a portfolio or
137. e Description Header Displays following Instrument Source Details Instrument Name Source For direct investment system should display source name as Direct and for indirect holding display source name as the parent instrument name for e g if by investing in Fidelity equity fund customer has indirect holding in IBM then under source name Fidelity equity fund name is displayed No of Units Total number of units held in that instrument under that source Market Value Market value which will be Price Units Composition holding of that source wrt total holdings in that instrument nee ORACLE 3 4 4 View Portfolio Analysis By Region Screen Region Details SOUTH ASIA India Figure 3 33 Portfolio Analysis By Region Screen Screen Navigation To view the analysis for Region please ensure that the Region option has been selected from the Category drop down list Now when the user selects the option By region for your analysis all the holdings of the customer get organized in accordance to the different regions and are displayed in the customer preferred currency Adjacent to the second tab is a tab displaying the graphical depiction of the type of view selected For further analysis of the holdings in each region the user can click on the hyper link under each region in the second tab An additional tab will appear below the second tab which will provide further inform
138. e Gain Loss due to Client CCY toCCY Impact price Impact Sa Unrealized 5 542 m 10 400 000 14 665 649 700 6 00 4 348 914 509 ise 3 75 ORACLE Figure 3 28 Gain Loss Summary in Client Currency Sub Constituent View of Instrument Type MF amp SP If Instrument type MF or Structured Product is selected then the sub constituent details of the scheme instrument will be displayed as a pop up by clicking on that scheme instrument name hyperlink Should be available to both views Individual as well as Household Screen E E FLEXCUBE PRIVATE BANKING SubInstruments Popup Windows Internet Explorer l Instrument Source DetailsSP SDR Instrument Name Instrument Type Composition Mac EQ Direct Eq 80 00 BBG Bond Test 1 Bonds 5 00 Mac OTH Others 15 00 Figure 3 29 Instrument Source Details Window Attribute Description Header Displays the Scheme Instrument name Instrument Displays the instrument name which are part of the sub constituents of Name the MF scheme or Structured Product Information regarding sub instrument name to be picked from INST_ASSET_ALLOC_PATTERN table Instrument Displays the instrument type Type Information to be picked from Mst_Instrument Composition Displays the allocation of the corresponding Instrument to the total holding Information to be picked from INST_ASSET_ALLOC_PATTERN table Decimal up to 2 decim
139. e approach adopted by the various fund houses in the industry While some fund houses are inclined to map all the additional investments of the customer into the same folio number in spite of the customer not declaring the folio number in his future applications Others tend to generate a new folio number for every application without the folio number mentioned in it Apart from this there is also an inconsistency in the levels at which the folio numbers are issued While some fund houses issue separate folio number for every Fund scheme combination others issue a new folio number for every fund scheme option combination FCPB provides its users the option to choose the existing folios numbers within the fund On picking a fund scheme through the search screen all the existing folio number s affiliated to the fund scheme in the portfolio of the selected customer are displayed in the Folio No dropdown field The user has the option either to select any of the existing folio number for making additional purchase or proceed to make a purchase exclusive of any of the existing folio numbers For first time purchase the dropdown will not have any values in it If the flag Folio at Issuer Level is maintained as Y at an Instrument Issuer level then FCPB system also checks if there are any holdings across the portfolios excluding held away where the issuer is same as the issuer of the selected instrument If so then it displays the existing
140. e appropriate account The account types available are Demat and Non Demat The system defaults the Account Type based on the Flags selected at Instrument Type level If Demat option is selected then the system displays Omnibus A c or Client A c or both in the Folio No field If Non Demat option is selected than system displays the existing Folio No in the drop down or provides an additional text box next to account number drop down field to enter a new folio number account number Step 7 There are two ways in which you can invest in a mutual fund A one time outright payment Regular In this type of investment the user just hands over the entire amount and get the fund units depending on the value of the units on that particular day Periodic investments or this is also referred to as a SIP is a periodic investment in a mutual fund At every frequency the user will have to commit to put in a fixed amount purchasing certain units FCPB offers the users with the flexibility to invest in both the payment options These options are provided as radio buttons next to the field Payment Option 29 ORACLE Step 8 After you place an investment order in any Mutual Fund the fund house generates a folio number for that particular fund The folio number generated by the Fund house is analogous to a Customer ld and is generally generated for every unique combination of name and date of birth However there is a great disparity in th
141. e cash e commodities e insurance e All the securities which cannot be categorized into any of the above defined asset classes will be classified into the category others The system also enables the user to analyze the multidimensional view for his her assets by clicking on the icon as explained in this section later 7 The tab adjacent to the second tab displays the graphical depiction of the type of view you have selected The user can view the graphs either as a pie chart or as a bar chart as explained earlier 8 For further analysis of the holdings in each asset class you can click on the hyper link under each asset class in the second tab An additional tab will appear below the second tab which will provide further information and analysis about the securities held in the selected asset class Understanding the screen Irrespective of the type of login customer or RM the system facilitates to analyze the holdings across all the portfolios An asset class which currently does not have any holdings will not be displayed in the screen If the customer does not have any holdings across any of the asset class then the system will display blank tabs The detailed descriptions of fields are given below Asset Class Field Description Mandatory 3 78 ORACLE Field Description Mandatory Asset All the asset classes of all the holdings across all the Display class portfolios of th
142. e different segments of the market capitalization for the selected customer Similar to the industry analysis the analysis on market capitalization is also applicable only to the holdings in equity instrument type which includes both direct and indirect holdings across all the portfolios The different segments of market capitalization to be used by the bank are identified and maintained by the administrator in the Reference Master Table ad ORACLE Now when the user selects the option By Market Capitalization for analysis all the holdings in equity get organized in accordance to the different segments of market capitalization and are displayed in the customer preferred currency This sorting of the holdings is done across all the portfolios of the customer 1 The tab adjacent to first table is a tab displays the graphical depiction of the type of view selected by the user The user has been provided with the flexibility to view the graph either as a pie chart or as a bar chart This can be done by selecting the appropriate type of graph from the drop box provided in this tab In the bar chart the y axis represents the of total i e composition of a segment in market capital as compared to the total composition of the market capital across the customer s holdings in equity This is arrived at by calculating all the associated amounts in the customer preferred currency The x axis names the different segments in the market capital in
143. e next two fields have been provided to capture the exit load and tax paid for redeeming the holding Exit load also known as Deferred Sales Charge is a fee paid when shares are sold Also known as a back end load this fee typically goes to the brokers that sell the fund s shares The amount of this type of load will depend on how long the investor holds his her shares and typically decreases to zero if the investor holds his her or her shares long enough Please note currently these fields are currently not being utilized for any of the valuation analysis or performance computations Step 12 Enter the appropriate transaction fee in the Transaction Fee text box Step 13 Enter the transaction details if any in the Description text box vee ORACLE The user is allowed to enter the details upto 250 characters If the entered details exceed 250 characters system displays the message as Description cannot exceed 250 characters Step 14 After entering all the fields in accordance to the outline given in the above steps the user can proceed to click on the save Guhanik button On saving the holding the user will be displayed with a confirmation message on the screen l Clear To clear the entire details captured earlier click on the button Mutual Fund Transaction Capture Transfer User Access levels Customer Can capture the Mutual Fund transfer transactions ve ORACLE Screen Figure 5 9 Mutual Fun
144. e nominal value of the bond in the Nominal Value text box Step 9 The next significant step is to capture the net purchase price per unit of the holding and no of units Please note that it is this price which will be considered for the purpose of analysis and performance computation and hence it is the onus of the user to enter the accurate value This field too is mandatory for entry by the user ae ORACLE Step 10 The next three fields have been provided to capture the interest fee commission and tax paid for obtaining the holding Also enter the valid Cap Factor Step 11 If Instrument Currency and Settlement Currency are different system displays the appropriate exchange rate in the Exchange Rate text box Step 12 Select the appropriate Counterparty Name using the search icon Step 13 Enter the appropriate ref no in the Counterparty Ref No text box Step14 Enables the user to enter the transaction details if any in the Description text box Step15 Enables the user to select the appropriate account from the Security Account drop down list The system defaults the Security Account no based on the Flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Security Account field Step 16 After entering all the fields in accordance to the outline given in the above steps the user can Save proceed to click on the save butto
145. e responsible for any loss costs or damages incurred due to your access to or use of third party content products or services m Table of Contents PREFACE c ccitssscsstsssescevsonsseastevonsssancosccssnstossveesonceaceeassoncesecssusccsssecshseosesdsstasevdesesonssdeccsvandescosdestassecesessessesessenss 1 1 1 1 1 TET O DUCTION AA EEEE E E A EEA E E E AE l 1 1 1 2 CODE A AE A E AEE E E san uasceevasseceytiuetbepsnstdea naneaeeuecamnts l 1 1 1 3 AUQION E LEARRA EE AED E PA EE TE T A ESE TN EE EA E E ENET l 1 1 1 4 Documentation ACCOSSIDIIUY 0s siccsiccciisustssceavicccsanevinsassadensisdestecd bsasssdevoviecdstecin Oa A ERE E ERE l 1 LIS Organization of the DOCUMENEL ccscesceesseeseeeseeeeeeeecesecusecaecuaecauecaeecaeeeaeeeseseceeeeeeseseeseaesnaseaesaeaas 1 2 1 1 6 Conventions USE ressonar iK E EREE E E ERE ER EEEE REEE ESER 1 2 1 2 SYSTEM OVERVIEW AND CAPABILITIES ccsscecssccesececssccesscecssceesneeceaccesceecssccnsneessaecesseecssceneaeessaeeeseeeenes 1 2 CUSTOMER RELATED MENUS sissssccsscnscssnscssesssscnssnsnsceonssnesessessensssesntesbeesveonscndusesoossnsceseccseasscesncsodnssssenssase 2 1 2 1 CUSTOMER IDASHBOARD ssdsssvascadeavecasccese cen denedin Nr aeaa E RRRA E a E E R N E aT 2 1 2 2 VEW PROFILE soiien neenon n Ee ekee aa PER EKER AECE E EAO E EEES EAE E Kea aE EEE EEEE AEE E 2 4 2 3 RM DETAN Siepen ena aE EE sue E T E toa AEE EEEE 2 5 2 4 VOLUNTARY CORPORATE ACTION sccsssssesseessseeccecsssssescees
146. e selected customer are displayed only Each asset class in the tab has a hyper link Click on the hyper link to view a tab displaying additional analysis of all the securities in the asset class The details of this tab have been detailed in the next table If the Asset Class Decomposition flag is set to Yes then the system displays the Asset Class values after considering decomposed components Further on click of any instrument hyperlink under Asset Class tab system displays the source for the decomposed values If the flag is set as No then system would not consider decomposed values 3 79 ORACLE Field Description Mandatory Market Market value is the product of the market price and Display value quantity only It is stated in the above section that the different asset classes to be used by the bank are identified and maintained by the administrator in the Reference Master Table and that every new security added to the Instrument Master Table contains the various related data for the security such as the instrument type currency region and industry and asset class We also stated earlier that FCPB captures the detailed security level composition of Mutual funds PMS and Structured products which are utilized in displaying the various views of the customer s holdings The asset class analysis is one of these which utilizes the constituents of these instruments for displaying the holdings
147. e transaction details if Y any Procedure for Placing Transaction 5 144 ORACLE Step 1 The system auto populates the name and ID of the customer Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 Click the 4 icon next to the Currency Pair field ory When the user clicks on the icon next to the Currency Pair field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the Forex instrument Instrument Name Instrument Type Forex Status Active Base Currency Select v Terms Currency Select v The search has been narrowed down to 250 instruments Please redefine your search if you are not able to find the instrument e koe Instrument Name Figure 5 36 Forex Instrument Search Window Once the user selects the Forex instrument following fields are automatically get populated e Base Currency ale ORACLE e Terms Currency The user can select the forex instrument either by directly entering the instrument name or by oF searching for the security using icon as explained in general characteristics section The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be
148. e user to the customer dashboard page Another option for the user is to choose the home from the top menu and navigate to the dashboard Screen Vapeos H es porto Summary Products Mame cev tuyCont Market vae Stlowent Oste umesti rts nom CD ED GD GID Recomm Asset Alocaton e Actual Asset Allocation e Porttoto by Instrument Group e dD Om a Ea n we io owe Figure 2 1 Customer Dashboard Screen Customer Login Navigation Customer The moment customer logs in and if his risk profile is updated in the system he will land on the customer dashboard page else he can choose the home from the top menu and he can navigate to the dashboard Main Tables Description Features ORACLE Main Tables Description Features NetWorth It displays networth details of the Also displays the Client i e details to all the sum Insured for a accounts held internal to bank that client If the Sum are not part of portfolio investment Insured field is It also displays the networth hyperlinked and it details of the Household members opens up a pop up on clicking of the Household icon on clicking of the located below the Sum Insured hyperlink to field display the details The Portfolio Value hyperlink of the insurance opens up the Portfolio taken by the client Maintenance screen a quicklink In case the policy to Portfolio Maintenance held by the customer is of type The blow up icon located at the ULIP
149. eDate 5 Instrument Name NO HOLDINGS EXIST FOR LESS THAN ZERO HOLDING Total Note Figure 3 24 Forex Valuation Screen 3 3 15 Fee The FCPB system calculates and stores the Periodic Fee based on the Client Segment Portfolio Type and IAG combination At a pre defined frequency these fees are charged for each applicable customer portfolio either as Percentage Flat combination or Higher and displayed in Portfolio Maintenance screen In Portfolio Maintenance screen Fee appears as an instrument with a hyperlink where the Buy Cost Qty and Market value etc is displayed as zero When the user clicks on the hyperlink the Fee Transaction Details the pop up is displayed showing the Fee history i e the various fees charged to the customer with the date of charge for that particular portfolio type Screen FLEXCUBE PRIVATE BANKING Customer Fees Pop up Windows Internet Explorer lo Sea Transaction Details E aa Currency Date Aomen Transaction Amount View Advice Narration Desc ave ORACLE 3 4 Figure 3 25 Fee Transaction Details Pop up Field Description Mandatory Currency Displays the currency of the corresponding fee instrument Date Displays the date on which corresponding Fee was charged Transaction Type Displays the type of transaction i e Fee Transaction Displays the description for the corresponding Narration Desc transaction Amount Displays the tot
150. ect the appropriate bond name Y by clicking on the search icon available next to the Instrument Name field Security Code Displays the Security Code for the instrument Instrument Currency Displays the currency for the selected instrument Y name Once the Bond Name is selected system auto populates this field Settlement Currency Displays the settlement currency for the selected Y bond instrument maintained in the bond master Security Sub Type Displays the Security Sub Type for the selected Based on instrument FAC Average Clean Buy Displays the average buy price of existing holdings of Y Price customer for the selected portfolio if any The average price of the instrument displayed is calculated either on FIFO or WAC basis depending on flag selected in Bank Parameters Holding Nominal Displays the nominal value of the holding quantity Based on FAC Holding Quantity Displays the existing holding quantity of the selected Y bond instrument for the corresponding CPIS The field defaults to zero if it is a first order of the selected instrument for the selected customer Custody Fee Displays the Custody Fee as maintained based on Based on the customer or customer segment amp IAG FAC 5 54 ORACLE Field Description Mandatory Last Traded Clean Price Displays the Last Traded Clean Price The field defaults to the Original Price as defined in the Price Master table It is assumed that Prices are always sent
151. ed Each currency in the tab has a hyper link Click on the hyper link to view a tab displaying additional analysis of all the securities in the selected currency Display only Market value This is computed as mentioned in the Asset class analysis The market value for a particular currency represents the sum of the market values for all the direct and indirect held securities in the particular currency denominated in the customer preferred currency Display only of Total This is the percentage composition of the holdings in a currency under consideration with respect to the total value of all the holdings across all the currencies The sum of the percentages across all the currencies would sum up to 100 Display only At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency As explained earlier on clicking any of the regions in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected currency Region Details Field Description Mandatory Name Displays the names of all the securities direct and Display indirect in the selected currency only ane ORACLE Field Description Mandatory Currency The currency of the security displayed is as captured Display in the instrument master table in the database only Units Units are computed for the indirect
152. ed for about 5 050 At the end of the 20 years the investor will receive 20 000 The difference between 20 000 and 5 050 represents the interest based on an interest rate of 7 which compounds automatically until the bond matures If the bond is taxable the interest is taxed as it accrues even though it is not paid to the investor before maturity or redemption Maturity A bond s maturity refers to the specific future date on which the investor s principal will be repaid Bond maturities generally range from one day up to 30 years In some cases bonds have been issued for terms of up to 100 years Maturity ranges are often categorized as follows e Short term notes maturities of up to five years e Intermediate notes bonds maturities of five to 12 years e Long term bonds maturities of 12 or more years Credit Ratings Major rating agencies include Moody s Investors Service Standard amp Poor s Corporation and Fitch Ratings Each of the agencies assigns its ratings based on in depth analysis of the issuer s financial condition and management economic and debt characteristics and the specific revenue sources securing the bond The highest ratings are AAA S amp P and Fitch Ratings and Aaa Moody s Bonds rated in the BBB category or higher are considered investment grade securities with ratings in the BB category and below are considered high yield or below investment grade While experience has shown that
153. een 2 7 ORACLE 2 5 Figure 2 5 Voluntary Corporate Action Questionnaire Screen for Customer Once the user clicks on the Submit button system displays the message Please note that your responses will be submitted and you cannot change your responses again Do you want to proceed and saves the questionnaire Send Message Description The Customer can send messages to the RM through send message screen The customer can enter free text in the subject field and also can choose the interaction category and product type from a list of drop down The customer has an option to type in free text in the message text box On clicking the clear button the screen clears all that was entered in the text boxes gets wiped off along with the selections done for interaction category and product type On clicking the send button the message is sent to the selected RM User Access Levels Customer The customer can view the send message screen by accessing this screen Screen oe ORACLE 2 6 Figure 2 6 Send Message Screen Screen Navigation After logging in the system as Customer select My Workspace Send message Screen from the top menu Model Portfolio Description The FCPB system allows the user to create the model portfolio for various risk profiles The performance of the model portfolio is computed at the end of each week The system computes the performance only for the bank specified model portf
154. en acquired on the record date and at a nil price The treatment for shares acquired under a rights issue is the same as for a bonus issue except that an allowance has to be made for the amount paid to acquire the additional shares In case of Mutual funds the dividend reinvest option is deemed to have been acquired on the record date and at nil price For securities under the instrument class insurance the premiums paid are considered as acquisition price for the policy Quantity As mentioned earlier the units considered for are after the application of the FIFO accounting rule In addition to the units purchased additional units received due to stock corporate actions are also taken into consideration while determining the units For the securities purchased under the instrument type insurance PMS SPL Product CASA TD and others units are not displayed by the system The orders entered for purchase sale of securities through the System Order Management System and which are in open status for the instrument type equity and mutual funds will not be considered Display only Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only 3 69 ORACLE Field Description Mandatory Market price The market price for securities defined under the instrument type equity mutual fund traded bonds PMS commodity SPL Product CASA TD and str
155. en future Display contracts Long contracts only Short Margin Amount The field displays margin amount to be paid Display only Market Price Market Price of future Display only Market Value Market Value of future Display only Value Date Indicates the latest date of reception of the Display market price feed only 3 59 ORACLE Field Description Mandatory Actions This field displays the links to Sell Buy The links Display are available for all the securities in this tab only 3 3 13 Options An Option is a contract which gives the right but no obligation to buy or sell the asset at a stated date and at a stated price Options are of two types Call and Put The Call option type gives the buyer the right to buy a given quantity of the underlying asset at a given price on or before a given future date On the other hand Put gives the buyer the right to sell a given quantity of underlying asset at a given price on or before a given future date There is no obligation for Call and Put options and are settled in cash Screen Options RM Managed A i Buy cost Premium paid No of open per unit Paid contracts Sa ka Recd Long Short M ar Account Stk Price CCY Danker Market Price Market Value Value Date Action Name Exp Date Opt Type opToo1 34 12 2020 CALL 20 0000 INR 1055 120 0000 400 0000 240 000 000 100 0000 200 000 05 2012 Buy Sell oproo2
156. endently and an RM can create as well as transact on behalf of the customer in his Self Managed portfolio The Held Away portfolio facilitates in capturing the holdings which are held away from the bank With the addition of held away assets you can have a single consolidated view of your customer s entire holdings The FCPB currently facilitates order management for the securities under the instrument type Mutual Fund Insurance Equity Structured Products Bonds Forex Futures Options and Commodities The trade affiliated orders for the securities under the instrument types Mutual Fund Insurance Equity Structured Products Bonds Forex Futures Options and Commodities can be initiated either through the Order Management screen can be navigated from the main menu and is explained in detail in the section on Transaction Management or through the current screen However the user can capture the post trade Buy amp Sell transaction related data through the Transaction Management screen and needs to capture other instrument specific transactions like CA or modify in the market values through the current Portfolio Maintenance screen For a new security to be included in the portfolio the user has to place orders through the Order Management screen or transactions through the Transaction Management Screen All the corporate action related data for the RM Managed and Self Managed portfolios can be updated through the hyperlink provided
157. ent Once the Instrument Name is selected system auto populates this field Transaction Details Transaction Type Enables the user to select the appropriate transaction type from the drop down list Transaction Date Enables the user to select the appropriate Y transaction date using the calendar icon Settlement Date Enables the user to enter the appropriate N settlement date using the calendar icon Quantity Enables the user to enter the appropriate Y transaction quantity in the Quantity text box Price Units Enables the user to enter the appropriate price per Y unit for the selected instrument in the Price Unit text box 5 98 ORACLE combination available in the drop down list Field Description Mandator y Amount Displays the total transaction amount Once the Y user selects the Quantity and Price Unit fields system auto populates this field Fees Enables the user to enter the appropriate fee in the N Fees field Commission Enables the user to enter the amount paid as N commission in Commission field Tax amp Other Charges Enables the user to enter the amount paid as N transaction tax in the Tax field Exchange Rate Enables the user to enter the appropriate exchange Y rate in the Exchange Rate text box The system defaults this value to 1 if the instrument currency and settlement currency is same Counterparty Name Enables the user to search for the appropriate N Co
158. ent benchmarks based on the needs Creating portfolios of different currencies permit the user to track investments denominated in more than one currency with the valuations converted to the portfolio base currency of user s choice Important Comprehension Before proceeding to understand about the portfolio maintenance analysis performance It is important for us to understand the concept of currency in the FLEXCUBE Private Banking FCPB permits the user to track investments denominated in more than one currency with the purchase amounts and valuations converted to the portfolio currency as well as to the customer preferred currency Thus the FLEXCUBE Private Banking accomplishes multi currency portfolio management by accounting for transactions in Security portfolio as well at a customer currency The term security currency refers to the currency in which a given security is purchased and sold and in which it receives corporate benefits such as dividend In multi currency portfolios transaction amounts denominated in the security s currency are converted to the portfolio currency using a currency exchange rate Thus at the portfolio level the portfolio is valued and profits are computed in the portfolio currency The portfolio currency must be specified for a portfolio at the time the portfolio is created In addition to converting transactions and valuations from a security currency denomination to a portfolio currency denominat
159. entity the currency shall get defaulted Step 8 The next significant step is to capture the net purchase price of the holding Please note that it is this price which will be considered for the purpose of analysis and performance computation and hence it is the onus of the user to enter the accurate value This field too is mandatory for entry by the user Step 9 Enter the appropriate transaction fee in the Transaction Fee field Step 10 ed ORACLE 5 9 5 9 1 In the next step has been provided to capture the Tax and Other Charges paid for obtaining the holding Please note currently this field is not being utilized for any of the valuation analysis or performance computations The Amount field is the sum of the Amount Fees and Tax amp Other Charges fields Step 11 The next field Description has been provided to the user to enter any essential information on the holding This field is a free text field Step 12 After entering all the fields in accordance to the outline given in the above steps the user can Sa proceed to click on the save button On saving the holding you will be displayed with a confirmation message on the screen l Clear To clear the entire details captured earlier click on the button Commodities Order Management for Commodities Please note that though this section of user manual explains order management and capabilities of Commodities instrument type but these feat
160. eption of the Display market price feed only Actions This field displays the links to Display Buy Sell Exercise Close Exercise hyperlink is only displayed when there is some holding in the portfolio it is not displayed for zero holding Close hyperlink is enabled only on and after the maturity date The links are available for all the securities in this tab If the option type is European the system displays the Exercise link on the contract expiry date For American option type the hyperlink is enabled all the time till the contract expiry date Exercise hyperlink is enabled if the underlying security instrument type is Equity or Bond 3 61 ORACLE 3 3 14 Forex FCPB provides the facility to input Forex deal details through the front end using the Forex Trxn Management screen or by upload through interface Transaction Processing of a Forex deal is done similar to Futures instrument type processing with a few specific changes done to accommodate the fact that unlike a Futures instrument which has predefined and fixed maturity dates standard contract amounts and is exchange traded a Forex instrument is an OTC product i e not exchange traded and hence could have any currency pair any amount and for any maturity date as required by the customer ee ORACLE Screen We ForexRM2 Net Open n FX Forward Comm Terms ae Market Quick Date c c FXRate Position Senh Amount ric Market Value Valu
161. er goes through on the 20th Jan but since gap between 20 Jan and 10th Feb the date on which the auto generation of orders should have started is not one month FCPB skips auto generation of order for 10th Feb and the auto generation will start from 10th March Step 13 The user then finally proceeds to capture the bank details This provides information as to which bank account the amount will get debited from Step 14 The system also facilitates the user to attach the Transaction Slip To attach click on the Browse button and attach the appropriate Transaction slip Step 15 After entering all the fields in accordance to the outline given in the above steps the user can Submit proceed to click on the button Once the user clicks on the Submit button system displays the Exception displays pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation oe ORACLE e KYC is not verified The orders placed by the customer are self approved by the customer If the order is to be placed in the minor s investment account the system first checks if the KYC Check for Signatories and if it maintained as Y the guardian KYC check is mandatory for placing the order Here if the user tries to place the order and if the gua
162. er is executed and other potion of it is cancelled The fields have been briefly described below Field Description Mandatory Input Section Instrument Enables the user to select the appropriate instrument type Y Type from the drop down list Instrument Enables the user to select the appropriate instrument using N Name the Search icon ae ORACLE Field Description Mandatory Order Type Enables the user to select the appropriate Order Type from Y the drop down list Order Status Enables the user to select the appropriate status from the Y drop down list Portfolio Name Enables the user to select the appropriate Portfolio Name Y to view the desired orders Country of Enables the user to select the appropriate Country of N Market Market using the Search icon to view the desired orders Order Date Enables the user to enter select the appropriate From Date N From to view the desired orders Order Date To Enables the user to enter select the appropriate To Date to N view the desired orders Display Section Order ID Displays the order id of the corresponding order Display Portfolio Name Displays the name of the portfolio associated with the order Display Inst Type Displays the instrument type for the corresponding order Display Inst Name Displays the name of the instrument Display Inst CCY Displays the instrument currency of the instrument agai
163. eric Instrument Master by clicking on the hyperlink Security Code Displays the alternate id of the selected instrument Instrument Currency Displays the currency for the selected Instrument Y 5 71 ORACLE Field Description Mandator y Settlement Currency This field captures the settlement date for an instrument based on the settlement cycle maintained in the system for the exchange on which the instrument trades Custody Fee This field displays the Custody Fee based on the customer segment amp IAG Instrument Group Displays the Instrument Group for the selected Y Instrument Once the user selects the Instrument Name system auto populates this field Exchange Enables the user to select the appropriate Exchange Last Traded Clean Displays the Last Traded Price Price Counterparty Enables the user to select the appropriate Y counterparty Order Details Trade Date Enables the user to select the appropriate trade Based on date The system does not allow the user to enter FAC the future trade date If the trade date falls on the system or exchange holiday the system displays the appropriate warning message Settlement Date Captures the settlement date for an instrument Based on based on the settlement cycle maintained in the FAC system for the exchange on which the instrument trades Account Type Enables the user to select the appropriate account type i e Demat or Non Demat Accou
164. erred currency If the Category is selected as Asset Class then in the Gain Loss Summary pop up the system displays the details in the customer preferred currency View of Direct and Indirect holding in an Instrument in Portfolio Analysis Screen e View of direct and indirect holding details in a particular instrument will be available for Instrument Type Equity Bonds and Commodity e The user can view the direct and indirect holding details in a particular instrument when selects a category as Asset Class Region Currency Industry and Market Capitalization note that for Industry and Market Cap only Equity instruments are considered ae ORACLE e Cases where indirect holding is because of MF Type Fund of Fund then only parent instrument name would be displayed under the source name and not the sub constituent scheme name though the number of units market value and composition would be based on the complete recursive decomposition e The user on clicking the instrument name hyper link can view the direct and indirect holding details Following pop up will be displayed Screen r FLEXCUBE PRIVATE BANKING SubInstruments Popup Windows Internet Explorer Instrument Source DetailsMac MF Instrument Name Instrument Type Composition Mac EQ Direct Eq 50 00 Equity Axis Direct Eq 40 00 Krina Future Inst FUTURES 10 00 Figure 3 32 Instrument Source Details Window Attribut
165. erred currency TA ORACLE As explained earlier on clicking any of the segments in market capital in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected segment oe ORACLE Market Cap Details Field Description Mandatory Name Displays the names of all the securities in equity Display direct and indirect in the selected segment only Currency The currency of the security displayed is as captured Display in the instrument master table in the database only Units Units are computed for the indirect holdings as Display described in the previous table only In case of direct holdings the units include the purchased and additional units received on account of stock corporate actions Market value Market value is the product of the market price and Display quantity only The market price will be as received from external data vendors of Total Is the percentage composition of the market value of a Display security in a segment of market capital as compared only to the total market value of all the securities in the segment Please note the values are computed in the customer preferred currency This section displays the details at Customer level across all portfolio holdings grouped by Market Cap Only the instruments of Asset Class EQ are considered and are displayed in this section Since CASA and TD instruments are not classified as
166. ership equity typically carries voting rights that can be exercised in corporate decisions An owner of a company s equity is also entitled to share in the profits of that company This participation usually takes place in two ways 1 A dividend distribution of earnings paid by the company to the share owners 2 An appreciation in the price of the stock capital gain generated by the future prospects of the company Equity has no maturity date the shareholders are entitled to these earnings for as long as they own the shares and the company is in business Equity Markets An equity or stock market is the place where companies issue shares of stock and investors purchase and sell these shares These markets usually have three types of participants 1 Investors 2 Issuers 3 Financial intermediaries brokers and dealers Essentially investors have capital and need opportunities to invest issuers need capital Brokers and dealers are financial intermediaries Brokers arrange for the issuers and investors to complete a deal dealers purchase securities from issuers and sell them to investors Equity Market Transactions There are essentially three types of transactions in the equities market 1 An initial public offering 2 A seasoned offering both 1 and 2 are primary market transactions and TE ORACLE 3 An investor to investor sale of securities Primary Market Transactions Initial Public Offering IPO In an init
167. esponding details for the selected customers are not updated then the system displays the appropriate messages and will not allow the user to place the order For a customer login the Portfolio Name drop down list defaults to the default portfolio of Portfolio type Self Managed The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Step 2 The subsequent step is to capture the fund scheme details For placing the order the user has to select the fund scheme to transact The user can select the fund scheme either by directly entering the name of the fund scheme or by searching for the fund oD scheme by clicking the button The fund scheme search screen displays only the schemes which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views NFO details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Once the Scheme name is selected the system populates the Security Code which is the alternate id of the selected instrument Security Sub
168. essage on the screen button On saving the holding you will be displayed If the user changes the decision on updating the holding entire details captured earlier can be E Clear cleared by clicking on the button Mutual Fund Transaction Management Redemption User Access levels Customer Can capture the Mutual Fund redemption transactions for the available portfolios created either by the customer or by the RM Saa ORACLE There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios Screen Figure 5 8 Mutual Fund Transaction Capture Redemption Screen Screen Navigation After logging into the system select Transaction Management gt Mutual Fund Click on the Redemption tab Rules for Redemption e Transactions can be updated only for customers in active status e For capturing a holding the customer should have at least one portfolio coupled to his her id and should have previously held holdings in a scheme Procedure for Redeeming a Holding Step 1 The system auto populates the name no and default portfolio name of the customer The Customer No and Customer Name fields are driven by the Field Access Controller Step 2 aap ORACLE For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Step 3 The subsequent step is to capture the
169. essesseeeecesecesecusecsecasecaeeeseeeseesaeesseeeeeeeensecnaeenaeeaas 3 90 3 4 5 View Portfolio Analysis By Currency scccsscecesecesnceceseceeneecnseeesneecseceeneecsaecseneecsaeceeneecaeeeeneeenaeeees 3 92 3 4 6 View Portfolio Analysis By Industr Yrren aean E E E ERa 3 94 3 4 7 View Portfolio Analysis By Market Capitalization osesneeeeseeeeeeeeneeesenerrsreeresresrssrrrrereseresesreses 3 97 ORACLE 3 5 SIMULATOR sanare e Cente a aa eE aE e Osea e ee Guveteste a E teas Siete cust eel 3 101 30 PORTFOLIO ALERTS c2cscstgscsacgegscsucetgscsacstescescst iconcstgstetestgdtencsti deokeetgiconcstgitezsslsstvncsteitebestdicenesteniepestavensest 3 120 Bel TRAC GOAD cianta a E EER EE EE EEE EA EES 3 128 4 INVESTMENT PERFORMANCE MANAGEMENT sccccssscssssscsscssssssssencsscsssessssssesssssnessssnessessssosees 4 1 5 ORDER MANAGEMENT AND TRANSACTION MANAGEMENT ccccsssssssscssssessscssesessseneesesssesesees 5 1 5 1 INTRODUCTION ey 2esccteSssite E RAE TAN AREEN EN aces tents 5 1 5 2 EQUITY ORDER MANAGEMENT ssissescccissssdieskesdessevseeoeeeh sce sas vetadcoadesds sveegeee cos cebavsaucedeeceseesteateddececessesgesteesseoe 5 2 5 2 1 Equity Order Capture srecna ni ipassnasi na ctnstigeseeseiunteadeapusseysayaseadeasesenpnipadvedecpuadey sinasbeascaeat 5 4 5 2 2 Tr ns chon Processing Jor Equity seirinin EEE EEE E ENEE T 5 12 5 3 MUTUAL FUNDS ORDER MANAGEMENT cccccsssssssssssssessessseessssassecsssassessssaese
170. ext field captures the total redemption amount received by the customer on redemption Please note that it is this price which will be considered as the sale price for the purpose of analysis and performance computation and hence it is the onus of the user to enter the accurate value This field too is mandatory for entry by the user Step 8 oa ORACLE In the next step the user needs to capture the units of redemption All the holdings in the same fund scheme held in the same portfolio of a customer will be consolidated It is mandatory for the user to capture information in this field The units captured by the user will be validated by the system against the balance number of units The units in mutual fund can encompass up to 4 decimal places Step 9 The user then proceeds to capture the redemption date The calendar for selecting the date has been provided adjacent to Date of Redemption field Click on the icon a calendar in order to open the As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions The user is restricted from capturing the date of transaction as prior to the first purchase transaction date of the fund scheme The system puts an additional check on the user from capturing a future transaction date Step 10 In the next field the user needs to capture the NAV at which the fund scheme was redeemed Step 11 Th
171. f stock corporate actions Market value Market value is the product of the market price and Display quantity only The market price will be as received from external data vendors TR ORACLE 3 4 7 Field Description Mandatory of Total This is the percentage composition of the market Display value of a security in an industry as compared to the only total market value of all the securities in the industry Please note the values are computed in the customer preferred currency This section displays the details at Customer level across all portfolio holdings grouped by Industry Only the instruments of Asset Class EQ are considered and are displayed in this section Since CASA and TD instruments are not classified as Asset Class Equity and they represents some appropriate Asset Class like Cash or Liquid etc these Instrument types are not displayed in this section At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency View Portfolio Analysis By Market Capitalization Screen Market Capitakzation Rucha 5 Chart Figure 3 36 Portfolio Analysis By Market Capitalization Screen Screen Navigation To view the analysis for Market Capitalization please ensure that the Market Capitalization option has been selected from the Category drop down list The first table on the left side displays the analysis for th
172. f the goals linked 3 129 ORACLE Field Description Mandatory Shortage Surplus Displays shortage surplus for the selected Y goals in current year with respect to the portfolios they are linked Goals to Portfolio Tracking Goal Years Portfolio Name Displays the name of the portfolio to which goal s are linked Goals Tracked Displays all the goals linked to the portfolio Y Year Displays the year in which the linked goal occurs Cumulative Goal Value Displays the sum total of all CURRENT Y YEAR GOAL VALUES of the goals linked Cumulative Value of Displays the sum total of all the goals Y Goals Maturing this maturing in year mentioned under Year year column Projected Portfolio Displays the portfolio values projected to the Y Value goal year Shortage Surplus Displays the shortage surplus for the Y selected goals in current year with respect to the portfolio they are linked 3 130 ORACLE 4 Investment Performance Management This module includes the following capabilities e Multi level ROR performance across investment products e Benchmark Performance for Regular Composite Benchmarks e Risk adjusted returns Dr aticiiaics Screens are available to the bank only if the bank s license entitles the user to Investment Performance Management module reter to the Investment Performance Management user manual for complete details of Performance Management featu
173. fit Loss Profit Loss of Total Asset Class Region Currency Industry Market Capitalization Market Value of Total 3 The user can view the details in the first table based on the selection For example if customer has selected View by portfolio for self in overall portfolio user will be able to view all the portfolios and their respective currency buy cost market value of total profit loss Indicator profit loss This table will display the aggregated value at portfolio level 4 Adjacent to the first table is a tab displaying the graphical depiction of the type of view user have selected The user has been provided with the flexibility to view the graph either as a pie chart or as a bar chart This can be done by selecting the appropriate type of graph from the drop box provided in this tab In the bar chart the y axis represents the of total i e composition of a portfolio in comparison to the total composition of the customer s holdings across all his portfolios This is arrived at by calculating the portfolio values in the customer preferred currency The x axis represents the names of the various portfolio held by the customer aoe ORACLE Buy Price QTY and Market Price columns remains blank for CASA and TD instrument types Every access of the screen through the main menu will result in renewal of the analysis with the current market price of the securities Understanding the screen The system facil
174. folios in the drop down list to select the one from it and in addition also provides the option to select the new folio using the select option of the drop down list Hence the user can choose either the existing folio or invest in a new folio If there are multiple folio s available for the same issuer then the system defaults the folio to the omnibus if applicable and depending on the Omnibus client level flag else defaults it to the first available folio Every order initiated through the FCPB will have a unique transaction id associated to it The id would be generated for every customer portfolio order combination FCPB assumes that this identification would be a common interfacing attribute between the external system and the FCPB FCPB assumes that the fund house would generate a separate folio number for every customer portfolio combination Hence investments made by the same customer into the same fund but in different portfolios would be issued with two separate folio numbers by the fund house Othe FCPB would update the folio number as received from the fund house against each order id Hence multiple orders associated with the same folio number would be clubbed by FCPB to display the net outcome FCPB assumes that the folio number attained for a holding in the FCPB would not be utilized by the customer to make any transactions outside the FCPB system am ORACLE On selecting the fund scheme name the currency and t
175. frequency and Commencement date are mandatory fields to be captured by the user on opting for SWP redemption The user will be restricted from initiating an SWP instruction for a date earlier than the current business date If the Frequency is selected as Weekly in SWP pop up of Product Master with few days mentioned in the select box and if the Investment Dates have not been specified then while placing the order if the user selects the date month or year which does not fall on the one of the specified days of Product Master then system display an appropriate an error message Similarly an error message will be displayed if the selected date does not fall on the Investments dates specified in the Product Master Please note that once the instruction is initiated by the user the fund house does not require any further instructions from the user to execute the forthcoming SWP instructions However FCPB would receive updates on the revised quantity of units from the fund house after execution of every SWP instruction The calendar for selecting the date has been provided adjacent to the Commencement Date field Click on the icon a in order to open the calendar and select the suitable date Also based on the Commencement date and No of transfers the system auto populates the SWP End Date ae ORACLE Step 9 The next field tenure is also associated only with SWP redemptions and is enabled on selection of the SWP option It is man
176. gh the Portfolio Maintenance screen it displays the existing alerts of the selected customer with Instrument Price as the default tab In this case system displays the same instrument name in the Instrument Name field as in the Portfolio Maintenance screen whose market price was clicked The fields displayed in the tab have been inscribed in the table below Field Description Mandatory Alert Type Enables the user to track the instrument price in terms of Y percentage and amount by using the appropriate option from the Alert Type drop down list Instrument Enables the user to select the appropriate instrument Y Name name using the search icon for which alert is to be set Price Enables the user to select the appropriate option from the Y Percentage list to set the alerts The alerts can be set for increase or decrease in price percentage Last Traded Once the user selects the instrument name the system Y Price auto populates the last traded price for that instrument Delivery Mode Enables the user to select the appropriate delivery mode Y for Instrument Price alerts Applicability Enables the user to select the appropriate recipients for Y the alerts using the option from the drop down list oe ORACLE 3 7 Reminder The last and final tab of Portfolio Alerts is Reminder For Reminder alert in view table Expiry column details would be displayed blank Instrument Price J Reminder
177. gnated authorities to place an order when the risk profile of the client is not updated and the approval is valid only for a day Any order placed from customer login will display an order confirmation screen If the restrictions are found while placing the order system does not allow the user to place the order and displays an appropriate error message using the exception framework These restrictions are validated only for Buy and SIP orders 5 2 1 Equity Order Capture User Access Levels Customer Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Wr we ORACLE Screen User Tulika Verma Current Login 01 02 2013 3 20 PM y Order Mgmt Home Portfolio Txn Management Order Mgmt Tools Reports My Workspace Logout Order Mgmt gt Equity gt Order Capture Custome iv Security Details Equity Test 99 YA Q d Tam Sheet Order Details Account Details Submit Clear FLEXCLBE PRIVATE BANKING Equty 2 Local intranet Figure 5 1 Equity Order Capture Screen Screen Navigation Entry to the screen Option 1 Select the Order Management option on the main menu gt Equity gt
178. h which the user had initiated the order The reverse rule will be applied for a buy instruction Cancelled The orders associated with the Day time condition and which fail to get executed will be automatically cancelled by the trading system at the close of business Day Such orders will be denoted as Expired by the trading system However in the event of failure to receive the status information from the trading system the FCPB at the close of business hours will automatically cancel all the open orders and update the status as cancelled ice ORACLE The orders which are cancelled by the user will also be displayed as cancelled Rejected The orders which are cancelled by the broker exchange due to inaccuracy in the order instruction will be displayed as rejected Similar to the status Expired on change of status of a sell order to cancelled or rejected the system will add back the corresponding quantity to the balance quantity of the security or will negate the balance quantity by the corresponding quantity for a buy instruction Executed Orders which are successfully executed will be displayed as Executed Partially Executed The status of the order is displayed as partially executed when a portion of the order is executed but not all of the order Open All the orders initiated in the system and which are yet to undergo any of the above mentioned status change will all be displayed as
179. he Customer Rate text box By default the system displays Treasury rate Spread for buy orders and Treasury rate Spread for sell orders The system also displays the spread value as maintained and recomputes the same as and when the Customer Rate Treasury Rate are modified In addition the system displays the Amount Customer Rate In Terms Currency Fees In Terms Currency Total Amount Revenue In Terms Currency and Revenue In Base Currency Step 13 Select the appropriate Counterparty using Search Icon and enter the appropriate ref no in the Counterparty Ref No text box Step 14 Enter the description if any in the Description text box Step 15 Select the appropriate account from the Debit Account drop down list Step 16 Select the appropriate account from the Credit Account drop down list Step 17 Enter the comments if any in the Comments text box Step 18 Click on the Submit button 5 141 ORACLE Once the user clicks on the Submit button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 5 12 2 Transaction
180. he current NAV of the scheme will be displayed in the corresponding Currency and NAV fields in the order screen Step 9 The next field is the amount field If the payment option is selected as Regular the system validates the amount with the minimum maximum subscription limit rule established for the particular fund scheme These subscription limits are maintained by the administrator in the MF Instrument Master table in the database Once the user enters the amount the system populates the data in the following fields as per the Fee structure set up for the Client Segment and IAG combination e Indicative Total Investment For Regular payment option the values for Amount and Indicative Total Investment are same but for SIP the Indicative Total Investment is obtained by multiplying the value in the Amount field with no of transfers The system validates the amount entered here against the amount set up in the Maximum Amount for Buy field of Product Master if any If it is greater than the value set up at product master system displays an appropriate error message In case of SIP order the system validates the amount entered in the Invested Amount field against the amount set up in the Maximum Amount field of SIP Details pop up of Product Master If it is greater than the value set up in the Product Master system displays an appropriate error message e Transaction fee including taxes and surcharge The value in
181. he equity instrument type as described in the only previous table Market value Market value is the product of the market price Display and quantity only of Total This is the percentage composition of the Display market value of a security in a region as only compared to the total market value of the region The values are computed in the customer preferred currency 3 91 ORACLE 3 4 5 Units field remains blank for all amount based instruments types like CASA and TD At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency View Portfolio Analysis By Currency Screen ORACLE Portato gt Analysis Figure 3 34 Portfolio Analysis By Currency Screen Screen Navigation To view the analysis for Currency please ensure that the Currency option has been selected from the Category drop down list The second tab on the left side displays the analysis for the holdings across different currencies for the selected customer The holdings span across all his her portfolios The different currencies are maintained by the administrator in the Reference Master Table Now when the Currency option is selected for analysis all the holdings of the customer get organized in accordance to the different currencies Note that values are however displayed in the customer preferred currency 1 The tab adjacent to the second tab displays the graphi
182. he market value of the holdings in pharmaceutical industry with the total market value of the holdings across all the industries The screen shot of the tab Exposure is as given below Screen ERD Instrument ETD Instrument Price Exposure Figure 3 45 Portfolio Alerts Exposure Screen The various fields displayed in this tab have been elucidated in the table given below Field Description Mandatory ee ORACLE Field Description Mandatory Exposure Type There are two selectable fields provided for opting forthe Y exposure type The first field enables to opt for the various dimensions of holdings The list of values displays industry currency region market capitalization and instrument These values will be displayed as drop down list On opting for a particular dimension the list of values in the adjacent field will get updated to display the corresponding subordinate dimensions However the subordinate dimensions so displayed will encompass across the current holdings of the customer In other words only those subordinate dimensions in which the customer has holdings will be displayed in this field All the values will be displayed as a drop down list for the customer to opt Exposure This field is analogous to the one described for the tab Y Portfolio This field captures the trigger criteria for the opted category and type of exposure There are two field displayed ag
183. he system will consider the preceding received price for the function of valuation and analysis The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation The Market Price is hyperlinked on click of which the system directs the user to Portfolio Alerts screen to set up the alerts as per requirement Accrued Interest It displays the accrued interest for the Display only instrument Market Value Market value is the product of the market Display only price and quantity Commitment Commitment Amount field is applicable for Display only Amount Structured Products which are of Payment Type Installment Based and it indicates the Commitment Amount that the investor has committed towards the fund Value Date Displays the valuation date of the market Display only value 3 44 ORACLE Field Description Mandatory Quick Launch This field displays the links to Buy Sell and CA The links are available for all One Time Structured Products and also for Installment Based Structured Products which are of On Call Drawdown Type On selection of any of the above links system takes you to the corresponding screens with pre filled information of the selected security The
184. he user to place the Sell transaction only for those instruments for which the customer has holdings ae ORACLE 5 9 2 Transaction Processing for Commodities BSricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Alternative Investments Module of FCPB The Commodities category under Transaction Management is used to enter the post trade entries for instrument type Commodities User Access levels Customer Can capture the commodities holdings for his her available portfolio created either by the customer or by the RM There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios Screen Figure 5 29 Commodities Transaction Management Screen Screen Navigation After logging into the system select Transaction Management gt Commodities Field Description Mandator y Customer Details Customer No Displays the Customer No field Customer Name Displays the Customer Name SER ORACLE Field Description Mandator y Portfolio Name Displays the list of the portfolio names for the Y customer Instrument Details Instrument Name Enables the user to select the appropriate instrument name by clicking on the search icon available next to the Instrument Name field Instrument Currency Disp
185. holdings in the Display equity amp debt asset class as described in the previous only table and in the section on asset class analysis For the indirect holding in other securities under the other asset classes the holdings are not displayed Market value Market value is the product of the market price and Display quantity only of Total This is the percentage composition of the market Display value of a security in a currency as compared to the only total market value across all the holdings in that currency Please note the values are computed in the customer preferred currency Units field remains blank for CASA and TD instrument types At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency 3 4 6 View Portfo io Analysis By Industry oe ORACLE Screen Figure 3 35 Portfolio Analysis By Industry Screen Screen Navigation To view the analysis for Industry please ensure that the Industry option has been selected from the Category drop down list of views The first table on the left side displays the analysis for the different industries for the selected customer As we understand the industry analysis is applicable only to the holdings in equity instrument type which includes both direct and indirect holdings across all the portfolios The different industries to be used by the bank are identified and maintained by the adminis
186. holdings of the Display selected customer span across are displayed Each only industry is displayed with a hyperlink Click on the hyperlink to view a tab displaying additional analysis of all the securities in the selected industry Market value This is computed as mentioned in the Asset class Display analysis However only the securities within the only category of equity instrument type are considered for computation of Total This is the percentage composition of the industry Display under consideration with respect to the total value of only all the industries The sum of the percentages across all the industries would sum up to 100 At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency As explained earlier on clicking any of the industry in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected industry Industry Details Field Description Mandatory Name Displays the names of all the securities in equity Display direct and indirect in the selected industry only Currency The currency of the security displayed is as captured Display in the instrument master table in the database only Units Units are computed for the indirect holdings as Display described in the previous table only In case of direct holdings the units include the purchased and additional units received on account o
187. ial public offering a privately held company offers shares in the company through the equity markets for the first time This is often referred to as taking a company public Seasoned Offering A company offers additional shares to investors after the initial public offering This is called a seasoned offering because shares of the company have been listed on an exchange and have been trading for some time IPOs and seasoned offerings are referred to as primary market transactions because companies sell stock directly to investors FCPB currently does support for purchasing securities through IPO Secondary Market Transactions Investor to investor Transactions The third type of equity market transaction is the sale of a company s stock by one investor to another The company does not receive or pay any money in this transaction so it is often referred to as a secondary market transaction For example if one investor sells 100 shares of General Motors stock to another investor through an exchange it is considered a secondary market transaction and has no effect on General Motors balance sheet There are various methods of buying stocks in the secondary market The most common means is through a stock broker Most trades are actually done through brokers listed with a stock exchange There are several markets or exchanges to buy and sell equity securities A company s stock must be accepted for trading or listed on a particula
188. iate name DOB If the user selects the Same as Customer option above Y then system populates the DOB field If the Other option is selected enables the user to enter the appropriate DOB Height Enables the user to enter the height in the Height text Y box 5 63 ORACLE Field Description Mandatory Weight Enables the user to enter the weight in the Weight text Y box Annual Income Enables the user to enter the customer annual income in the Annual Income text box Medical Checkup reqd Enables the user to select the appropriate option for Y the Medical Checkup reqd field by using the radio button Order Details Application No Enables the user to enter the Application No Y Sum Insured Enables the user to enter the appropriate amount in Y the Sum Insured field Premium Amount Enables the user to enter the appropriate amount in Y the Premium Amount field Premium Frequency Enables the user to enter the appropriate frequency for Y the premium amount The options available are Annually Monthly Quarterly Semi Annually and Single Premium Transaction Fee Displays the total fee applicable if any for the selected customer Total Amount Displays the user to enter the appropriate total amount Premium Paying Enables the user to enter the appropriate premium Y Period paying period Coverage Period Enables the user to enter the appropriate coverage Y period Additional
189. ice The surrender value would be considered as market price for the securities under the instrument type insurance In the absence of market price for the securities requiring market price to be manually updated the system considers the acquisition price as the market price 3 67 ORACLE Field Description Mandatory of Total Percentage composition of the portfolio under consideration with respect to all the portfolios This figure is computed as Market value of the portfolio under consideration in customer preferred currency total market value of all the portfolios in customer preferred currency The sum of the percentages across all the portfolios would sum up to 100 Display only Profit Loss Profit loss at the portfolio level is again the sum of the profit loss of all the securities across all instrument types in the portfolio in the portfolio currency The profit loss at the security level is computed as the difference between the Market value and the buy cost market value and buy cost are computed as explained above Loss figures are displayed in RED color and are prefixed with a minus sign Display only Profit Loss The of the above computed profit loss is displayed here This is computed by dividing the profit loss by the buy cost and then multiplying it by 100 Loss is also displayed in RED color and are prefixed with a minus sign
190. if no held away portfolio is found system should display an error message stating No preferred portfolio exists for Held away portfolio type Step 5 After entering all the fields in accordance to the outline given in the above steps the user can Add proceed to click on the Add button If the user changes the decision on the details entered he she can clear the entire details f is Clear captured earlier by clicking on the button To modify the details that are entered select the Radio button from the View Section for the M record to be modified and then click on the Modify button aan ORACLE 6 1 6 Reports Introduction Apart from providing on screen views and analysis FLEXCUBE Private Banking also generates industry standard reports covering the customer s individual portfolio and also household portfolio Summary reports showing the overall Net worth Holdings exposure analyses and returns as well as detailed reports covering in addition to the above the details of transactions corporate actions and tax classification of gains for a defined date range are also provided Transaction reports provide details of transactions under each portfolio for various user defined criteria The system will provide for on demand and also end of day batch report generation Reports can be generated for a date or for a historical range applying various filters in PDF and excel format as applicable Description Cu
191. ing this button This button will lead you back to the first screen of the Simulator Field Description Mandatory Portfolio The dropdown list displays all the portfolios of the Yes customer including those which are without any holdings Instrument Type All the instrument types as defined in the Reference Yes Table of the database are displayed in the drop down list Name This field will be converted into a display field on Yes selection of the instrument types equity mutual fund bonds insurance commodity or structured product For the securities under such instrument types the field will display the name of the security acquired by means of the look up button displayed adjacent to this field For the securities classified under the instrument type others PMS CASA TD amp specialized product this field will be changed into a user enterable field eae ORACLE Field Description Mandatory Look Up Based on the instrument type selected by the user the search button will be enabled or disabled On clicking the look up button a pop up window will appear This pop up window aids in searching the securities under the selected instrument type The detailed explanation of this security look up screen can be obtained from the section on Miscellaneous functionality N A Units To recap market value is the product of quantity and market price FCPB provides you the flexibility to si
192. inize the impact of the changes on the holdings This button leads you back to the screen1 displaying the analysis of the entire holdings which is inclusive of the simulated holdings Thus allowing you to gauge the impact of the simulations on the various analysis dimensions and evaluate with the model portfolio After analyzing the simulated holdings if you revisit the simulator screen again by clicking on the Simulate button you will be displayed with the entire holdings inclusive of the earlier simulated values This provides the user with the benefit of executing multiple levels of simulations simultaneously by moving to and forth between the two screens In order to simulate the holdings afresh the user needs to access the screen 1 again through the main menu Print The user can also view the Simulator report by clicking on the button The simulator report shows the details of the transactions of the simulated portfolio along with its STCG and LTCG at run time It also gives the breakup of the simulated portfolio based on Asset Class Market Cap and Top 10 Industries Exposure The system does provide with the option to save the simulated holdings Hence on every access of the main screen screen1 through the main menu the system will refresh the screen and display the analysis based on the actual holdings of the customer Please note that user can simulate holdings even if he currently does not has any investment nor has any h
193. instrument analytics details by clicking on the Analytics icon a ORACLE 2 7 Field Description Mandatory Y N Portfolio Displays the weighted average returns of the Weighted portfolio for the corresponding time period Average Returns If the returns are not available for any model portfolio constituents the system displays NA This will happen in case when a new instrument is added to the portfolio which is just 3 months old For such instrument the returns columns beyond 3 months will display NA on performance computation Also weighted average return of the portfolio displays NA if all the instruments in the portfolio do not have the complete price details In case of bonds that are a part of the portfolio the coupon rate is used to compute the returns However if the bonds are zero coupon bonds the system does not compute any returns and displays NA Also if a bonus is issued for an equity share while calculating the returns the system adjusts the price based on all the bonus ratios of the past Customer Risk Profiler Description The Risk Profiler screen under the Tools menu enables the user to do the Risk Profiling of the customer Based on the Client Segment and Client IT Type the system displays the particular set of questions and depending on the feedback received from the client it allocates the particular risk score to the customer After filling in the questionnaire
194. intenance screen The Portfolio Maintenance screen displays the Market Price with a hyperlink for various instrument types The system navigates the user to the Portfolio Alerts screen by clicking on this hyperlink The alerts screen accessed in such a manner is defaulted to the Instrument Price tab How to read the screen 1 The screen displays two sections when you arrive at the screen The first section is the display section displaying the list of all the existing alerts which are currently in force The alerts will be displayed in the descending order of their expiry i e the alert which is likely to expire earliest will be displayed at the top This section also displays the type of alert and the criteria for triggering the alert The user can select an alert by clicking on the radio button provided against the corresponding alert ee ORACLE 2 The second section has been embedded with multiple tabs Currently the system facilitates the users to set up the following categories of alerts namely Portfolio Instrument and Exposure Instrument price and Reminder alert Each of the multiple sub tabs facilitates in defining a particular alert category In other words the user can set up alerts for the various categories by picking the corresponding sub tab On accessing the screen the user will be defaulted to the first sub tab Portfolio On selection of any of the existing alerts depending on the type of alert the corresponding sub
195. io of the selected customer For multiple sale orders initiated on the same business day for a particular security within a portfolio for a customer under consideration the balance quantity is construed by considering both the current holding of the customer as well as the quantities against the orders which are in open status All the orders initiated by the users are said to be in open status till the moment they are transformed into any other status The different order statuses are discussed in the next section a ORACLE For Example e Total Holding 1000 shares Sale Transaction Ordered 100 Executed 10 Holding 1000 10 990 Balance qty available for initiating sale Holding open qty 990 90 900 e Total Holding 1000 shares Step 8 Sale Transaction Ordered 100 Executed 10 Cancelled 90 Holding 1000 10 990 There are no orders in open status and hence the entire 990 is available to the user to initiate a sale transaction FCPB allows users to enter orders with various conditions attached to them as per their requirements The conditions are broadly divided into Time conditions quantity conditions and price conditions Several combinations of the above are allowed thereby providing flexibility to users The price conditions provided as a drop down list in the order type field are summarized below Market Order Market orders are orders for which price is specified as Mk
196. ion FCPB permits the user to maintain and generate analysis and reports in a third currency the customer currency At the customer level all the transaction amounts denominated in the security s currency are converted to the customer currency using a currency exchange rate This customer currency must be specified at the time the customer is created Please note that the closing exchange rate s on the corresponding transaction dates is used for converting the transactions into their corresponding values in the portfolio and customer currency However the Market values displayed in the portfolio and customer currency across all the portfolio maintenance analysis simulation screens are computed and displayed utilizing the online exchange rate User Access Levels Customer can add and modify only the Held Away and Self Managed portfolios but can view other portfolios a ORACLE 3 2 1 Portfolio Creation Screen CL Figure 3 1 Portfolio Creation Screen Screen Navigation 1 After you login the portfolio creation screen can be accessed through the Portfolio and Maintenance sub menu 2 Click onthe Add Portfolio button in the Portfolio Maintenance screen Entering the details of the portfolio creation screen As seen the screen is dividend under three main categories Portfolio addition joint holder details and nomination While some of the attributes for instance the benchmark can be changed while maintaining a portf
197. ion Enables the user to enter the transaction details if any in the Description text box It is a free text box and allows the user to enter maximum 250 characters Security Account Enables the user to select the appropriate Security Y Account from the drop down list Procedure for Capturing a Transaction Step 1 Customer For a customer login the Portfolio Name defaults to the portfolios Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 The subsequent step is to select the Bond The user can select the Bond either by directly ra entering the name of the bond or by searching for the bond by clicking the button The bond search screen displays only the schemes which are in open status On selecting the bond the currency of the bond will be displayed in the corresponding field Instrument Currency in the screen The system also displays the Settlement currency Cap Factor on selection of the scheme Please note the system does not aggregate multiple purchases into the holding Hence any additional purchases need to be captured as separate security holding or first time purchase oat ORACLE Next to the Bond Name field a check box has been provided in order to distinguish traded bonds The user needs to check the box for all the traded bonds Step 4 The
198. ional check on the user from capturing a future transaction date Step 10 In the next step the user needs to capture the units of holding It is mandatory for the user to capture information in this field Step 11 In the next field the user needs to capture the NAV at which the fund scheme was purchased Once the NAV is entered the system calculates the amount and displays it in the Amount field Step 12 Enter the appropriate transaction fee in the Fee text box oes ORACLE Step 13 The next field Taxes amp Surcharges has been provided to capture the tax paid for obtaining the holding Step 14 Select the appropriate Counterparty name using the search icon If the user enters the Counterparty name the Counterparty Ref No is a mandatory field else the system gives the error message Step 15 Enter the appropriate ref no in the Counterparty Ref No text box If the user enters the Counterparty Ref No the Counterparty name is a mandatory field else the system gives the error message Step 16 Enter the transaction details if any in the Description text box The user is allowed to enter the details upto 250 characters If the entered details exceed 250 characters system displays the message as Description cannot exceed 250 characters Step 17 After entering all the fields in accordance to the outline given in the above steps the user can proceed to click on the save Ghai with a confirmation m
199. iption Mandatory Booking Date The creation date of the deposit is displayed in Display this field only Tenor The tenor of the deposit denoted in days is Display represented in this field only Principal The original amount invested in the deposit is Display displayed in this field only Maturity Date The maturity date indicating when the customer Display will get his principal back is displayed in this field only Interest Rate The effective rate received on the invested Display amount is displayed here only Accrued Interest This field indicates the interest till date that has Display been earned but not received by the customer only Interest Paid The interest that has been paid by the bank or Display received by the customer till date is displayed in only this field As on Date Indicates the latest date of reception of the Display account balance only Quick Launch This field displays the CA link The links are Hyperlink available for all the securities in this tab The link CA directs the user to Corporate Action screen to post the interest payment transactions At the end of the tab the last row displays the sum of all the above fields in the portfolio preferred currency DCD Maturity Screen Navigation RM Login gt Customer gt Portfolio Maintenance gt TD Instrument Type gt DCD Maturity Quick Launch 3 3 12 Futures A future contract is an agreement between t
200. isplayed in a view table Details such as TD number Inception date Maturity date and interest rate compounding frequency principal value interest accrued and paid Last interest paid date will be shown Interest accruals will be calculated in FCPBS on a daily basis However the actual interest paid to the customer will be a data field received from the core banking system which will be stored in the Interest Dividend field Interest paid on any partial amp premature withdrawal will also be received as a data field from the core banking system Accrued interest will also be received from the Core Banking System The TD transactions will be uploaded as a batch considering previous day transactions Screen Aime Deposit RM Managed Maturity Interest Accrued Interest Account Type Account TD No CCY Booking Date Tenor Principal Date Rate Bat Paid AsonDate Quick Launch TD INR TD INRO 1042013 Total INR 12 000 000 0 000 0 000 Figure 3 21 TD Screen Field Description Mandatory Account Type Displays the name of the Time Deposit Y instrument If the TD is of type Dual Currency the instrument name is concatenated with the text DCD Account TD No As the name suggests this field displays the Display Term Deposit account number Please note that only each TD will be represented separately in this tab CCY This field displays the currency of the deposit Display only ee ORACLE Field Descr
201. isplays the bank accounts concatenated with the corresponding bank currency If the instrument currency settlement currency and bank account currency are different and post FX rate conversion if the bank account does not have sufficient funds to process the order the system displays an appropriate error message on submission of the order If the selected portfolio is of type Discretionary the system defaults the Bank Account drop down list to the bank account no attached to it at the time of portfolio creation FCPB assumes that the trading account utilized for transacting through FCPB would not be employed by the customer to make any transactions outside the FCPB system ve ORACLE Step 15 After entering all the fields in accordance to the outline given in the above steps the user can proceed to click on the Submit S t button Once the user clicks on the Save button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation e Trigger Price more less than x of the LTP where x is the no which is configurable e Bank A C CCY and Settlement CCY are different e Not enough balance to place the order e Instrument Restriction for client country of domicile FLEXCUB
202. itates to analyze the holdings across all the portfolios Portfolios which currently do not have any holdings will not be displayed in the screen If the customer does not have any holdings across any of the portfolios then the system will display blank tabs This system behaviour is applicable to all the screens under Portfolio submenu PORTFOLIO Field Description Mandatory Portfolio All the portfolios of the selected customer are Display displayed Each of the portfolios is displayed only with a hyperlink Click on the hyperlink to view a tab which displays the analysis of all the securities in the portfolio The details of this tab have been detailed later in this section Currency All the figures associated to the portfolio are Display displayed in the portfolio currency For all the only securities in the portfolio the system converts and stores all the transaction amounts from the security currency to the portfolio currency Buy Cost This is the sum of the buy costs of all the Display securities across all the instrument types in the only portfolio denominated in the portfolio currency Market value Similar to the buy cost the market value at the Display portfolio level represent the sum of the market only values for all the securities across all the instrument types in the portfolio denominated in the portfolio currency Market value at the security level is computed as a product of quantity and market pr
203. ity name and currency get displayed in the subsequent Security Name Currency Settlement Currency Last Traded Price Security Sub Type Holding Quantity and Custody Fee fields in the order screen Step 5 A company may have its stock listed on more than one exchange Hence on selecting the security all the exchanges in which the security is listed are displayed in the drop down list The user has to decide on the exchange before proceeding with entering the order particulars The information of the exchanges in which the security is listed is updated by the administrator in the Instrument Exchange reference table Step 6 Select the appropriate Settlement Date using the calendar icon If the Settlement Date falls on the currency holiday then the system gives the appropriate error messages and auto rollover the date to next valid business date while for system and exchange holidays the system gives the appropriate warning messages enabling the user to proceed further The system validates Order Capture screens of all Instrument types for Trade and Settlement Dates and displays the appropriate messages Step 7 The primary step in initiating an order is to opt for a type of transaction The user can place either the bid ask buy sell order While there is no restriction on the buy transaction the sell transaction is restricted to the extent of balance quantity available for the security in the portfol
204. ket index or it can be even more exotic The name coupon originates from the fact that in the past physical bonds were issued with coupons attached to them On coupon dates the bond holder would give the coupon to a bank in exchange for the interest payment Types of Coupon Bonds pay interest that can be fixed floating or payable at maturity Most debt securities carry an interest rate that stays fixed until maturity and is a percentage of the face principal amount Typically investors receive interest payments semiannually For example a 1 000 bond with an 8 interest rate will pay investors 80 a year in payments of 40 every six months When the bond matures investors receive the full face amount of the bond 1 000 m ORACLE But some sellers and buyers of debt securities prefer having an interest rate that is adjustable and more closely tracks prevailing market rates The interest rate on a floating rate bond is reset periodically in line with changes in a base interest rate index such as the rate on Treasury bills Some bonds have no periodic interest payments Instead the investor receives one payment at maturity that is equal to the purchase price principal plus the total interest earned compounded semiannually at the original interest rate Known as zero coupon bonds they are sold at a substantial discount from their face amount For example a bond with a face amount of 20 000 maturing in 20 years might be purchas
205. l by the system e Indirect With the exception of securities under the asset class equity amp debt for the securities under the other asset classes the holdings composition denominated as number of units will be defaulted to null In case of equity the number of units held in each security will be computed based on the percentage composition of each security as provided in the fact sheet Under the equity asset class for a security of the same class the indirect holdings of the customer would be combined with the direct holdings if any Display only me ORACLE Field Description Mandatory Let us understand how to calculate the market value at the asset level The market value at the asset level represents the sum of the market values for all the direct and indirect held securities in the particular asset denominated in the customer preferred currency For the securities held as direct holdings and falling under the asset type equity and traded bonds the market price will be as received from external data vendors For the other securities under the asset class insurance others metals gems real estate and non traded bonds the price will be as per the last manual update Analogous to the direct holdings the indirect holdings in equity and traded bonds will also receive price feeds from the external data vendors However for the other indirect holdings falling under the asset
206. lass the Multi Dimensional Model pop up appears as shown in the screenshot below This Multi dimensional model displays the recommended dimension wise allocation based on the selected asset class In addition it also displays the comparison between the actual vs recommended The system displays the Actual value of different dimensions based on the flag Asset Decomp flag maintained at bank parameters level The Multi dimensional icon is also displayed for Household and Group members 3 87 ORACLE Screen Multidimensional Model Windows Internet Explorer Multi Dimensional Model Asset Class Actual Recommended Deviation Equity 6 09 50 44 Instrument Analysis Group Actual Recommended Deviation Equity 40 20 PMS 0 40 MF Equity 0 30 30 SP 0 30 30 Instrument Type Recommended Deviation Equity 50 10 Mutual Fund 25 5 Structured Product 0 15 15 Bond 10 10 0 Region Actual Recommended Deviation North America 50 60 10 Asia 0 30 Europe 40 20 Currency Deviation USD 10 Euro 18 Singapore Dollar 18 0 18 Market Cap Actual Recommended Deviation Large Cap 100 60 40 Mid cap 40 40 Industry Actual Recommended Deviation 40 0 0 20 0 30 60 50 Done Internet Protected Mode On f Q 100 Figure 3 31 Portfolio Analysis Multi Dimensional pop u At the end of the tab the last row displays the sum of all the above fields in the customer pref
207. lays the instrument currency for the selected Y instrument name Once the Instrument Name is selected system auto populates this field Settlement Currency Displays the settlement currency for the selected Y instrument Measure Units Displays the measure of units for the selected Y instrument Once the Instrument Name is selected system auto populates this field Transaction Details Transaction Type Enables the user to select the appropriate transaction type from the drop down list Transaction Date Enables the user to select the appropriate Y transaction date using the calendar icon Settlement Date Enables the user to enter the appropriate N settlement date using the calendar icon Quantity Enables the user to enter the appropriate Y transaction quantity in the Quantity text box Price Units Enables the user to enter the appropriate price Y per unit for the selected instrument in the Price Unit text box Amount Displays the total transaction amount Once the Y user selects the Quantity and Price Unit fields system auto populates this field Fees Enables the user to enter the appropriate fee in N the Fees field Commission Enables the user to enter the amount paid as N commission in Commission field 5 116 ORACLE Field Description Mandator y Tax amp Other Enables the user to enter the amount paid as N Charges transaction tax in the Tax field Exchange Rate Enables the user to
208. lays the total buy cost obtained by Display multiplying Buy Price with Qty only Market Price Displays the last updated market price of the Display underlying security only Market Value Market value indicates the value of the Display constituent as of the given valuation date It is only calculated as Market Price Qty Value Date Indicates the latest date and time of reception of Display the market price feed only Action This field displays the links to Sell Buy Display only 3 3 10 Corpus Corpus refers to quantum of money brought in or taken out from the Portfolio by the client in the form of cash The investments are made by the client by utilizing the money already available in the portfolio and all the transactions are made through the discretionary portfolios Corpus Details Discretionary Name Corpus INR Total INR DP ID ccy Std CCY Total Buy Cost Market Value 10057 INR INR 80 416 67 80 416 67 Yalue Date 80 416 67 80 416 67 Note Buy price is calculated based on FIFO method Figure 3 19 Corpus Valuation Screen Field Description Mandato ry Name All the securities in the chosen instrument type Display Corpus and portfolio are displayed Each only security name in the tab is displayed with a hyperlink Click on the hyper link to view all the transaction executed in the security 3 53 ORACLE Field Description Mandato ry
209. ld Description Mandatory Asset Class All the segments of the market capital in which the equity holdings of the selected customer span across are displayed Display only Market Value Only the securities within the category of equity instrument type are considered for computation The market value is denominated in customer preferred currency Display only of total This is the percentage composition of the segment of market capital under consideration with respect to the total value of all the segments The sum of the percentages across all the segments would sum up to 100 Display only Screen 2 TAB 1 Displaying the Holdings Field Description Mandatory Selection Radio Button This button enables the user to opt for a particular holding On selecting the holding the corresponding data of the security gets displayed in the second tab in the screen This facilitates for the modification or deletion of the selected holding Gwhen the CASA TD or amount based instruments are selected for addition or modification the system enables the Amount option and disables the Units option in the lower maintenance section Display only Portfolio Name All the portfolios encompassing all the holdings of the selected customer are displayed Portfolios which do not have any holding are not displayed in this screen Display only Instrument type Displays the i
210. le for customer portfolio valuation The Todays Unit Price is hyperlinked on click of which the system directs the user to Portfolio Alerts screen to set up the alerts as per requirement Display only Accrued Interest This field displays the accrued interest for the bond Accrued interest is the interest that has accumulated since the principal investment or since the previous interest payment if there already exists one Display only Market value Market value is the product of the current unit price and quantity Display only 3 36 ORACLE To recap the hyperlink for updating the Corporate Action related data is available for RM Managed portfolios Once the user updates the holdings for a bond in FCPB system initiates the computation of the accrued interest for the current interest payment period At the end of the interest period the system automatically credits the accrued interest as realized interest All the earlier realized interest prior to the entry of the bond s holdings in the system needs to be captured by the user through the Corporate Action screen Through the link for sell the user can initiate multiple transactions for the particular security to the extent of its holdings On selection of any of the above links system takes you to the corresponding screens with pre filled information of the selected security On clicking the Buy Sell hyperlink the use
211. lier section ORACLE The system also provides the hyperlink to the Total Market Value on click of which following pop up window appears Screen r CANARA Total INR FLEXCUBE PRIVATE BANKING Portfolio Summary Popup Windows Internet Explorer l m Unrealized Average RAR Market Ke Unrealized Unrealized A Name InstCCY Account No Exchange Eir Cost Exchange Market Napa Gain Lossin Gain Loss due beers Loss due Rate rtfolio Rate wi Portfolio CCY to CCY Impact las ae Mac EQ INR 87 091 667 37 091 667 0 000 37 091 667 14 665 649 700 0 000 14 665 649 700 56 000 000 0 000 56 000 000 33 999 315 700 19 426 757 667 14 572 558 033 0 000 14 572 558 033 i 7 Figure 3 4 Gain Loss Summary in Portfolio Currency Pop up The pop up displays the acquisition cost market value and unrealized gain loss in portfolio currency In addition the system also provides the details of unrealized gain loss due to currency and price impacts As explained earlier on clicking the name of any of the portfolios of the customer in the earlier tab displays a tab representing a detailed valuation of the portfolio at the instrument level Field Description Mandatory Instrument Type All instrument types encompassing total Display holdings in the chosen portfolio of the customer only are displayed Each type of instrument in the tab has a hyper
212. link Click on the hyper link to view a tab displaying detailed valuation of all the securities in the selected instrument type The details of this tab have been detailed in the next table Amount The market value at the instrument level Display represents the sum of the market values of all only the securities in the particular instrument type denominated in the portfolio currency of Total It is the percentage composition of the type of Display instrument under consideration with respect to only the total value of all the instrument types Again at the end of the tab the last row displays the sum of all the above fields in the customer preferred currency computed as explained in the earlier section ore ORACLE 3 3 1 As explained earlier on clicking any of the instrument types in the earlier tab displays a tab representing a detailed valuation of all the securities in the selected instrument The attributes displayed in the table correspond to the type of instrument selected Please study through the subsequent tables to comprehend the valuation attributes associated with every instrument type Equity Equity represents ownership in a corporation and entitling the holder to a share of the company s success through dividends and or capital appreciation f Equity Details RM Managed Name DP ID cey Buy Price Qty Total Buy Cost std Market cey Price Market Value GOOGLE G21345 8G621345 l U
213. list The system defaults the account no based on the flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Security Account field Step 16 oe ORACLE Click the Save button On saving the holding you will be displayed with a confirmation message on the screen If you change your decision on updating the holding you have the option to clear the entire details l ie Clear captured earlier by clicking on the button 5 10 Futures 5 10 1 Order Management for Futures Futures Order Capture Please note that though this section of user manual explains order management and capabilities of Futures instrument type but these features of order management UI and processing would be available to the bank only ifthe bank s license entitles them to the Alternative Investments module and Order Management module User Access levels Customer can place orders for RM Managed and Self Managed portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen Figure 5 30 Futures Order Capture lee ORACLE Screen Navigation After logging in the system select Order Management
214. list select the appropriate option Step 15 From the Bank Account No drop down list select the appropriate option Step 16 Click the Submit button Once the user clicks on the Save button system displays the Exception pop up window if the order to be placed violates certain conditions such as akig ORACLE e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation e Trigger Price more less than x of the LTP where x is the no which is configurable e Spread deviated approval required The customer can self approve all the exceptions that occur in the order capture if the error levels are not 99999 Commodity Order Capture Sell User Access levels Customer For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Figure 5 28 Commodity Order Capture Screen Sell Screen Navigation Select the Order Management gt Commodity gt Commodity Order capture From the Transaction drop down list select the Sell option To place the Commodity Sell transaction follow the same procedure as explained in Commodity Order Capture Buy above The only difference here is that the user needs to select the transaction type as Sell from the Transaction Type drop down list The system allows t
215. lly Monthly Quarterly Semi Annually Single Premium Once the values in Sum Insured Premium Amount and Premium Frequency fields are entered system displays the fee applicable for the selected client for that particular instrument in the Transaction Fee text box Step 12 Enter the appropriate period in the Premium Paying Period text box see ORACLE Step 13 Enter the appropriate period in the Coverage Period text box white entering the Coverage Period remember that it has to be within the minimum and maximum Policy Tenor for the selected instrument Otherwise the system gives an error message Step 14 Enter the additional information if any in the Additional Information field Step 15 From the Payment Type drop down list select the appropriate option Step 16 From the Account No drop down list select the appropriate account no Step 17 Enter the appropriate MICR or Cheque No in the MICR Cheque No text box Step 18 To add the nominee details click the EP con at the bottom right side of the Nominee Details table ee ORACLE Once the user clicks on the EP con the Nominees window appears a Add Modify FLEXCUBE PRIVATE BANKING Microsoft Internet Explorer Nominees Customer number 10034 Customer Name nikita parekh Relationship Name DOB Relationship Share Figure 5 17 Nominees Window Enter the appropriate details and click the Add button Click the Save button to c
216. lly specified contingency Some policies have the flexibility of paying the entire premium amounts as a single upfront payment and are known as Single Premium policies This field is not applicable for single premium policies and will be displayed vacant However for all the other policies the field will display the next periodic payment due date Please note that it is the responsibility of the user to renew this data regularly in the system Annual Premium Displays the total premium amount paid annually Display For the single premium policies it is the only responsibility of the user to compute manually and update the relevant data Premium paid The total premium amount paid till date is Display displayed in this field only 3 39 ORACLE Field Description Mandatory Fund Value Displays the Fund Value for the selected ULIPs Display Unit Linked Insurance Plan only Surrender Value This is the cash value due to the policy holder if he Display terminates his her policy on the given date The only surrender value would be considered as market price for the purpose of valuation Analysis Simulation Only financial type of policies has Surrender Value Value Date Displays the valuation date of the surrender value Display only The system also displays the valuation time of the surrender value Quick Launch The column displays a hyperlink called Details On clicking this hyperlink the user ge
217. lose the Nominee window Adding nominee details is a mandatory field Step 19 Click the Save button Once the user clicks on the Save button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation e Insurance Analysis Done is not updated in the system ToB ORACLE Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 5 6 Structured Product 5 6 1 Order Management for Structured Products Please note that though this section of user manual explains order management and capabilities of Structured Products instrument type but these features of order management UI and processing would be available to the bank only if the bank s license entitles them to the Alternative Investments module and Order Management module Structured Products Order Capture Buy User Access Customer For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed vee ORACLE Screen 1 Onder capture n dasbied tor thn eatrement type for your sccowst oe FD D dima Figure 5 18 Structured Products Order Capture
218. ment Display only Market Value Market value is the product of the market price and quantity Display only Value Date Displays the valuation date of the market value The system also displays the valuation time of the market value Display only 3 48 ORACLE Field Description Mandatory Quick This field displays the links to Sell Buy The links are Launch available for all the securities in this tab On selection of any of the above links escorts you to the corresponding screens with pre filled information of the selected security The screens associated to these links have been explained in depth in the section on Transaction Management The action buttons will be disabled for a Customer viewing the securities held in a RM Managed Portfolio On clicking the Buy Sell hyperlink the user navigates to the Order management or Transaction management screen This depends on the way portfolio type maintenance has been set up 3 3 8 PMS Portfolio Management Services PMS are similar to Mutual Funds and offer customized solutions to the high net worth investors and invests on their behalf in both the equity and debt markets There are mainly two kinds of portfolio management services namely Discretionary Portfolio Management and Non discretionary Portfolio Management Discretionary Portfolio Management is where the fund manager has the liberty to invest the funds at his
219. mple In the condition field the user opts for lt and captures the value 15 in the percentage field Hence for the defined alert a performance of less than 15 will trigger the alert Y Delivery Mode The Private Banking offers its customers with flexibility to opt for various modes of receiving the alerts The user can either opt for email intimation or an alert on the dashboard or even opt for both All the three options are available to the user as list of values in the drop down field The email mode will however be displayed as a default value on accessing the screen Applicability Enables the user to select the appropriate recipients for the alerts using the option from the drop down list Instrument The second tab Instrument enables the user to define performance alerts at an instrument level The various fields displayed in this tab have been elucidated in the table given below Portfolio GID Exposure Instrument Price Reminder Veianen Instrument Performance Select Figure 3 44 Portfolio Alerts Instrument Screen Field Description Mandatory en ORACLE Instrument Name All the list of customers holdings across all his portfolios are Y displayed in this field However for a customer login the list will be restricted to the extent of his holdings in Self Managed and Held Away portfolio Portfolio Name On selection of a p
220. mulate with either of the constituents quantity or price of the market value There are two radio buttons in this tab one adjacent to this field and one adjoining the amount field Selection of either of the radio button flips the opposite field into disabled or display status In other words on selection of the radio button adjacent to this field and entering relevant the units triggers the system to compute the appropriate market value for the units and display it in the amount field Please note the system will compute the market value based on the current market price available Similarly on selection of the radio button adjacent to the amount field will alter the unit field into a display field However this principle of flipping the status of the two field s amount and units is available only for the securities under the instrument type Equity bonds structured product commodities and Mutual Fund This field will be disabled for all the securities under the other instrument types Yes Amount This price allows the user to simulate with the market price of the existing or new holdings As mentioned in the details for the preceding field this field has a radio button adjacent to it Contrast to the unit s field this field however is accessible for all the securities under all the types of instrument However for the securities under the instrument type Equity bonds structured product commodities and Mutual Fund
221. n ere ORACLE Screen Sake Figure 5 42 Bank A C and Loans Capture Procedure for Placing of a Bank A c or Loan Step 1 The customer shall select from the list of available Banking Products on selection of which the corresponding Banking Account Subtype shall get default listed Similarly the intended Bank Name and Currency is selected from the dropdown list Step 2 The branch name MICR and A C No Balance and As on Date fields are entered Account no is validated for duplicity If same a c no exist for any Bank ID for same customer system should display error message Record already exists for this A c no Customer should not be allowed to enter same account number even if the Bank Name is different for that same customer As on Date should not be Greater than System date Step 3 The following fields are entered in the banking product type is a term deposit Tenor In Days Booking Date Interest Rate Maturity Next Due date Step 4 Portfolio name is a display only field which gets populated for asset product types and is blank for liability type of products The A c status field is selected from the dropdown which by default shall be ACTIVE ne ORACLE the user sets the A C status to CLOSED and if Balance is greater than zero system should display an error message stating Balance greater than zero Please make the balance to zero to close this Account or external Bank accounts
222. n On saving the holding a confirmation message appears on the screen Clear To clear the entire details captured earlier by clicking on the button Bond Transaction Management Modify User Access levels Customer Can modify the non traded bond holdings for his her available portfolios ai ORACLE Screen FLEXCUBE PRIVATE BANKING Bonds Transacti fa gt B amp wm gt Pager Safet User Alok Nath Current Login 14 0 FLEXCUBE Private Banking Order Mgmt Home Portfolio Txn Management Order Mgmt Tools Reports My Workspace Logout Bonds Transaction Search Modify Customer Details Customer No 1007 omer Name Alok Nath Portfolio Name Heldaway Instrument Details Bond Name SW Corporate Bond Instrument Currency INR Settlement Currency INR Transaction Deatils Transaction Buy Settlement Type Receipt Free Transaction Date 10 01 2013 tlement Date 10 01 2013 Nominal Value 100000 Units 100 Net Traded Price Clean 120 Amount 120000 Commission 2 Fee 10 Exchange Rate Tax amp Other charges 1 Cap Factor 1 Counterparty Name F Counterparty Ref No 122547 Description 3 Account Details Security Account Save Clear Delete Figure 5 12 Bond Transaction Management Modify Screen Screen Navigation After logging in the system select Transaction Management gt Transaction Search Select the appropriate record and click on the modify hyperlink This
223. n order to interpret this screen However for thorough understanding of the computation methodologies of the fields please refer to the section on Portfolio Analysis for further details Actual Asset Allocation Field Description Mandatory Asset Class Asset class classification of holdings at customer or household level is displayed If the Asset Class Decomposition flag is set to Yes the Actual Asset Allocation tab displays the Asset Class values after considering sub constituent values The graph will also consider decomposed values If the flag is set to No the system does not consider decomposed values Display only oe ORACLE Field Description Mandatory Market Value Market value is the product of the market price and quantity The asset class type of analysis comprises of the direct investments and the indirect investments in the different asset classes The indirect investments are on account of the holdings in mutual funds PMS and structured products types of instrument constituents of mutual fund PMS and structured product Quantity e Direct In case of direct holdings for the securities under the asset class equity and bonds the units include the purchased and additional units received on account of stock corporate actions For the direct holdings under asset class like insurance metal real estate gems and others the units are defaulted to nul
224. nal 500 shares were purchased 3 06 The buy price using the weighted average price would now be computed as 200 x 2 54 500 x 3 06 700 Cash corporate actions dividend will not be considered while computing buy price The stock corporate actions viz bonus stock dividends are deemed to have been acquired on the record date and at a nil price The treatment for shares acquired under a rights issue is the same as for a bonus issue except that an allowance has to be made for the amount paid to acquire the additional shares 3 21 ORACLE Field Description Mandator y Qty As mentioned earlier the units will be calculated after the application of the FIFO accounting rule for each trading account In addition to the units purchased additional units received due to stock corporate actions will also be considered while determining the units The orders entered for purchase sale of securities through the FCPB Order Management System and which are in open status will not be considered while determining the quantity Display only Total Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only Market Price The market price for securities will be received as online update from external data vendors In a scenario where market price is not received updated in the system at end of day then system will consider the previous day
225. ned asset classes can be classified into the category others It is interesting to note that though the mutual funds Portfolio Management Schemes and structured products are itself classified into the asset category others the assets class of the underlying securities are considered for the purpose of portfolio analysis and simulation This table displays all the securities categorized under the instrument type others and asset class real estate art gems metals and others Display only Buy Price Buy price is the purchase price of the security The system defaults the units of the securities in the instrument type others to 1 The system does not currently support for capturing the additional purchase data Hence any such additional purchase transactions need to be captured as separate security holding or first time purchase Thus the concept of weighted average price and FIFO are not applicable Display only Market Value Market value is the current price of the security The latest market price updated by the user is displayed here Display only Value Date Displays the valuation date of the market value The system also displays the valuation time of the market value Display only 3 41 ORACLE Field Description Mandator y Quick This field displays the links to Modify Sell securities The The Launch links are available for all the securities in the ins
226. ned in General Characteristics section Once the user selects the Future ID following fields are automatically get populated e Futures Name e Expiry Date e Instrument Currency e Settlement Currency Step 4 Select the appropriate Counterparty using the search icon Step 5 From the Transaction drop down list select the appropriate transaction type There are two options available for Futures Transaction They are Buy and Sell By default Buy option is selected Step 6 From the Order Type drop down list select the appropriate order type If the user selects the Order Type as Stop Loss or Limit Order the Trigger price field is editable and user can enter the desired trigger price else system auto populates the appropriate trigger price Step 7 Enter the appropriate number in the No of Contracts text box ee ORACLE Once the user enters the number in No of Contracts field system auto populates the data in Quantity Price Amount and Margin Amount fields Step 8 Select the appropriate option from Time Condition drop down list Step 9 Select the appropriate DP ID from the DP ID drop down list Step 10 Select the appropriate account no from the Bank Account drop down list Step 11 Click on the Submit button Once the user clicks on the Submit button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List
227. nly the logged in customer can view his her own profile by accessing this screen ORACLE 2 3 Screen Figure 2 2 View Profile Screen for Customer Screen Navigation After logging in the system as Customer select My Workspace gt View Profile from the top menu RM Details Description The screen enables the user to view his her RM details In addition to this the screen also displays the details of Backup RM applicable if any User Access Levels Customer The customer can view the Primary RM and Back RM details by accessing this screen ORACLE 2 4 Screen Figure 2 3 RM Details Screen for Customer Screen Navigation After logging in the system as Customer select My Workspace gt RM Details Screen from the top menu The system displays the details like RM Name Email Phone Home Office Mobile Fax and Address in the screen In addition to this system also displays the RM photograph if available Voluntary Corporate Action Description The screen enables the user to fill the Corporate Action questionnaire responses if any Corporate Action questionnaire is pending When the CA is declared for any particular instrument the customers satisfying the criteria to fill the CA questionnaire receives a mail asking to login and answer the CA related questionnaire Once the customer makes his her choice and enters response he is not allowed to modify the responses again User Access Levels Customer
228. not in Portfolio B then equity appears as asset class but if customer does not have real estate in any of the portfolio then Real estate should not be displayed as asset class All the values should be displayed in Field Description Mandatory Asset Allocation Portfolio Name Displays all the portfolio name of the customer First row Yes has recommended asset allocation at customer level Asset Class Displays all the asset classes where customer has Yes ue ORACLE Field Description Mandatory Display Displays of asset class to total holding in that portfolio Suppose customer holding in Portfolio A is 10 000 and he has 5000 in equity 2000 in debt and 2000 in Insurance and 1000 in Gems then to be displayed will be Equity 50 Debt 20 Insurance 20 and Gems 10 under portfolio A Formula to be used will be Asset class holding total holding 100 Yes Geographical Exposure Region Displays all the region name where customer has holdings Yes Asset Class Displays all the asset class where customer has some holdings at customer level i e if customer has Equity holdings n Middle east but does not have debt in that region even than equity should be displayed but if customer does not have real estate holdings in any region then it should not be displayed Yes Display Displays of asset class to total holding in that region Suppose customer holding in Middle East is
229. nsaction Capture screen as shown in the screen above and save the details Once the user clicks on the Save button the transaction get saved and the system displays the message as Generic Instrument Transaction Saved Successfully Common Order Book User Access levels Customer The customer can view the status of the orders initiated for his her Portfolios 5 150 ORACLE Order 10 Perttoho ast mame Type tmtitame MST Orde onder Date Order ty Onler Price Order Amt Onder statue fat Figure 5 38 Common Order Book Screen Screen Navigation Entry to the screen 1 Select the Order Management option on the main menu gt Common Order Book How to Read the Screen 1 This order book displays the orders initiated for securities across all instrument types 2 The statuses of all the orders initiated are displayed in this screen On reaching the screen the user can view two sections The first section provides multiple filter alternatives to observe the order book and the second section displays all the orders for the selected criteria 3 The first tab provides the user with the multiple filter options which can be employed either as solo or in combinations with the other filter options in the screen This provides the user with flexibility while accessing the order book The information of these filter options are provided below e Instrument Type The user has the option to view all the orders initiated for
230. nsaction processing for Mutual Fund riase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Mutual Funds and Insurance Module of FCPB Mutual Fund Transaction Capture Subscription User Access levels Customer Can capture the Mutual Fund subscription holdings for portfolios created either by the customer or by the RM There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios aa ORACLE Screen WOVSa Figure 5 7 Mutual Fund Transaction Capture Subscription Screen Screen Navigation After logging into the system select Transaction Management gt Mutual Fund The screen will default the Subscription screen Rules for Commencement of a Transaction e Transactions can be updated only for customers in active status e For capturing a holding the customer should have at least one portfolio coupled to his her id Procedure for Capturing a Holding Step 1 The system auto populates the name no and default portfolio name of the customer The Customer No and Customer Name fields are driven by the Field Access Controller Step 2 ae ORACLE For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Step 3 The subsequent step is to capture the fund scheme de
231. nst Display which the order has been initiated Order Type Displays the type of order For eg Buy Sell or any other Display order type Order Date Displays the date on which the order was placed Display Order Qty Displays the order quantity In case of amount based Display orders this column is blank Order Price Displays the price at which the transaction was placed Display In case of insurance the price column displays the Premium amount This is blank in case of amount based orders Order Amt Displays the amount of the order In case of insurance the Display price column displays the Sum Insured Order Status Displays the current status of the order Display 5 154 ORACLE Field Description Mandatory Action This field displays the links to View Display Details Modify Cancel Approve View Details All the users who have access to common order book can Display view all the details of the order including the comments written by checker by clicking on the View Details hyperlink They cannot modify the details of the order Cancel Customer can cancel the corresponding order Display Transaction Details Pop Up In order to view the transaction details for the orders through the order book a new hyperlink Trxn Details is introduced for following order status in the Order Book screen e Executed e Partially Executed e Partially Executed Cancelled When the user clicks on the Trxn Det
232. nstrume Displays the Display Y For a given nt Type instrument CLIENT_ID type for and which MODEL_ID performance combination is computed Display value from PMS_MOD EL _PORTF OLIO INSTR UMENT_TY P 3 116 ORACLE Attribute Description Input Object Mandatory Data Field Default Selectab Type Y N Type Validation Values le Size Display Name Displays the Display Y For a given name of the CLIENT_ID instrument and for which the MODEL _ID performance combination is computed Display value from MST_INSTR UMENT INS TRUMENT_ NAME Weighta Displays the Display Y For a given ge total CLIENT_ID weightage and allocated to MODEL _ID correspondi combination ng Display instrument value from for the PMS _ MOD selected EL PORTF portfolio for OLIO COMP which OSITION performance is computed Return 1 Months Displays the Display Y For a given portfolio Instrument performance Name for the display correspondi value from ng INSTRUME instrument NT_ANALY for the first TICS month RETURNS _ FIRST_MO NTH 3 117 ORACLE Attribute Description Input Object Mandatory Data Field Default Selectab Type Y N Type Validation Values le Size Display 3 Months Displays the Y For a given portfolio Instrument performance Name for the display correspondi value from ng INSTRUME instrument NT_ANALY for la
233. nstrument type for each of the securities across all the portfolios The instrument type is displayed as per the data captured in the instrument master table in the database Display only Name Displays the names of all the securities across all the instrument types and portfolios Display only n ORACLE Field Description Mandatory Market value Market value is the product of the market price and Display quantity denominated in the security currency only TAB 2 Modification Tab The functionality of each of the buttons at the bottom of the screen has been explained below Add In order to simulate by adding a new holding enter the appropriate security particulars in this tab and click the button Add Delete Pick the holding to be deleted in the first tab on this screen This results in the display of the corresponding security details in the second tab Proceed to click the button delete Modify Select the holding to be modified in the first tab on this screen Modify the quantity market value of the selected holding Click the button modify in order to update the changes made Clear This button assists in undoing the changes made to a selected holding prior to clicking on the modify button Clear List This button aids in clearing the complete holdings of the selected customer Return The impact of the changes on the holdings can be analyzed by click
234. nt Issuance Fee Enables the user to enter the appropriate N Issuance Fee Custody Fee Enables the user to enter the appropriate N custody fee This field is enabled only if the Charge Custody Fee on CA flag is set to Y at instrument type level and if it is amount based CA Processing Logic for Equity Order Capture The system follows the below logic to process Equity Order Capture 1 For security quantity is mentioned in multiples of regular lot size If not mentioned the system displays an error message You can enter an order with a disclosed quantity less than or equal to the order quantity Conditions for the order price prices are in multiples of the tick size for a particular security Market Order The price and the trigger price fields are disabled Stop Loss If you select this option you must specify the trigger price in the Trigger Price field However it is optional to indicate the price in the Price field If the price is not specified then the system considers the trigger price as the price for the order For buy SL orders the trigger price is less than or equal to the Price Similarly for sell SL orders the trigger price is greater than or equal to the Price Limit Price If you select this option the system disables the Trigger Price However you are allowed to specify desired price The price mentioned is in the multiple of the ti
235. nt No Enables the user to enter the Account No Y Transaction Type Displays the appropriate transaction type Buy or Y Sell Order Type Displays the appropriate order type market order Y Limit Order or Stop Loss Order Trigger Price Enables the user to enter the appropriate price at which the trade is expected to happen Time Condition Enables the user to enter the appropriate time condition The options available are IOC GTC and Timed Order 5 72 ORACLE Field Description Mandator y Expiry Date Displays the order expiry date Nominal Amount It displays the stated value of an issued security which remains fixed Quantity Display the units which are calculated as Nominal Amount Face Value Accrued Days Displays the number of days for which the last accrual of interest has happened Accrued Interest Displays the appropriate interest accured for the selected instrument Treasury Price Enables the user to enter the appropriate treasury price This field is enabled only if the instrument is unit based else the system displays it in the disabled mode Treasury Yield Displays the corresponding YTM for a given Treasury price Customer Price Enables the user to enter the price charged to the client Customer Yield This field populates with the corresponding YTM for a given Customer price Spread Bps Enables the user to enter
236. ntitled licenses Portfolio Management provides e An account for customer s entire portfolio e Daily portfolio monitoring and decision making transparency e Flexibility to adjust customer s portfolio at any time if customer s goals lifestyle preferences or investment strategies change e Regular performance updates and completely transparent portfolio reporting Key Features Features e Choice of creating several portfolios for a customer e Flexibility of creating multi currency portfolio e Choice of associating a benchmark for the portfolio e Choice of selecting method of calculation FIFO or WAC Online reporting allowing user to view their portfolio holdings and transactions e For each instrument type e Separately in each portfolio Online analysis based on their composition across different dimensions like asset class industry currency region market capitalization and instrument type a ORACLE Daily reports showing for each holding as well as for each portfolio e Performance e Dividends Distributions Facilitates decision making through what if analysis across multiple dimensions such as asset class instrument region industry and market capitalization Facilitates to stay informed with custom portfolio alerts Key Benefits Transparency User can view all investments transactions online allowing them to track movement in their portfolio Diversifi
237. o enter the trigger price if the Y Order Type is selected as Stop Loss or Limit Order from the drop down list else system auto populates the appropriate value Time Condition Enables the user to select the appropriate time Y condition Margin Amount Displays the margin amount and is calculated as No Y of contracts of Margin defined per contract Account Details DP ID Client ID Enables the user to select the appropriate DP ID details of the selected customer Bank Account Enables the user to select the appropriate bank account detail of the selected customer Procedure for Placing of an Order Step 1 Customer For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed aes ORACLE Step 3 Click the a icon next to the Future ID field When the user clicks on the a icon next to the Future ID field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the future instrument The instrument search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explai
238. od Y from the drop down list Bank Account No Enables the user to select the appropriate bank account no from the drop down list 5 93 ORACLE Field Description Mandatory Cheque No Displays the cheque no for the order capture This field appears only for Buy orders Redemption Amount Displays Redemption Amount Procedure for Placing of an Order Step 1 For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Step 2 Click the S icon next to the Instrument Name field When the user clicks on the a icon next to the Instrument Name field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the Instrument Name The instrument search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Once the user selects the Instrument Name following fields are automatically get populated e Instrument Group e Currency Step 3 From the Order Type drop down list select the appropriate order type There
239. of terms currency in view mode based on the FX ID selected Transaction Details a ORACLE Field Description Mandator y Transaction Type Enables the user to select the appropriate Y transaction type from the drop down list Deal Type Enables the user to select the appropriate deal type Y from the drop down list Amount In Base Enables the user to enter the appropriate amount in Y Currency base currency of the selected Instrument Amount In Terms Displays amount in terms currency and is calculated Currency as Amount in Base CCY Forex Deal Rate Forex Deal Rate Enter the Forex Rate per unit of commodity currency Y Fees In Terms Enables the user to enter the fees applicable for Currency transacted units In terms currency Tax amp Other Charges Enables the user to enter the tax applicable for In Terms Currency transaction amount In terms currency Total Amount In Displays the total amount of transaction in terms Terms Currency currency FX Forward Date Enables the user to select the appropriate FX Y forward date Transaction Date Enables the user to select the appropriate Y transaction date Counterparty Name Enables the user to select the appropriate N counterparty name using the Search icon Counterparty Ref No Enables the user to enter the appropriate ref no in N the Counterparty Ref No text box Description Enables the user to enter th
240. of the percentages across all the asset class would sum up to 100 Display Only At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency 3 85 ORACLE As explained earlier on clicking any of the assets in the earlier tab displays a tab representing a detailed analysis of all the securities in the selected asset category Asset Details Field Description Mandatory Name Displays the names of all the securities direct and Display indirect in the selected asset class only Currency The currency of the security displayed is as captured Display in the instrument master table in the database only Units Units are computed for the indirect holdings in the Display equity asset class as described in the previous table only For the indirect holding in other securities under the other asset classes the holdings are defaulted to 1 In case of direct holdings for the securities under the asset class equity commodities and bonds the units include the purchased and additional units received on account of stock corporate actions For the direct holdings under asset class like insurance metal real estate cash gems and others the units are defaulted to null by the system For the holdings in the PM Scheme the constituents will be regarded as Direct holdings and the procedure of computation will be analogous as mentioned above The sub consti
241. ogin the Portfolio Name is the first field displayed on the Order screen Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Step 2 Click the y icon next to the Instrument Name field When the user clicks on the a icon next to the Instrument Name field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the Instrument Name Once the user selects the Instrument Name following fields are automatically get populated e Security Code e Instrument Currency e Settlement Currency e Custody Fee e Instrument Group R ORACLE e Exchange e Last Traded Clean Price at d The user can select the instrument by searching for the security using general characteristics section icon as explained in The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Securi
242. oldings by means of investments made through the FLEXCUBE Private Banking However this is achievable under the condition that the customer has at least a portfolio created and associated to his her Customer ld The holdings of can be simulated only when the customer in active status The fields of each tab have been briefly described below Screen 1 ai ORACLE For simplicity we have abridged the explanation of this screen into three sections The first table clarifies the fields on the Model portfolio and the second table elucidates on the fields for the holdings decomposition To recap the user has the option to flip between the graphical and tabular view In the tables given below the fields pertaining to the tabular view have been described Additionally the corresponding figures from the tabular views have been used for generating the graphs Model Portfolio all times sum up to 100 Field Description Mandatory Asset The assets defined in the particular model Display only recommended asset allocation as per customer risk profile are displayed in this field of Asset This field defines the proportion allocated to each asset Display only in the model Total The total weight assigned to all the asset class would at Display only Holdings Decomposition The reader of this section needs to understand the concept of decomposition of holdings as envisaged in the FLEXCUBE Private Banking i
243. olio there are some attributes such as portfolio type and currency that cannot be changed once entered and saved Enter all the valid inputs into all the mandatory fields in order to save the portfolio After entering the details save the portfolio by clicking the Save button Click the Gancel button to go back to portfolio maintenance screen To access any other screens please use the top horizontal menu bar The fields have been briefly described below Portfolio Maintenance Field Description Mandatory Portfolio Name Enables the user to enter Y appropriate portfolio name 1a ORACLE Field Description Mandatory Portfolio Type The user can choose a valid portfolio type from the list of values that are available Self Managed and Held Away Portfolio will be displayed in the list of values The self managed group will contain portfolios whose assets are captured through the bank but managed independently by customer Held Away portfolios are those which are owned and managed by the customer but not processed through the bank Y Default When the user selects this check box the current portfolio is selected as Default portfolio for the selected portfolio type If this is the only single portfolio for the Portfolio type it is automatically selected as default portfolio Portfolio Currency The user can use the drop down list to select the currency from the se
244. olios For customer specific model portfolios this performance computation is not available Also the system presents the user with the performance of the model portfolio for last one year at any point of time User Access levels Customer can access the model portfolio screen on ORACLE Screen Figure 2 7 Model Portfolio Screen Screen Navigation After logging into the system select Tools gt Model Portfolio Field Description Mandatory Y N Instrument Type Displays the instrument type for which performance Y is computed Instrument Name Displays the name of the instrument for which the Y performance is computed Weightage Displays the total weightage allocated to Y corresponding instrument for the selected portfolio for which performance is computed Returns 1 Month Displays the portfolio performance for the Y corresponding instrument for the first month 3 Months Displays the portfolio performance for the Y corresponding instrument for last 3 months 6 Months Displays the portfolio performance for the Y corresponding instrument for last 6 months 1 Year Displays the portfolio performance for the Y corresponding instrument for last 1 year 3 Years Displays the portfolio performance for the Y corresponding instrument for last 3 years Fact Sheet Enables the user to view the fact sheet details by clicking on the Fact Sheet icon Analytics Enables the user to view
245. omatically get populated e Options Name e Reference Date e Contract Settlement Date e Instrument Currency e Settlement Currency e Commodity Currency Step 3 Select the appropriate Trade Date By default display the current system date or business date whichever is later but user can modify the trade date Step 4 Select Premium payment Date Payment date or date when Premium is received paid Step 5 From the Transaction drop down list select the appropriate transaction type There are two options available for Option Transaction They are Buy and Sell By default Buy option is selected aaa ORACLE Step 6 Enter the appropriate number in the No of Contracts text box Step 7 Select the appropriate Counterparty using Search Icon Step 8 Select the appropriate ref no in the Counterparty Ref No text box Step 9 Enter the appropriate price in Bank Price Premium Per Option text box Step 10 Enter the appropriate price in Client Price Premium Per Option text box Once the user enters the Bank Price and Client Price system auto populates the data in Quantity Total Unitary Commission Broker Unitary Commission Private Unitary Commission Total Amount and Total Revenue fields Step 11 Enter the description if any in the Description text box Step 12 Select the appropriate DP ID from the DP ID drop down list Step 13 Select the appropriate account no from the Bank Account drop down list Ste
246. on Mandatory Instrument Group Instrument group classification of the holdings at customer or household level is displayed here Display only Market Value The market value for a particular instrument group represents the sum of the market values for all the direct and indirect held securities denominated in the customer preferred currency The computation methodology is similar to that explained in the previous table on asset class analysis Display only of total This is the percentage composition of the holdings in a instrument group under consideration with respect to the total value of all the holdings across all the instrument groups The sum of the percentages across all the instrument group would sum up to 100 Display only Industry Field Description Mandatory Industry All the industries in which the equity holdings of the selected customer span across are displayed Display only Market Value Only the securities within the category of equity instrument type are considered for computation The market value is denominated in customer preferred currency Display only of total This is the percentage composition of the industry under consideration with respect to the total value of all the industries The sum of the percentages across all the industries would sum up to 100 Display only oe ORACLE Market Cap Fie
247. on Percentage basis and therefore the Original Price is the unconverted Percentage Price If the price is not available in table then the field defaults to the Issue Price of the Instrument as per bond master Y Exchange Enables the user to select the appropriate exchange Order Details Trade Date Captures the date on which the trade has happened Settlement Date Displays the Settlement date for the order Transaction Type Displays the order type in the drop down list whether Buy or Sell Nominal Amount If the bond Quotation Method defined in the bond master is Quantity then it is a display field and computed as Quantity entered Face Value of bond from bond master If Bond Quotation Method is defined as Nominal then it is an input field In this case the derived quantity is a whole number and is expected to adhere to the minimum tradable order quantity as per the Bond master Y N Quantity Displays the number of the units of the bond If the bond Quotation Method as defined in the bond master is Nominal this will be a display field and is computed as Nominal Amount entered Face Value of the bond as per Bond Master If Bond Quotation Method is Quantity this is an input field where the Quantity is to be mentioned and is expected to adhere to Minimum tradable Quantity Y N Order Type Specifies the Price condition of the order for the selected instrument
248. on is deviated Do you want to proceed The user can click the OK button to continue If no risk score is defined for the customer then there will not be any model asset allocation and hence system will not display any message Step 10 Depending on the type of order selected the price field will be enabled or disabled To summarize what we discussed the price field will be enabled only for the Limit price and Stop Loss type of order For the Limit price order the user can overwrite the market price with any other desired price and in case of stop loss orders a user has the flexibility of specifying a limit price along with the trigger price The price should be quoted in multiples of the tick size Step 11 To reiterate FCPB provides users with the flexibility of placing orders with Quantity conditions An order with the Disclosed quantity order condition allows the user to disclose only a portion of the order quantity to the market For e g Order quantity 10000 Disclosed quantity 2000 Only 2000 are disclosed to the market a ORACLE The disclosed quantity should be less than equal to the order quantity After this quantity is fully matched a subsequent quantity of 2 000 is disclosed Step 12 The trigger price field will be enabled on selection of the Stop Loss order It is mandatory for the user to enter a value in this field on selection of the stop limit price condition Step 13 The user can set either of
249. on on updating the holding can clear the entire details captured earlier a Clear by clicking on the button 5 11 Options 5 11 1 Order Management for Options Please note that though this section of user manual explains order management and capabilities of Options instrument type but these features of order management UI and processing would be available to the bank only if the bank s license entitles them to the Alternative Investments module and Order Management module Options Order Capture User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y ae ORACLE Screen TE ka Figure 5 32 Options Order Capture Screen Navigation After logging in the system select Order Management gt Options gt Order capture Field Description Mandator y Customer Details Portfolio Name Displays the list of the portfolio names for the Y customer Options Details Options Name Once the user selects the Options ID system auto Y populates the corresponding Options name Underlying Asset Displays the Name of the underlying asset as Y captured
250. onary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen k Figure 5 24 PMS Order Capture Screen Screen Navigation Select the Order Management gt PMS gt PMS Order capture From the Order Type drop down list select the Sell option Procedure Step 1 From the Order Type drop down list select the appropriate order type Here select the Sell option Once the user selects the Sell option the available Instrument names appears in the drop down list Step 2 For a customer login the Portfolio Name is the first field displayed on the Order screen The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Step 3 we ORACLE From the Instrument Name drop down list select the appropriate instrument Once the user selects the appropriate Instrument Name the following fields are automatically populated e Currency e Holding Amount e Account No Step 4 Enter the appropriate application no in the Appli
251. op down list select the appropriate order type If the user selects the Order Type as Stop Loss or Limit Order the Trigger price field is editable and user can enter the desired trigger price else system auto populates the appropriate trigger price Step 7 Select the appropriate option from Time Condition drop down list ante ORACLE Step 8 Enter the appropriate quantity in the Quantity text box Step 9 Enter the appropriate price in the Treasury Price text box Step 10 Enter the appropriate price in the Customer Price text box Once the Quantity and Treasury Price and Customer Price are entered system auto populates Spread Total Treasury Amount Total Customer Amount and Fee amount if any The system auto populates the Spread amount depending on the Customer Segment IAG and Order Type combination However the system recalculates this amount based on Customer Price and Treasury Price It can have negative value when the Customer Price is less than the Treasury Price for Buy order and when the Customer Price is more than the Treasury Price for Sell order If Spread is not defined in the master then system defaults the field to zero value Step 11 ra Select the appropriate Counterparty Name using the icon Step 12 Enter the appropriate ref no in the Counterparty Ref No text box Step 13 Enter the appropriate description in the Description text box Step 14 From the DP ID Client ID drop down
252. op up screen This option is however unavailable for the accounts held under the instrument type CASA and TD Generic Instrument The Others instrument type has few drawbacks and it does not support Partial Sale of units It is only used for non unitized instruments that are bought and sold in amounts rather than units e g PMS Art collectibles Property etc To overcome this problem the new instrument type called Generic is introduced These instruments are unitized i e which are traded in the market at a per unit price and are not of type direct equity mutual funds Insurance structured product amp Alternatives bond commodity Generic Instrument RM Managed std Name ccY cY Total SGD Qty Total Buy Cost Market Price Market alue Yalue Date 65 09 65 09 Action Figure 3 18 Generic Instrument Valuation Screen Field Description Mandatory Name Name of the Generic Instrument is displayed Display with a hyperlink When the hyperlink is clicked only a pop up window appears showing transaction history Instrument Currency Displays the currency in which transaction took Display place only Settlement Currency Displays the currency in which transaction Display settlement took place Only 3 52 ORACLE Buy Price Displays weighted averaged buy price Display only Qty Displays the quantity of transaction Display only Total Buy Cost Disp
253. or previous received price for valuation and analysis The Market Price is hyperlinked on click of which the system directs the user to Portfolio Alerts screen to set up the alerts as per requirement The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation Display only Market Value Market value is the product of the market price and quantity Display only Value Date Displays the date on which the price was received for determining the market value The system also displays the time at which the last price was received for determining the market value 3 22 ORACLE Field Description Mandator y Quick Launch This field displays the links to Buy Sell the securities The links are available for all the equity securities in this tab The field also displays an additional link CA for including corporate action related data for portfolios On selection of any of the above links the user is directed to the corresponding screens with pre filled information of the selected security The screens associated to these links have been explained in depth in the section on Transaction Management On clicking the Buy Sell hyperlink the
254. orders that will be placed hence forth post the modification and will not update the orders which are in open status Field Description Mandatory 1st Nominee 2nd Nominee 3rd Nominee Enables the user to modify the nominee names N ORACLE 3 3 Field Description Mandatory Relationship Enables the user to modify the nominee N relationships Ownership Enables the user to modify the ownership N of the nominees Portfolio Valuation Description The portfolio valuation option offers an expanded detailed overview of all portfolios at a glance Portfolio valuation maintains a record of the current market value of the different types of instruments in a portfolio Each valuation record further represents the security holdings and their associated values as of the valuation date A list of all the security transactions can be seen by clicking on the security holdings These are clearly listed in terms of execution details and transaction type purchase or sale The Portfolio Valuation feature of FCPB system is further enhanced to value Customer and Proprietary Portfolios at different instrument prices The system identifies the Proprietary Portfolio by the Client Id of Proprietor set at bank parameter level and treats all the portfolios linked to this client id as Proprietary Portfolios To accomplish this FCPB stores two set of prices for a single instrument with Bid
255. ortfolios with no transactions for no of days mentioned in the bank parameters Currently the following instrument types are supported by FCPB namely equity mutual fund structured product commodities bonds PMS insurance derivatives such as futures and options CASA and Time Deposits The current and savings accounts will be categorized under an instrument type CASA whereas the term deposit will fall under the instrument type TD All the miscellaneous securities which cannot be categorized into any of the above defined instrument types can be classified into the instrument category others Unless defined otherwise the units or quantity of a security are dependent on a direct transaction However for the purpose of portfolio analysis and simulation elucidated in detail in the subsequent sections the units of a security may also include units derived as underlying securities of one or more instruments For instance you can hold shares in ACC Cement either as an outcome of a direct purchase or as an indirect holding due to purchase of a Mutual Fund which in turn has ACC as one of its constituents However please note that the concept of holding underlying securities is applicable only for the instruments types Mutual Fund PMS and Structured products Analogous to a Mutual Fund or a Structured product for a PMS scheme its constituents or sub constituents will be considered for the purpose of analysis By referring sub
256. ository The archiving facility has been provided to archive customer reports a ORACLE All the reports which are converted to BI Pub will be generated in the language selected at Preferred Language for Statement field available in Demographics section of Customer Creation screen os ORACLE
257. p 14 Click on the Submit button Once the user clicks on the Submit button system displays the Exception pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation oes ORACLE Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 5 11 2 Transaction Processing for Options BSricase note that transaction capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Alternative Investments Module of FCPB User Access levels Customer Can capture the transactions only for his her portfolios ARS ORACLE Screen ka Figure 5 33 Options Transaction Capture Screen Navigation After logging in the system select Txn Mgmt gt Options Procedure for placing transaction Step 1 The system auto populates the customer no name and default portfolio name of the customer which is already in context Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 Click the a icon next to the Options ID field When the user clicks on the a icon next to
258. prevalent rate for the current coupon period is displayed Maturity Date Displays the maturity date of the bond The Maturity date is the date on which the issuer repays the principal amount Display only 3 35 ORACLE Field Description Mandatory Market Price This field displays the current prevailing price of the bond To recap FCPB supports the holdings of both traded and non traded bonds The traded bonds will receive the current market price as a data feed from external data vendors FCPB assumes that the prices quoted for the bonds in all the markets are clean price Clean price is the basic price of the security and excludes accrued interest For the non traded bonds the user can manually update the price of the bond by utilizing the Modify hyperlink provided in this tab The most recent manually updated price will be considered for the purpose of valuation Analysis Simulation Please note that the Modify hyperlink will be enabled only for the non traded bonds In the absence of the user providing any information on the market price the system will consider the acquisition price as the market price The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price availab
259. ption Trigger Price Enables the user to enter the trigger price if the Y Order Type is selected as Stop Loss or Limit Order from the drop down list else system auto populates the appropriate value Time Condition Enables the user to select appropriate values like Y GTC IOC Timed Order Expiry Date Enables the user to enter Order Expiry Date Y Amount In Base Enables the user to enter Value is in Base currency Y Currency of the Instrument ID selected Treasury Rate Enables the user to enter Treasury Rate per unit of Y commodity currency Amount Treasury Value displayed is in Terms currency of the Y Rate In Terms Instrument ID selected Currency Spread decimal Displays the Spread as maintained in the system Y Customer Rate Enables the user to enter Customer Rate per unit of Y Commodity currency Amount Customer Value displayed is in Terms currency of the Y Rate In Terms currency instrument ID selected Fees In terms currency Display value of Fees as computed by the system Total Amount Displays the Total amount charged to the customer 5 138 ORACLE order details Field Description Mandator y Credit Limit Check Hyperlink Y N Revenue In Terms Displays the total commission received by the bank Y Currency Revenue In Base Displays the total commission received by the bank Y Currency Counterparty Name Enables the user to enter the name of the Based on co
260. r navigates to the Order management or Transaction management screen This depends on the way portfolio type maintenance has been set up Field Description Mandatory Value Date Displays the date on which the current unit Display only price was received or manually updated for determining the market value The system also displays the time at which the last unit price was received for determining the market value Quick Launch This field displays the links as M CA S to The action modify capture Corporate Action and Sell the buttons will securities The links are available for all the be disabled securities in this tab fora Customer As mentioned earlier the Modify link will be viewing the enabled only for the non traded bonds and securities facilitates the user to update the prevailing held ina RM market price of the bond Managed portfolio Bond Corporate Action User Access Level ae ORACLE 3 3 4 CUST The CUST can add modify the details of Corporate Actions announced by the companies institution for Self managed portfolio Screen Sie E E Figure 3 10 Bond Corporate Action Screen Navigation After you login as an CUST user select Portfolio Maintenance gt Bond and then click on the CA hyperlink The fields in the Bond Corporate action screen are similar to the Equity Corporate Action screen Additional fields in Bond corporate Action have been inscribed as below
261. r the instrument type equity mutual fund traded bonds structured product commodities will be received as external downloads or imports The most recent manually updated price by the user will be considered for the securities under the instrument type insurance others and non traded bonds The surrender value would be considered as market price for the securities under the instrument type insurance In the absence of market price for the securities requiring market price to be manually updated the system considers the acquisition price as the market price The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation Display only of Total Is the percentage composition of the portfolio under consideration with respect to all the portfolios This figure is computed as Market value of the portfolio under consideration in customer preferred currency total market value of all the portfolios in customer preferred currency The sum of the percentages across all the portfolios would sum up to 100 Display only At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency computed as explained in the ear
262. r exchange This acceptance is based on the ability of the company to meet certain minimum size requirements and also on the amount of capital the company has raised in the public markets Selling stock is procedurally similar to buying stock Generally the investor wants to buy low and sell high although a number of reasons may induce an investor to sell at a loss e g to avoid further loss Orders are matched automatically by the system Where an order does not find a match it remains in the system till a fresh order comes in or the earlier order is cancelled or modified The status of the order can be monitored through the Order Book of the FCPB The FCPB trading system provides tremendous flexibility to the users in terms of kinds of orders that can be placed on the system Several time related day immediate or cancel or price related buy sell limit and stop loss orders ue ORACLE Every order initiated through the FCPB will have a unique transaction id associated to it The FCPB assumes that this identification would be a common interfacing attribute between the external broker system and the FCPB If updating the risk score is mandatory in the bank parameters screen then risk score of a client needs to be updated in FCPB before placing any order else the system will display error and the user will not be able to place orders This is applicable to all order capture screens Exception approval can be taken from the desi
263. rare e E a a e E E EAEE 3 33 3 3 4 INS UTONGCE a renro aE NEN A TE saab N EA AE AAE 3 38 3 3 5 OEIS pana a a a a a a E tas 3 40 3 3 6 Str ct r d Produttore naia bensad dasausniceniaaatecescadcea anstasaacouadsencets dade taagcatae eee 3 42 3 3 7 Commoditl eS soigne dai sea de cotaesdacudaentge sia she E atv eda todd eaten E E 3 46 3 3 8 PMS 22 ioscan eee siete sags ctasedes tte vac EA Asean cheese E he cea boats a eae eee See 3 49 3 3 9 Generic THSTVUIN ONE eisereen nen duedeveosiedssvs iuecvebened Soave laesis anyedesssbnuseveandeseeetee Gissysunseensiineieeasse 3 52 DDAQ CORPUS siiperi E E E cub cgiapctnbv ingsveadonset sleet tue RE widanaetes tits E 3 53 TILE CASA esa ra E ERE dav oleetcdet EEEE E EEE EEE 3 54 3 342 PULP OS oram A RE ease A A A R A E awk AVA A E A RES 3 57 333 Opos eosa an E ER R A EE EE E A R E E 3 60 IIA dH OVEM oreen a E E E E eassgand eneasscgeasigeas neeeseeaee 3 62 RILI PEORES a 3 63 3 4 PORTFOLIO ANALYSIS peeaire acs E EEE AEE Aa AE RENE E tates 3 64 3 4 1 View Portfolio Analysis By Portfolio esseseesnseeseneeeensenesesreerereeserrerresesrreresreesesresrnsesrreresrresesreees 3 65 3 4 2 View Portfolio Analysis By Instrument Type ccccscceeseceseceeseeensecesaceesseceeneecaeceeneeesaeceeneeeaeeees 3 7 3 4 3 View Portfolio Analysis By Asset Class ceccccssccesssecenscesncecsseceeneecseceeacecsaeceeneesaeceeneesaeeesneeenaeenes 3 77 3 4 4 View Portfolio Analysis By Regiom 1 ccccsccesceese
264. rdian KYC is not done the system does not allow the user to place the order and displays an appropriate exception message If the flag is maintained as N then KYC check for Signatories is not required If the order is to be placed in a portfolio where there are joint holders the system first checks if the KYC Check for Joint Holder is maintained as Y then the Joint Holder KYC check is mandatory for placing the order Here if the user tries to place the order and if KYC check of any or all joint holders is not done the system does not allow the user to place the order and displays an appropriate exception message If the flag is maintained as N then KYC check for Joint Holder is not required If the order is placed successfully the system displays the message as Order placed successfully If the user changes the decision on the order he she can clear the entire details captured earlier E Clear by clicking on the button The above screen explains the fields gets displayed for payment option as Regular lf payment option is selected as SIP then the additional fields like Frequency No of Transfers Commencement Date SIP End Date and Total Indicative Amount gets displayed Mutual Fund Order Capture Redemption User Access Levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed
265. re for Placing of an Order Step 1 Customer For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Step 2 Click the a icon next to the Instrument Name field 5 111 ORACLE When the user clicks on the a icon next to the Instrument Name field Security Search window appears Enter the appropriate search criteria in the respective fields to search for the Instrument Name The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Once the user selects the Instrument Name following fields are automatically get populated e Security Code e Instrument Currency e Settlement Currency e Measured Units e Last Traded Price e Spread Step 3 Enter the appropriate Transaction Date using the calendar icon Step 4 Enter the appropriate Settlement Date using the calendar icon Step 5 From the Transaction Type drop down list select the appropriate order type There are two options available for Commodity Order Capture The options are Buy and Sell Step 6 From the Order Type dr
266. reas for the non traded bonds the bank user needs to manually update the price for each holdings For the transactions defined under the instrument type Bonds the user can capture the Buy Sell Asset Transfer In and Asset Transfer Out transaction related data As the transactions for the Bonds have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions Currently there is no restriction on the user in sequencing the backdated transactions The system will automatically sequence the transactions as per the date of execution as entered by the user Bond Transaction Management Buy Sell Asset Transfer In Asset Transfer Out User Access levels Customer Can capture the transactions for his her available portfolios There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios E ORACLE Screen ORACLE Tenure Figure 5 11 Bond Transaction Management Screen Screen Navigation After logging in the system select Transaction Management gt Bonds Rules for Commencement of a Transaction e Transactions can be updated only for customers in active status e For capturing a holding the customer should have at least one portfolio coupled to his her id Field Description Mandator y Customer Details Customer No Displays the customer no Customer Name Displays the
267. res in FCPB i ORACLE 5 5 1 Order Management And Transaction Management Introduction FLEXCUBE Private Banking FCPB makes it possible to trade and process Equity and Mutual Fund transactions While FCPB facilitates order management for Equity Mutual Funds Insurance SP amp Alternatives PMS Commodity Futures Options Forex and Bonds it supports transaction management for all asset classes including bonds arts gems metals and real estate This product provides all of the tools FCPB needs for the entire transaction processing purchase sale and corporate action to computation of accrued interest Designed from inception as a global system FCPB provides full multi currency capabilities Please note that though this section of user manual explains order management and transaction management capabilities for all the instrument types supported by FCPB but whether a particular order management UI and processing feature would be available to the bank or not depends on whether the bank s license entitles them to the transaction management and Order management module for that instrument type Key Benefits e Full support for multi currency transactions e Pre trade compliance checking e Electronic order routing and trade execution for Equity and Bonds e Supports online review of transaction history Understanding Transaction Management To recap what we had explained in the section on Portfolio Valuation the customer ha
268. ring the transaction is to opt for a type of transaction The user can place the buy sell Asset Transfer In and Asset Transfer Out transactions through this screen The Asset Transfer In ATI type of transaction allows the customer to transfer the securities to current wealth management system and reflect the holding in the active portfolio On the other hand Asset Transfer Out ATO enables the user to transfer the securities from current active portfolio to the desired depository The ATI transaction is considered as Buy transaction whereas the ATO transaction is considered as Sell transaction Step 5 The user also needs to select the appropriate settlement type from the Settlement Type drop down list For Buy transactions the system displays the settlement types as Receipt Free and Receipt Against Payment For Sell transactions the settlement types are Delivery Free and Delivery versus Payment Step 6 The user then proceeds to capture the transaction date The calendar for selecting the date has been provided adjacent to Transaction Date field Click on the icon a calendar in order to open the As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions However in case of a sell transaction the user is restricted from capturing the date of transaction as prior to the first purchase transaction date of the security In case of
269. roducts types of instrument constituents of mutual fund PMS and structured product This is explained with examples given below 1 AIM Japan Report has provided the following information on its constituents Name Asset Class Holding Tokyo Motor Equity 69 81 Cash Cash 30 19 And Kotak Gilt has declared 100 holding in Treasury Bill which is classified under the Asset class debt Now if the customer you have selected holds both these instruments then on opting for the asset class analysis the user will be displayed with all the analysis on all the three asset classes namely equity debt and cash 2 Take the second instance where the customer holds Tokyo Motor direct investment and AIM Japan report as his her holdings Now on selecting the asset level analysis you will be presented with the analysis on equity comprising both direct and indirect holding and cash 3 Take the third instance where the customer holds Tokyo Motor AIM Japan report and a PM Scheme as his holding The PM Scheme has AIM Japan report as its constituent On opting for the asset level analysis the analysis will be presented as Tokyo Motor Direct Tokyo Motor Indirect cash indirect Tokyo Motor Indirect due to PMS cash Indirect due to PMS 3 81 ORACLE Field Description Mandatory Typically the PM Schemes generally constitute of securities under the instrument t
270. rporate Action screen ane ORACLE Additional fields in MF Corporate Action have been inscribed as below Field Description Mandatory Dividend Enables the user to enter the Dividend Y Percentage percentage per unit if the selected CA type is Dividend Payout Ratio Enables the user to enter the appropriate Y Corporate Action ratio for the corresponding instrument This field is enabled only for Dividend Reinvest and Bonus CA types New Units Issued Enables the user to enter the appropriate Y no of new units issued This field is enabled only for Dividend Reinvest and Bonus CA types Amount Enables the user to enter the dividend Y amount per unit if the selected CA type is Dividend Reinvest 3 3 3 Bond A bond is a debt security in which the authorized issuer owes the holders a debt and is obliged to repay the principal and interest coupon Though the bonds cannot be transacted purchased or sold directly through the System the system computes the accrued interest for the bonds details of which are explained in the section on Transaction Management 3 33 ORACLE Screen Bond Details RM Managed Sttl Nominal Cap Buy Name C Ccy Amount Factor Price Bonds20 1 Total INR Buy Units TotalBuy Coupon Maturity Market Market Accrued Yield Cost Rate Date Yield Price Interest IA 244 4444 4 608 000 Figure 3 9 Bond Valuation Screen Market Value Value Date Quick Launch 0
271. rrency Market Value l O Self Managed Direct Eq EQ TOYOTA INR 10 500 00 0 O RM Managed Direct Eq EQ TOYOTA INR 7 875 00 O RM Managed Direct Eq EQ TOYOTA INR 315 000 00 O RM1 Direct Eq EQ TOYOTA INR 525 000 00 i O RM2 Direct Eq EQ TOYOTA INR 15 750 00 O RM Managed Commodity COMM1 INR 15 000 00 QO RM1 Commodity COMM1 INR 150 000 00 O Rm2 Commodity COMM1 INR 7 500 00 AY RM2 Bonds Bonds10 1 INR 13 230 00 Y Portfolio RM2 Instrument Type Bond X Name oF Q Units Amount L a il i Currency AFGHANISTAN AFGHANI Region AFRICA v Asset Class ALCIUTDesc r Industry TESSE Market Cap ie Ee Figure 3 41 Simulate Holdings Screen FLEXCUBE PRIVATE BANKING Model Portfolio Model Portfolio Instrument Type Direct Eq Mac EQ Bonds Mac BOND Portfolio Weighted Average Return Weightage 1 Month 40 00 0 00 60 00 0 01 100 00 0 01 Figure 3 42 Model Portfolio Icon Screen Windows Internet Explorer Returns 3 Months 6 Months 0 00 1 28 0 01 7 30 0 01 3 89 3 104 Analytics ORACLE Screen Navigation 1 After you login the portfolio creation screen can be accessed through the Portfolio and Simulator sub menu How to Read the Screen e Onreaching the screen the user can view multiple graphs e These graphs depict consolidated holdings of the portfolios in different dimensions like asset class industry instrument group market capitalization and instrument type The computation and
272. rtfolios can be single or jointly held or could be operated by either or survivor If the account is singly held the user cannot specify the Joint Holder Details as the fields will get disabled However if the mode of operation is joint or either or survivor as the mode of operation selection of joint holder details is mandatory 3 7 ORACLE Field Description Mandatory Nomination The mode of operation and the Y nominee details would also be useful while entering orders for buying selling instruments for such portfolios through the FCPB Order Capture screens This information regarding the mode of operation and nominee details would be passed along with the orders through an interface to an external order management system for execution Details of which are discussed in the section on Order Management If the user creates a new Portfolio of a Portfolio Type for which there is an earlier existing portfolio the system displays a message One Default portfolio exists for this type check Default checkbox to make this portfolio default If the user clicks on the Default Checkbox the newly created Portfolio becomes Default Portfolio for that type while the earlier one no longer remains the default Joint Holder Details Bon selection of any other mode of operation apart from Single held it is mandatory for you to capture the details of the secondary holder
273. s including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate failsafe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not b
274. s an existing entity the asset class shall get defaulted Step 5 After selecting the asset class the subsequent step is to capture the country to which the asset belongs and was purchased This can be done by selecting the names of the countries provided in the dropdown list in the field Country If the instrument is an existing entity the country shall get defaulted On selecting the country the system will display the corresponding Region associated to the country Then Instrument Group too gets selected if an existing instrument is selected else the data should be selected from the dropdown list Step 6 The user then proceeds to capture the purchase details of the holding The first step in this process is to capture the date of purchase The calendar for selecting the date has been provided adjacent to Purchase Date field Click on the icon z in order to open the calendar As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions The transactions in these portfolios can be backdated maximum till the customer creation date The user is also restricted from capturing a future purchase date Step 7 In the next step the user has to capture the currency of the holding The currencies are provided as a drop down list It is obligatory for the user to capture the currency of the holding If the instrument is an existing
275. s in active status e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order ve ORACLE Field Description Mandatory Customer Details Customer No Enables the user to select the customer by clicking on Y the search icon available next to the Customer No field Customer Name Displays the Customer Name for the selected Y Customer No Portfolio Name Displays the list of the portfolio names for the Y customer Source Code Displays the Source Code for the banker who has Y sourced the transaction Lead Generation Code Displays the Lead Generation Code for the banker Y who has provided the lead for the transaction Instrument Details Instrument Name Enables the user to select the appropriate instrument name by clicking on the search icon available next to the Instrument Name field Currency Displays the currency for the selected instrument Y name Once the Instrument Name is selected system auto populates this field Holding Amount Displays holding amount Order Details Order Type Displays the order type in the drop down list whether Buy or Sell Account No Enables the user to enter the Account No Y Application No Enables the user to enter the Application No Y Invested Amount Displays Invested amount for Buy and Redemption Y amount for Sell Bank Account Details Payment Method Enables the user to select the appropriate meth
276. s the option of creating multiple portfolios under the type Self Managed and Held Away based on the setting done at Portfolio type master screen The Self Managed portfolio is intended to be managed by the customer independently although an RM can create as well as transact on behalf of the customer in his her Self Managed portfolio The Held Away portfolio facilitates in capturing the holdings which are held away from the bank With the inclusion of held away assets the user can have a single consolidating view of customer s entire holdings The FCPB currently facilitates trade order management only for the securities under the instrument type Mutual Fund Equity Bonds Structured Products Insurance Futures Options and Forex The trade affiliated orders can be initiated either through the Order Management screen an ORACLE 5 2 For all the other securities classified under various other instrument types the user can capture the post trade transactions into the relevant portfolios Equity Order Management Please note that though this section of user manual explains order management and capabilities of Equity instrument type but the features of Equity order management UI and processing would be available to the bank only if the bank s license entitles them to Order Management module and the Traded Securities module Description Equity represents a share of ownership in a corporation As a unit of own
277. screen explains the fields gets displayed for payment option as Regular If payment option is selected as SWP then the additional fields like Frequency No of Transfers Commencement Date SWP End Date and Indicative Total Redemption gets displayed n ORACLE Mutual Fund Order Capture Transfer User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen Figure 5 6 Mutual Fund Order Capture Transfer Screen The user can also transfer the fund details from one Scheme Name to another Scheme Name by clicking on the Transfer tab Enter the appropriate details in the From section as well as in the To section and click on the Submit button If the Amount option is selected and if the Close the Account flag is set to N then the system validates the amount against the Maximum Amount for Switch Out maintained at the Product Master if any for From Fund These limits are maintained by the administrator in the Product Master If Close the Account flag is Y then the system does not validate the amount against the Maximum Amount for Switch Out maintained at
278. selected portfolio The details of this tab have been detailed later in this section Display only Description Displays the description entered during the creation of the portfolio Display only Type Displays the type of portfolio which was opted during its creation A user logging in as customer will be able to view the RM Managed portfolio in addition to the Self Managed and Held Away Portfolios Display only CCY All the figures associated to the portfolio are displayed in the portfolio currency For all the securities in the portfolio the system converts and stores all the transaction amounts to their corresponding portfolio currency Display only Sttl CCY This field displays the settlement currency for the selected instrument If the instrument currency and settlement currency are different the system displays the settlement currency with hyperlink When the user clicks on this hyperlink the system displays the pop up showing corresponding settlement currency details Display only 3 16 ORACLE Field Description Mandatory Amount The market value at the portfolio level represents the sum of the market values of all the securities across all the instrument types in the portfolio denominated in the portfolio currency Market value at the security level is computed as a product of quantity and market price The market price for securities defined unde
279. sociated with the risk score and Client IT type of the selected customer If the returns are not available for any of the model portfolios then the system displays NA Model Portfolio displays only the bank specific model portfolio of Instruments and not customer specific model portfolios If there are no bank specified model portfolios then the system displays the error message as Selected customer does not have bank specified model portfolio The user can print a simulation report in PDF format Report will provide details about the holding details and analysis of simulated portfolio 3 119 ORACLE 3 6 Portfolio Alerts Description The alerts facilitate by providing the customer a round up of all the relevant information about their investments When the customer creates an alert the system runs automatic predefined searches on the portfolio or the instrument or the exposure or the instrument price they specify The alerts so set up will be notified either through an email or on their dashboard depending on the notification mode opted by the user User Access levels Customer Alerts can be created for RM managed Self managed and Held away portfolio types Screen Bama co ns Figure3 42 Portfolio Alerts Screen Screen Navigation 1 After you login the portfolio alerts screen can be accessed through the Portfolio and Portfolio Alerts sub menu 2 The screen is also accessible through the Portfolio Ma
280. sonal service customized portfolios and a spectrum of investment options This coupled with new regulatory issues have introduced a plethora of complexities in the Wealth Management process Technology is critical to helping advisors meet the needs of their growing client base and new regulatory responsibilities Hence Wealth Management service providers have a requirement for an integrated technology solution fit that spans customer acquisition portfolio planning amp advice portfolio execution portfolio administration and portfolio monitoring amp analysis FLEXCUBE Private Banking is a comprehensive tool which is designed to provide a single platform to record track and manage the overall wealth of a customer across a range of asset classes and instruments The system consists of various modules that enable the users like banks financial institutions and brokerage houses to create preserve and transfer the customer wealth and help them to maximize their returns ie ORACLE 2 1 2 Customer Related Menus Customer Dashboard Description When a Customer logs into FCPB system the Customer dashboard page is launched as shown below Customer dashboard is a snap shot of various details like demographic details Net worth Recommended Portfolio Actual Asset Allocation Portfolio Summary and Alerts User Access Levels Customer The moment customer user logs in and if the user risk profile is updated the system directs th
281. ssencncesssencscessnsecnecessseecseeesseesneceesssesneceeesess 2 6 2 5 MS END IVIES SA GI ice oie cessuctu steaeeecatecesenteascatasthvesereusccenscaeeeteat usc ch a r o 2 8 2 6 IMODEL PORTFOLIO ERANA EE EE E E EEE E EEEE EA 2 9 2 7 CUSTOMER RISK PROFILER cisiccescevesshevsecluvacasde cos i a a iai a a Eai EEEE ASEE RE ASAE a EE EEAS 2 11 2 8 PRODUCT SEARCH vores Eee ia EEE SEA EEE AEE OEE VAES E EEEIEE EE NAESER REDES 2 12 2 9 FEE MANDA TE irean e e a EREA ea A E a E 2 13 2 10 CHANGE PASSWORD 350 3 ci veassassceseoczevcnes E r EEEREN EE E SEEKER EAEE E EEEE E Er KEER e KSR 2 14 2 11 SURVEY QUESTIONNAIRE ninie eenia EE raai E EE EEEE E AE EAE EE REESE EEES 2 15 PORTFOLIO MANAGEMENT sssicssusssaccsteccssssncssncseacssdssnssseesssbessuscsssecsdsessescessssscvseatsosessenssesivessessseacssedessensts 3 1 3 1 INTRODUCTION 33 cess iss ea aaa e i E E A Aa a a Aaa a AE RA 3 1 3 2 PORTFOLIO CREATION AND MAINTENANCE scceessscesecessseceereessaeceseeessaeceneecsaecesneecsaeceeneeesaeceteeessaeeeneees 3 3 3 2 1 Portfolio Ce CUI OM esses aay cusassaisusans ce a cpsanaan cu viet y asecdap zoned AEE E 3 5 3 2 2 Portfolio Maintenance Modify Delete ccccccccesccessceseceseceseeseeesceeeceeeeesecesecnseceaecnaecnaecaeeaeeeaeeeaeees 3 9 3 3 PORTFOLIO VALUATION riea raaa n OE tessa ves E EE daa cesadennss EE AE A NE REET E E E 3 12 3 3 1 PUY sats E E AO O E E A O 3 19 3 3 2 Mutual PUIG sieneen E ER AT AEK E R E KE AEREE NERE AEREN 3 28 3 3 3 DONG a
282. ssssassesassassecassaseesansasenentsgs 5 17 5 3 1 Order Management for Mutual Funds ccccccccsccesscesecesecsseenseesceeseeseeeseeeeeessecesecesecaecsaeeaeeeseeeneees 5 17 5 3 2 Transaction processing for Mutual Fund 0 ccccccecsessseeseesscesecesecesecsecacecseeeseeeeeeeeeeseseseeesecnaeenaeeaes 5 3 5 3 3 MEF Sys Plan Concell glo eissii iR EEE NEE EE E E E ER O 5 40 34A BONDS ceran reneo ee EEEE EEEE aD EEEE E E E A EET E A 5 42 5 4 1 Transaction Processing Jor BOndSoiiisnianinen annaia iveeldeesweadaoners 5 42 5 4 2 Order Management for Bonds sccccccscceeceesceescesscesecusecuseccecaeeeaeeeseeeeeeeeeeeenaeeaecaecaessaeeaaeeaeeeneees 5 52 DED INSURANCE esiescssesdcsccscsetecslecss cnesscsetdendedeczcsacst Hecsteseond otdst cecsegecucctcee tucsuede onectiee cecsdege zectccevucuseseescesdseeseesesenies 5 61 5 5 1 Order Management for Insurance ccccecceecceescesecesecuse suse cusecneeesceeseeeeeeeeeeeeesecaecaessaessaecaeeeaeeeaeees 5 61 30 STRUCTURED PRODUCT suninri rn enaA EEE AEE EEEE 5 69 5 6 1 Order Management for Structured Product cscccscceseceeecseeesseenseeseeeseeeeeeeeeeacensecnaeceaecsaecsaeeaeeeneees 5 69 5 6 2 Transaction Processing for Structured Products ccccccssscesscesecesecesecuseeseeeseesseeseeessensecnsecnaesnaeenas 5 82 ST PMS erensia hs tisdiv ee Hines scnaetsies sanbhiod TEE EET TE NE EEEE EEEE T 5 91 5 7 1 Order Management for PMS crisissen a E E A E REA 5 91 5 8 TRANSACTION PROCESSING FOR
283. st 3 TICS months RETURNS _ THIRD _MO NTH 6 Months Displays the Y For a given portfolio Instrument performance Name for the display correspondi value from ng INSTRUME instrument NT_ANALY for last 6 TICS months RETURNS _ SIXTH_MO NTH 1 Year Displays the Y For a given portfolio Instrument performance Name for the display correspondi value from ng INSTRUME instrument NT_ANALY for last 1 TICS year RETURNS __ FIRST_YEA R 3 Year Displays the Y For a given portfolio Instrument performance Name for the display correspondi value from ng INSTRUME instrument NT_ANALY for last 3 TICS years RETURNS __ THIRD_YEA R 3 118 ORACLE Attribute Description Input Selectab le Display Object Type Mandatory Y N Data Type Size Field Validation Default Values Fact Sheet Enables the user to view the fact sheet details by clicking on the Fact Sheet icon Icon Instrument Fact sheet Analytics Enables the user to view instrument analytics details by clicking on the Analytics icon Icon Instrument Analytics Icon Portfolio Weighte d Average Returns Displays the weighted average returns of the portfolio for the correspondi ng time period The above screen enables you to view model portfolio of the customer and to analyze the impact of simulation On clicking icon read only pop up screen displays the model portfolio as
284. stem select Transaction Management gt Others This screen has been elucidated in depth in the next section Field Description Mandator y Customer Details Customer No Displays the Customer Number Customer Name Displays the Customer Name Portfolio Name Enable user to select from the list of the portfolio Y names for the customer Instrument Details Instrument Enables the user to select the appropriate Y instrument by clicking the radio button The options available are New amp Existing If the user selects the New option the system allows the user to enter the new instrument name in the Name text box If the user selects the Existing option the search icon appears next to the Name field and the system allows the user to search for the existing instrument using that icon S ORACLE Field Description Mandator y Instrument Name Enables the user to enter the appropriate instrument Y name in the Name text box If the user opts for the existing instrument system allows the user to search for the existing instrument name using the search icon Asset Class Enables the user to select the appropriate Asset Y Class from the drop down list If the user opts for the existing instrument system auto populates this field Country Enables the user to select the appropriate country Y name from the drop down list If the user opts for the existing instrument s
285. stomer can generate Detailed Summary and Transactions report for both individuals as well as for households Summary Reports will give a bird s eye view to the clients portfolios User Access Levels Customer Customer has an access to portfolio reports through Customer Login Fields Description Mandatory Report Type Enables the user to select the Y appropriate report type by selecting the radio button oT ORACLE Customer Login pe epee Ten Mgmt Order Mamwt Home portido Ten Figure 6 1 Summary Report Screen for Customer Navigation After logging in the system as Customer select Reports gt Portfolio gt Summary Portfolio from the top menu for summary portfolio report After logging in the system as Customer select Reports gt Portfolio gt Detailed Portfolio from the top menu for detailed portfolio report After logging in the system as Customer select Reports gt Portfolio gt Transaction Report from the top menu for detailed portfolio report Portfolio Summary Report On clicking the report gets generated as a PDF document To reset the screen select Reset button Following are the formats of the list of reports available at individual level similar reports at household level will also be generated e Summary Portfolio Report oe ORACLE Summary Portfolio Report Rucha S Summary Portfolio Report generated as on 26 06 2013
286. t at the time order is entered For such orders the trading system determines the price and hence the price field gets disabled on selection of this option The screen displays this type of order as default order For Market Order the system should default the Time Condition field to GTC Stop Loss This facility allows the user to release an order into the system after the market of the security reaches or crosses a threshold price called the trigger price On opting for the stop loss condition the user has to enter both the trigger price in the Trigger Price field and as well as the price in the Price field If the price is not specified the trigger price is taken as the price for the order The trigger price and the price mentioned should be in multiples of the tick size for that particular security and within the day s minimum maximum price range A sell order in the stop loss book gets triggered when the last traded price in the market reaches or falls below the trigger price of the order On the other hand the buy order in the Stop Loss book gets triggered when the last traded price in the normal market reaches or exceeds the trigger price of the order Example If for stop loss buy order the trigger price is Rs 93 00 the price is Rs 95 00 and the market last traded price is Rs 90 00 then this order is released into the system once the market price reaches or exceeds Rs 93 00 Limit Order On opting for this option
287. t Transaction Management gt Transaction Management gt Equity Rules for Commencement of a Transaction e Transactions can be updated only for customers in active status e For capturing a transaction the customer should have atleast one of the portfolios RM Managed Self Managed or Heldaway Portfolio coupled to his ID The user can capture Equity holdings for the selected portfolio Procedure for Placing of a Transaction Step 1 The Customer No and Customer Name fields are display only fields Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 The subsequent step is to capture the security details aas ORACLE The user can select the security details by directly searching for the security The security search a button displayed adjacent to the Security Name field enables to search for the required security The security search screen displays only securities which are in open status On picking a security through the search screen the security name instrument currency and settlement currency will be displayed in Security Name and Instrument Currency and Settlement Currency fields respectively The user can capture the purchases made through either an IPO offer in the primary market or purchases made in the secondary market Step 4 The next step in captu
288. tab of the alert will be displayed along with the other information of the selected alert Understanding the Screen The alerts get triggered on realization of certain pre defined criteria s by the user To start with let us first understand how alerts are defined in the system In the Admin module the system administrator will predefine the validity and the frequency of running the alerts This is the foremost step required to be done to configure the alerts The validity of the alert indicates the time period for which the alert will remain in force and will be computed from the date it is triggered The period will always be denoted in days The administrator has been provided with the flexibility to schedule the frequency of running the validations for each type of alert The system will verify and validate for the alerts depending on the frequency opted by the administrator for the particular alert Currently the following options are available to the administrator viz daily weekly fortnightly monthly and quarterly The system will process the alerts on the last business day of the respective periods The alerts will be processed as part of the EOD End of Day calculation process The alerts processing will be initiated after all the daily feeds files are uploaded and the entire process of performance computations are completed The user can set up alerts for the customer provided the customer has at least a holding in respecti
289. tab on the screen has been elucidated one by one eae ORACLE The table below describes the fields displayed in the first tab hyperlink facilitating the user to renew the date on click of the hyperlink When the user clicks on the renewal hyperlink the screen is refreshed and the new expiry date is displayed Failure to renew an alert will result in the expiry of the alert and the alert will be deleted from the system in the EOD cycle run on the expiry date Field Description Mandatory All Customer If this check box is selected it enables the user to view all N the alerts set customer wise and for entire hierarchy Customer No If the RM selects the single customer to view the portfolio Display and Name alerts then system displays the Customer No amp Name at only the top of the Portfolio Alerts screen Alert Type The various categories under which the alerts have been Display characterized are displayed in this column only Alert Criteria The condition opted by the customer to trigger the alert Display will be displayed in this column only Expiry This field displays the expiry date of the alert Each Display category of alert has validity depending on the period link for the defined by the administrator Five days prior to expiry an alerts expiry notification message is displayed to the user and at which are the same time the expiry date in this column will be due to highlighted in red color The d
290. tails For capturing the transaction the user has to select the fund scheme for which he wants to capture the transaction The user can select the fund scheme either by directly entering the name of the fund scheme or by searching oD for the fund scheme by clicking the button The fund scheme search screen displays only the schemes which are in open status The user can capture the subscriptions made through either NFO or continuous offer On selecting the fund scheme name the instrument currency and settlement currency of the scheme will be displayed in the Instrument Currency and Settlement Currency fields respectively Step 4 Select the appropriate Account Type from the drop down list The Account Type field is driven by the Field Access Controller for Mandatory and Modify actions The Display option will always be in the disabled mode in FAC for this field Step 5 The folio number needs to be entered If there is an existing folio for the scheme this will be visible as a drop down in the folio field The system defaults the Folio Account No based on the Flags selected at Instrument Type level If the Demat option is selected then the system displays Omnibus A c or Client A c or both in the Folio Account No field This field is also driven by the Field Access Controller for Mandatory and Modify actions The Display option will always be in the disabled mode in FAC for this field Step 6 The ne
291. te done through disabling the button as soon as the radio button is selected for RM managed or Discretionary portfolio Entering the details for portfolio modification deletion On selection of a portfolio and clicking the modify button in the portfolio maintenance screen screen defaults all the details of the selected portfolio in the corresponding fields in the maintenance screen As observed the screen is similar to the portfolio creation screen Hence all the field validations applicable to the portfolio creation screen are also applicable to this screen However unlike the portfolio creation screen some fields in the maintenance screen portfolio name type and currency cannot be modified Modify Delete ae Click the button to save the modifications you have specified If there are any mandatory fields that you have not entered the system will not save your modification but prompt you to specify the same before you click the modify button again Click Cancel to clear all the modifications entered in the screen and the user will be directed back to the Maintenance screen By selecting the cancel button all the modifications done will be lost and the system will replenish the field attributes as existed prior to your initiation of the current modification request To access any other screens please use the top horizontal menu bar The user can also delete a portfolio by using the Delete to confirm the deletion before finally dele
292. te but it should be less than the maturity date Units Enables the user to enter the appropriate units for transaction Nominal Value Enables the user to enter the nominal value of the bond in the field provided Net Trade Price Enables the user to enter the appropriate net trade price per unit Amount Displays the total amount of the transaction Interest Enables the user to select the appropriate option for interest from the drop down list If the transaction type is selected as BUY ATI default value will be Paid And if the transaction type is SELL PUT ATO default will be Received Fee Enables the user to enter the transaction fee Commission Enables the user to enter the appropriate commission Tax amp Other Charges Enables the user to enter the amount paid as transaction tax Exchange Rate Enables the user to enter the appropriate value in the text box if the instrument currency and settlement currency is different 5 46 ORACLE Field Description Mandator y Cap Factor Displays the cap factor value for selected instrument Y Counterparty Name Enables the user to select the appropriate counterparty name who executes the transaction Counterparty Ref No Enables the user to enter the Counterparty Ref No in the text box provided This is a reference number usually assigned by the external service provider Descript
293. tfolio reier CETTE Historic Portfolio Detailed Statement For the period 01 01 2009 to 30 11 2009 Customer Holdings Folio Acco Quantity Total Cost Corporate Bond Hyundai Corp Bond 1120 110 00 17 00 3 815 66 30 11 2009 Direct Equity GOOGLE 4512265 48 00 191 00 13 283 88 255 47 TOYOTA 4512265 210 00 72 00 21 907 97 Equity Funds Infosys 4512265 325 00 50 00 524 22 sarmon 42 00 440 351 83 88 oa 0 00 4 90 Hedge Funds MF JPMC Highly 123 25 00 15 00 375 00 30 11 2009 Private Equity Structured Product CITI Bank Private 123 50 00 25 00 40 32 30 11 2009 34 00 54 84 14 52 oa 0 00 78 02 Real Estate Investment Trust New India Infra Fund 32699 60 00 80 00 154 85 30 11 2009 Reliance MF oa ORACLE Holding Period Holding Period Report Customer Name Rucha S Address Holding Period Report Holding Period Report As on 26 06 2013 Rucha S Folio 1 Original Holding Instrument Portfolio Instrument Remaining Date of s Instrument Name eure pitts Account earument Buy Ti purchoce period Buy Price Market Value No Qty in days Auto MF EQuiTy Discretionary MF 12345 INR 11 000 11 000 01 01 2013 176 1 000 11 000 Bonds10 1 RM1 BSD 310 INR 400 000 400 000 01 01 2012
294. th break up between Price and Currency impact of Total Is the percentage composition of the market Display value of a security in the instrument as compared only to total market value of the instrument Please note the values are computed in the customer preferred currency Profit Loss Is computed as the difference between the buy Display cost and market value only Loss figures are displayed in RED color and are prefixed with a minus sign Profit Loss Is the percentage of the profit loss computed Display above only Buy Price QTY and Market Price columns remains blank for CASA and TD instrument types At the end of the tab the last row displays the sum of all the above fields in the customer preferred currency If the Category is selected as Instrument Type then the system displays the details in the customer preferred currency in the Gain Loss Summary pop up as shown below Screen Total INR r FLEXCUBE PRIVATE BANKING Portfolio Summary Popup Windows Internet Explorer Gain Loss Summary in Client Currency Average a in Market r Unrealized Unrealized Name Inst CCY Account No Exchange cavisition Ais zi Exchange Morket vane Rate Rate Cien 1 000 35 701 000 1 000 1 000 0 000 1 000 1 000 1 000 0 000 0 000 14 665 649 700 0 000 18 10 400 000 1 000 1 000 1 000 1 000 1 000 950 00 1 000 36 420 166 700 Gain Lossin Gain Loss du
295. the Instrument Name drop down list Once the instrument is selected the system displays the Security Code Instrument Group Instrument Currency Settlement Currency and Exchange rate Step 3 Select the appropriate account no from the Account Number drop down list The Nominal amount is displayed on selection of the account number Step 4 The first step is to capture the date of sale transaction called transaction date and then fill up the settlement date The calendar for selecting the date has been provided adjacent to Transaction a Date field Click on the icon in order to open the calendar The system validates the date entered against the purchase date The user will be restricted to the extent of capturing a date before the purchase date The user is also restricted from capturing a future sale date Step 5 In the next step the user has to capture the Nominal Amount Price Interest Fee Commission and Tax and Other charges Once the Nominal Amount Is entered system displays the Quantity calculated as Amount Face Value The Quantity and Price fields are enabled only for Unit based instruments a0 ORACLE Step 6 Select the appropriate Counterparty name using the search icon Step 7 Enter the appropriate ref no in the Counterparty Ref No text box Step 8 Select the appropriate option for Asset Transfer Out field Step 9 Enter the order details if any in the Description text box Step 10
296. the Options ID field Search window appears Enter the appropriate search criteria in the respective fields to search for the Options ID Once the user selects the Option ID following fields are automatically get populated e Options Name e Options Type TUS ORACLE e Strike Price e Expiry Date e Instrument Currency e Settlement Currency The user can select the options instrument either by directly entering the id or by searching for the oF security using icon as explained in general characteristics section The security search screen displays only securities which are in open status and which are approved by the bank Securities which are suspended from trading will not be displayed in the search screen The user can view the Recommended instruments Focussed instruments House Views details and Instrument Analytics details by clicking on the respective icons next to the Security ID field as explained in General Characteristics section Step 4 Select the appropriate option from the Transaction drop down list Step 5 Select the appropriate transaction date Step 6 sa Select the appropriate issuer broker by clicking on the icon next to the Counterparty field Step 7 Enter the appropriate counterparty reference no Step 8 Enter the appropriate quantity in the Quantity field The quantity entered should be in multiples of regular lot size Step 9 Enter the appropriate value in the Premium Unit fiel
297. the Product Master aN ORACLE 5 3 2 Also while placing the STP order if the Close the Account flag is set to No then the system validates the Amount with the value entered in Maximum Amount field of STP Details pop up of Product Master for From Fund If the amount entered here is greater than the amount set up in Product Master system displays an appropriate error message In case of STP order if Close the Account option is set to No and if Units option is selected then the system validates the amount obtained by multiplying quantity with the Latest Trade Price of From Fund with the Min Amount of Buy Min First Purchase Amount for To Fund For example if the customer already has holdings in the To Fund and that folio is selected then the Min Amount of Buy of To Fund is validated However if the To fund has no holdings then Min First Purchase Amount of To Fund is validated against the amount obtained The system validates KYC check for Joint holders while placing the transfer order Once the user clicks on the Save button the system displays the message MF Order Placed successfully The above screen explains the fields gets displayed for payment option as Regular If payment option is selected as STP then the additional fields like Transfer Frequency No of Transfers Commencement Date STP End Date and Indicative Total Transfer gets displayed Tra
298. the appropriate spread value This is a display only field for unit based instrument Transaction Fee Displays the transaction fee for the selected transaction Treasury Total Amount It displays the amount calculated as Treasury Total Amount Treasury price Quantity Accrued Interest Customer Total Amount It displays the amount calculated as Client Total Amount Price to client Quantity Accrued Interest transaction Fee Profit Flat It displays the profit amount calculated as Profit Nominal Amount Customer Price Treasury Price Trade Fee Counterparty Name Enables the user to select the appropriate Counterparty Name Counterparty Ref No Enables the user to enter the appropriate ref no 5 73 ORACLE Field Description Mandator y Application No Enables the user to enter the Application No Y Description Enables the user to enter the description for the selected order if any Payment Details Payment Method Enables the user to select the appropriate method Y from the drop down list Bank Account No Enables the user to select the appropriate bank account no from the drop down list Cheque No Enables the user to select the appropriate cheque no from the drop down list Comments Enables the user to enter the comments for the selected order if any Procedure for Placing of an Order Step 1 Customer For a customer l
299. the new instrument name in the Name of Instrument text box Instrument Currency Displays the currency for the selected instrument Y Settlement Currency Display the settlement currency for the selected Y instrument Account No Enables the user to enter the account number Y Transaction Details Transaction Type Enables the user to select the appropriate option Y from Transaction Type drop down list Transaction date Enables the user to select the appropriate Y transaction date using the calendar icon Units Enables the user to enter the appropriate units in the Y Units field Price Enables the user to enter the appropriate price in the Y Price field Fees Enables the user to enter the appropriate amount in Tax amp Other Charges Enables the user to enter the appropriate amount in the Tax and other charges field 5 149 ORACLE 5 14 Field Description Mandator y Amount Displays the total amount of transaction For Buy Units Price Fees Tax amp Other Charges For Sell Units Price Fees Tax amp Other Charges Y Description Enables the user to enter the transaction details if any in the Description text box It is a free text box and allows the user to enter maximum 250 characters Exchange This field is enterable when the Instrument CCY is different from the Settlement CCY Enter the appropriate details in the Generic instrument Tra
300. the trading system and are only displayed by the FCPB Search aa oi After opting for the appropriate search option click on the button This will display all the orders in the chosen search criteria eee en Clear To change the filter criteria click on the button 4 The second tab displays all the orders placed during the current business day across all the instrument types for the selected criteria 5 From the time the orders are initiated to the time they are matched the trading system labels the orders at each stage with their corresponding status All the orders initiated by the users are said to be in open status till the moment they are transformed into any of the below given status The order statuses are displayed online in the Order Book Let us comprehend the various statuses displayed in the trading system Expired The orders which do not get executed at the exchange due to time out are displayed as Expired orders To comprehend this with uncomplicated words orders which are placed with time condition IOC or Day and fail to act in accordance will be automatically cancelled by the trading system Such orders will be identified as expired For a sell instruction on change of status of an order to expired the system will add back the corresponding quantity to the balance quantity of the security Obviously this addition of the quantity will be done to the security in the portfolio of the customer throug
301. the user has the alternative either to redeem an amount or redeem certain units For either of the options the system validates against the balance number of units or the value of the balance units available in the folio The value of the units is determined by considering the latest NAV available for the particular fund scheme oR ORACLE For multiple redemption orders initiated on the same business day for the same fund scheme folio number in a customer s portfolio the balance qty is validated by netting the current holding of the customer against the quantities in open status All the orders initiated by the users are said to be in open status till the moment they are transformed into any other status The different order statuses are discussed in the next section For E g Total Holding 1000 units Redemption Order units 100 Status Open Balance qty available for initiating sale Holding open qty 1000 100 900 If the Amount option is selected and if the Close the Account flag is set to N the system validates the amount with the maximum redemption limit rule established if any for the particular fund scheme These redemption limits are maintained by the administrator in the Product Master If Close the Account flag is Y then the system does not validate the amount with the maximum redemption limit rule In case of SWP order if the Close the Account flag is set to No
302. this field is displayed based on the Fee structure set up for given Client Segment and IAG e Total Amount It displays the amount obtained by adding Indicative Total Investment and Transaction fee If no fee is applicable the amount in this field is same as Total Indicative Investment If the selected instrument does not follow the Model asset allocation for the customer the system displays the message as Model asset allocation is deviated Do you want to proceed The user can click the OK button to continue If no risk score is defined for the customer then there will not be any model asset allocation and hence system will not display any message Step 10 The subsequent field Frequency gets enabled only for SIP payments The user needs to select the frequency monthly quarterly semi annually from the drop down list provided Let s say that the user has opted for a fund A with an investment amount of 500 with monthly frequency subsequently the effective monthly investment would be 500 Step 11 Similar to the Frequency field the next field Commencement Date also gets enabled only for SIP payments The commencement date is a pre determined date on which the SIP instruction would be executed by the fund house at a frequency defined by the user A ORACLE If the Frequency is selected as Weekly in SIP pop up of Product Master with few days mentioned in the select box and if the Investment Dates have
303. this point in the existing screen it was essential for the user to opt for a category dimension of analysis before proceeding to drill into the analysis This first tab in the screen providing the facility to opt for the category of analysis has been modified in Release 1 3 to include two additional fields Household and Portfolio Type The screen shot of the tab is as given below ategory Portfolio X Household David Smith v Portfolio Type Overall X Go Figure 3 37 Household screen The field Category provides the various dimensions of analysis as a list of values in the drop down field The field will default to the analysis dimension Portfolio The field household will display the names of each household member including that of the customer The names of the household member will be retrieved as captured in the screen Household By selecting a member from this list the user will be able to examine the chosen dimension of analysis for that particular member In addition to the names of the members and the customer the field will also provide an option Household The user can opt for this particular alternative to view the chosen dimension of analysis of the holdings spanning across the entire household The third field facilitates the user to select the type of portfolio for which he desires to view the chosen dimension of analysis This drop down field will display three options to the users as a list of values
304. ties through the FCPB Order Management System and which are in open status will not be considered while determining the quantity Display only 3 30 ORACLE Field Description Mandatory Total Buy Cost Buy Cost is the product of the buy price and quantity mentioned above Display only Current NAV The Net asset value or NAV is the current market value of a fund s holdings The NAV is calculated based on the total value of the fund divided by the number of shares currently issued or outstanding The market price for the funds will be received as online update from external data vendors In a scenario where NAV is not received updated in the system at end of day then system will consider the previous day or previous received NAV for valuation and analysis The Current NAV is hyperlinked on click of which the system directs the user to Portfolio Alerts screen to set up the alerts as per requirement The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation Display only Market Value Market value is the product of the NAV and quantity Display only Value Date Displays the date on which the NAV was received for determining the
305. ting the portfolio button The system prompts you wy ORACLE If the portfolio selected for deletion is Default portfolio the system will not allow the user to delete the same until some other portfolio is selected as Default The user is permitted to delete a portfolio only if there are no holdings in the portfolio and if there are no orders in open status orders waiting for confirmation from the external interface in the portfolio The fields have been briefly described below Portfolio Maintenance Field Description Mandatory Portfolio Name The portfolio name is displayed here Display only Portfolio Type The type of portfolio is available as an non editable field Display only Default The selected check box reveals that portfolio is a default portfolio Display only Portfolio Currency The currency of the portfolio is available as a display field Display only Portfolio Benchmark wy Click and select any other benchmark from the list of benchmarks available As mentioned earlier Benchmark is used for comparing performance Please note that as performance is computed during the End of Day process refer to the section on performance for further details the altered benchmark and its associated performance can be seen in the screen only after the End Of day process is completed Portfolio Description The user can change the description for the portfolio entered earlier
306. tion Management Helps to understand the order management and transaction management Chapter 6 Reports Helps to understand the reports 1 1 6 Conventions Used 1 2 This sub section explains the conventions followed in the preparation of the manual Text Description Example Illustration of the concept Additional comments or instructions F Search icon to search for the desired data Bold Letters Command buttons or important text The command button titles appear as they appear on the screen System Overview and Capabilities Wealth Management is one of the fastest growing areas in the banking industry Wealth Management services typically follow the cycle of financial planning portfolio construction amp execution portfolio administration monitoring and on going management of the overall wealth of the customer Growing population and increasing disposable incomes have necessitated Banks Financial Institutions and other Wealth Management Service providers to offer structured wealth management offerings to different customer segments ke ORACLE With the undeniable growth in the affluent and high net worth segments financial advisers and institutions offering wealth management services are demanding robust and scalable technology platforms to address the diverse needs of their clients The new generation of customers is more investment savvy and demand per
307. to Y in the Product Master The system also displays the draw down amount till date if the Commitment Amount Applicable field is Y Step 13 Enter the appropriate application no in the Application No text box Step 14 Enter the description in the Description text box if any Step 15 From the Payment Method drop down list select the appropriate payment method The available options for payment method are ECS Cheque and DD Step 16 From the Bank Account No drop down list select the appropriate account no Step 17 Enter the appropriate cheque no in the Cheque No text box Step 18 Enter the comments in the Comments text box if any Step 19 Click the Save button Once the user clicks on the Save button system displays the Exception displays pop up window if the order to be placed violates certain conditions such as e Selected instrument is not in Approved List e Selected instrument is not in Model Portfolio e Selected instrument is not in Recommended List e Deviation from Model Asset Allocation ue ORACLE Customers can self approve all the exceptions that has occurred while placing the order except the exceptions which are defined at level 99999 Structured Products Order Capture Sell User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios
308. to compute the holding details in PMS all the information regarding buy cost market value and transaction details will come as a feed from external source Market Value Market value indicates the value of the scheme as of Display the given valuation date and will be received as a only feed from external source Value Date Indicates the latest date of reception of the market Display price feed The system also displays the time at only which last market value was received 3 50 ORACLE View This field displays the links to Details and CA The links are available for all the securities in this tab The link Details enables the user to view the constituents of the scheme The screen shot of this screen and its fields have been elucidated below The link CA directs the user to Corporate Action screen to set the details for CA The action buttons will be disabled for a Customer viewing the securities held in a RM Managed Portfolio At the end of the tab the last row displays the sum of all the above fields in the portfolio preferred currency On clicking the link Details will result in the opening of a pop up window displaying the constituents of the scheme Screen 3 FLEXCUBE PRIYATE BANKING Microsoft Internet Explorer provided by i flex Instrument Name Instrument Type Currency Qty Buy Price Total Buy Cost Market Price Market alue Weresliced alue Date Reliance Equity INR
309. tomer get organized in accordance to the different instrument types and are displayed in the customer preferred currency This sorting of the holdings is done across all the portfolios of the customer For Example Suppose user have 2 portfolios RM Managed and Self Managed and securities held under each portfolio are as given below RM Managed Security Instrument type Units IBM Equity 200 oe ORACLE HSBC Global Opportunity Fund Mutual Fund 500 Self Managed Security Instrument type Units Walmart Equity 200 HSBC Global Opportunity Fund Mutual Fund 500 When you select the option By Instrument type the holdings data gets sorted and displayed as Instrument Type Units Mutual Fund 1000 Equity 400 Currently the following instrument types are supported by the system e Equity e Mutual Fund e Insurance e Commodities e Bonds e Generic e Portfolio Management Schemes e CASA e TD e Others e Structured Product e Specialized Product e Derivatives Futures and Options 5 Adjacent to the first table is a tab displaying the graphical depiction of the type of view selected by the user The user has been provided with the flexibility to view the graph either as a pie chart or as a bar chart This can be done by selecting the appropriate type of graph from the drop down list provided in this tab 3 72 ORACLE In the bar chart the y a
310. trator in the Reference Master Table Now when the user selects the option By Industry for your analysis all the holdings in equity get organized in accordance to the different industries and are displayed in the customer preferred currency This sorting of the holdings is done across all the portfolios of the customer 1 The tab adjacent to the second tab is a tab displaying the graphical depiction of the selected type The user has been provided with the flexibility to view the graph either as a pie chart or as a bar chart This can be done by selecting the appropriate type of graph from the drop down list provided In the bar chart the y axis represents the of total i e composition of an industry in comparison to the total composition of the customer s holdings in equity across all the industries This is arrived at by calculating all the associated amounts in the customer preferred currency The x axis names the different industries in which the customer has invested for his equity holding 2 For further analysis of the holdings in each industry you can click on the hyper link under industry in the first table An additional table will appear below which will provide further information and analysis about the securities held in the selected industry The detailed descriptions of fields are given below ee ORACLE Industry Field Description Mandatory Industry All the industries in which the equity
311. trument action type others in this tab buttons will be The screen Modify enables the user to update the disabled market price of the security The latest market price fora provided by the user will be utilized for the purpose of Customer valuation In the absence of the user providing any viewing information on the market price the system will consider the the acquisition price as the market price securities held ina The field also displays a link Sell for capturing all the RM sell transactions of the securities Managed portfolio On selection of any of the above links the system takes the user to the corresponding screens with pre filled information of the selected security 3 3 6 Structured Product Structured Products are synthetic investments specially created to meet specific needs that cannot be met from the standardized financial instruments available in the markets A structured product is generally a pre packaged investment strategy which is based on derivatives but which features protection of principal if held to maturity Screen Structured Products RM Managed Name HDFC Structured Product INR Total INR Sttl Nominal c Amount Accrued Buy Price Qty Total Buy Cost Market Price Biet 0 0000 0 000 30 001 100 30 011 100 30 001 100 Figure 3 13 Structured Products Valuation Screen 3 42 Market Value Commitment yalue Date Amount Quick Launch ORACLE Field Des
312. ts to see the funds actually held by the customer for the specific ULIP and further clicking on the fund name the user gets to see the actual sub holdings of that fund 3 3 5 Others The holdings in the securities which cannot be classified into any of the instrument types defined in the instrument master can be updated in Others Others RM Managed Name Total ag Asset Class Buy Price Market Value Value Date Quick Launch Figure 3 12 Others Valuation Screen Field Description Mandator y Name All the securities in the chosen instrument type Others Display and portfolio are displayed Each security in the tab has only a hyper link Click on the hyper link to view all the transaction executed in the security CCY This field displays the security currency Display only 3 40 ORACLE Field Description Mandator y Asset Class We have seen the classification of securities into the various instrument types Now let us proceed to comprehend the classification of the securities into a range of asset classes The different asset classes to be used by the bank can be identified and maintained by the administrator in the Reference Master Table Currently the following asset classes are defined in FCPB namely equity debt art real estate gems metals cash commodities and insurance All the securities which cannot be categorized into any of the above defi
313. tual Benchmark meets the criterion defined the alert is generated Portfolio Name The list of all the portfolios associated to the customer willbe Y displayed in this field The list will be available as drop down value for choosing Please note that for a customer login only the portfolios categorized as Self Managed and Held Away will be available in the drop down list Apart from the portfolios the user irrespective of whether RM or Customer will be displayed with an additional value Aggregate Portfolio in the drop down list Opting for this option will result in setting of an alert for the consolidated performance across all the portfolios of the customer paleo ORACLE Field Description Mandatory Returns This field captures the trigger criteria for the opted category and type of alert There are two field displayed against this field The first field has been provided to opt for the various mathematical conditions viz less than lt less than equal to lt greater than gt greater than equal to gt and equal All these options have been provided as list of drop down values for the user to opt The next field has been provided for the user to enter values Please note that the values denote in percentage The value captured in this field denotes the threshold limit for triggering the alert Let us understand this field with an exa
314. tuents of the holdings in the PM Scheme will considered as Indirect holdings and will be computed as elucidated above 3 86 ORACLE Field Description Mandatory Market value Market value is the product of the market price and quantity For the accounts held under the instrument type CASA and TD which are categorized under the asset class cash the most recent updated cash balance from these accounts will be considered as the market price Similar to the direct holdings the indirect holdings in equity and traded bonds will also receive price feeds from the external data vendors However for the other indirect holdings falling under the asset class debt real estate cash and others the market value would be based on of the asset value on the total value of the fund The system also provides the hyperlink to the Total Market Value giving the details of Unrealized Realized Gain Loss summary in Portfolio and Client Currency against each instrument with break up between Price and Currency impact Display only of Total This is the percentage composition of the market value of a security in an asset as compared to the total market value of the asset Please note the values are computed in the customer preferred currency Display only Buy Price QTY and Market Price columns remains blank for CASA and TD instrument types When the user clicks on the icon next to the asset c
315. ty Account field Step 17 After entering all the fields in accordance to the outline given in the above steps you can proceed Sa to click on the save S button On saving the holding you will be displayed with a confirmation message on the screen If the user changes your decision on updating the holding he she has the option to clear the entire a Clear details captured earlier by clicking on the button oD ORACLE 5 3 5 3 1 Mutual Funds Order Management Order Management for Mutual Funds Please note that though this section of user manual explains order management and capabilities of Mutual Funds instrument type but whether Mutual Fund order management UI and processing feature would be available to the bank or not depends on whether the bank s license entitles them to the Mutual Funds and Insurance Module and Order management module for Mutual Fund instrument type Description A mutual fund is just the connecting bridge or a financial intermediary that allows a group of investors to pool their money together with a predetermined investment objective The mutual fund has a fund manager who is responsible for investing the gathered money into specific securities stocks or bonds When you invest in a mutual fund you are buying units or portions of the mutual fund and thus on investing becomes a shareholder or unit holder of the fund Mutual Fund Order Capture Subscription User Access
316. ty ID field as explained in General Characteristics section The user can also view the instrument details available in the Generic Instrument Master by clicking on the Term Sheet hyperlink The Term Sheet pop up window appears as below sie ORACLE i FLEXCUBE PRIVATE BANKING CUST Instrument Details SP Txn Buy M E X Instrument Details Instrument Name UOB IB Market linked Plan Issuer UOB Instrument Currency SGD Settlement Currency INR Alternate Currency Singapore Dollar Face Value 10 00 Minimum Amount 500 000 00 Start Ref Date 01 12 2008 Underlying Asset Type Name Lifecycle Event Description The price at any point crosses a barrier of 1000 Instrument Mundra Port Ltd O o Key Parameters Contingent coupon Coupon Payout Details 10percent if the barrier is hit else 20 percent amp f Figure 5 19 Instrument Details Pop up Window Step 3 Select the appropriate Trade Date using the calendar icon Step 4 Select the appropriate Settlement Date using the calendar icon Step 5 Select the appropriate account type from the Account Type drop down list aag ORACLE Step 6 Select the appropriate account number from the Account Number drop down list Step 7 Enter the appropriate price in the Treasury Price text box Once the user enters the Treasury Price the system calculates and displays the corresponding YTM in the Treasury Yield This field is ena
317. type of transaction Buy Sell Asset Transfer In or Asset Transfer Out needs to be selected from the drop down list Step 5 The user also needs to select the appropriate settlement type from the Settlement Type drop down list For Buy transactions the system displays the settlement types as Receipt Free and Receipt Against Payment For Sell transactions the settlement types are Delivery Free and Delivery versus Payment Step 6 The user then proceeds to capture the purchase details of the holding The first step in this process is to capture the date of purchase The calendar for selecting the date has been provided adjacent to Transaction Date field Click on the icon a in order to open the calendar As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions The transactions in these portfolios can be backdated maximum till the customer creation date The user is also restricted from capturing a future purchase date Step 7 The user then proceeds to capture the settlement date It is obligatory for the user to capture data in this field for all traded bonds The calendar for selecting the date has been provided adjacent to Settlement Date field Click on the icon a in order to open the calendar The user will be restricted from backdating the settlement date prior to the purchase date Step 8 The user then needs to enter th
318. uctured product will come from external feed For the securities under the instrument type insurance others and non traded bonds the price is as per the last manual update The surrender value would be considered as market price for the securities under the instrument type insurance The system does the valuation of Proprietary Portfolios at different instrument prices maintain in the system If the instrument price for proprietary portfolio valuation is not available price is not available for any day then system considers the price available for customer portfolio valuation and displays the same Display only Market value Market value is the product of the market price and quantity The system also provides the hyperlink to the Total Market Value on click of which it displays the pop up giving Unrealized Realized Gain Loss summary in Portfolio and Client Currency against each instrument with break up between Price and Currency impact The system does not provide this price and currency impact break up for amount based FEE and Futures and Options instrument types Display only of Total Is the percentage composition of the market value of a security in the portfolio as compared to total market value of the portfolio Display only Profit Loss Is computed as the difference between the buy cost and market value Loss figures are displayed in RED color and are prefixed with a minus sign Display
319. uld be club into asset class equity whereas as others debt would fall into asset class debt Note that the currency for any security in the Instrument Master including the security denoted under the category others cannot be classified as others In such cases the relevant instrument currency is indicated as the currency of the security The basis for this is in order to accomplish multi currency accounting at Security portfolio as well as at the customer currency the relevant exchange rates are required between all the three levels By defining the currency as others the currency conversion would be abridged 3 82 ORACLE Field Description Mandatory Please note that the ability and frequency to provide updated information on the constituents of the mutual fund are dependent upon the providers of data Hence any delay of data would result in display of obsolete figures by the system Lets understand this further with the following example AIM Japan Report fact sheet has provided the information on 60 holdings information in its constituents Tokyo Motor and cash The administrator is required to classify the balance 40 under the category others Name Asset Class Holding Tokyo Motor Equity 49 81 Cash Cash 10 19 Others Others 40 Now consider the fact sheet has provided additional information that equity asset class constitutes 80 of the above fun
320. unterparty Name for the transaction Counterparty Ref No Enables the user to enter the transaction reference N number Description Enables the use to enter the transaction details if N any in the Description text box It is a free text box and allows the user to enter maximum 250 characters DP ID Client ID Displays the list of depositories and Client id Y Procedure for Placing of an Transaction Step 1 The system auto populates the name no and default portfolio name of the customer which is already in context Step 2 For a customer login the Portfolio Name populates the Self Managed default portfolio followed by other portfolios in alphabetical order Select a portfolio Step 3 TA ORACLE Click the y icon next to the Instrument Name field ra Once the user clicks on the icon Instrument Search pop up window appears Enter the appropriate search criteria in the Name field to search for the Instrument Name Once the user selects the Instrument Name following fields automatically populates e Instrument Currency e Settlement Currency e Measured Units Step 4 From the Transaction Type drop down list select the appropriate Transaction Type The options available are Buy and Sell Step 5 Click the E icon next to Transaction Date and Settlement Date fields and select the appropriate transaction and settlement dates Step 6 Enter the appropriate quantity in the Quantity field
321. unterparty for the transaction FAC Counterparty Ref no Enables the user to enter transaction reference Based on number FAC Description This text box will capture any specific details for the order that the user would like to input Account Details Debit Account Enables the user to select the appropriate Value Y displayed should have A C no suffixed with the currency For example 12345 USD Credit Account Enables the user to select the appropriate Value Y displayed should have A C no suffixed with the currency For example 12345 USD Comments Allows to capture user remarks before saving the Y N Procedure for Placing of an Order Step 1 For a customer login the Portfolio Name defaults to the 1st Portfolio name in alphabetical order of Portfolio type Self Managed Step 2 Click the a If Check Certificate for Source is set to Yes in Instrument Type Master screen then the system checks for certificate and its expiry If it is set to No system does not check for the certificate and allows the user to proceed further Step 3 Click the a icon next to the Currency Pair field 5 139 icon next to Source Code field and select the appropriate Source Code ORACLE When the user clicks on the a icon next to the Currency Pair field Instrument Search window appears Enter the appropriate search criteria in the respective fields to search for the future instrument The instrument search screen displays only se
322. updation and performance computation Insurance Order Management for Insurance BSricase note order capture UI and processing feature would be available in FCPB only if the bank s license entitles the bank for Mutual Funds and Insurance module and Order Management module of FCPB oe ORACLE Insurance Order Capture User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen opace POSA Figure 5 16 Insurance Order Capture Screen Screen Navigation After logging into the system select Order Management gt Insurance gt Order Capture Rules for Commencement of an Order Insurance orders can be placed only for customers in active status The rules for placing the Insurance order are e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order Field Description Mandatory Customer Details Customer No Enables the user to select the customer by clicking on Y the search icon available next to the Customer No field Customer Name Displays the Customer Name for the selected Y Customer No
323. urance The user also has an additional facility to categorize all the holdings which cannot be sorted into any of the above defined asset classes into the category others It is also imperative for us to recapitulate our understanding on the rudiments of the types of portfolios defined in the FCPB All the transactions for the instruments defined under the category Others can be captured by the user into any of the portfolios The consideration for allowing the user to capture his her holdings in the Held Away portfolios though these holdings have not be acquired through the FCPB is due to the perception that these holdings could have been obtained through any other system within the bank As the transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions Currently there is no restriction on the user in sequencing the backdated transactions The system will automatically sequence the transactions as per the date of execution as entered by the user Other s Transaction Management Buy User Access levels Customer Can capture the transactions only for available portfolios There are no restrictions on the either of the users for updating the holdings in either the RM or customer created portfolios es ORACLE Screen Fors cera Figure 5 26 Other s Transaction Management Screen Screen Navigation After logging into the sy
324. ures of order management UI and processing would be available to the bank only if the bank s license entitles them to the Alternative Investments Module and Order Management module Commodities Order Capture Buy R ORACLE User Access levels Customer can place orders for RM Managed Self Managed and Discretionary portfolios The Portfolio Name field will display the list of Self Managed RM Managed and Discretionary portfolios based on the set up done for each portfolio type at the Admin level Only portfolios of that type will appear in the drop down for which Allow in OMS Customer is set to Y Screen ORACLE PERDUE rrr Onder Mgmt gt Commodity gt Order Capture Figure 5 27 Commodity Order Capture Screen Buy Screen Navigation Entry to the screen Option 1 Select the Order Management option on the main menu gt Commodity gt Order capture Rules for commencement of an Order The rules for placing the Commodities order are e Orders can be placed only for customers in active status e The bank account information of the customer also needs to be updated in the FCPB prior to initiating an order Field Description Mandatory Customer Details Portfolio Name Displays the list of the portfolio names for the Y customer ie ORACLE Field Description Mandatory Commodity Instrument Details
325. user navigates to the Order management or Transaction management screen This depends on the way portfolio type maintenance has been set up The action buttons will be disabled fora Customer viewing the securities held ina RM Managed portfolio Equity Corporate Action User Access Level CUST The person who is logged in as Customer can add modify the details of Corporate Actions announced by the companies institution Customer login allows to add modify the corporate action details only for Self managed Portfolio 3 23 ORACLE Screen E aa Figure 3 6 Equity Corporate Action Screen Screen Navigation After you login as CUST user select Portfolio Maintenance gt Equity and then click on the CA hyperlink Field Description Mandatory Customer Details Portfolio Name Displays the portfolio name Y Security Details Security Name Displays the name of the security for Y which the CA has been declared Currency Displays the currency of the of the Y security for which the CA has been declared Settlement Currency Displays the currency of the security for Y which the CA has been declared DP ID Client ID Displays the default account id for the Y customer in context 3 24 ORACLE Field Description Mandatory Corporate Actions Type Enables the user to select the appropriate CA type from the Type drop down list Record D
326. usuuientheuttestebevienessasusotueputestsduvteas 5 147 5 13 1 Generic Instruments Transaction Processing 1 1 ccscccscessessseeseeeeceseceecusecusecaecaeeeseeeseeeseeeseensensees 5 147 DIA ICOMMON ORDER BOOK sepsescisd cece een askean ese eTA tad EEEE EREE EEEE EEEE 5 150 Ae e e E saaptccepwesdesdsscsececsteseotesueseceepeesty 5 156 9 16 BANK A C AND EOANS SCREEN piisaa ori inne a E EE ERE E REEERE 5 158 ITOR REPORTS O E A E E A A A E O TE 6 1 6 1 INTRODUCTION s ccsesscscvsectcacvseseti coieceescoawsteacusectescosesedacuieeccscosesteacuaccsea dosvssei RETETE ERARE EREEREER 6 1 6 1 1 Reports Rep sit t ysr ene E EE EEn EEEE EAEE AE ARE TAEA AE EEEO EE RA 6 8 ORACLE 1 1 1 1 Preface Introduction The objective of the current user manual is to clearly describe and document the functions of the system from the customer perspective The current User Manual serves the following purpose related to Customer tasks 1 It represents the entry point into the system from the end user s angle 2 Provides a chronological and complete view of all the information necessary to understand and use the system within the user environment It thus serves as a hand book that instructs the user how to access the system run programs correct mistakes and solve typical problems 3 Identifies the tasks which must be carried out by the user in using the system the objectives of those tasks and the main deliverables which signify successful completion of e
327. utomatically populated with the corresponding information e Security Code e Instrument Currency e Settlement Currency e Custody Fee e Instrument Group e Last Traded Clean Price e Exchange e Nominal Amount Held e Quantity Held Step 6 Select the appropriate Trade Date using the calendar icon Step 7 Select the appropriate Settlement Date using the calendar icon Step 8 Select the appropriate order type from the Order Type drop down list Step 9 Select the appropriate time condition from the Time Condition Type drop down list mee ORACLE Step 10 Select the appropriate account type from the Account Type drop down list Step 11 Select the appropriate account number from the Account Number drop down list Step 12 Select the appropriate account number from the Account Number drop down list Step 13 Enter the appropriate price in the Treasury Price text box Step 14 Enter the appropriate price in the Customer Price text box Step 15 Enter the appropriate spread amount in the Spread text box if the selected instrument is amount based instrument Once the Treasury Price Customer Price and Transaction Fee are entered the system calculates and displays the Treasury Total Amount and Customer Total Amount Step 16 sa Select the appropriate Counterparty using the icon next to the Counterparty Name field Step 17 Enter the appropriate reference number in the Counterparty Ref No text box Step 18
328. ve portfolio The users of the system viz the RM and the customer have no restriction on the quantity of alerts maintained by them and hence can set up unlimited number of alerts Once the alert criteria or condition is met the alert will be displayed either on the dashboard of the user or sent as an email depending on the option opted by the user Each alert has a validity associated to it Five days prior to the expiry of the alert a message indicating the expiry of the alert will be presented on the dashboard of the user Please note that the expiry will be displayed as a system alert Such expiry messages will have a hyperlink beneath the message On clicking the hyperlink the user will be automatically guided to the alert maintenance screen In the alert maintenance screen all the alerts which are due to expire will have the expiry date in the column Expiry of the first display tab highlighted in red color The expiry date is displayed with the hyperlink The user can renew the alert by clicking on the hyperlink when selected the alert will be renewed for an additional validity period as defined by the administrator for the corresponding type of alert The screen will get refreshed and new expiry date for the alert will be displayed Failure to renew the alert will result in the deletion of the alert from the system after the expiry date Let us now proceed to understand each field displayed in the screen For ease of the readers each
329. veral currencies displayed in the list The Portfolio Currency is the currency in which the portfolio is valued in which realized Gain Loss are computed and reported Once the Portfolio Base Currency is selected for a portfolio you cannot change it later to another currency The reason for this restriction is that all exchange rates would have to be changed for all transactions and valuations in the portfolio if the Portfolio Currency is changed 3 6 ORACLE Field Description Mandatory Portfolio Benchmark Click d and choose a benchmark from the list of benchmarks available Benchmark allows the user to compare performance of the portfolio versus performance of selected benchmark indices The indices displayed in the search screen are market indices eg S amp P 500 which are maintained by the administrator The user can choose the Composite Benchmark while adding new portfolio Y Model Name Enables the user to select the appropriate asset allocation model from the drop down list for the portfolio in context The drop down displays the list of the model portfolios that belongs to the same client segment as that of the logged in customer Portfolio Description Multi line text box where you can enter a description for the portfolio Mode Of Operation The user can set up each portfolio by choosing a valid mode of operation from the list of values available Po
330. w the advice for each of the transaction entered into the system by clicking on the View Advice hyperlink in the pop up that appears on click of respective instrument type hyperlink The advice generated is different for POA and non POA Customers and is based on the value of Power Of Attorney flag set at the customer level These advices are sent either through fax SMS or through e mail communication mode The advices are getting generated for all types of instruments The system does not generate the advices for proprietary portfolio If any modification is done to the existing transaction then the system generates the revised advice with revised values Please note that every time user accesses the portfolio maintenance screen through the main menu it will result in renewal of the valuation with the current market price of the securities This would consequently display renewed valuation for the instrument as well as that for the portfolio ae ORACLE This tab also facilitates in the initiation of transactions for all the holdings across all the instrument type Before proceeding to understand on the subject of Order Management as delineated in FCPB it is necessary for us to summarize our understanding on the different types of portfolios defined in the system The customer has the option of creating multiple portfolios under the type Self Managed and Held Away Self Managed portfolio is supposed to be managed by the customer indep
331. when the user clicks on the Calculate button the system displays the Risk Profiler screen with Recommended Asset Allocation and performance of the model portfolio associated with the risk score with different set of messages as mentioned below User Access levels Customer can access the Risk Profiler screen to view the Recommended Asset Allocation and performance Screen an ORACLE 2 8 e Figure 2 8 Risk Profiler Screen If there are instruments for which customers have holdings but no records in the Price table For such instruments the system does the following e Check and list the instruments for which there is not even a single price record but customers have holdings e For such instruments system checks for transactions across the customers e Pick the latest transaction from the above list and assign the transaction price as the instrument price even if it is across a month e This price is used to update the price history table through historization process Product Search Description The Product Search feature of FCPB enables the user to search for the desired products available in the system using various filters The search result displays the products qualifying the given search criteria along with the instrument related details like factsheets analytics data price movements etc User Access Levels Customer can access the Product Search screen Screen ue ORACLE 2 9 Returns 0
332. wo parties to buy or sell an asset at a certain time in the future at a certain price It is an agreement between the buyer and a seller for the purchase and sale of a particular asset at a specific future date The price at which the asset would change hands in the future is agreed upon at the time of entering in to the contract The actual purchase or sale of the underlying involving payment of cash and delivery of the instrument does not take place until the contracted date of delivery A futures contract involves an obligation on both the parties to fulfill the terms of the contract ak ORACLE 3 58 ORACLE Screen Fules RM Managed Name ExpDate CCY Account Number Price Buy Sell Of open contracts Amount Market Price Market Value Total INR Long Short 1 010 000 11 020 000 Figure 3 22 Futures Valuation Screen Value Date Action Field Description Mandatory Name The field displays the Futures Instrument type Display only Exp Date The field displays the Exp Date of the Futures Display contract only Instrument The field displays the instrument currency Display Currency only Settlement The field displays the currency in which Display Currency settlement took place only Account Number The field displays the Account Number for the Display future only Price Buy Sell The field displays the price of the future Display only No of open The field displays number of the op
333. xis represents the of total i e composition of an instrument type in comparison to the total composition of the customer s holdings across all the types of instruments across all his portfolios This is arrived at by calculating all the associated amounts in the customer preferred currency The x axis names the different instrument types held by the customer 6 For further analysis of the holdings in each instrument type you can click on the linked instrument name in the table An additional table will appear below the first table which will provide further information and analysis about the securities held in the selected type of instrument In the above example on selecting the instrument type mutual fund the holdings in the HSBC Global Opportunity Fund in both the portfolios will be collectively displayed as 1000 units Understanding the Screen Both the screens on Analysis By Portfolio and By Instrument Type are similar and so are the fields in both the screens As the screens differ only in some of the validations please refer to the description in the section on By Portfolio for the common features and computation methodology The distinctive field features are indicated below Instrument Type Field Description Mandatory Instrument All the types of instruments encompassing all his Display Type holdings across all the portfolios of the selected only customer are displayed Each type of instrument
334. xt field Dividend provides the user with the option to select either of the options Dividend payout or Dividend reinvest Please note that it is not essential that all the fund schemes provide both the options on dividend The options will be made available to the user to select based on the alternatives offered under a particular fund scheme ee ORACLE Please note it is obligatory for the user to capture both the folio number and the dividend option Step 7 Select the appropriate option from Payment Option drop down list The options available are Regular and SIP The screen will always default to the option Regular Step 8 Select the appropriate option for Asset Transfer In The user can place Asset Transfer In transactions through this screen The Asset Transfer In ATI type of transaction allows the customer to transfer the securities to current wealth management system and reflect the holding in the active portfolio By default No option is selected Asset Transfer In transaction is not allowed in Discretionary type portfolios Step 9 The user then proceeds to capture the purchase and settlement date The calendar for selecting the date has been provided adjacent to respective fields Click on the icon BE the calendar in order to open As these transactions have been carried out outside the FCPB system the user has been provided with the flexibility to capture backdated transactions The system puts an addit
335. y Dropdown On navigation of mouse pointer to field system should display tool tip If Value selected in Dropdown is Paid tool tip should read as Interest Paid If Value selected in Dropdown is Received tool tip should read as Interest Received Commission Allows user to enter the commission Fee Enables the user to enter the appropriate fee Exchange Rate Enables the user to enter the appropriate exchange rate when instrument CCY is different from sett CCY Tax and Other Enables the user to enter the appropriate tax and Charges other charges Amount Displays the total transaction amount Once the user Y enters the Nominal Amt Quantity and Price Unit fields system auto populates this field Commitment Amount Displays the commitment amount of payment for the Y selected instrument when the Commitment Amount Applicable is Yes for the instrument Asset Transfer In Enables the user to enter the appropriate option for Asset Transfer Counterparty Name Enables the user to select the appropriate counterparty name who executes the transaction Counterparty Ref No Enables the user to enter the Counterparty Ref No in the text box provided This is a reference number usually assigned by the external service provider Description Enables the user to enter the transaction details if any in the Description text box It is a free text box and allows the user to enter maximum 250 characters
336. ype equity debt or Mutual Fund The constituents of the PMS are customer specific and will be received as an external data feed from the issuer of the scheme Whereas the sub constituents of securities under the instrument type Mutual Fund will be reinstated as elucidated below The system also assumes that any restructuring in the constituents of the PM Scheme will be updated on continual basis through a data feed The details of the composition of the constituents of the Mutual Fund or the Structured product are published by the fund house or the issuer of the Structured Product Ideally the composition of the Structured product does not change till its maturity However in the case of Mutual Fund the constituents are constantly restructured and published in Fact sheets Fact sheets provide handy information on the current price of the instrument NAV Net Asset Value repurchase sale price and the break up of the instruments constituents Some Fund Houses and the issuers of the Structured product confine the constituent s information by revealing partial information For instance the fact sheet providing only the asset class information on the constituents and its composition For such scenarios the administrator will categorize the constituent as others and suffix the asset class name to it Such securities would be clubbed into their corresponding asset class as specified by the administrator For instance others equity wo
337. ystem auto populates this field Region Displays the region for the selected country Once the user selects the country system populates the region for that country If the user opts for the existing instrument system auto populates this field Instrument Group Displays all available Instrument groups in the drop Y down list If the user opts for the existing instrument system auto populates this field Transaction Details Transaction Date Enables the user to select the appropriate Y transaction date using the calendar icon Currency Enables the user to select the appropriate currency Y from the drop down list If the user opts for the existing instrument system auto populates this field Amount Enables the user to enter the appropriate amountin Y the Amount field Amount Amount Fees Tax amp Other Charges es ORACLE Field Description Mandator y Fees Enables the user to enter the appropriate amountin N the Fees field Tax amp Other Charges Enables the user to enter the amount paid as N transaction tax in the Tax field Description Enables the user to enter the information related to N transaction in the Description free text field Rules for Capturing a Transaction e Transactions can be captured only for customers in active status e For capturing a transaction the customer should have at least one of the portfolios coupled to his her id Procedure for Capturing a Tr

Oracle FLEXCUBE Private Banking

Contents

Download Pdf Manuals

Related Search

Related Contents