appLOAD | appLOAD suite | Chain-Sys Corporation

appLOAD - a next generation data loading tool for Oracle E-Business Suite R12/11i

appload appLOAD is the flagship product in the appLOAD suite of productivity tools for Oracle E-Business Suite environments. It is a robust, backend, server based solution for reliable and easy data loading for enterprise EBS customers. It is not a front-end/excel macros driven solution. More than 250+ templates are available covering various EBS modules.

	It has extensive pre-validation, cleansing and correction capabilities.
	Available as "Software as a Service"
	It accepts data input in excel, csv, and xml formats. Also accepts inputs directly from database.
	Our customers have experienced over 80% reduction in the cost and time of data loading activities.
	Business Users can use the tool with confidence for their data loading needs with no technical assistance. appLOAD is a flexible configuration engine which needs no programming.

7 Step process for data loading
Key Benefits
Features
Resources

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.

Transformation- appLOAD has a powerful and yet easily configurable data transformation engine. Using this engine the users can transform the input data to a different value based on conditions as required.

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.

Saves cost and time on data loading. Our customer see savings over 80%.
Assured high quality data conversion program.
Hub and Spoke model.
New revolutionary concept.
Data load is available as "Software as a Service"(SaaS)
Simple configurations. No additional programming needed.
Easy and intuitive to use which makes it an ideal data load tool for business users.
Reduce Oracle implementation time frame.

Architectural Overview
Templates
Technical specifications
Whitepapers
Case Studies

appLOAD suite templates

The appLOAD suite has 200+ pre-configured templates covering various functional modules of Oracle EBS. Additionally appINTERFACE offers these templates as web services for SOA orchestration. Sample listing below.

Oracle Financials
Oracle Manufacturing/ Supply chain planning
Oracle Distribution
Oracle Projects
Oracle CRM | Oracle Configurator
Oracle HRMS

Oracle Financials
1	Create GL Code Combinations: This template is used for creation of the new general ledger chart of accounts.	2	AR Invoice, Credit and debit memos This template is used for loading Account Receivables Invoice, Credit memos and Debit memos. Both open and historical transactions can be processed using this template.
3	Create Supplier, sites and contacts This template is used for creation of the supplier, supplier sites and supplier contacts.	4	AR Cash Receipts This template is used for loading Account Receivables Cash Receipts – partial or complete receipts against 1 or more AR Invoices.
5	Create Customer, address and sites This template is used for creation of the customer, customer address, customer sites and customer contacts.	6	AR Cash Remittance This template is used for recording the Account Receivables Cash Remittance transaction which will post the cash received into Oracle Cash Management module.
7	Append Customer Address This template is used for appending new customer addresses to the existing customer master data.	8	FA Mass Addition This template is used for loading the Fixed Assets.
9	GL Balances (Journal import) This template is used to import Journals into Oracle General Ledger module. The opening balances of the GL accounts can be converted using this template.	10	A Mass Transfer This template is used for transferring the Fixed Assets from one division to another.
11	GL Budget This template is used to load the General Ledger Budgets.	12	FA Adjustments This template is used for updating the Fixed Asset information.
13	AP Invoice Accounts Payable Invoices (open and closed) can be imported using this template. Both open and historical transactions can be processed using this template.	14	Bank Interface This template is used for loading the bank statements from the Bank into Oracle Cash management for both internal and external banks.
15	AP Payments This is a custom template made for loading Accounts payable payments against the AP invoices.	16	iExpenses This template helps in loading the iExpense Reports, Approving the expense report and interfacing the expense report into Oracle Payables as an AP Invoice.

Oracle Manufacturing

Item, Item Revisions and Material cost

This template is used for creation and update of item master in master and child organizations including revision control and material / material overhead cost. Item categories can also be loaded through this template.

MRP Forecasting

The MRP forecasting can be created using this template. Forecast name should be setup manually and then forecasting entries can be generated using this template.

Item Categories

This template is used for creation and update of item category assignment against items in Oracle Inventory module.

QA Collection Plan

Oracle Quality's Collection Plan data can be loaded through this template. This is a very useful functionality to maintain all the quality data collected from the Inbound and shop floor transactions and also maintain any custom collection plan data.

Item Catalogs

Assign catalog and catalog values to an item using this template.

Demantra – Sales History

Demantra is a statistical forecasting solution. This template helps in loading the sales history into Demantra. This data can be used for executing the statistical forecasting engine to get the final forecasting data which then can be interfaced into Oracle ASCP.

Item Cross Reference

Item cross references can be created using this template for individual inventory organizations or all inventory organizations.

WIP Mass load

This template helps you to load the Work in process Discrete Jobs and Schedules

Advanced Products Catalog

This template helps to load the additional custom item attributes created in the Oracle Product Lifecycle management module using the Advanced products catalog functionality.

Item On-hand Conversion

This template helps you to load the quantity on-hand information into Oracle Inventory module. This template also would load the costing information if you are following average costing methodology.

Sub-inventory item assignment

This is a functionality in Oracle Inventory – Sub-inventory definition. Items can be assigned to the sub-inventories with or without locator controls.

WIP Move Transactions

This template helps you to record the movement of Work in process (WIP) stock from one operation to another. Also this template can be used for moving the work in process stock from one status (IN-QUEUE, RUNNING, REJECT, REWORK, COMPLETE) to another in the same operation.

Item Costs (material, material overhead, resource, resource overhead, outside processing)

This template is used for loading material, material overhead, resource, resource overhead and outside processing cost for an item against any PENDING cost types. Once the cost is verified and rolled up, this pending cost type values can be updated to the FROZEN cost type.

Inventory Transactions (Miscellaneous Receipt, Miscellaneous Issue, Account Alias Receipt, Account Alias Issue and Work order less Completion)

This template will be very useful to perform any inventory transactions from an external system such as: recording the material movements from PLC, Scrap management, Work order less completion transactions for Flow manufacturing scenarios etc.

Purchase Receipt

This template helps in loading the Purchase order receipt transaction.

OPM Item Creation

Oracle process manufacturing Item creation can be automated using this XML template.

Bills of material Creation

Bills of material – Primary, Alternate and Common BOM's can be created using this template. The data loaded through this template includes: Assembly, components, revisions, reference designators and substitute components.

OPM Create Item LOT/ SUB LOT's

Oracle process manufacturing stores the LOT and SUBLOT information for an item and this template can be used for loading the LOT and SUBLOT information for the items created in OPM.

Bills of material update

This template is used for updating the Bills of material data and appending components to an existing Bills of material structure.

OPM Create Immediate

Initial stock for OPM items can be created using the Create Immediate transaction. This template helps you perform the create immediate transaction.

Routing Creation

This template is used for creating Routing information. The data loaded includes: Routing Header, Operation details, Resource details, Alternate Resources and Item revision details.

OPM Transfer to warehouse

This template can be used for recording all the material movement from one warehouse to another in OPM environment.

BOM with component item creation

This template is used when you want to create new items from the component listing which are not currently available and then create the Bills of material assembly and component structure. This can minimize the time in creating the items and bills of material in separate loads.

OPM Adjust Immediate

This template is used for making any material stock adjustments to the OPM items.

Oracle Distribution
1	Approved Supplier List This template helps in loading Approved Supplier list. Approved supplier functionality ties suppliers with items and during purchase order approval if the ASL flag is turned on for an item, the system will not allow to buy from any unapproved suppliers.	2	SO Open Interface This template used the Order import process for loading sales orders in Entered, Booked or Closed status.
3	Requisitions Open Interface This template helps in creating Standard Purchase requisitions in the Oracle Purchasing module.	4	Process Order API This template is useful for loading Sales order header information. This also allows to perform the actions on the sales order headers.
5	Internal Requisition This template helps in creating the Internal requisitions in the Oracle Purchasing module.	6	Process Line API This template is useful for loading sales order lines and performing several actions on sales order lines.
7	PO Open Interface This template helps in creating Purchase orders.	8	Item Reservation This template helps in performing Sales order reservation process.
9	Receipts Open Interface This template helps in creating Purchase order receipts.	10	Move Orders This template helps in performing the move orders against the sales orders and without the reference to a sales order.
11	Price List create and update This template helps in creating Price list header and lines in Oracle Advanced Pricing module which is part of Oracle Order Management Suite.	12	Pick Confirmation Pick confirmation template helps you to allocate the inventory to the delivery or trip and perform the pick confirmation process in Oracle Shipping module.
13	Price List with Attributes This template helps in loading price list along with Pricing attribute information.	14	Ship Confirmation This template helps you to ship confirm the deliveries or trips in Oracle Shipping module. This can trigger the Interface trip stop process as well.
15	Price List Qualifiers This template helps in loading price list header and lines along with Price list qualifiers for the pricing lines.	16	Interface Trip Stop Closure This template can be used to closing the Trip Stops automatically in Oracle Shipping module.

Oracle Projects
1	Create Resources This template helps in loading the Project Resources. Resources are also employees.	2	Project Budget conversion The Project Budgets can be loaded using this template.
3	Create Projects and Tasks This template helps in loading Project, Tasks and Key member information.	4	Project Billing The Project Billing information can be loaded using this template.
5	Create Agreement This template helps in loading the Project agreements.	6	Material issue to Project and task Any material inbound and outbound transactions can be recorded with project and task reference. This template is used for loading the material transactions with project and task information.
7	Cost Conversion The Project Cost can be loaded using this template.	8	Mass update to key members This template is used for updating the key members on the Project or the task.
9	Revenue Conversion The Project Revenue can be converted using this template.

Oracle CRM/Configurator
1	Installed Base This template helps in loading the Installed base information in Oracle CRM/ Service suite.	2	CZ Item, Item type, Property and prop values creation This template helps in creating the Oracle Configurator data such as: items, item types, item type property and item type property values.
3	Service Contracts This template helps in loading the Service Contracts in Oracle CRM/ Service suite.	4	CZ Item, Item type, Property and prop values update This template helps in updating the Oracle Configurator data such as: items, item types, item type property and item type property values.
5	Service Request Creation This template helps in loading the Service Requests in Oracle CRM/ Service suite.	6	CZ Non BOM Model Structure creation This template helps in creating the Oracle Configurator data such as: Non BOM model structure with Components linked with ATO/PTO items, Boolean Features and values, Text features and values, Option Features and values, Property and Property values assignment for each node.
7	Service Request Update This template helps in updating the Service Requests in Oracle CRM/ Service suite.	8	CZ Non BOM Model Structure update This template helps in updating the Oracle Configurator data such as: Non BOM model structure with Components linked with ATO/PTO items, Boolean Features and values, Text features and values, Option Features and values, Property and Property values assignment for each node.

Oracle HRMS
1	Create Location API This template helps to create HR Locations. Locations are used in creation of HR Organizations.	2	Create Previous Job Usage API This template is used for creating the employee's history details related to the previous job usage.
3	Create Organization API This template is used for creating the HR Organizations – Business Units, Legal Entities, Operating Units and Inventory Organizations.	4	Create Previous Job extra information This template is used for creating the employee's history details related to the previous job extra information.
5	Create Job API This template is used for creating the Jobs data into the Job Key Flexfield.	6	Create Employee History Summary All History related to the employee can be loaded using this template. This helps in loading all current employment (date tracked history).
7	Create Position API This template is used for creating the Position data into the Position Key Flexfield.	8	Create Employee Assignment This template helps in loading the Employee assignments to an organization, job, position, payroll, grade, supervisor assignments, salary basis etc.
9	Create Applicant This template is used for creating the applicant in Oracle HRMS module.	10	Employee Grade This template is used for creating and updating the Employee's grade information.
11	Create Employee API This template is used for creating the employee master details: All Basic Information about employee.	12	Employee Grade Rate API This template is used for creating the pay scale rate for the grade.
13	Create Person Address API This template is used for creating the employee's address (Home, Work and Any other details). This can also be used for updating the employee's address whenever it changes.	14	Employee Grade rate values API This template helps in creating grade rate values.
15	Create Phone API This template is used for creating the employee's phone (Home, Work and Any other details). This can also be used for updating the employee's phone whenever it changes.	16	Employee Qualification This template is used to create the employee's qualification.
17	Create Contract API This template is used for creating the employment contract.	18	Employee Qualification Type This is a quick code. This data can be loaded using
19	Create Previous Employer API This template is used for creating the employee's history details related to the previous employers.	20	HR Appraisals This template helps to upload employee appraisal values and results.
21	Create Previous Job API This template is used for creating the employee's history details related to the previous jobs.	22	Competency Assignment Creating and updating competency profiles to the employees

Technical Specifications for the appLOAD suite

Overview
Requirements
Platform Certifications
Technical Architecture
System Architecture

The document comes up with the following technical specifications for the appLOAD suite

Hardware and Software requirements
Platform Certifications

Operating System
Application Servers

System Architecture
Technical Architecture

Software Requirements

The following are the software pre-requisites for the appLOAD suite.

J2SE 5 – Java 2 Standard Edition 5 (JDK 1.5.x)
Oracle 10 g Enterprise Edition
J2EE Application Server

Hardware Requirements

Server Capacity varies with the quantum of data and transactions. An approximate server configuration would need the following

Should be a server hardware
Processor – Dual-Core Intel Core2 Duo processor (2 GHz and 2 MB Cache or higher)
Memory – 8 GB memory or Higher
Drives – Hard Disk Drive (HDD) 160 GB

Operating Systems

appLOAD suite can run on the following operating systems

Microsoft Windows Server Editions (XP / 2003 / VISTA)
Redhat Linux Enterprise Edition (4.x / 5.x) server

Certified by redHat and runs well with the RHEL server versions as well.

Application Servers

appLOAD suite can run on the following J2EE Application/Web servers

Oracle Application server 10.1.3.x
JBoss Enterprise Web Server 4.x and 5.x
Apache Tomcat 5.5 and 6.0

technical architecture

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.
As developers have grown familiar with the J2EE architecture, it has become increasingly apparent that access to the data, or persistent storage layer, through enterprise beans often incurs an unnecessary overhead. This overhead is a result of the transactional support provided through these components. In general, read-only access to data is much more common than transactional (create, update, delete) access.
As a result, non-transactional methods for access to the persistent data layer have been developed. These methods continue to provide the abstraction between applications and data, but don't incur the overhead associated with an enterprise bean approach. Chainsys intended to develop frameworks that implement these data access methods to support access to the persistent data layer without an enterprise bean implementation.
This architecture is based upon the Struts MVC pattern and provides abstractions between the various tiers of the architecture. The dataflow is as follows:
Step 1 – Browser sends request to HTTP server via a URL that forwards the request to the Web application server. Based on the <servlet-mapping> entries in web.xml, the application server passes the requests having matching URL patterns, to the Struts Controller Servlet.
Step 2 – The Struts Controller Servlet matches the incoming request to a Struts Action. Further Struts Controller Servlet based on the action mappings passes control either directly to a JSP or instantiates the Action Form associated with the Struts Action. Struts populates the Action Form using the HTTP request parameters and stores the form bean in either HTTP request or HTTP session based on the form scope.
Step 3 – The Custom Action creates a Value Object (VO) and sets its attributes using data provided within the Action Form. It then calls Business Delegate method with VO as parameter. The Business Delegate serves to abstract the lookup of other resources and the methods accessed by the Custom Action
Step 4 – Business Delegate directs application business logic and calls other business objects to affect the application workflow.
Step 5 – Business Object requiring data access uses DAO Factory. A DAO Factory provides connections to a specific data store and implements retrieval of various DAOs.
Step 6 –DAO Implementation implements DAO Interface and provides interaction with Persistent Data (in some cases) via embedded SQL. For other sources of Persistent Data, this access may include EDI interfaces, XML exchanges or proprietary formats. The getDAO () method of the DAO Factory instantiates a new DAO Implementation object.
Step 7 –DAO object reference is passed to the Business Object.
Step 8 – Object calls CRUD operations on DAO Interface.
Step 9 – DAO Interface abstracts data store request to data store-specific DAO Implementation.
Step 10 – Data Access Object (DAO) accesses Persistent Data through JDBC or data store-specific interface.
Step 11 – Persistent Data is returned to DAO Implementation.
Step 12 – DAO Implementation converts retrieved data into list of VO's.
Step 13 – DAO Interface passes VO list back.
Step 14 – Business Objects passes VO list back.
Step 15 – Business Delegate passes VO list back.
Step 16 – Custom Action places results embedded list of VOs into either the HTTP Request Object or HTTP Session Object depending on whether the information is session-persistent or transactional in nature. The Custom Action returns a "forward" tag attribute value to the Controller Servlet, indicating the next URI to which the flow should proceed.
Step 17 – Controller Servlet identifies and forwards request to the appropriate JSP for the above Custom Action.
Step 18 – JSP assembles HTML page and responds to browser with resulting page.

system architecture

LifeWay Christian Resources - Case Study

Hypercom - Case Study

Patel Integrated Logistics - Case Study

ACE Ltd. - Case Study

Application programmable interfaces (API)

Data Validation

Software as a service

Data Transformation

User Friendliness

Scalability

Security

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

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

Other tools in the appLOAD productivity suite
appEXTRACT	appINTERFACE	appMIGRATE	appBI

Home

Corporate

Products

Services

Resources