3S SIMPLE SOLUTION SERVICES

	Interface
	Data transfer between two or more applications or synchronizing the data between two or more applications are done by interfaces. Interfaces can be done by many ways, and few are listed below. dB Links between applications Flat file data extract, and import using SQL Loader or PL/SQL program using file read utilities EDI Gateways BPEL / SOA Power Automate / Web Methods / Oracle Integration Cloud (OIC) For all the options, the mapping of source and destination is driven by the business process. There are application validations in the standard interfaces. All the other custom validation rules need to be done before using the standard interface programs. In a very simple interface system there will be one source and one destination application. All the validations are done during the data extract. Seeded validations are handled by the application. In a complex interface system, there will be more than one source and more than one destination instances. For example, in one of the project there is a requirement to synchronize the HR details between PeopleSoft, Oracle EBS, and SAP. BPEL process is used to transfer the data, translate to the respective application values, and synchronize between systems. Most Common Interfaces Items, and BOM Inventory and WIP Transactions HR Details including Person, and Salary Processing Bank Transactions Purchase Orders, and Receipts Orders and Shipments Payments

Interface

Data transfer between two or more applications or synchronizing the data between two or more applications are done by interfaces. Interfaces can be done by many ways, and few are listed below.

dB Links between applications
Flat file data extract, and import using SQL Loader or PL/SQL program using file read utilities
EDI Gateways
BPEL / SOA
Power Automate / Web Methods / Oracle Integration Cloud (OIC)

For all the options, the mapping of source and destination is driven by the business process. There are application validations in the standard interfaces. All the other custom validation rules need to be done before using the standard interface programs.

In a very simple interface system there will be one source and one destination application. All the validations are done during the data extract. Seeded validations are handled by the application. In a complex interface system, there will be more than one source and more than one destination instances. For example, in one of the project there is a requirement to synchronize the HR details between PeopleSoft, Oracle EBS, and SAP. BPEL process is used to transfer the data, translate to the respective application values, and synchronize between systems.

Items, and BOM
Inventory and WIP Transactions
HR Details including Person, and Salary Processing
Bank Transactions
Purchase Orders, and Receipts
Orders and Shipments
Payments