ERP INTEGRATION
ORACLE e-Business ADDITIONAL FOREIGN TRADE SOLUTION
Softway has the best solution to complement its E-Business Suite in the Foreign Trade area. The company is specialized in the development of software and solutions for operating, controlling, and managing different Foreing Trade segments: Import, Export, Import/Export Exchange, and Business Intelligence, as well as controlling and managing special Customs Regimes assigned by SRF, such as: Drawback, RECOF, Blue Line, Industrial Customs Warehouse, Bonded and Assured Warehouse, PEXPAM-Manaus, DCT and DCI, all of them integrated with Oracle ERP.
Today, the success for this integration can be noticed in several clients that have chosen Softway solutions to complement their Oracle E-Business Suite, such as Alcoa, Cummins, Day Brasil, Eaton, Essilor, Flextronics, Karina, Marfrig, Motorola, Mundial, Nextel, Odebrecht, Sanmina-SCI, Scania, TAM, Tecumseh, and Yamaha.
QUALITY, INNOVATION, AND COMMITMENT are the guidelines for this integration success, which has the objective to offer a complete solution that can meet all the customer’s needs in the Foreign Trade area.
INTEGRATION DETAILS - MASTER DATA
The master data included in e-Business Suite (EBS) is transferred to Softway solution, assuring a total integration with the solutions.
Thus, the following information is obtained from EBS modules:
• INV: measure units, inventory items;
• PO: suppliers, carriers;
• AR: clients;
• GL: currency, accountancy;
• OM: Return Orders (RMA).
IMPORT
Softway Import solution is part of the “Procure to Pay” process for the items acquired from vendors of other countries. It allows for managing and executing the import flow phases, including the integration with Government Customs Systems in order to control legal, logistics, and financial parts for imported goods and services. This aspect includes the integration with the following E-Business Suite modules: Inventory (INV), Purchases (PO), Account Payables (AP), General Ledger (GL), Integrated Receipt (RI), and Order Management (OM).
The start data in the import processes for Softway solution are the purchase orders and contracts registered in E-Business Suite. Based on these orders and contracts, Import.Sys/Broker Sys registers invoices that are obtained via EDI or ERP, and creates International Bills of Lading and Import processes, registers Import Licenses (LIs) and Declarations (DIs) into Siscomex, issues Inbound and Additional Notas Fiscais, and controls supplier's payment in foreign currency through exchange operations.
Thus, the following information is obtained from EBS modules:
• PO: purchase orders;
• AP: supplier's invoices, advances and expenses;
• RI: entry and additional notas fiscais;
• GL: expense accounts and exchange fluctuations.
EXPORT
Softway Export solution is part of the “Order To Cash” process for the items sent to customers of other countries. It allows for managing and executing the export flow phases, including the integration with Government Customs Systems in order to control legal, logistics, and financial parts for exported goods and services. This aspect includes the integration with the following E-Business Suite modules: Inventory (INV), Order Managament (OM), Account Receivables (AR), and General Ledger (GL).
Softway export processes are based on sales orders, and on goods deliveries registered into Oracle E-Business Suite. Based on the orders and shipments (translated into Export Sys export processes), the system issues invoices, and origin certificates; transfers Export Registrations, Clearance Declarations, Export Simplified Declarations to Siscomex, sends Notas Fiscais issuing requests to Oracle, and controls the reception of client certificates in foreign currency through Exchange operations.
Thus, the following information is obtained from EBS modules:
• OM: sales orders, deliveries, and package data;
• AR: sales Notas Fiscais data;
• AR: request for issuing Notas Fiscais, and Debit/Credit Advice, as well as information on the client certificate reception;
• GL: expense accounts and exchange fluctuations.
SPECIAL CUSTOMS REGIMES
Softway also has several solutions for the control of fiscal benefits related to suspension, exemption, and partial payment of import and export special operation taxes. These controles include the integration with the following E-Business Suite modules: Inventory (INV), Bill of Materials (BOM), and Discrete Manufacturing and per Process.
The Special Customs Regimes work as collector of inventory, fiscal, and accounting information from Oracle E-Business Suite, providing SRF and other government institutions with the data necessary for the companies to continue making use of the fiscal and logistic benefits granted by such regimes, as well as performing operational controls.
The following data is obtained from these EBS modules:
• INV: stock, and inventory transactions;
• WIP: engineering tree (BOM – “bill of materials”), and production order data;
• RI: Entry Notas Fiscais;
• AR: Output Notas Fiscais;
• MRP: forecast data for exportations;
• RI: Notas Fiscais for tax payment.
Oracle e-Business Suite Release 11
The communications between Softway solutions and Oracle E-Business Suite is optimized by the fact that they all use Oracle database technology, which allows for direct data transfer, with no need of generating intermediate files.
The communications engines meet Oracle standards in its partnership and integration program, which means that the entire Oracle e-Business Suite data collection is performed through CAI Notification Architecture, and its view and trigger sets. For the information return, Softway solutions are written into Open Interface tables, assuring that the data will be handled as necessary in order to be completely inserted into e-Business Suite.
The integration between Softway solution and Oracle eBusiness Suíte Release 11 is homologated by Oracle Brasil.
Oracle e-Business Suite Release 12
The integration process between Softway solution and Oracle E-Business Suite Release 12 is technically based on Oracle Fusion Middleware components, such as Oracle BPEL Process Manager (part of Oracle SOA Suíte). The integration is based on the message exchange process between E-Business Suite and Softway, and BPEL is used to control these processes. This technology allows for a safe integration between the solutions, and is clear for the users.
For E-Business Suite / Softway interface, BPEL process starts with the alerts generated by EBS, and finishes by calling Softway interface API Web Services. For the data return interface (from Softway solution to Oracle E-Business Suite), when a transaction is executed through Softway solution, a message also starts a BPEL process, which finishes by triggering EBS services for the API call, or saving the data in open interface tables.
It is important to highlight that Softway integration with Release 12 is homologated towards Oracle Brasil and Oracle Corporation (Global Homologation).
SFW SOA Console
By adopting SOA (Service Oriented Architecture) platform as the technology to build the integrations between applications, it is necessary to develop a tool that can provide the user with a clear view of the integration scenario for his/her work environment, with no need of deep technical expertise.
This way, Softway has designed SFWSOA Console, which allows for tracking the execution of all the services responsible for the information flow in an easy and fast way. SFWSOA Console main purpose is to enable searching for logs that have been generated by the processes that form the integration environment.
Softway is certified in the ABOVE (Accelerated Business Offerings with Valeu-added Enhancements) Program by Intel and Oracle, with eSoftcomex solution (WEB-based system for Import, Export, Exchange, and Drawback processes).