| appLOAD - a next generation data loading tool for Oracle E-Business Suite R12/11i | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
||||||||||||||||||
|
||||||||||||||||||
![]() |
||||||||||||||||||
Configuration - Chain-Sys provides a free proof of concept for your data loading requirements. This becomes the baseline for the initial appLOAD template. So our customers get the template with over 95% of their business requirements mapped. We have over 100 templates available immediately. Mapping- appLOAD users can extend the base templates mapping between input excel/xml/csv/database files against open interface tables or API's. This is a simple drag and drop operation. Validation- appLOAD proves to be a valuable asset for highly configurable and flexible pre-validation engine. Chain-Sys provides many standard pre-validations along with the template. The end users can add further pre-validations as needed. This engine helps the users to stop any incorrect data from being processed and shows cumulative totals of records processed, unprocessed and errored. Cleansing- appLOAD provides extensive data cleansing capabilities at the pre-validation stage. The source and destination data is compared using our proprietary algorithms. Cleansing engine will show the matching percentage for the source data in comparison to the target. Automatic threshold factor can be introduced to allow the system to match the source and the target data. Correction- appLOAD provides extensive and flexible features for data correction. Both offline and online data correction is available. The corrected data can be re-validated as required. appLOAD also shows cumulative total records processed, unprocessed and errored. Email and dashboard notifications for corrections are provided. Execution- appLOAD handles the data load execution process in the application server. Multiple processes can be executed simultaneously. appLOAD's execution is very robust and scalable. There is no need for manual monitoring and intervention.
Data from Excel into Oracle E-Business Suite (EBS) ![]()
Technical Specifications for the appLOAD suite
The document comes up with the following technical specifications for the appLOAD suite
Software Requirements The following are the software pre-requisites for the appLOAD suite.
Hardware Requirements Server Capacity varies with the quantum of data and transactions. An approximate server configuration would need the following
Operating Systems appLOAD suite can run on the following operating systems
Application Servers appLOAD suite can run on the following J2EE Application/Web servers
Specifics of the Architecture The Model-View-Controller (MVC) pattern, originally developed to support the Smalltalk language, supports a logical separation between presentation (view), application (controller) and the data (model) layers of the system.
Application programmable interfaces (API) Integration with appLOAD suite Application programmable interfaces (API): All APIs of Oracle E-Business Suite R12/11i are available through appLOAD. Data Validation: appLOAD provides powerful validation checks. The system shows clear warnings and errors reflecting the actual data load process. Software as a service: Data load capabilities of appLOAD are available as service. appLOAD can be accessed over the internet with high security. Data Transformation: appLOAD provides features such as: Change Case, to-Date, to-Char, Decode Statements, SQL Pre-Validations, as well as Results based on SQL Query or Constant. Complex data translation needs are handled smoothly. Data Corrections: appLOAD writes any errors back to the Excel input file. Separate info is provided for Processed Data, Unprocessed Data and Erroneous Data after the data load process is complete. Open Interfaces: All open interfaces within Oracle E-Business Suite R12/11i are available through appLOAD. 11i to R12 Excel Input: appLOAD accepts data input in excel format. Sample data templates are provided with the software. Data templates are highly flexible to accommodate changes. Data Mapping: appLOAD offers easy data mapping between the excel input and the open interface table columns and API input and output parameters. It is a simple drag-and-drop model. Extra column mapping is allowed over and above standard template mappings. User Friendliness: appLOAD is designed for business users. It provides an easy and intuitive HTML user interface, online help documentation, and instructional movies. Scalability: appLOAD loads any size excel file in a single load. This applies up to the CSV and XML inputs. Security Helps protect sensitive data in non-production instances. Simple Configurations. No Programming needed. Protection coexists with Referential Integrity. Helps in SOX compliance. Integration with appLOAD suite
|
||||||||||||||||||
appLOAD is a new generation data conversion tool for Oracle E-Business Suite 11i/R12.
The tool significantly reduces project timelines and cuts costs. Extremely useful during implementation or reimplementation of Oracle E-Business Suite and for routine production data maintenance. Very easy to use and does not need programming. Supports all open
interfaces and APIs. 











