5. Importing Bulk Client Information

The AMC may need to import information relating to investor accounts and investor transactions from an external source or client, into its database. The volume of information that is imported in such cases is usually very large.

The external source or client, in such cases, is called a bulk client. The information is usually handed off in flat files, ASCII text or any other text format. The ‘import’ of this information means updation of the AMC database (with the information that is found in the hand-off files) so that the AMC database may reflect the import information. All necessary validations for the successful updating the database with the imported information are performed during the import.

The Oracle FLEXCUBE Investor Servicing (FCIS) system enables the AMC to import information in bulk, from an external client, relating to any of the following:

The import can be performed using the generic interface or bulk interface facility.

This chapter contains the following sections:

5.1 Process of Importing Bulk Client Information

To import information from bulk clients and process the same in the FC-IS system, you must:

For a fuller discussion of each of the steps, refer the following sections under the appropriate heads in this chapter:

You can understand the process from the following illustration:

5.2 Bulk Import Clients Setup

The client from whom bulk information needs to be imported must be introduced into the FC-IS system. You can do so as follows:

  1. Identify the external client (called the bulk client) in the system by providing a profile for the same. You can do this using the Bulk Clients Maintenance screen. Access this screen through the Bulk Clients Defaults menu Browser.
  2. Set up the information that would be used as default for import of any information from the bulk client. If the import information files from the client do not contain the required data, then the default information maintained for the bulk client in the FC-IS system is used to furnish the same.

To set up the default information for a bulk client, use the Bulk Clients Defaults Maintenance screen. Access this screen through the Bulk Clients Defaults option in the Browser. Click new icon to enter the details.

The following considerations must be borne in mind when you set up the default information for a bulk client in the Bulk Client Default Maintenance screen:

Note

    • If any mandatory information required in the FC-IS system is not found either in the import hand off file, or the defaults maintained for the client, the entire import fails and the import records are rejected.
    • Each file that needs to be imported from the bulk client into the system for all the information set has a specified format. If the file is formatted in any other way than prescribed in the required format, then the import will fail and all the import records will be rejected.

The prescribed formats for the hand-off files from the bulk client that are to be uploaded are found in the chapter ‘Appendix B – Upload File Formats B’ of the ‘Upload Format’ User Manual. Refer the same for complete information about the file formats.

Note

    • The default information that you maintain for a SMDPARAM’ bulk client in the Bulk Clients Defaults Maintenance screen contains the defaults for all the different types of data imports – unit holder new accounts, information change, transactions, unit holder income distribution setup, standing instructions, transaction load overrides, fund prices, Unit Holder Deal uploads, broker details, check book requests, fund rules and redemption checks.
    • When the import of data is performed by the system, the validations for the imported data are performed in the same manner, as they are applicable when you set up the default information for the bulk client in the Bulk Client Defaults Maintenance screen.

5.3 Interfaces for Import Setup

After you have set up the client from whom the bulk information is being imported, you must set up the interfaces in the system that will actually drive the import according to the frequency at which it is required to run.

Note

You need to set up the following interfaces:

You can set up all the interfaces through the Interface Maintenance screen that is invoked by clicking the Interface Maintenance menu item in the Maintenance menu item of the Fund Manager component.

5.4 Import Interfaces Schedule

This section contains the following topics:

5.4.1 Scheduling Import Interfaces to be Executed

After you have set up the interfaces that will drive the import of information from an external client, you must schedule their execution, so that the imports can occur according to a pre-defined frequency, without manual intervention.

You must schedule all the three interfaces that have been set up for the import of bulk information. You can do this as follows:

Note

Initially, at the first instance when the interfaces are scheduled, they are associated with the pre-defined tasks in the Scheduler Services Task Maintenance facility. The implement­ers at the installation will perform this activity. Subsequently, the administrator at the in­stallation would perform any change to the task.

Refer the section ‘Setting up jobs for interface-related tasks’ in this chapter to understand how to set up the jobs in the Job Maintenance screen.

5.4.2 Setting up Jobs for Interface-related Tasks

Setting up a job for the import of unit holder information

To set up a job for the import of new unit holder accounts and information change accounts,

Note

Whenever this job is executed, the system creates an event for the execution and inserts it into the event log. Now, the system is ready to perform the other imports, using this one as a trigger for the execution of all the other import as well.

Setting up a job for the import of all information other than unit holder information

To set up a job for the import of new or amended transactions, income distribution setups and standing instructions for unit holders, load overrides for transactions and fund prices for transactions, proceed in the manner described below.

Note

Typically, the import of any information other than unit holder information is performed af­ter the successful import of unit holder information. Accordingly, when the unit holder im­port job is executed, the system creates an event (‘BulkUH’) for the execution and inserts it into the event log. Now, the system is ready to perform the other imports, using this as a trigger for the execution of all the other imports.

Setting up a job for the export of records rejected during import

To set up a job for the export of records that are rejected during import, proceed in the manner described below.

Note

Typically, the import of any information other than unit holder information is performed af­ter the successful import of unit holder information. Accordingly, when both the import jobs have been executed, the system creates an event (‘FAILEDRECS’) for the execution and inserts it into the event log. All records that have failed the imports are also identified and stored in the database, for the purpose of exporting. The system is now ready to perform the export, using the completion of the two imports as a trigger for the execution of the ex­port.

Refer the Interfaces User Manual in FC-IS system for a fuller discussion of the Job Maintenance screen.

5.5 Imported Bulk Information

This section contains the following topics:

5.5.1 Processing Imported Bulk Information

After you have set up the Scheduler Services to automatically perform the upload of bulk client information, the import and processing of data will proceed according to the defined frequencies.

The import of each file containing bulk client information is given a unique Process ID. The export of rejected records corresponding to the import is likewise is given a unique Process ID. Therefore, the Process ID is unique for each file that is imported or exported.

The job that you have set up for the automatic execution of the imports will trigger processes that:

Note

The validations for the imported data are performed in the same manner, as they are ap­plicable when you set up the default information for the bulk client in the Bulk Client De­faults Maintenance screen.

5.5.2 Bulk Import Processing Workflow

After you have set up the import interfaces and scheduled the imports, the system automatically performs the import and the processing of imported information in the following sequence:

Note

Sequences 1 and 2 are performed by the execution of interface definition you have set up for the unit holder import. Sequence 4 is performed by the execution of the interface defi­nition you have set up for the non-unit holder information import. Sequence 6 is performed by the execution of the interface definition you have set up for the export of rejected re­cords.

The flow of sequences is illustrated in the following diagram:

5.6 Errors during Import or Processing of Client Informa­tion

If any error occurs during the import of unit holder information or the processing of the same, then the ‘BulkUH’ event is not raised by the system. Since this event is the trigger for all remaining bulk import processes, all subsequently scheduled imports and processing will terminate.

Errors occurring during import of bulk information or processing of the bulk interfaces could be due to:

The errors are logged into the interface error log tables. The interface log will display the success or failure of the interface process, and the detail log displays the details of the errors.

When the export of rejected records are triggered by the raising of the ‘FAILEDRECS’ events the reporting of logged errors are also triggered. The details of the errors can be obtained in an Excel worksheet for printing.

When a bulk interface process is terminated abnormally for reasons other than errors relating to imported data, the system maintains the status of the terminated processes as ‘In-process’ or ‘Running’. The End of Day process checks for the completion of these processes, and they can be cleared manually.

5.7 Bulk Account Clients Maintenance

This section contains the following topics:

5.7.1 Invoking Single Entity Maintenance Detail Screen

You can enter the record of a client for whom the bulk import facility would be used, into the system, by creating it as an entity.

You can set up a bulk client in the ‘Single Entity Maintenance Detail’ screen. You can invoke this screen by typing ‘UTDENTMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

To set up a bulk client, select the Bulk Client option from the option list in the Entity Type field in the General Information section, and then proceed to enter the details for the bulk client. You must specify all information such as the common information, basic information and contact details for any bulk client that you set up.

You must also capture the following additional details specifically for a bulk client:

 

Only those fields specific to bulk clients are detailed here.

Refer the chapter ‘Maintaining Reference Information’ of FC-IS system for a discussion of the other fields common to all entity type.

Other Information Section

Customer Interface Key

Optional

This facility is to be used if customer information from an installation of Oracle FLEXCUBE Corporate (FCC) is to be imported into the FCIS system using the bulk interface facility, for the creation of unit holder accounts. The drop-down list displays the following values:

The customer interface key determines the level at which unit holder account creation must take place in the FC-IS system, for a given Customer Information File (CIF) in Oracle FLEXCUBE Corporate – either at CIF level or at a customer account level. Accordingly, you can indicate either of the following two options:

The FC-IS system will create corresponding unit holder accounts when the customer information is imported from FCC, according to option you exercise in this field.

Note

If you select either FCR or FCC as the Bulk Client Type, then you must specify the Cus­tomer Interface Key as mandatory information.

Bulk Client Type

Optional

Select the type of client from which information is to be imported using the bulk interface. This could be any of the following:

Online Interface

Optional

This facility is also available for imports of customer information from FCC. It allows you to control the uploading of customer information from FCC into the data stores in FC-IS.

Print Rejected Imports Report

Mandatory

Select ‘Yes’ if a report consisting of a list of rejected imports along with the reason for rejection must be printed by the system. If not, select ‘No’. By default, this field contains a ’Yes’ value.

Print Successful Imports Report

Mandatory

Select ‘Yes’ if a report consisting of a list of successful imports along with the other details must be printed by the system. If not, select ‘No’. By default, this field contains a ’Yes’ value.

5.8 Bulk Clients Defaults Maintenance

This section contains the following topics:

5.8.1 Maintaining Bulk Client Default Information

You can use this screen to map the default values for all information that must be applicable during bulk information import for a particular bulk client, for a particular AMC or Distributor.

For any import from any bulk client, the information specified in the hand-off file will be accepted and imported as part of the imported record, even if a specification exists in this screen for the same field or column name. Any information that is not specified in the hand-off file will be picked up from the specifications you make in this screen.

You can maintain default information for bulk imports relating to:

You can invoke this screen by clicking the Detail option under the Bulk Client Defaults menu in the Browser. Click new icon to enter the details.

5.9 Default Information for Bulk Client Imports

This section contains the following topics:

5.9.1 Maintaining Default Information for Bulk Client Imports

In the Bulk Client Defaults Maintenance screen, you can maintain default information for bulk imports from a bulk client, to be applicable for a distributor institution. The specifications you make in any of the fields here, for each upload type, are accepted as the default values for the corresponding field or column name, for all bulk imports where the hand off files from the bulk client do not contain the corresponding information.

Accordingly, you must select the ID of the bulk client for whom the default information is applicable, in the Bulk Account Client Code field, and the AMC / distributor entity in the AMC / Distributor ID field.

For some of the upload types, the default information consists of fields from the corresponding maintenance in the system; therefore, the default information is very similar to a maintenance template or blueprint. For instance, when you define the defaults for fund rules import, you specify all the fund rules in the Bulk Clients Defaults screen. This is just like filling in the fund rules in the system for a new fund; validations for all fields are similar to those made in the Fund Rules screens when a new fund is entered.

The default information for each upload type is listed in this chapter; for field level information, you must refer the chapters in the user manual where the corresponding entry screen in the system is discussed.

5.9.1.1 Note on Scheme/ Cross Reference Number

The Bulk Client would wish to export, in the hand off files, a unique identifying number for each upload type that might be different from that of the Oracle FLEXCUBE generated identification. In such cases it is possible to set a reference between the Oracle FLEXCUBE identification and the unique identifying number given by the bulk client. To specify such a request, use the Scheme/Cross Reference Number field; for transaction and unit holder related data imports, and the Fund Scheme / Cross Reference Number for fund information related imports.

Effect of applying Scheme / Cross Reference Number

For example, the Credit Card Number of investors can be a uniquely identifiable value. In such cases the credit card number can be setup as an additional information and this field can be referred to here as a unique value by making it the Scheme/Cross Reference number column in the Bulk Client -AMC default maintenance. This means that when the unit holder import file upload is performed, the relevant Scheme/Cross Reference Number field will be populated with the value given in the import file.

Note

The Scheme/Cross Reference Number value should be given in the appropriate field po­sition in the import file. This is not applicable where the Scheme/Cross Reference Number is, itself, the Unit Holder ID (for transaction and unit holder related imports) or the Fund ID (for fund information related imports).

When the transaction import file upload is performed for the Bulk Client - AMC combination, the Unit Holder ID field value should contain the Scheme/Cross Reference Number value.

Note

The system will not validate for uniqueness if the same field is populated with duplicate values through the Unit Holder Additional Information Maintenance screen. It is assumed that such cross-reference numbers are populated only through import file uploads.

Scheme / Cross Reference Numbers for Transactions and Unit Holder Related Imports

Scheme / Cross Reference Number from additional information

The specification made in the scheme/cross reference number field will pertain to any one of the fields mentioned below and should be properly specified (in the relevant field position) in the import file given for unit holder new accounts. For example, if the Scheme/Cross Reference Number has been specified as the third additional information set, this information should correspond to being the AdditionalInformation3 field in the import file.

All the above fields are additional information that can be optionally set to capture additional data relating to the investor.

It is possible to set a restrictive list of values to be captured in the additional information value fields.

All additional information setup through the additional information master where the restrictive clause is not applied are considered to be free-format fields. These fields will be the candidates to be set as the scheme/cross reference numbers.

Scheme / Cross Reference Number as Unit Holder ID

If the Scheme/Cross Reference Number value is set the same as the Unit Holder ID, this means that the bulk client would supply the Unit Holder ID in all the file imports. If the Scheme/Cross Reference Number is another uniquely identifiable value then the relevant value should be specified in the import file. In such cases the system will map the Scheme/Cross Reference Number to Unit Holder ID and the transaction will be tagged to the relevant unit holder.

Scheme / Cross Reference Number as Unit Holder Reference Number

If the Scheme/Cross Reference Number value is set the same as the Unit Holder Reference Number, this means that the bulk client would supply the Unit Holder Reference Number in all the file imports. If the Scheme/Cross Reference Number is another uniquely identifiable value then the relevant value should be specified in the import file. In such cases the system will map the Scheme/Cross Reference Number to Unit Holder Reference Number and the transaction will be tagged to the relevant unit holder.

Scheme / Cross Reference Numbers for Fund Information Related Imports

For fund information related imports, the scheme / cross-reference number can be set as any of the following:

5.9.1.2 Specifying Generation of System Reference Numbers

It is required in the FC-IS system that the reference numbers be mentioned along with the unit holder new account details and the transaction details. If this option is specified, the system will generate reference numbers wherever the reference number field in the import file is empty.

5.9.1.3 Specifying Checking of Duplicates during Imports

You can choose this indicate that all the records that have duplicate Scheme/Cross Reference Number values should be rejected when the transaction or unit holder import file up-loads are performed. If this option is not chosen, the following processes would occur:

5.9.1.4 Specifying Generation of Authorized Data during Import

This option, if chosen, signifies which imported information sets would generate authorized records – fund rules, transactions, unit holder accounts, income distribution setup, standing instructions, fund price or transaction load override.

Redemption Payouts to Unit Holder Bank Accounts Only?

Optional

Check this box to indicate that, by default, it must be designated that for all unit holder accounts imported, redemption payouts are to be made to the unit holder bank account only.

5.10 Default Information for Fund Rules Imports

This section contains the following topics:

5.10.1 Invoking Default Information for Fund Rules Imports

You can invoke the FCIS Bulk Clients Defaults (Fund Rule) Detail screen by typing ‘UTDBLKFR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

5.10.2 Bulk Client Tab

Click ‘Bulk Client’ tab in ‘FCIS Bulk Clients Defaults - Fund Rule - Detail’ screen.

 

You must maintain the following default information for fund rules imports:

Bulk Clients

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the name of the selected bulk client code.

Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the selected AMC or Distributor ID.

Client Defaults

Fund Base Currency

Alphanumeric; 3 Characters; Mandatory

Specify the fund base currency.

Fund Country

Alphanumeric; 3 Characters; Mandatory

Specify the fund country code.

Fund Family

Alphanumeric; 6 Characters; Mandatory

Specify the fund family details.

Fund Type

Alphanumeric; 38 Characters; Mandatory

Specify the type of fund.

Minimum Holding Period

Numeric; 22 Characters; Mandatory

Specify the minimum holding period.

AMC/Distributor Id

Alphanumeric; 255 Characters; Mandatory

Specify the AMC or distributor ID.

Shares Characteristics Defaults

Scrip Based

Mandatory

Select the scrip based fund from the drop-down list. The list displays the following values:

Account statement frequency

Alphanumeric; 1 Character; Mandatory

Specify the account statement frequency.

General Operating Rules Defaults

Post Priced?

Optional

Select if the fund is post priced or not from the drop-down list. The list displays the following values:

Price Declare Frequency

Alphanumeric; 1 Character; Optional

Specify the price date frequency.

Ageing Policy

Optional

Select the ageing policy for the fund from the drop-down list. The list displays the following values:

NAV Lot

Numeric; 6 Characters; Mandatory

Specify the NAV lot

No of Decimals for NAV

Numeric; 22 Characters; Mandatory

specify the number of decimal points to be used for NAV.

Roundin of NAV

Mandatory

Select the rounding option of NAV from the drop-down list. The list displays the following values:

Minimum Holding Period Violation

Mandatory

Select if the value of Enforce Minimum Holding Period or Not from the drop-down list. The list displays the following values:

Income Distribution Rules Defaults

Default Distribution Mode

Optional

Select default distribution mode from the drop-down list. The list displays the following values:

EPU Lot

Numeric; 6 Characters; Mandatory

Specify the EOU lot value.

Look Ahead Processing?

Optional

Select if fund will be marked for Look Ahead Processing or not during dividend process from the drop-down list. The list displays the following values:

Fund Level Holiday Defaults

Holiday Rule

Mandatory

Select the holiday rule from the drop-down list. The list displays the following values:

Click ‘Default Holiday Maintenance’ button to view calendar.

5.10.3 Fund Account Details Tab

Click ‘Fund Account Details’ tab in ‘FCIS Bulk Clients Defaults - Fund Rule - Detail’ screen.

 

You can specify the following details:

Bank

Alphanumeric; 12 Characters; Optional

Specify the bank name.

Branch

Alphanumeric; 50 Characters; Optional

Specify the branch name.

Account Number

Alphanumeric; 50 Characters; Optional

Specify the account number.

IBAN

Alphanumeric; 40 Characters; Optional

Specify the IBAN details.

Account Currency

Alphanumeric; 3 Characters; Optional

Specify the account currency code.

Account Name

Alphanumeric; 50 Characters; Optional

Specify the account holder name.

5.10.4 Fund Agency Back Dating Tab

Click ‘Fund Agency Back Dating’ tab in ‘FCIS Bulk Clients Defaults - Fund Rule - Detail’ screen.

 

You can specify the following details:

Agent Code

Alphanumeric; 12 Characters; Optional

Specify the agent code.

Agency Branch Code

Alphanumeric; 12 Characters; Optional

Specify the agency branch code.

Transaction Type

Alphanumeric; 2 Characters; Optional

Specify the type of transaction.

Backdating Period

Numeric; 22 Characters; Optional

Specify the backdating period.

Transaction Processing Rules Tab

Click ‘Transaction Processing Rules’ tab in ‘FCIS Bulk Clients Defaults - Fund Rule - Detail’ screen.

 

You can specify the following details:

Transaction Rules

Start Date

Date Format; Mandatory

Select the start date from the adjoining calendar.

End Date

Date Format; Mandatory

Select the end date from the adjoining calendar.

Start Period

Numeric; 22 Characters; Mandatory

Specify the transaction start period.

End Period

Numeric; 22 Characters; Mandatory

Specify the transaction end period.

Transaction Frequency

Alphanumeric; 1 Character; Mandatory

Specify the transaction frequency.

Start Time(HH24:MI:SS)

Alphanumeric; 15 Characters; Mandatory

Specify the transaction start time for a day. By default, the system displays 00:00:01. However, you can amend the value accordingly.

End Time(HH24:MI:SS)

Alphanumeric; 15 Characters; Mandatory

Specify the transaction end time for a day. By default, the system displays 23:59:00. However, you can amend the value accordingly.

CutOff Time(HH24:MI)

Alphanumeric; 15 Characters; Mandatory

Specify the transaction cut-off time for a day. By default, the system displays 23:59:00. However, you can amend the value accordingly.

Transaction Limits

Minimum Amount

Numeric; 30 Characters; Mandatory

Specify the minimum transaction amount.

Maximum Amount

Numeric; 30 Characters; Mandatory

Specify the maximum transaction amount.

Minimum Units

Numeric; 27 Characters; Mandatory

Specify the minimum transaction units.

Maximum Units

Numeric; 27 Characters; Mandatory

Specify the maximum transaction units.

Step Amount

Numeric; 30 Characters; Mandatory

Specify the step amount for the transaction amount.

Step Units

Numeric; 27 Characters; Mandatory

Specify the step units for the transaction unit.

Pricing

Back-Dating Allowed?

Mandatory

Select if back dating is allowed or not from the drop-down list. The list displays the following values:

Rounding Precision For Unit Price

Numeric; 22 Characters; Optional

Specify the rounding precision for unit price.

Rounding Options For Unit Price

Optional

Select the rounding options for unit price from the drop-down list. the list displays the following values:

Price Lag

Numeric; 22 Characters; Mandatory

Specify the price lag details.

Back-Dating Limit

Numeric; 22 Characters; Optional

Specify the back-dating limit.

Rounding Options For Units

Optional

Select the rounding options for units from the drop-down list. the list displays the following values:

Policies

Allocation Lag

Numeric; 22 Characters; Mandatory

Specify the allocation lag.

Confirmation Lag

Numeric; 22 Characters; Mandatory

Specify the confirmation lag.

Check On Par With Cash?

Mandatory

Select if the check on par with cash is required or not from the drop-down list. The list displays the following values:

Credit Card On Par With Cash?

Mandatory

Select if the credit on par with cash is required or not from the drop-down list. The list displays the following values:

Transfer On Par With Cash?

Mandatory

Select if the transfer on par with cash is required or not from the drop-down list. The list displays the following values:

5.10.5 Fund Agent Mapping Tab

Select ‘Fund Agent Mapping’ tab in ‘FCIS Bulk Clients Defaults - Fund Rule - Detail’ screen.

 

You can specify the following details:

Allowed Agents Details

Agent Code

Alphanumeric; 255 Characters; Optional

Specify the agent code.

5.11 Default Information for Fund Price Imports

This section contains the following topics:

5.11.1 Invoking Default Information for Fund Price Imports

The only default information to be maintained for fund price import is whether authorized fund prices must be generated for the fund.

Specify this in the Generate Authorized Fund Price field. You must also specify the Fund Scheme / Cross Reference Number.

You can invoke the FCIS Bulk Clients Defaults (Fund Price) Detail screen by typing ‘UTDCDFP’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

You can specify the following details:

Bulk Clients Details

Bulk Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk client code.

Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the distributor ID.

Distributor

Display

The system displays name of the distributor for the selected distributor ID.

Client Defaults

Generate Authorized Fund Price

Mandatory

Select ‘Yes’ from drop-down list if authorized fund price has to be generated. The options available in the drop-down are as follows:

Other Details

Fund Scheme/Cross Reference Number

Alphanumeric; 60 Characters; Mandatory

Specify the fund scheme or cross reference number.

Check Fund Price Fluctuation

Optional

Select ‘Yes’ from drop-down list to check fund price fluctuation. The options available in the drop-down are as follows:

5.12 Default Information for Income Distribution Setup Im­ports

This section contains the following topics:

5.12.1 Invoking Default Information for Income Distribution Setup Imports

You can invoke the FCIS Bulk Clients Defaults (Income Distribution Rule) screen by typing ‘UTDCDIDS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For income distribution setup import, you must maintain:

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the distributor ID.

Distributor

Display

The system displays the name of the distributor for the selected distributor ID.

Client Defaults

Generate Authorized IDS

Mandatory

Select ‘Yes’ from the drop-down list if authorized IDS has to be generated. The options available in the drop-down are as follows:

Other Details

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme or cross reference number.

Fund Scheme/Cross Reference Number

Alphanumeric; 60 Characters; Mandatory

Specify the fund scheme or cross reference number.

Check Duplicates

Mandatory

Select ‘Yes’ from drop-down list if check duplicates are available. The options available in the drop-down are as follows:

5.13 Default Information for Redemption Check Imports

This section contains the following topics:

5.13.1 Invoking Default Information for Redemption Check Imports

You can invoke the FCIS Bulk Clients Defaults (Redemption Check) screen by typing ‘UTDBLKRC’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For redemption check imports, you must maintain:

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the AMC or distributor for the selected AMC or distributor ID.

Client Defaults

Check Duplicates

Mandatory

Select ‘Yes’ from drop-down list if check duplicates are available. The options available in the drop-down are as follows:

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme or cross reference number. Alternatively, you can select scheme or cross reference number from the option list. This option list will fetch the add info details for the entity add info for Unit holder as well as unit holder ID and UH reference number.

5.14 Default Information for Standing Instructions Imports

This section contains the following topics:

5.14.1 Invoking Default Information for Standing Instructions Imports

You can invoke the FCIS Bulk Clients Defaults (Standing Instruction) screen by typing ‘UTDBLKSI’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For standing instructions imports, you must maintain:

Bulk Clients Details

Bulk Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the AMC or distributor for the selected AMC or distributor ID.

Client Defaults

Generate Authorized SI

Mandatory

Select ‘Yes’ from the drop-down list if authorized SI has to be generated. The options available in the drop-down are as follows:

Other Details

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme or cross reference number. Alternatively, you can select scheme or cross reference number from the option list. This option list will fetch the add info details for the entity add info for Unit holder as well as unit holder ID and UH reference number.

Fund Scheme/Cross Reference Number

Alphanumeric; 60 Characters; Mandatory

Indicates the param value for the param code FUNDSCHEMECROSSREFTYPES.

Check Duplicates

Mandatory

Select ‘Yes’ from drop-down list if check duplicates are available. The options available in the drop-down are as follows:

5.15 Default Information for Transactions Imports

This section contains the following topics:

5.15.1 Invoking Default Information for Transactions Imports

You can invoke the FCIS Bulk Clients Defaults (Transaction) screen by typing ‘UTDBLTXN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For imports of new subscription, redemption, transfer and conversion transactions, and amended transactions if indicated for the bulk client, you must maintain:

Note

If you wish to disallow upload of amended transactions for a particular client, select the ‘No’ option in the Allow Amendment field, when you are setting up the default information for the bulk client. During bulk upload of transactions from a bulk client, amended orders are not imported if disallowed in the Bulk Clients Defaults Maintenance for the bulk client, but errors are logged in respect of them.

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the distributor ID.

Distributor

Display

The system displays the name of the distributor for the selected distributor ID.

Client Defaults

Generate Authorized Transactions

Mandatory

Select ‘Yes’ from the drop-down list if authorized transactions has to be generated. The options available in the drop-down are as follows:

Redemption Bank

Optional

Select if redemption bank has to be selected or not from the drop-down list. The list displays the following values:

System Generated Reference Number

Optional

Select if reference number has to be system generated or not from the drop-down list. The list displays the following values:

Other Details

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme or cross reference number.

Check Duplicates

Mandatory

Select ‘Yes’ from drop-down list if check duplicates are available. The options available in the drop-down are as follows:

Fund Scheme/Cross Reference Number

Alphanumeric; 60 Characters; Mandatory

Specify the fund scheme or cross reference number.

Default Date Format

Display

The system displays the date format.

Communication Mode

Alphanumeric; 2 Characters; Mandatory

Specify the communication mode.

Sub Payment Mode

Alphanumeric; 2 Characters; Mandatory

Specify the sub payment mode.

LOI Transaction

Optional

Select LOI transaction status from the drop-down list. The list displays the following values:

Translation Required

Optional

Select transaction required or not from the drop-down list. The list displays the following values:

Amendment Allowed

Optional

Select if amendment is allowed or not from the drop-down list. The list displays the following values:

5.16 Default Information for Transaction Load Override Im­ports

This section contains the following topics:

5.16.1 Invoking Default Information for Transaction Load Override Imports

For load override imports, you must maintain whether authorized load override records must be generated in the system.

You can invoke the FCIS Bulk Clients Defaults (Transaction Load Override) screen by typing ‘UTDBLTLO’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

You can specify the following details:

Bulk Clients Details

Bulk Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the AMC or distributor for the selected AMC or distributor ID.

Client Defaults

Generate Authorized Load Override

Mandatory

Select ‘Yes’ from the drop-down list if authorized load override has to be generated. The options available in the drop-down are as follows:

5.17 Default Information for Unit Holder Accounts Imports

This section contains the following topics:

5.17.1 Invoking Default Information for Unit Holder Accounts Imports

You can invoke the FCIS Bulk Clients Defaults (Unit Holder) screen by typing ‘UTDBLKUH’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

5.17.2 Bulk Clients Tab

Click ‘Bulk Clients’ tab in ‘FCIS Bulk Clients Defaults - Unit Holder - Detail’ screen.

 

You can specify the following details:

Bulk Clients

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the AMC or distributor for the selected AMC or distributor ID.

Client Defaults

Title

Alphanumeric; 15 Characters; Mandatory

Specify the customer title.

Default to Introducer Broker

Mandatory

Select if the client details has to be defaulted to introducer broker or not from the drop-down list. The list displays the following values:

Sex

Mandatory

Select the options from the drop-down list. The list displays the following values:

System Generated Reference Number

Optional

Select if reference number has to be system generated or not from the drop-down list. The list displays the following values:

Marital Status

Alphanumeric; 1 Character; Mandatory

Specify the marital status.

Redemption Mode of Payment

Alphanumeric; 1 Character; Mandatory

Specify the redemption mode of payment.

Resident Status

Alphanumeric; 1 Character; Mandatory

Specify the resident status.

Account Type

Alphanumeric; 1 Character; Mandatory

Specify the type of account.

Investor Type

Alphanumeric; 1 Character; Mandatory

Specify the type of investor.

Account Operation Type

Alphanumeric; 1 Character; Mandatory

Specify the account operation type of the customer.

Country

Alphanumeric; 3 Characters; Mandatory

Specify the country code of the customer.

Identification Type

Alphanumeric; 3 Characters; Mandatory

Specify the identification type.

Occupation

Alphanumeric; 3 Characters; Mandatory

Specify the occupation of the customer.

Account Statement Frequency

Alphanumeric; 1 Character; Optional

Specify the account statement frequency.

Corporation

Alphanumeric; 3 Characters; Mandatory

Specify the corporation details.

Introducer Broker

Alphanumeric; 12 Characters; Mandatory

Specify the introducer broker details of the unit holder.

Language

Alphanumeric; 12 Characters; Mandatory

Specify the language code.

Unit Holder Base Currency

Alphanumeric; 3 Characters; Mandatory

Specify the unit holder base currency code.

Nationality

Alphanumeric; 3 Characters; Mandatory

Specify the nationality of the customer.

Bank Account Currency

Alphanumeric; 3 Characters; Mandatory

Specify the bank account currency code.

Category (Individual)

Alphanumeric; 2 Characters; Optional

Specify the individual category code.

Account Statement Currency

Alphanumeric; 3 Characters; Mandatory

Specify the account statement currency code.

Category (Corporate)

Alphanumeric; 2 Characters; Optional

Specify the corporate category code.

Template ID

Alphanumeric; 6 Characters; Optional

Specify the template ID.

Place of Issue

Alphanumeric; 3 Characters; Optional

Specify the place of issue details.

Preferred Fund ID for Redemption

Alphanumeric; 6 Characters; Optional

Specify the preferred fund ID for redemption.

5.17.3 Additional Info Tab

Click ‘Additional Info’ tab in ‘FCIS Bulk Clients Defaults - Unit Holder - Detail’ screen.

 

You can specify the following details:

Additional Information Defaults

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme/ cross reference number.

Reject duplicates during Imports

Optional

Select if duplicate records needs to be deleted during import or not from the drop-down list. The list displays the following values:

Additional Information Details

Other Info Field

Alphanumeric; 100 Characters; Optional

Specify the other additional information.

Field Value

Alphanumeric; 100 Characters; Optional

Based on the Other Info Field, specify the field value.

5.17.4 Other Details Tab

Other Details

UH Account Type

Alphanumeric; 2 Characters; Optional

Specify the unit holder account type.

IRS Notification on A/C

Alphanumeric; 10 Characters; Optional

Specify the IRS notification on account.

RPO Code

Alphanumeric; 10 Characters; Optional

Specify the RPO code.

Telephone Redemption

Mandatory

Select if redemption request by telephone is allowed or not from the drop-down list. The list displays the following values:

Telephone Switch

Mandatory

Select if switch request by telephone is allowed or not from the drop-down list. The list displays the following values:

Registration Type

Alphanumeric; 2 Characters; Optional

Specify the type of registration.

Preferred Mailing Mode

Alphanumeric; 2 Characters; Optional

Specify the preferred mailing mode.

Write Check for MMF

Mandatory

Select ‘Yes’ option from drop-down list if system allows check writing.

Fee Category (Individual)

Alphanumeric; 3 Characters; Optional

Specify the fee category for an individual.

Fee Sub Category (Individual)

Alphanumeric; 6 Characters; Optional

Specify the fee sub category for an individual.

Fee Category (Corporate)

Alphanumeric; 3 Characters; Optional

Specify the fee category for corporate.

Fee Sub Category (Corporate)

Alphanumeric; 6 Characters; Optional

Specify the fee sub category for corporate.

Pay by FEDWIRE / ACH

Mandatory

Select ‘Yes’ option from drop-down list if paid by FEDWIRE/ ACH.

5.17.4.1 Choosing Template for Automatic Replication

Modifications made to a unit holder account under a CIF, through an Information Change operation, might require to be replicated to all unit holder accounts under the CIF. Oracle FLEXCUBE Investor Servicing provides the facility of configuring the system so that automatic replication could be achieved, through automatic replication templates.

For each bulk client, you can define the template to be used for automatic replication, as part of the client default information. The automatic replication template you select here is used for replication of changes made to a unit holder account through Information Change, to all unit holder accounts belonging to the CIF.

How the template is used

Any changes that have been made through Information Change, to any of the fields defined in the template, are replicated to all unit holder accounts belonging to the CIF, when the Information Change is authorized. The replication occurs at the level defined for the template – CIF level (changes made to CIF fields are replicated) or Identification Type level (changes made to Identification Type fields are replicated)

Additional Information Defaults

For the additional information defaults, the list shown is the additional information for which the valid values (restrictive list) are maintained as part of Additional Information Master Setup and Additional Information Valid Values Setup.

5.18 Default Information for Check Book Requests Imports

5.18.1 Invoking Default Information for Check Book Requests Imports

For check book request imports, you must maintain whether check book requests are mandatory.

You can invoke the FCIS Bulk Clients Defaults (Cheque Book Request) screen by typing ‘UTDBLCBR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

You can specify the following details:

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC/ distributor ID.

Distributor

Display

The system displays the name of the distributor for the selected AMC/ distributor ID.

Client Defaults

Cheque Book Request Mandatory

Mandatory

Select if check book request is mandatory or not from the drop-down list. The list displays the following values:

5.19 Default Information for Policy Transactions

This section contains the following topics:

5.19.1 Invoking Default Information for Policy Transactions

You can invoke the FCIS Bulk Clients Defaults (Policy Transaction) screen by typing ‘UTDBLKPT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For policy transactions import, you must maintain:

You can specify the following details:

Bulk Clients Details

Bulk Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the AMC or distributor ID.

Distributor

Display

The system displays the name of the AMC or distributor for the selected AMC or distributor ID.

Client Defaults

Generate Authorized Transactions

Mandatory

Select if authorized transactions needs to be generated or not from the drop-down list. The list displays the following values:

System Generated Reference Number

Optional

Select if reference number needs to be system generated or not from the drop-down list. The list displays the following values:

Other Details

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme/cross reference number. Alternatively, you can select scheme or cross reference number from the option list. This option list will fetch the add info details for the entity add info for Unit holder as well as unit holder ID and UH reference number.

Fund Scheme/Cross Reference Number

Alphanumeric; 60 Characters; Mandatory

Indicates the param value for the param code FUNDSCHEMECROSSREFTYPES.

Transaction Intermediary

Mandatory

Select the transaction intermediary option from the drop-down list. The list displays the following values:

5.20 Default Information for Broker

This section contains the following topics:

5.20.1 Invoking Default Information for Broker

You can invoke the FCIS Bulk Clients Defaults (Broker) screen by typing ‘UTDBLCBD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For Broker import, you must maintain:

You can specify the following details:

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

Distributor/AMC ID

Alphanumeric; 12 Characters; Mandatory

Specify the distributor or AMC ID.

Distributor

Display

The system displays the name of the distributor or AMC ID for the selected distributor or AMC ID.

Client Defaults

Broker Base Currency

Alphanumeric; 3 Characters; Mandatory

Specify the broker base currency code.

VAT Registered

Optional

Select if VAT is registered or not from the drop-down list. The list displays the following values:

Commission Percentage

Numeric; 5 Characters; Mandatory

Specify the commission percentage.

Commission Payment Frequency

Alphanumeric; 1 Character; Mandatory

Specify the commission payment frequency.

Broker Type

Alphanumeric; 6 Characters; Optional

Specify the broker type.

Use Broker Type Payment Dates

Optional

Select if broker type payment dates can be used or not from the drop-down list. The list displays the following values:

Broker Category

Optional

Select broker category from the drop-down list. The list displays the following values:

Additional Information Details

Other Information Field

Display

The system displays the mapped field against that function ID.

Field Value

Display

The system displays the field value based on other information field.

5.21 FCIS Bulk Clients Defaults Broker Summary

This section contains the following topics:

5.21.1 Retrieving Amended Bulk Clients Defaults Broker Record

You can retrieve a previously entered record in the FCIS Bulk Clients Defaults Broker Summary screen, as follows:

Invoke the FCIS Bulk Clients Defaults Broker Summary screen by typing ‘UTSBLCBD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

Specify any or all of the following details in the corresponding fields:

Click ‘Advanced Search’ button for advanced level of query where records can be retrieved based on specific fields. Click ‘Reset’ button, so that the entire search criteria will be cleared for a new level of search. Click ‘Search’ button to view the records. All records with the specified details are retrieved and displayed in the lower portion of the screen. Click ‘Refresh’ button, so that the search criteria will be refreshed based on existing criteria.

Note

You can also retrieve the individual record detail from the FCIS Bulk Clients Defaults Bro­ker detail screen by doing query in the following manner:

You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operation by selecting from the Action list. To edit and amend a record a user has to click unlock button under Action menu.

You can also search the record by using combination of % and alphanumeric value.

Example

You can search the record by using the combination of % and alphanumeric value as follows:-

5.21.2 Editing Amended Bulk Clients Defaults Broker Record

You can modify the details of Bulk Clients Defaults Broker parameters that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:

5.21.3 Viewing Amended Bulk Clients Defaults Broker Record

To view a record that you have previously entered, you must retrieve the same in the FCIS Bulk Clients Defaults Broker Summary screen, as follows:

5.21.4 Deleting Amended Bulk Clients Defaults Broker Record

You can delete only unauthorized records in the system. To delete a record that you have previously entered:

5.21.5 Authorizing Amended Bulk Clients Defaults Broker Record

An unauthorized Bulk Clients Defaults Broker record must be authorized in the system for it to be processed. To authorize a record:

When the checker authorizes a transaction, details of validations, if any, that were overridden by the maker of the transaction during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the transaction.

5.21.6 Amending Amended Bulk Clients Defaults Broker Record

After a Bulk Clients Defaults Broker is authorized, it can be modified using the Unlock operation from Action list. To make changes to a transaction after authorization:

5.21.7 Authorizing Amended Bulk Clients Defaults Broker Record

An amended Bulk Clients Defaults Broker record must be authorized for the amendment to be made effective in the system. The authorization of amended records can only be done from Fund Manager Module and Agency branch Module.

The process of authorization is subsequently the same as that for normal transactions.

5.22 Default Information for UH Deal Upload

This section contains the following topics:

5.22.1 Invoking Default Information for UH Deal Upload

You can invoke the FCIS Bulk Clients Defaults (UH Deal Upload) screen by typing ‘UTDBLUHD’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

For UH deal import, you must maintain:

Only those fields in the header portion of the screen are discussed here. For the other fields, depending upon the upload type, you must refer the user manual files for the corresponding maintenance in the system.

You can specify the following details:

Bulk Clients Details

Bulk Account Client Code

Alphanumeric; 12 Characters; Mandatory

Specify the bulk account client code.

Bulk Client Name

Display

The system displays the bulk client name for the selected bulk account client code.

AMC/Distributor ID

Alphanumeric; 12 Characters; Mandatory

Specify the distributor ID.

Distributor

Display

The system displays the name of the distributor for the selected distributor ID.

Client Defaults

Apply At CIF Level

Optional

Select if UH deal has to be applied at CIF level or not from the drop-down list. The list displays the following values:

Scheme/Cross Reference Number

Alphanumeric; 12 Characters; Mandatory

Specify the scheme/cross reference number.

5.23 Bulk Clients Defaults Summary Screen

This section contains the following topics:

5.23.1 Viewing Bulk Clients Default Summary

After you have set up all the default specifications for a bulk client, you must have another user authorize the defaults so that they would be effective in the system database.

Before the default specifications are authorized, you can edit them as many times as necessary. You can also delete a default specification for a bulk client before it is authorized.

After authorization, you can only make changes to any of the specifications through an amendment.

The Bulk Client Summary screen can be used for the following operations on bulk client default specifications:

To invoke the Bulk Client Default Find screen, click on Summary under the Bulk Client Defaults menu in the Browser.

You can invoke the FCIS Bulk Clients Defaults (Broker) Summary screen by typing ‘UTSENTMN’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.

 

5.23.2 Retrieving Default Specifications Record for Bulk Client

To retrieve a previously entered default specifications record for a bulk client:

Note

You can also retrieve an individual bulk client detail from the Detail screen by doing query in the following manner:

Example

You can search the record for Bulk Account Client code by using the combination of % and alphanumeric value.

5.23.3 Editing Bulk Client Details

You can modify the details of the bulk client details that you have already entered into the system, provided it has not been subsequently authorized. You can perform this operation as follows:

5.23.4 Viewing Bulk Client Details

To view the bulk client details that you have previously entered:

5.23.5 Deleting Bulk Client Details

You can delete only unauthorized records in the system. To delete a bulk client record:

5.23.6 Authorizing Bulk Client Details Records

An unauthorized bulk client record must be authorized in the system for it to be processed. To authorize a bulk client record:

When the checker authorizes an bulk client record, details of validations, if any, that were overridden by the maker of the record during the Save operation, are displayed. If any of these overrides results in an error, the checker must reject the bulk client record.

5.23.7 Amending Bulk Client Records

After a bulk client is authorized, it can be modified using the Unlock operation from Action list. To make changes to a bulk client record after authorization, you must invoke the Unlock operation which is termed as Amend Operation.

5.23.8 Authorizing Amended Bulk Client Details

An amended bulk client record must be authorized for the amendment to be made effective in the system.

The process of authorization is the same as that of normal authorization process.

5.23.9 Copying Attributes

If you want to create a bulk client record having the same attributes of an existing record: