1. Secondary Loan Trading
  2. Maintaining Details Specific to SLT
  3. Portfolio Details Maintenance
  4. Creating Portfolio IDs

2.6.1 Creating Portfolio IDs

Oracle Banking Corporate Lending automatically creates the Portfolio details whenever system receives a new Firm Account Mnemonic from e-sales.

System derives the Portfolio ID and other details using the following logic.
  • Based on the MCC received from e-sales, system derives the following fields that are used to setup the portfolio. For non-CFPI cases too, e-sales sends MCC, and that MCC is used to compare with the MCC mapping maintenance to derive the following fields:
    • Desk Code
    • Branch Code
    • CFPI (Yes/No)
    • Position Product
    If the MCC maintenance does not exist, then Portfolio creation is not done and an exception is logged for the same.
  • These identified details are used to create a Portfolio.
  • System creates a unique customer number for a Portfolio. A new customer is uploaded for every new Portfolio that is created.
  • Customer maintenance for this customer number is auto-authorized.
  • The following basic details are populated for the system created customer number.
    • Short Name: Firm Account Mnemonic
    • Name: Firm Account Mnemonic
    • Address Line 1: MCC code
    • GFCID is blank.
    • MEI code UDF for this portfolio is populated based on the MEI code that is mapped at the branch level for the resolved Branch Code based on the MCC mapping maintenance.
    • Country, Nationality and Exposure is populated with the country code maintained for the resolved branch code.
    • Customer Type: I
    • Source Code: CFPI
    • SIC Code: Firm Account Mnemonic
    • US_PAY_ID_TYPE: N
    • Once Auth: Y
    • FX MANUAL LIQD: N
    • Disallow Changes: N
    • AML Required: N
    • Record Status: O
  • Portfolio maintenance is created using the above details.
    • Portfolio- System generated new Customer Id
    • Desk- Resolved based on the MCC mapping (as described above)
    • Branch- Resolved based on the MCC mapping (as described above)
    • Firm Acct Mnemonic- This is populated with the firm account mnemonic for which the portfolio is being created (For both CFPI and Non-CFPI portfolios).
  • The details for the Portfolio for the other fields are defaulted as below:
    • Default Portfolio- Not selected
    • Costing Method- WAC
    • Interface Type- Internal
    • Position Product- Is picked from the MCC maintenance
    • Reval Reqd- Yes
    • Reval Frequency- Daily
    • Reserve Calculation Reqd- No
    • Auto Generate Position Identifier- Not selected
    • Position Identifier Format- Blank
Portfolio Id Maintenance is auto-authorized with SYSTEM as the user Id.

Note:

  • Portfolio creation happens only if the firm account mnemonic is being received for the first time to Oracle Banking Corporate Lending.
  • If it is an existing firm account mnemonic and updated details are received for the same, then no action is taken in Oracle Banking Corporate Lending for such cases.
  • The Portfolio Id’s once created systematically reside in the system. No systematic updates happen on these portfolio Id’s for any subsequent updates.
  • If the portfolio has to be closed/amended, user should initiate it from the portfolio Id maintenance screen, as per existing functionality.
  • The existing functionality for user to create portfolio, maintain firm account mnemonic – expense code mapping, create new customer, and so on all continue to function as it is, with only the automation process newly added as summarized in the approach.
  • While creating a new position, system populates the firm account mnemonic. For existing positions, one-off conversion script to link all the existing positions with a firm account mnemonic is taken up as an implementation exercise.

Parent topic: Portfolio Details Maintenance