| Oracle® Application Integration Architecture Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide Release 3.1 Part Number E23246-06 |
|
|
PDF · Mobi · ePub |
| Oracle® Application Integration Architecture Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide Release 3.1 Part Number E23246-06 |
|
|
PDF · Mobi · ePub |
This chapter provides an overview of the process integration for training and absence calendar and covers:
Business process flows
Training and absence calendar integration details
Assumptions and constraints
Oracle E-Business Suite interfaces
Oracle Transportation Management (OTM) interfaces
Core Application Integration Architecture (AIA) components
Integration services
While the driver details exist in the HRMS system as an employee or contractor with appropriate data, OTM also needs to hold driver data because logistics-specific attributes that exist need to be maintained; therefore, you must send driver profile data such as skills, competencies, licenses, and certifications along with other data to OTM. Training and Absence Calendar enables you to use Oracle E-Business Suite HRMS in addition to Oracle Transportation Management. Training and Absence Calendar reference data should be published from Oracle E-Business Suite HR and Learning Management to Oracle Transportation Management.
The process integration for training and absence calendar supports these integration flows:
Initial Loading of Training and Absence Calendar Information: Training and Absence Calendar information is published and sent from Oracle E-Business Suite HR and Learning Management to the Oracle Transportation Management (OTM) at implementation time.
Updating Training and Absence Calendar Information: Enables the synchronization of incremental creation and updates of the newly created or modified training and Absence Calendar information from Oracle E-Business Suite HR and Learning Management into OTM. Irrespective of whether the absence date is planned, approved, confirmed, or actual the date is synchronized from Oracle E-Business Suite to OTM.
This integration flow uses these integration services:
SyncTrainingCalendarListInitialLoadDBAdapter
SyncAbsenceCalendarListInitialLoadDBAdapter
CreateDelegateBookingEbizAdapter
CreateAbsenceAttendanceEbizAdapter
UpdateDelegateBookingEbizAdapter
UpdateAbsenceAttendanceEbizAdapter
UpdateClassScheduleEbizAdapter
UpdateLocationEbizAdapter
UpdateTrainingCenterandLocationEbizAdapter
DeleteDelegateBookingEbizAdapter
DeleteAbsenceAttendanceEbizAdapter
SyncTrainingCalendarListProcess
SyncAbsenceCalendarListProcess
SyncTrainingCalendarListEbizJMSProducer
SyncTrainingCalendarListEbizJMSConsumer
SyncAbsenceCalendarListEbizJMSProducer
SyncAbsenceCalendarListEbizJMSConsumer
SyncTrainingCalendarListEbizReqABCSImpl
SyncAbsenceCalendarListEbizReqABCSImpl
ResourceCalendarEntryEBS
SyncResourceCalendarEntryListLogisticsProvABCSImpl
The purpose of this flow is to load into Oracle Transportation Management (OTM) the training calendar created in Oracle E-Business Suite Learning Management.
When you initiate the process, these events occur:
The SyncTrainingCalendarListInitialLoadDBAdapter service is initiated manually by providing the range of the Start_ID and End_ID that need to be synced to Oracle Transportation Management (OTM), as part of the initial load. For every Booking_ID this service invokes the SyncTrainingCalendarListProcess.
The SyncTrainingCalendarListProcess reads all the training delegate bookings information from the Oracle E-Business database based on the input values provided for the get_training_details API and drops the output messages from these APIs into AIA_EbizTrainingCalendarJMSQueue through the SyncTrainingCalendarListEbizJMSProducer.
The SyncTrainingCalendarListEbizJMSProducer service reads the complete payload from the SyncTrainingCalendarListProcess and drops the messages into AIA_EbizTrainingCalendarJMSQueue.
The SyncTrainingCalendarListEbizJMSConsumer service listens to the AIA_EbizTrainingCalendarJMSQueue, dequeues the messages, and invokes the SyncTrainingCalendarListEbizReqABCSImpl with the TrainingCalendarListEbizABM.
The SyncTrainingCalendarListEbizReqABCSImpl service transforms the TrainingCalendarListEbizABM into the SyncResourceCalendarEntryListEBM and populates the enterprise business message (EBM) header. The transformation does cross-referencing for system-specific values and invokes the ResourceCalendarEntryEBS with the SyncResourceCalendarEntryList operation. The ResourceCalendarEntryEBS is a routing mediator service with several operations on the ResourceCalendarEntryEBO.
The ResourceCalendarEntryEBS service with the SyncResourceCalendarEntryList operation routes the messages based on the CAVS flag to either the SyncResourceCalendarEntryListLogisticsProvABCSImpl service or the CAVS simulator.
The SyncResourceCalendarEntryListLogisticsProvABCSImpl transforms the SyncResourceCalendarEntryListEBM into the LogisticsABM and invokes the OTM web service, which connects to the OTM application.
The purpose of this flow is to load into Oracle Transportation Management (OTM) the training calendar that was updated in Oracle E-Business Suite learning management.
When you initiate the process, these events occur:
In the case of new enrollments, the CreateDelegateBookingEbizAdapter service listens to the oracle.apps.per.api.location.delegate_booking.create_delegate_booking business event. This business event is raised when a new training enrollment is created in Oracle E-Business Suite. The event information is then passed to the SyncTrainingCalendarListProcess.
In the case of updates to existing training enrollments, the UpdateDelegateBookingEbizAdapter service listens to the oracle.apps.ota.api.delegate_booking.update_delegate_booking business event. This business event is raised when a training enrollment is updated in Oracle E-Business Suite. The event information is then passed to the SyncTrainingCalendarListProcess.
In the case of updates to existing training class schedules, the UpdateClassScheduleEbizAdapter service listens to the oracle.apps.ota.api.event_api.update_class_schedule business event. This business event is raised when a training class schedule is updated in Oracle E-Business. The event information is then passed to the SyncTrainingCalendarListProcess.
In the case of updates to a location for a class within a training enrollment, the UpdateLocationEbizAdapter service listens to the oracle.apps.ota.api.event_api.update_location business event. This business event is raised when a location for a class within a training enrollment is updated in Oracle E-Business Suite. The event information is then passed to the SyncTrainingCalendarListProcess.
In the case of updates to a training center and a location for a training enrollment, the UpdateTrainingCenterandLocationEbizAdapter service listens to the oracle.apps.ota.api.event_api.update_trng_cntr_and_location business event. This business event is raised when a training center and a location for a training enrollment is updated in Oracle E-Business Suite. The event information is then passed to the SyncTrainingCalendarListProcess.
In the case that a training enrollment is deleted, the DeleteDelegateBookingEbizAdapter service listens to the oracle.apps.ota.api.delegate_booking.delete_delegate_booking business event. This business event is raised when a training enrollment is deleted in Oracle E-Business Suite. The event information is then passed to the SyncTrainingCalendarListProcess.
The SyncTrainingCalendarListProcess reads all the training delegate bookings and training updates information from the Oracle E-Business database based on the input values provided for the get_training_details API and drops the output messages from these APIs into AIA_EbizTrainingCalendarJMSQueue through the SyncTrainingCalendarListEbizJMSProducer.
The SyncTrainingCalendarListEbizJMSProducer service reads the complete payload from the SyncTrainingCalendarListProcess and drops the messages into AIA_EbizTrainingCalendarJMSQueue.
The SyncTrainingCalendarListEbizJMSConsumer service listens to the AIA_EbizTrainingCalendarJMSQueue, dequeues the messages, and invokes the SyncTrainingCalendarListEbizReqABCSImpl with the TrainingCalendarListEbizABM.
The SyncTrainingCalendarListEbizReqABCSImpl service transforms the TrainingCalendarListEbizABM into the SyncResourceCalendarEntryListEBM and populates the enterprise business message (EBM) header. The transformation does cross-referencing for system -specific values and invokes the ResourceCalendarEntryEBS with the SyncResourceCalendarEntryList operation. The ResourceCalendarEntryEBS is a routing mediator service with several operations on the ResourceCalendarEntryEBO.
The ResourceCalendarEntryEBS service with the SyncResourceCalendarEntryList operation routes the messages based on the CAVS flag to either the SyncResourceCalendarEntryListLogisticsProvABCSImpl service or the Composite Application Validation System (CAVS) simulator.
The SyncResourceCalendarEntryListLogisticsProvABCSImpl transforms the SyncResourceCalendarEntryListEBM into the LogisticsABM and invokes the OTM web service, which connects to the OTM application.
The purpose of this flow is to load into Oracle Transportation Management (OTM) the absence calendar that was created in Oracle E-Business Suite.
When you initiate the process, these events occur:
The SyncAbsenceCalendarListInitialLoadDBAdapter service is initiated manually by providing the range of the Start_ID and End_ID that need to be synced to Oracle Transportation Management (OTM), as part of the initial load. For every Absence Attendance IDs this service invokes the SyncAbsenceCalendarListProcess.
The SyncAbsenceCalendarListProcess reads the absence information, using Absence Attendance from the Oracle E-Business database based on the input values provided for the get_absence_details API and drops the output messages from these APIs into AIA_EbizAbsenceCalendarJMSQueue through the SyncAbsenceCalendarListEbizJMSProducer.
The SyncAbsenceCalendarListEbizJMSProducer service reads the complete payload from the SyncAbsenceCalendarListProcess and drops the messages into AIA_EbizAbsenceCalendarJMSQueue.
The SyncAbsenceCalendarListEbizJMSConsumer service listens to the AIA_EbizAbsenceCalendarJMSQueue, dequeues the messages, and invokes the SyncAbsenceCalendarListEbizReqABCSImpl with the AbsenceCalendarListEbizABM.
The SyncAbsenceCalendarListEbizReqABCSImpl service transforms the AbsenceCalendarListEbizABM into the SyncResourceCalendarEntryListEBM and populates the enterprise business message (EBM) header. The transformation does cross-referencing for system -specific values and invokes the ResourceCalendarEntryEBS with the SyncResourceCalendarEntryList operation. The ResourceCalendarEntryEBS is a routing mediator service with several operations on the ResourceCalendarEntryEBO.
The ResourceCalendarEntryEBS service with the SyncResourceCalendarEntryList operation routes the messages based on the CAVS flag to either the SyncResourceCalendarEntryListLogisticsProvABCSImpl service or the CAVS simulator.
The SyncResourceCalendarEntryListLogisticsProvABCSImpl transforms the SyncResourceCalendarEntryListEBM into the LogisticsABM and invokes the OTM web service, which connects to the OTM application.
The purpose of this flow is to load into Oracle Transportation Management (OTM) the absence calendar that was updated in Oracle E-Business Suite.
When you initiate the process, these events occur:
In the case of new absences, the CreateAbsenceAttendanceEbizAdapter service listens to the oracle.apps.per.api.person_absence.create_person_absence business Event. This business event is raised when a new absence is created in Oracle E-Business Suite. The event information is then passed to the SyncAbsenceCalendarListProcess.
In the case of updates to existing absences, the UpdateAbsenceAttendanceEbizAdapter service listens to the oracle.apps.per.api.person_absence.update_person_absence business event. This business event is raised when an absence is updated in Oracle E-Business Suite. The event information is then passed to the SyncAbsenceCalendarListProcess.
In the case that an absence is deleted, the DeleteAbsenceAttendanceEbizAdapter service listens to the oracle.apps.per.api.person_absence.delete_person_absence business event. This business event is raised when an absence is deleted in Oracle E-Business Suite. The event information is then passed to the SyncAbsenceCalendarListProcess.
The SyncAbsenceCalendarListProcess reads all the absences and updates to the absences from the Oracle E-Business database based on the input values provided for the get_absence_details API and drops the output messages from these APIs into AIA_EbizAbsenceCalendarJMSQueue through the SyncAbsenceCalendarListEbizJMSProducer.
The SyncAbsenceCalendarListEbizJMSProducer service reads the complete payload from the SyncAbsenceCalendarListProcess and drops the messages into AIA_EbizAbsenceCalendarJMSQueue.
The SyncAbsenceCalendarListEbizJMSConsumer service listens to the AIA_EbizAbsenceCalendarJMSQueue, dequeues the messages, and invokes the SyncAbsenceCalendarListEbizReqABCSImpl with the AbsenceCalendarListEbizABM.
The SyncAbsenceCalendarListEbizReqABCSImpl service transforms the AbsenceCalendarListEbizABM into the SyncResourceCalendarEntryListEBM and populates the enterprise business message (EBM) header. The transformation does cross-referencing for system-specific values and invokes the ResourceCalendarEntryEBS with the SyncResourceCalendarEntryList operation. The ResourceCalendarEntryEBS is a routing mediator service with several operations on the ResourceCalendarEntryEBO.
The ResourceCalendarEntryEBS service with the SyncResourceCalendarEntryList operation routes the messages based on the CAVS flag to either the SyncResourceCalendarEntryListLogisticsProvABCSImpl service or the CAVS simulator.
The SyncResourceCalendarEntryListLogisticsProvABCSImpl transforms the SyncResourceCalendarEntryListEBM into the LogisticsABM and invokes the Oracle Transportation Management (OTM) web service, which connects to the OTM application.
These are the assumptions and constraints:
A business group can have only one unique name for Domain.
The Calendar Event Type is manually maintained in both Oracle E-Business Suite and Oracle Transportation Management (OTM) and mapped using DVM.
For the training and absence calendar integration flow, these are the Oracle E-Business Suite interfaces:
SyncTrainingCalendarListInitialLoadDBAdapter
SyncAbsenceCalendarListInitialLoadDBAdapter
CreateDelegateBookingEbizAdapter
CreateAbsenceAttendanceEbizAdapter
UpdateDelegateBookingEbizAdapter
UpdateAbsenceAttendanceEbizAdapter
UpdateClassScheduleEbizAdapter
UpdateLocationEbizAdapter
UpdateTrainingCenterandLocationEbizAdapter
DeleteDelegateBookingEbizAdapter
DeleteAbsenceAttendanceEbizAdapter
SyncTrainingCalendarListProcess
SyncAbsenceCalendarListProcess
SyncTrainingCalendarListEbizJMSProducer
SyncTrainingCalendarListEbizJMSConsumer
SyncAbsenceCalendarListEbizJMSProducer
SyncAbsenceCalendarListEbizJMSConsumer
SyncTrainingCalendarListEbizReqABCSImpl
SyncAbsenceCalendarListEbizReqABCSImpl
For more information about Oracle E-Business Suite web services, see Oracle E-Business Suite references: Oracle E-Business Suite Electronic Technical Reference Manual (eTRM) located on My Oracle Support and Oracle Applications Online Documentation Library, located on the Oracle Technology Network (http://www.oracle.com/technology/documentation/applications.html)
The SyncTrainingCalendarListInitialLoadDBAdapter service is used for initial loads and is triggered manually. The input to this process should be the Start_ID and the End_ID. This service reads all the Booking ID information from the Oracle E-Business Suite database based on the input values and passes this information to the SyncTrainingCalendarListProcess for further processing.
The SyncAbsenceCalendarListInitialLoadDBAdapter service is triggered manually for initial loads. The input to this process is Start_ID and the End_ID. This service reads all the Absence Attendance ID information from the Oracle E-Business Suite database based on the input values and passes this information to the SyncAbsenceCalendarListProcess for further processing.
The CreateDelegateBookingEbizAdapter service is used for incremental changes. When any Training Enrollment is created, the oracle.apps.ota.api.delegate_booking.create_delegate_booking business event queries the Oracle E-Business Suite database for Delegate Booking with the Booking_ID and invokes the SyncTrainingCalendarListProcess.
The CreateAbsenceAttendanceEBizAdapter service is used for incremental changes. Whenever an absence is created, this service calls the oracle.apps.per.api.person_absence.create_person_absence business event to query the Oracle E-Business Suite database for attendance ID and invokes the SyncAbsenceCalendarListProcess service.
The UpdateDelegateBookingEbizAdapter service is used for incremental changes. When any training enrollment is created, the oracle.apps.ota.api.delegate_booking.update_delegate_booking business event queries the Oracle E-Business Suite database for Delegate Booking with the Booking_ID and invokes SyncTrainingCalendarListProcess.
This service is used for incremental changes. This service raises the oracle.apps.ota.api.event_api.update_class_schedule business event when a class schedule of a training enrollment is updated and invokes the SyncTrainingCalendarListProcess.
The UpdateLocationListEbizAdapter is used for incremental changes. When a location for the class in a training enrollment is updated, this service calls the oracle.apps.ota.api.event_api.update_location business event to query the Oracle E-Business Suite database for delegate booking and invokes the SyncTrainingCalendarListProcess.
The UpdateTrainingCenterandLocationEBizAdapter raises the oracle.apps.ota.api.event_api.update_trng_cntr_and_location business event when a training center and location for the training enrollment is updated; this event queries the Oracle E-Business Suite database for delegate booking and invokes the SyncTrainingCalendarListProcess.
The UpdateAbsenceAttendanceEbizAdapter service is used for incremental changes. This service listens to oracle.apps.per.api.person_absence.update_person_absence business event. Whenever an absence is updated, this business event is triggered, which contains absence_attendance_ID. This service invokes the SyncAbsenceCalendarListProcess service.
When any location for the training enrollment is deleted, the DeleteDelegateBookingEBizAdapter service raises the oracle.apps.ota.api.delegate_booking.delete_delegate_booking business event and invokes the SyncTrainingCalendarListProcess service.
The DeleteAbsenceAttendanceEbizAdapter service is used for incremental changes. This service listens to the oracle.apps.per.api.person_absence.delete_person_absence business event. Whenever an absence is deleted, this business event is triggered, which contains the absence_attendance_ID. This service invokes the SyncAbsenceCalendarListProcess service.
This service is used for initial loads through the SyncTrainingCalendarListInitialLoadDBAdapter and is called from the Oracle E-business Suite adapters. This service reads all the training information from the Oracle E-Business Suite database using the get_training_details API and drops the output messages into the AIA_EbizTrainingCalendarJMSQueue through the SyncTrainingCalendarListEbizJMSProducer service.
This service is used for initial loads through the SyncAbsenceCalendarListInitialLoadDBAdapter and is called from the Oracle E-business Suite adapters for incremental changes. This Service reads all the absence information from the Oracle E-Business Suite database using the get_absence_details API and drops the output messages into the AIA_EbizAbsenceCalendarJMSQueue through the SyncAbsenceCalendarListEbizJMSProducer service.
The SyncTrainingCalendarListEbizJMSProducer is a mediator service used for both initial and the incremental loads. This service pushes the messages to AIA_EbizTrainingCalendarJMSQueue and is picked up by the SyncTrainingCalendarListEbizReqABCSImp service.
The SyncTrainingCalendarListEbizJMSConsumer service is used for initial and incremental loads. This service picks up the messages from AIA_EbizTrainingCalendarJMSQueue and invokes the SyncTrainingCalendarListEbizReqABCSImpl service.
The SyncAbsenceCalendarListEbizJMSProducer is a mediator service. This service is used for both initial and incremental loads. This service pushes the messages from the AIA_EbizAbsenceCalendarJMSQueue and invokes the SyncAbsenceCalendarListEbizReqABCSImpl service.
Oracle Transportation Management (OTM) provides an interface through a web service to connect to its application. This connectivity is established as a partner link in the provider service. Once invoked, the logistics web service immediately returns an acknowledgement with a transmission number. Once the processing is complete, it then sends a transmission report back indicating the success or the failure.
The application business message (ABM) details can be seen in the GLOG xsd with specific element as DriverCalendarEvent.
For more information about the Logistics Service, see Oracle Transportation Management Integration Guide.
The integration flow uses these components:
ResourceCalendarEntryEBO
SyncResourceCalendarEntryListEBM
ResourceCalendarEntryEBS
The core enterprise business object (EBO) and enterprise business message (EBM) XSD files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseObjectLibrary/Core/EBO/ parent folder.
The core enterprise business services (EBS) web services definition language (WSDL) files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseBusinessServiceLibrary/Core/EBO/ parent folder.
For detailed documentation of individual EBOs and EBMs, click AIA Reference Doc link on EBO and EBM detail pages in the Oracle Enterprise Repository.
For more information about using the Oracle Enterprise Repository and configuring it to provide the AIA Reference Doc link, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, Configuring and Using Oracle Enterprise Repository as the Oracle AIA SOA Repository.
EBOs can be extended, for instance, to add new data elements. These extensions are protected, and remain intact after a patch or an upgrade.
For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, Extensibility for AIA Artifacts.
These are the services delivered with this integration:
SyncTrainingCalendarListEbizReqABCSImpl
SyncAbsenceCalendarListEbizReqABCSImpl
ResourceCalendarEntryEBS
SyncResourceCalendarEntryListLogisticsProvABCSImpl
The SyncTrainingCalendarListEbizReqABCSImpl is a business process execution language (BPEL) process that has the ResourceCalendarEntryEBS as a partner service. This service receives the TrainingCalendarListEbizABM message as a request and does not return a response to the calling service.
This service performs these actions:
Accepts the TrainingCalendarListEbizABM message from Oracle E-Business Suite. This message contains a cross-reference for Resource Calendar Entry ID.
Transforms the TrainingCalendarListEbizABM into the SyncResourceCalendarEntryListEBM. While it is transforming from the application business message (ABM) to the EBM, cross-references are looked up for RESOURCECALENDARENTRY_ID.
Sends the SyncResourceCalendarEntryListEBM message as an input to the SyncResourceCalendarEntryList operation in the ResourceCalendarEntryEBS service.
The SyncAbsenceCalendarListEbizReqABCSImpl is a business process execution language (BPEL) process that has the ResourceCalendarEntryEBS as a partner service. This service receives the ResourceCalendarListEbizABM message as a request and does not return a response to the calling service.
This service performs these actions:
Accepts the ResourceCalendarListEbizABM message from Oracle E-Business Suite. This message contains a cross-reference for resource calendar entry ID.
Transforms the ResourceCalendarListEbizABM into the SyncResourceCalendarEntryListEBM. While it is transforming from the application business message (ABM) to the enterprise business message (EBM), cross-references are looked up for RESOURCECALENDARENTRY_ID.
Sends the SyncResourceCalendarEntryListEBM message as an input to the SyncResourceCalendarEntryList operation in the ResourceCalendarEntryEBS service.
The DVM lookup used by this service is CALENDAR_EVENT_TYPE. It is the domain value mapping for Absence Category/Calendar Event types.
The ResourceCalendarEntryEBS is the Enterprise Business Service that exposes all the enterprise operations related to the resource calendar, such as create resource calendar, update resource calendar, synchronize resource calendar, and so on. This integration uses only the SyncResourceCalendarEntryList operation. This Enterprise Business Service routes the request to the appropriate provider like the SyncResourceCalendarEntryListLogisticsProvABCSImpl or the Composite Application Validation System (CAVS) based on the filter condition and operations. No transformations are done in this service. Oracle Transportation Management (OTM) determines whether this synchronize location message is for a create or an update action.
For more information about this EBS, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, Designing and Developing Enterprise Business Services and Oracle Fusion Middleware Concepts and Technologies Guide for Oracle Application Integration Architecture Foundation Pack, Understanding Enterprise Business Services.
The SyncResourceCalendarEntryListLogisticsProvABCSImpl receives the SyncResourceCalendarEntryListEBM as an input from the ResourceCalendarEntryEBS, transforms it into the LogisticsABM, and invokes the Logistics web service. This service waits for the transmission report from the OTM. If the transaction is successful, the cross-reference is populated; otherwise, the AIAAsyncErrorHandling process is invoked with the error message. This SyncResourceCalendarEntryListLogisticsProvABCSImpl is a business process execution language (BPEL) process, which receives the SyncResourceCalendarEntryListEBM, transforms the message into the LogisticsABM, invokes the Logistics web service with the SyncResourceCalendarEntryListEBM, and waits for the transmission report from the Logistics web service. If the transmission report specifies that the transaction is successful, it supplies the cross-reference values; otherwise, it invokes the AIAAsyncErrorHandlingBPEL process to generate the error messages.
The DVM lookup used by this service is CALENDAR_EVENT_TYPE. It is the domain value mapping for Absence Category/Calendar Event types.
|
 Copyright © 2001, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
