4 Interfaces with External Systems

This topic describes about the information on interfaces with external systems.

Oracle FLEXCUBE Investor Servicing (FCIS) 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 effected 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 effecting 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 module that will actually process the interface, effect 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 effecting 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 dialogue 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:
  • Define an interface definition from FCIS to the external system or vice versa. The interface definition will be associated with a unique Interface ID.
  • Define a task (through the Task Maintenance screen) and indicate the Interface ID as a parameter to the task.
  • 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.
  • 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.
  • 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 (Detail) screen from the Maintenance menu category.
• The Interface Maintenance Summary Screen.
• The Online Execution of Interfaces screen from the Batch menu category

This topic contains the following sub-topics:

• FCIS Interface Maintenance Detail
  This topic provides infromation on FCIS interface maintenance details.
• FCIS Interface Maintenance Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Interface Mapping Detail
  This topic describes the systematic instructions to interface mapping detail.
• Interface Mapping Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Online Interface Execution
  This topic describes the systematic instructions to execution online interfacel.
• Scheduler Services
  This topic describes about the description of the Scheduler Services.
• Jobs Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Tasks Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Scheduling Jobs
  This topic describes the about the information on scheduling the jobs.
• UH NAV Alert Setup Detail
  This topic describes about the instructions to set up alert for UH NAV.
• UH NAV Alert Setup Summary Screen
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Setting up General Ledger Template
  This topic describes the about the information on setting up template on general ledger.
• GL Template Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• GL Interface Set-up Detail
  This topic describes about the instructions to set up details for GL interfaces.
• GL Interface Set-Up Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• Accounting System GL Setup Detail
  This topic describes about the infromation setting up accounting system GL.
• Accounting System GL Setup Summary
  This topic provides the systematic instructions to perform the basic operations on the selected records.
• FCIS – AWD Interface
  This topic describes about the information on interfaces with FCIS - AWD.
• EPU Upload
  This topic describes about the information on EPU upload.
• Tax Aggregation Interface
  This topic describes about the information on Tax Aggregation Interface.
• Agent Reference File
  This topic describes about the information on Agent Reference File.
• Oracle Financial Interface
  This topic describes about the information on Oracle Financial Interface.
• Product - Fund - Asset Code Mapping Interface
  This topic describes about the information on Product - Fund - Asset Code Mapping Interface.
• Global Order Placement Interface
  This topic describes about the information on Global Order Placement Interface.