Oracle® Application Integration Architecture Siebel CRM Integration Pack for Oracle Order Management: Order to Cash Implementation Guide Release 3.1.1 Part Number E20515-03 |
|
|
PDF · Mobi · ePub |
This chapter provides prerequisites and data requirements for initial data loads and each of the process integration flows.
This chapter includes the following sections:
Section 13.2, "Customer Management: Prerequisites and Data Requirements"
Section 13.3, "Product Management: Prerequisites and Data Requirements"
Section 13.6, "Available to Promise: Prerequisites and Data Requirements"
Section 13.7, "Shipping Charges: Prerequisites and Data Requirements"
Section 13.8, "Credit Check: Prerequisites and Data Requirements"
Section 13.9, "Payment Authorization: Prerequisites and Data Requirements"
Section 13.10, "Order Management: Prerequisites and Data Requirements"
Section 13.11, "Asset Management: Prerequisites and Data Requirements"
Before proceeding with the data loads, ensure that:
The Siebel CRM Integration Pack for Oracle Order Management pre-built integration is installed.
Oracle Data Integrator (ODI) is installed on the same machine as AIA_HOME.
ODI master and work repositories are created.
Siebel is installed on Oracle, and users can access the Siebel base tables and Enterprise Integration Manager (EIM) tables for account, product, asset, and price list.
If there are any schema changes on the Siebel side for mandatory columns, then they have to be included in the sample ifb files provided so that the EIM jobs on the Siebel side run successfully.
A database sequence with the name AIA_BULK_LOAD_SEQ is created in the target Siebel database schema. Use this SQL command to create the sequence CREATE or REPLACE sequence AIA_BULK_LOAD_SEQ.
For pricelist initial load, QP_CRMINTEG_PRICELIST_V retrieves records for the pricing organization setup in the profile option QP: Item Validation Organization at the site level. This profile option must be setup with the org for which pricing data has to be retrieved.
This section discusses the prerequisites and data requirements for the Customer Management process integration flow.
The process integration for customer management does not depend on other processes being run; however, the Organization cross-reference must be set up first.
For more information about setting up cross-references, see Chapter 15, "Configuring the Order to Cash Pre-Built Integration."
The process integration for customer management data requirements are:
The Siebel Customer relationship Management (Siebel CRM) business units and Oracle E-Business Suite (Oracle EBS) operating units should be mapped as described in Chapter 15, "Configuring the Order to Cash Pre-Built Integration."
Oracle EBS profile options must be specified.
The contact associated with the order must have the same account associated with it.
Specify the contact name on the Payments tab of the Sales Order screen.
The address must include address line 1, city, state, and zip code.
Different organization parties cannot share locations in Oracle EBS, though they can share addresses between accounts in Siebel. Therefore, the address should be recreated in Siebel.
In Oracle EBS, the contact should be associated at the account level only. For the Order Management application programming interface (API) to process the contact, it should not be associated at multiple levels of an account. For example, the contact should not be associated at the account site (address) level.
If the contact used in Siebel CRM during Order submit is associated with more than one account and contact points (phone numbers or email address) are present, then Order submit will not be supported because the Oracle EBS API for contact update or create does not support shared contact points.
For more information about setting up Siebel Organizations and about Oracle EBS Operating Units and profile options, see Chapter 15, "Configuring the Order to Cash Pre-Built Integration."
This section discusses the prerequisites and data requirements for the Product Management process integration flow.
The process integration for product management does not have a dependency on other processes; however, the following steps should be performed:
Set up organization cross-references.
Set up inventory location cross-references.
For more information about setting up the organizations and cross-references, see Chapter 15, "Configuring the Order to Cash Pre-Built Integration."
The process integration for product management has the following data requirements:
The Item Name field in Oracle EBS is comprised of concatenated key flexfield segments. It cannot exceed 50 characters in length.
Do not use special characters, such as &, in the Oracle EBS item name field definition.
For an Item to be synchronizable from Oracle EBS:
It must have a Customer Orderable Flag
The Item Type value must be either Model, Option Class, or Standard
The Item must belong to an Oracle EBS Item Validation Org.
The unique key to product in Siebel CRM is product name, organization (business unit), and vendor account (not mapped in this integration). The organization name in Siebel CRM must be unique. Siebel CRM supports duplicate product names across organizations but not within an organization.
This section discusses prerequisites for the Price List process integration flow.
The prerequisite for the process integration for price lists is to run the product synchronization flow.
For more information about product synchronization, see Chapter 4, "Process Integration for Product Management."
This section discusses prerequisites and data requirements for the Quotes process integration flow.
The prerequisites for the process integration for quotes integration are:
Product synchronization.
Pricing synchronization.
For more information, see Chapter 4, "Process Integration for Product Management." and Chapter 5, "Process Integration for Price Lists."
This list indicates the mandatory information that must be provided to make this flow successful:
The Quotes integration flow must have a minimum of one quote line item, and the quote line item must have a product already synchronized from the back office.
The quote must have valid customer information details, including account, billing and shipping address, and contact information.
This section discusses prerequisites and data requirements for the Available to Promise process integration flow.
The prerequisite for the ATP Check integration flow is product synchronization.
For more information about the product synchronization flow, see Chapter 4, "Process Integration for Product Management."
This list indicates the mandatory information that must be provided to make this flow successful:
Order has at least one line item.
The quantity on the order line is greater than zero.
A product that has been synchronized from Oracle EBS is specified.
A valid requested delivery date is specified.
This section discusses prerequisites and data requirements for the Shipping Charges process integration flow.
The prerequisites for the shipping charges integration flow are:
For the shipping charges integration flow to work successfully, you must set the glog.integration.remoteQuery.wrapReplyInTransmission property for OTM 5.5 CU5.
For more information about setting this property, see Section 15.12, "Setting a Property in OTM."
The prerequisite for the shipping charges integration flow is product synchronization.
For more information about the product synchronization flow, see Chapter 4, "Process Integration for Product Management."
This section discusses prerequisites and data requirements for the Credit Check process integration flow.
Product synchronization is the prerequisite for the Credit Check integration flow.
For more information about product synchronization, see Chapter 4, "Process Integration for Product Management."
This section discusses perquisites and data requirements for the Payment Authorization process integration flow.
This section discusses prerequisites and data requirements for the Order Management process integration flow.
The prerequisites for the process integration for order management are:
Product synchronization.
Account synchronization.
Price List synchronization (optional).
Organization cross-reference setup.
For more information about these process integrations, see Chapter 13, "Reviewing Prerequisites and Data Requirements," Chapter 4, "Process Integration for Product Management," and Chapter 5, "Process Integration for Price Lists."
The process integration for order management has the following data requirements:
The order must be of the type Sales Order.
The sales order must contain account, billing and shipping address, and shipping contact.
Orders are submitted with the Booked status.
If Price List integration is implemented, the price list name must be specified on the order header.
Only one payment type can be used for the entire order.
If an order line is revised or canceled, a change reason value must be provided at the line-level. The default value is No Reason.
If the entire order is being canceled, the cancel reason must be provided at the order header-level.
This section discusses prerequisites and data requirements for the Asset Management process integration flow.
The cross-business process functional prerequisites for asset integration are:
Product synchronization.
Customer Account synchronization.
For more information about these process integrations, see Chapter 3, "Process Integration for Customer Management" and Chapter 4, "Process Integration for Product Management."