Oracle® Application Integration Architecture Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite and Siebel CRM Implementation Guide Release 3.1.1 Part Number E20504-05 |
|
|
PDF · Mobi · ePub |
This chapter includes the following sections:
Section 8.1.1, "Obtaining Oracle E-Business Suite Operating Unit IDs"
Section 8.4, "Creating Oracle E-Business Suite System Profiles"
Section 8.6, "Setting Up Cross-References for Accessorial and Special Services Products"
This section describes how to set up organizations in Oracle E-Business Suite.
You must determine what organizations you want to support and then get the IDs for those organizations.
To get the Operating Unit details:
Log in to Oracle E-Business Suite database.
Identify the Operating Units that must be synchronized or maintained in Oracle E-Business Suite.
If you want to pick other Operating Units, use this query:
select organization_id, name from hr_operating_units
This section describes how to map Siebel CRM organization.
To map Siebel Organizations to EBS Operating Units:
Log in to Siebel Application.
Click Site Map.
Select Administration - Group, Organizations.
For the Oracle E-Business Suite Operating Units that were identified previously, create the same in Siebel CRM. See Figure 8-1.
Figure 8-1 Administration - Group View Tab in Siebel
This section describes the setup to be done for Oracle Transportation Management (OTM).
You must determine what domains in OTM must be supported.
To get the domain details:
Log in to OTM application.
Navigate to Configuration and Administration.
Click Domain Management.
Select Domain Settings and click Search. Figure 8-2 shows the screen that appears with domain setup:
You must determine what StatusType in Oracle Transportation Management (OTM) is required, for example, CUSTOMERPARTYSTATUS.
To create a StatusType:
Log in to OTM application.
Navigate to Configuration and Administration.
Click the New button.
Enter a Status Type ID, for example, CUSTOMERPARTYSTATUS.
Select LOCATION as the Object Type.
Enter Sequence 1.
Enter two rows: ACTIVE and INACTIVE.
Check the initial value for the ACTIVE row:
Create external systems for all inbound flows to OTM. This table lists the processes involved.
Table 8-1 Processes for Creating External Systems for Inbound Flows to OTM
Process Name | External System ID |
---|---|
SyncCustomerPartyListLogisticsProvABCSImpl |
CUSTOMERPARTY_ESID |
SyncItemListLogisticsProvABCSImpl |
ITEM_ESID |
SyncTransportationSalesOrderListLogisticsProvABCSImpl |
ORDER_ESID |
SyncTransportationStopListLogisticsProvABCSImpl |
TRANSPORTATIONSTOP_ESID |
Note:
: External System IDs and their corresponding processes are in the AIAConfigurationProperties.xml file.
To create external systems:
Log in to Oracle Enterprise Manager Fusion Middleware Control.
Click the desired process.
Click Show WSDL and endpoint URIicon.
Click Concrete WSDL URI and add style="document"attribute to soap:binding.
Save the source on your local system.
Log in to OTM.
Go to Business Process Automation, Communication Management, Web Services and click New.
Click New for WSDL Document.
Click Document Detail.
Enter name for ID.
Upload the saved concrete WSDL.
Ensure Storage is set to Text and Mime Type as text/xml.
Click Finished.
Click Service Details.
Enter Service ID, Service Endpoint ID
Enter Service Endpoint as Endpoint URI as depicted in the screen. See: Section 8.3.3, "Creating Contacts in Oracle Transportation Management".
Enter username and password of your weblogic server.
Note:
For Oracle Transportation Management (OTM) versions earlier than 6.1.2 encrypt the password before entering using Base64 encoding.
Click Finished.
Go to Business Process Automation, Communication Management, External Systems.
Click New.
Enter value for External System ID. See: Section 8.3.3, "Creating Contacts in Oracle Transportation Management" for these values.
Select the web service created previously.
Select Operation as TransmissionReport.
Select the Service Endpoint created earlier.
Click Finished.
Doing these steps creates a contact automatically in Oracle Transportation Management (OTM) with the same name as of External System ID.
To verify, go to Business Process Automation, Communication Management, Contacts.
Note:
: Update OTM_01.Contact_Domain Property in AIAConfigurationProperties.xml for each process with the domain in which External System is created for the corresponding process.
For more information about Oracle Transportation Management, refer Oracle Transportation Management User Guide.
To setup external systems
Login to OTM.
Go to Business Process Automation, Communication Management, External Systems.
Click New.
Enter External System ID as AIA_PLANNEDSHIPMENT_AQ and add a description.
Enter the Queue Name as AIA_PLANNEDSHIPMENT_AQ under the For Queue section.
Figure 8-5 External System Manager Screen
In the Out XML Profiles section, click 'n' for New XML profile.
Enter Out XML Profile ID as MAX.
Choose Default Mode as MAX.
Keep Validate for Max check box unchecked.
Click Finished.
In the Out XML Profiles section, choose the XML Element ID as PlannedShipment.
Click Save.
Click Finished.
You set specific profile options for the customer process integrations in Oracle E-Business Suite.
To set specific profile options for the Customer Management integration:
Log in to Oracle E-Business Suite using the System Administrator responsibility.
Open the System Profile Values form.
Query these profile options and set the indicated values at the site level:
For E-Business Suite:
HZ: Generate Party Number to Yes
HZ: Generate Party Site Number to Yes
Cross-references can be created after organizations have been created in Siebel CRM, operating unit in Oracle E-Business Suite, and domain in Oracle Transportation Management (OTM).
To set up a cross-reference:
Log in to the Siebel database as the table owner.
Run this query to get the IDs for the organizations created in the previous step:
select row_id, name from s_org_ext where name like '%Vision%'
To get the operating unit details:
Log in to Oracle E-Business Suite database (Apps/Apps).
Identify the operating units that must be synchronized or maintained in Oracle E-Business Suite.
Log in to Oracle Applications and get the exact name for the operating units. For example:
Vision Operations (204)
Vision Germany (888)
To pick other operating units, use this query:
select organization_id, name from hr_operating_units
To populate Cross reference values for ORGANIZATION_ID table:
Log in to database.
Connect to schema <AIA_INSTANCE>_xref.
Enter values into cross-reference table using the insert command. See Example 8-1.
Example 8-1 Insert Command for Cross-References
INSERT INTO XREF_DATA VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref','EBIZ_01','27F4D6303B2511DFBFA11DB680CBD54F','204','N','25-AUG-10 02.26.11.000000000 AM') INSERT INTO XREF_DATA VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref','COMMON','27F4D6303B2511DFBFA11DB680CBD54F','COMMON_ORG_ID','N','25-AUG-10 02.26.11.000000000 AM') INSERT INTO XREF_DATA VALUES ('oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref','OTM_01','27F4D6303B2511DFBFA11DB680CBD54F','OTM_ORG_VALUE','N','25-AUG-10 02.26.11.000000000 AM')
Note:
: Keep the row number (third column) same while inserting date for each pair of cross-reference values.
For more information about creating the cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, "Working with Cross References".
Cross-references must be manually maintained for accessorial and special service products that are part of the Orders.
To set up a cross-reference:
Log in to the Siebel application.
Navigate to the Accessorial Product created in Siebel through Administration - Product.
Click the product and then Menu, About Record; the system displays a Row # label. This label is the Row ID of the Accessorial Product in Siebel.
In the same manner, the row ID can be determined for the Special Service product.
To get the row number for the equivalent product ID in Siebel:
Log in to AIA XREF database (aia/aia).
Identify the cross-reference row number of the accessorial or special service product maintained in Siebel by executing this query:
select row_number from xref_data where value = '<SIEBEL ROW ID>' and xref_table_name = 'oramds:/apps/AIAMetaData/xref/ITEM_ITEMID.xref
'
To pick other row_number, repeat the above query with appropriate value for the Siebel row ID.
For more information about creating the accessorials and specials, see Oracle Transportation Management Guide.
To populate cross-references:
Log in to the AIA XREF database (aia/aia).
Create the corresponding entries for the Oracle Transportation Management (OTM) in XREF table. Siebel and COMMON entries would be available in the XREF table.
Create the corresponding OTM entries in XREF manually. Run the query in Example 8-2 to insert the cross-reference values for the accessorials created in OTM.
Example 8-2 Query to Create OTM Entries in XREF
insert into xref_data values ('oramds:/apps/AIAMetaData/xref/ITEM_ITEMID.xref','ACCCESSORIAL_OTM_01',<row number found in the section Identifying XREF Section>,<OTM DOMAIN::otm accessorial product>,'N','17-SEP-10 02.26.11.000000000 AM')
Example 8-3 is the query used to enter the accessorial item Forklift present in the GUEST domain in OTM.
Example 8-3 Query to Enter Forklift Item
insert into xref_data values ('oramds:/apps/AIAMetaData/xref/ITEM_ITEMID.xref','ACCCESSORIAL_OTM_01',F40CCE8024C911DE8F559994B8D73F6F,''GUEST:: Forklift','N','17-SEP-10 02.26.11.000000000 AM')
For more information about creating the cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, "Working with Cross References".
Run the query in Example 8-4 to insert the cross-reference values for the special services created in OTM.
Example 8-4 Query to Insert the Cross-Reference Values for Special Services
insert into xref_data values ('oramds:/apps/AIAMetaData/xref/ITEM_ITEMID.xref','SPECIALSERVICE_OTM_01',<row number found in the section Identifying XREF Section>,<OTM DOMAIN::otm Special service product id>,'N','17-SEP-10 02.26.11.000000000 AM')
Example 8-5 is the query used to enter the special service Customer Unload present in the GUEST domain in Oracle Transportation Management (OTM).