Interface Framework

Migrate Data Easily to Oracle Applications

Our proprietary Interface Framework, which will help to migrate data easily from legacy systems to Oracle Applications. This is an easy and elegant way to transfer legacy data during migration to Oracle Applications. This framework will help in Defining Sources, Defining Interfaces, Defining lookup codes, Data Mapping and Defining Staging tables. The framework is an engine that will ‘execute’ the interfaces.

Major Features

• Dynamic Load script generation based on parameters of interface submission and hence avoid coding and maintaining loader scripts for each interface
• Launch interfaces programs in a simple and consistent manner with Oracle Applications concurrent job submission for all interfaces
• Allow for system source level control in interface job submission
• Maintain audit trail of interfaces operations
• Organize data files in a systematic manner (at interface and system source levels)
• Provide appropriate levels of data security (secure data in database and data files by interface and system source levels)
• Check for proper sequencing of data files, if required (at legacy system source level)
• Check for basic data integrity
• Report errors with documented error codes
• Provide simple installation procedures for the framework and interfaces
• Maintain Interface Program Files in custom application TOP directory without interfering with the standard application file directories
• Ease of defining Metadata in the form of look-ups at the source interface level
• Dynamic pre-validation transformation (PVT) definitions using front-end screens. The PVTs can be redefined anytime by the administrator
• Ability to support multiple data formats across sources for the same interface