8. Interfaces with External Systems

Oracle FLEXCUBE Investor Servicing provides a facility to effect data exchanges and transfers with external systems. You can import exchange rates or NAV from an external system, or export transaction and dividend information to any external accounting system. The external system may be a file system or an application.

The data exchange can be affected through an interface with the external system. This interface consists of the following components:

• An interface definition that will capture all the information that is needed for processing and affecting the data exchange. You can designate all the procedures that need to be called, the internal tables that will be inserted into or read from, the database objects that will be used, the file formats and so on.
• The interface processing modules that will actually process the interface, affect the data exchange, and create a log of these activities.
• The file access services that will be utilized by the interface processing module for the purpose of affecting the data exchange.

You can process an interface in one of the following ways:

• As part of the End of Day Procedures, you can trigger the processes specified for the interface through a simple dialog screen. The system performs the data exchange and flashes a message upon successful completion of the activities.
• You can schedule the interface through the Scheduler Services in FCIS by specifying the Interface ID as a parameter for a task, and then schedule the task to be executed as desired, as a job, as follows:

1. Define an interface definition from FCIS to the external system or vice versa. The interface definition will be associated with a unique Interface ID.
2. Define a task (through the Task Maintenance screen) and indicate the Interface ID as a parameter to the task.
3. Schedule the task by associating it with a time-based or event-based frequency and define it as a job, through the Job Maintenance screen.
4. Activate the scheduler, and it will call the Interface Processing module at the time specified, and pass the Interface ID as a parameter to the module.
5. The Interface Processing module will then execute the defined interface and log any errors that will result.

You can access the interface processing screens from the following menu categories in the Fund Manager component:

• The ‘Interface Maintenance’ screen from the Interfaces menu category in the browser.
• The ‘Interface Maintenance Find Options (Summary)’ screen
• The ‘Online Interfaces Execution’ screen under the Batch menu in the browser.

For each of the below function ID, Modify, Delete or Authorize Action is supported from the module in which the record is created.

ACCOUNTOFFICERIFATBL	UTDAOIFA
AMCAGENTSLATBL	UTDAMCSL
AMCBANKBRANCHMAPPINGTBL	UTDAGYBN
B_AMINTERFACESETUPTBL	UTDACSYC
B_COUNTRYCURRENCYTBL	UTDCONCU
B_CURRENCYTBL	UTDCURMA
B_EXCHANGERATETBL	UTDEXCRM
B_LOADTBL	UTDLOADM
B_MODEOFPAYMENTTBL	UTDMPAYS
B_SOURCETBL	UTDSORCE
DEFAULTSTBL	UTDDEFMT
DISTRIBUTORAOTBL	UTDAGTAO
DIVIDENDCOMPONENTTBL	UTDDVCOM
ELEMENTTBL	UTDENMNT
ENTITYBASETBL	UTDENTMN
ENTITYNOTEPADTBL	UTDNTPDE
ENTITYPAYMENTDETAILSTBL	UTDENTPY
FEECATEGORYHDRTBL	UTDFEECA
FUNDTYPETBL	UTDFNTYP
INDEXATIONTBL	UTDINDEX
INTERFACEDEFINITIONTBL	UTDIFAC
LANGUAGETBL	UTDLNGSU
PARAMSHDRTBL	UTDPARAM
PRODUCTTYPETBL	UTDPRTYP
RATETBL	UTDRATES
RULETBL	UTDHDRUL
STTM_CUSTOMER	UTDCUST
TIMEZONETBL	UTDTIMEZ

Refer to the chapter ‘Interfaces with External Systems’ in Volume Four for further details on setting up and maintaining interfaces.

This chapter contains the following sections:

• Section 8.1, "FCIS – AWD Interface"

8.1 FCIS – AWD Interface

This section contains the following topics:

• Section 8.1.1, "FCIS-AWD Interface Description"
• Section 8.1.2, "Maintaining Interface Specific Details"
• Section 8.1.3, "Interface Attributes"
• Section 8.1.4, "Process Workflow"
• Section 8.1.5, "File Format for FCIS – AWD Interface"

8.1.1 FCIS-AWD Interface Description

At the end of a day’s batch processing, Oracle FLEXCUBE Investor Servicing will produce a file which contains all the transactions that have failed validation criteria. The FCIS – AWD Interface will assign a unique error code for each of the failed transactions and pass the file to another external system. This external system will translate the error codes into AWD Worktype and produces an AWD/RIP control file for AWD/RIP.

8.1.2 Maintaining Interface Specific Details

You need to maintain the external system AWD in the FCIS Data Mapping Maintenance screen with the code description as ERROR CODE. Consequently, the file that will be sent to AWD by FLEXCUBE Investor Services will have the header ‘AWD’.

Refer to the section ‘Maintaining Data Mapping’ in the chapter ‘Maintaining System Parameters’ for further details.

8.1.3 Interface Attributes

The FCIS – AWD Interface has the following attributes:

Trigger	EOD Activity
Transport Type	File System
File Type	Delimited
Header Row	No
Record Separa­tor	New Line Charac­ter
Field Separator	Comma

8.1.4 Process Workflow

The FCIS - AWD interface will fetch all the allocation errors that have occurred on transactions after all the validations. The interface will then transfer a file with the details in the required format. The interface will also provide the subscriptions, redemptions and income distributions for which the bank details are unverified.

8.1.5 File Format for FCIS – AWD Interface

The file which contains the errors that have occurred on transactions will be in the following format:

Field Name	Data Type	Details
Error Code	Number	The FCIS error code will be translated as per the data mapping maintenance.
Account Number	Character	The unit holder ID of the transaction.
Fund id	Character	The fund ID of the transaction.
Account Group No	Character	Product ID of the transaction. The value will be ‘UT’ if it is a unit trust transaction.
Account Group Type	Character	The product type of the product maintained in FCIS.
Surname	Character	The Last Name of the unit holder involved in the transaction
Date of birth	Number(8)	Unit holder’s Date of birth in YYYYMMDD format
Account Refer­ence Number	Character	The transaction number.
Date	Number(8)	Transaction date in YYYYMMDD format