oow16 - oracle e-business suite integration best practices [con6709]

OracleE-BusinessSuiteIntegraEonBestPracEces

VijayShanmugamDirector,ApplicaEonsTechnologyGroupOracleE-BusinessSuiteDevelopmentSeptember19,2016

SafeHarborStatementThefollowingisintendedtooutlineourgeneralproductdirecEon.ItisintendedforinformaEonpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfuncEonality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andEmingofanyfeaturesorfuncEonalitydescribedforOracle’sproductsremainsatthesolediscreEonofOracle.

Agenda

OracleE-BusinessSuiteIntegraEonOverview

EBSIntegraEonProducts&BestPracEces

EBSforSOA,Mobile&CloudIntegraEons

KeyTakeaways

Roadmap

Agenda

KeyTakeaways

Roadmap

AnOverviewOracleE-BusinessSuiteIntegraEons

OracleE-BusinessSuite

Mobile On-Premise,CloudApplicaBons

PartnerApplicaBonsProcessIntegraBons

OracleE-BusinessSuiteIntegraEonStyles&Technology

NaBveInterfaces Data Event Process B2B SOAP

OpenInterface

ConcurrentProgram

BusinessEventSystem

Workflow

XMLGateway

E-CommerceGateway

PL/SQLAPIs

JavaAPIs

Mobile,UI

SOAPServices RESTServices

IntegratedSOAGateway

IntegraEonRepository

INTERFACES

OF EBSINTEGRATIONINTERFACES

MANAGEMENT

IntegraEonRepositoryCentralizedRepositoryforEBSSeededandCustomInterfaces

Annotate

Upload

Interfaces CentralizedViewofOracleSeeded&CustomInterfaces

XMLGateway

PL/SQLAPIs

ConcurrentPrograms

JavaAPIs BusinessServiceObjects

BusinessEvents

Agenda

KeyTakeaways

Roadmap

JavaandPLSQLAPIsNaEveInterfaces–IntegraEonStyle

•  PL/SQLandJavabasedPublicAPIs•  UsedforExtension,IntegraEonwithinFirewallinHomogeneousplacorm

•  FollowEBSguidelinesforcustomizaEon&extension

•  DescribedinIntegraEonRepository•  Create,updatebusinessobjects,re-usebusinesslogic/rules,retrievebusinessdata

OpenInterface&ConcurrentProgramforBulkDataUpdatesDataCentricIntegraEon–IntegraEonStyle

ConcurrentProgram

OpenInterfaceTables

BaseTables OpenInterfaceViews

SQL*Loader

OracleDataIntegrator

3rdpartyAdapter

DataSourceToolstoExtract,Transform&Load

Extract

TextFile

CustomTable

WebADIforSmallBatchDataUploadDataCentricIntegraEon–IntegraEonStyle

ConcurrentProgram

OpenInterfaceTables

BaseTables

TextFile

ManualVerificaBon,Update&Upload

UploadWebADI

DownloadCustomTable

DataSource

Download

CreateCustomWebADIIntegratorsDesktopIntegraEonFramework

•  UseDesktopIntegraEonFrameworktoCreateCustomWebADIIntegrators

•  UseLOVs&DatePickerComponents

•  ImporterRules– HandleerrorsituaEons&displayerrormessage

–  Cleanuptemporarydata

EmbeddedBusinessEventSystemEventDriven–IntegraEonStyle

AdvancedQueue

BusinessEvent

WorkflowProcess

ServiceInvocaBonFramework

NoBficaBonMailer

XMLGateway

PL/SQL&JavaAPIs(BusinessLogic)

TradingPartners

Emails

WebServices

BusinessAcBvityMonitoring

BusinessProcessAutomaBonusingOracleWorkflowProcessCentric–IntegraEonStyle

WorkflowBusinessEvents

NoBficaBons

ParallelFlows Looping ChainingRouBng

WebServices

BPELProcess/SOAComposites

TradingPartners

BusinesstoBusiness–IntegraEonStyle

TransacBonManagement Point

PointPoint

TradingPartner

Management

MessageTransport

Monitoring

TradingPartners

•  IndustryB2BStandards•  CrossFirewall•  MulE-Enterprise

•  CollaboraEonwithPartners

OracleE-CommerceGatewayforEDITransacBonsBusinesstoBusiness–IntegraEonStyle

ConcurrentProgram

OpenInterfaceTables/Views

BaseTables

ASCIITextFile

E-CommerceGateway

B2BGateway/3rdPartyEDITranslator

TradingPartnersEDIStandardFile

OracleXMLGatewayforXMLbasedStandardBusinessTransacBonsBusinesstoBusiness–IntegraEonStyle

BusinessEvents

WorkflowProcess

PL/SQL&JavaAPIs(BusinessLogic)

TradingPartners

AdvancedQueue

OpenInterfaceTables/Views

BaseTables

XMLGateway

WebServices–IntegraEonStyle

•  WS-Standards•  MessagelevelProtocols•  TransportProtocolsHTTP,JMS•  XMLMessageFormat

•  DatatransmieedoverHTTP(S)•  HTTPVerbs•  HTTPHeaders•  XML,JSON,CSVMessageFormats

OracleE-BusinessSuiteIntegratedSOAGatewayWebServices–IntegraEonStyle

Monitor

SOAP/RESTServiceProviders

Secure

Provide

HRMS ProcurementFinanceCRM

Publish

Consume

ServiceInvocaBonFramework

DeployanInterfaceasSOAPWebService

Generate

Deploy

DeployanInterfaceasRESTWebService

Generate

Deploy

FuncEonalSecurityatOperaEonlevel

Monitor,AuditandViewLogforWebServiceInvocaBonsServiceMonitor

ServiceenabledInterfaceTypesinISG

InterfaceType SOAPService RESTService

PL/SQLAPI(1200)

BusinessServiceObject(40)

JavaBeanService(4)

ApplicaEonModuleService

ConcurrentProgram(90)

OpenInterfaceTable(190)

OpenInterfaceView(20)

XMLGateway(51,inbound)

EDI(22)

*CPasRESTServiceiscurrentlyavailableforEBSR12.1.3only.

SummaryofSetupandConfiguraBonforIntegratedSOAGatewaySOAPandRESTServiceProviders

E-BusinessSuiteRelease SOAPServices RESTServices

12.1.3MOSDoc556540.1

•  SetupwithinEBSmid-Eer•  NoaddiEonallicense

•  NoaddiEonallicense•  SetupwithinEBSmid-Eer•  SimplesetupstepsOracleE-BusinessSuite

12.2MOSDoc1311068.1

•  RequiresexternalSOASuite•  HaslicenseimplicaEons•  DedicatedEBSISGWLSdomain•  LeverageWSstandardssupportedbySOA

ConsumeandInvokeExternalSOAPWebServicesServiceInvocaEonFramework

PL/SQLAPIs Forms Workflow ConcurrentPrograms(Java/PLSQL)

OAFpages

ServiceInvocaBonFramework(WebServiceClient)

SOAPServices

JavaAPIs

UseBusinessEventSystemtoInvokeWebServiceConsumeSOAPWebService

CreateInvokerBusinessEvent

CreateInvokeWebServiceSubscripBon

ConsumeWebServiceWSDLandCreateMeta-

WriteBusinessLogictoPrepareInputandConsumeResponse

RaiseBusinessEventtoInvokeWebService

CreateInvokerBusinessEventandInvokeWebServiceBusinessEventSubscripBonConsumeSOAPWebService

Agenda

KeyTakeaways

Roadmap

•  DriveEBSandCloudCo-existenceStrategy•  WebServiceStandarddrivenSOAPIntegraEons•  Messagelevelsecurity•  Asynchronousmessaging•  ExcepEonandFaulthandling

Fine-grainedServicesE-BusinessSuiteSOAPWebServices

OracleE-BusinessSuite12.2

EBSWLSDomain

ManagedServers(OACORE,OAFM)

AdminServer

ExternalSOAPWebServiceIntegraBons

OracleSOASuite

EBS-ISGWLSDomain

ISGSOAServer

ISGAdminServer

EBSSOAPWebServices

EBSDatabase EBS-ISGDomainSchema

SOADatabase

Coarse-grainedServicesE-BusinessSuiteSOAPWebServices

OracleE-BusinessSuite12.2

EBSWLSDomain

ManagedServers(OACORE,OAFM)

AdminServer

ExternalSOAPWebServiceIntegraBons

OracleSOASuite

EBSISGWLSDomain

ISGSOAServer

ISGAdminServer

OtherSOAWLSDomain

EBSSOAPWebServices

SOAServer

AdminServer

SOAComposites

EBSDatabase EBS-ISGDomainSchema

OtherSOADomainSchema

SOADatabase

Scalable&HighlyAvailableConfiguraEonforSOAPServices

SOAPClient

EBSLoadBalancer WebClient

EBSNode1

SOASuiteLoadBalancer

SOANode2

EBSNode2

SOANode1

TechnicalIntegraBonArchitectureCo-existenceScenario–OracleEBSandAccounEngCloud

ERPCloud

SOAPWebService

(SOASuite)

DrilldowntoEBSGL–SLA-

TransacEons

SetUpDataGLBalances

heprequestfromuser’sbrowser

EBSWorkflowServiceInvocaEonFramework

EBSGeneralLedger

hepsprotocol

NoExtraTechnologyDependencyIntegratedSOAGatewayServiceInvocaEonFramework

BusinessEvent

EventPayloadasAaachment

ServiceInvocaBonFramework CloudSOAPWebServicesWebServiceSubscripEon

TransferLedgerSetup,Balances

Programs

XSLTransformaBon

EmbedWS-Securityheaders

EmbedcustomSOAPHeaders

CloudFinancialReports

HTTPSRequest

HTTPSResponse

• CreateLedger• ImportandPostJournals• GenerateReports

OracleE-BusinessSuite AccounEngHubReporEngCloudService

Mobile• Lightweight•  InteracBve• Developerfriendly

LightweightRESTServicesinOracleE-BusinessSuite12.1.3and12.2Mobile&UIIntegraEonswithE-BusinessSuite

EBSDatabase

RESTServiceProviderApplicaBonServer

PL/SQL

ApplicaBonModule JavaBeanServices SecurityServices

HighlyInteracBveforMobileandUIintegraBonsPaginaEonUsingEBSRESTServices

RESTWebServices

IntegraBonInterfaces

hep://.../webservices/rest/.../getemployees?offset=0&limit=5

Scalable&HighlyAvailableConfiguraEonforRESTServices

EBSLoadBalancer

Web/RESTClient

EBSOACoreNode1

EBSOACoreNode2

EBSOAFMNode1

EBSOAFMNode2

EBSOAFMNode3

OAFMCluster

OACoreCluster

BeInformedandTakeAcBonontheGoE-BusinessSuiteSmartphoneApplicaEons

HorizontalApps–formostemployees•  Approvals•  Expenses•  Timecards•  iProcurement

LineofBusinessApps•  SalesOrders•  ProductInformaEon•  Inventory•  Procurement•  ProjectManager•  ProjectManufacturing•  ServiceManager

•  Self-ServiceHumanResources•  Learning•  PersonDirectory

•  FieldService•  Maintenance•  MobileSupplyChainApps(MSCA)•  DiscreteProducEonSupervisor•  ProcessProducEonSupervisor•  DiscreteQualityManager•  ProcessQualityManager•  Yard

•  EBS12.1.3and12.2•  iOSandAndroid•  NoaddiEonalcostsforlicensed

usersofbaseproducts•  BuiltwithOracleMobileApplicaEon

Framework(MAF)

Forlatestappavailability,checkEBSMobileAppsMOSNote1641772.1orsearch‘OracleEBSAmerica’onappstore

SmartphoneApplicaBons(22) DeliveryStrategy

Cloud• IntegratewithEBSusingICSandSOACS• InboundandOutboundIntegraEons

Industry’sMostComprehensiveCloudPlacormStrategy

SobwareasaService

InfrastructureasaService

PlacormasaService

IntegraBonCloudService

SOACloudService

IntegraEonCloudService&SOACloudService

ICS SOACS/SOASuite

Deployment OnCloud OnCloudorOnPremise

UserPersona BusinessUser ITDeveloper

UseCases • Simplepoint-to-pointintegraEons• UsecaseswithlimitedorchestraEons• MessagebasedrouEng,StatelessexecuEons

• ComplexorchestraEons(includingB2B)• StatefulexecuEons• Liu&Shiu(Dev,Test)

Cloud-PremiseConnecEvity

Agentframework VPNservicefromCompute

E-BusinessSuiteAdapterinIntegraEonCloudService

IntegratedSOAGatewayRESTServices

ORACLECLOUD ONPREMISE

ICSEBSAdapter

IntegratedSOAGatewayRESTServiceFramework

ServiceRequests

OracleRightNowtoE-BusinessSuite–ServiceRequestExampleIntegraEonScenario

Oracle Service Cloud

Incidents

•  CustomerenterstheRNCustomerportalto:•  Searchknowledgebase(RN)

•  Submitnewissue/incident-CheckstatusofServiceRequest

•  Checkstatusofdispatchtask•  CheckstatusofRMA

•  ServiceIncidentswillbecreatedandstoredinRN/shadowSRwillbecreatedinEBS

•  RepairordersanddispatchtaskswillbecreatedinEBSandexposedthroughRNincident

On-Premise/CloudbasedIntegraEonPlacorm

ON-PREMISES

On-premisesIntegraBonPlacorm(SOASuite,OSB)

IntegraBonPlacormasaService(ICS,SOACS)

HYBRID

IntegraBonPlacormasaService(ICS,SOACS)

On-premisesIntegraBonPlacorm(SOASuite,OSB)

Agenda

SOA,Cloud&MobileIntegraEons

OracleE-BusinessSuiteIntegratedSOAGateway

KeyTakeaways

Roadmap

OracleE-BusinessSuiteIntegraEonStyles&Technology

NaBveInterfaces Data Event Process B2B SOAP

OpenInterface

ConcurrentProgram

BusinessEventSystem

Workflow

XMLGateway

E-CommerceGateway

PL/SQLAPIs

JavaAPIs

Mobile,UI

Agenda

SOA,Cloud&MobileIntegraEons

OracleE-BusinessSuiteIntegratedSOAGateway

KeyTakeaways

Roadmap

ISGRoadmap• AutomaEonofISGconfiguraEons• RESTenable:– ConcurrentPrograminR12.2(forwardport)– OpenInterfaceTables– OpenInterfaceViews

• RESTServiceInvocaEon• RESTMonitoring&Logging

RelatedSessionsIntegraBons

WEDSep214:15PM

CON6724-LeverageIntegraEonCloudServiceforOracleE-BusinessSuiteRekhaAyothi,ProductManager,ApplicaEonsTechnology,OracleE-BusinessSuite

MosconeWest3022

MosconeWest–ExhibiBonHallMon,Sep19:10:15AM–5:30PMTue,Sep20:10:15AM–5:15PMWed,Sep21:10:15AM–4:15PM

ConfidenEal–OracleInternal/Restricted/HighlyRestricted

DEMOgrounds–OracleE-BusinessSuitePods

•  WAJ-016–OracleE-BusinessSuiteonOracleCloud(IaaS&PaaS)

•  WAJ-017–AutomatedOracleE-BusinessSuiteTestsUsingOracleFlowBuilder

•  WAJ-018–SystemAdministraEon,AdvancedArchitecture&Security

•  WAJ-019–OracleE-BusinessSuite:TechnicalUpgradeBestPracEces

•  WAJ-020–NewUserInterfaceCapabiliEesinOracleE-BusinessSuite

Note:LocatedintheApplicaEonsandJDEdwardsShowcase

QuesEons

oow16 - oracle e-business suite integration best practices [con6709]

Technology

administering oracle soa suite and oracle business · pdf...

oow16 - oracle e-business suite: technology certification...

first steps with oracle autonomous database transaction...

oow16 - oracle enterprise manager 13c cloud control for...

oow16 - faster and better: oracle e-business suite desktop...

first steps with oracle autonomous transaction...

oracle idm suite

oracle® functional testing suite advanced pack for oracle...

oracle soa suite/bpm suite virtualbox appliance · oracle...

oow16 - deploying oracle e-business suite for on-premises...

oow16 - planning your upgrade to oracle e-business suite...

oow16 - simplified and touch-friendly user interface in...

oracle e-business suite deployment on oracle …oracle...

oow16 - technical upgrade best practices for oracle...

guide de l'utilisateur - oracle developer suite 10g vista de...

deployment in oracle soa suite and in oracle bpm suite

#oow16 - implement the best practice for oracle financial...

oow16 - advanced architectures for oracle e-business suite...

oow16 - maintenance strategies for oracle e-business suite...

oracle business suite