7 Configuring the Oracle Product Hub Integration

Oracle Product Hub, Siebel CRM, and Oracle E-Business Suite must be set up for the integration to work properly. This includes setting up organizations, setting up inventory locations, and so on.

This chapter includes the following sections:

• Section 7.1, "Adding a New Spoke Instance"

• Section 7.2, "Post Installation Configuration Set Up"

• Section 7.3, "Setting Up Oracle BRM"

• Section 7.4, "Setting Up Cross-References"

• Section 7.5, "Working with Cross-References"

• Section 7.6, "Working with Domain Value Maps"

• Section 7.7, "Handling Errors"

• Section 7.8, "Setting Configuration Properties"

• Section 7.9, "Setting Up the Data for Seeded Attributes of the Telecommunications Library"

• Section 7.10, "Setting up List of Values in Siebel"

7.1 Adding a New Spoke Instance

To add a new spoke or target instance for the integration:

1. Add the instance name to the destination system to pick target systems while publishing.

   1. Login to OPH.

   2. Navigate to the responsibility OPH Data Librarian.

   3. Under Batch Import, navigate to Import Workbench.

   4. Click the System Setup tab.

   5. Click Define Source System.

   6. Provide the Name and Code for the new Target Instance. (Example: If the new target system is JD Edwards:

      Name: JD Edwards

      Code: JDE

2. Add the same entry on the destination system valueset Destination_System in OPH.

   1. Select the responsibility Setup Workbench (Setup)

   2. Click the Value Sets tab.

   3. Search for the valueset Destination_System.

   4. In values section, click Create.

   5. Add the display value and internal value for the new target system.

      Example:

      Value: JDE (This value must match the code value defined above).

      Translated Value: JD Edwards (This value must match the name value defined above).

      Description: New Target System JD Edwards.

3. Add the entry for the instance in the System Setting in AIA.

   1. Login to the System Setting page.

   2. Click the Setup tab.

   3. Click the System tab.

   4. Click Create.

   5. Add the entry for the new Target System. Here is an example:

      System Code: JDE_01. (The code that identifies the system.)

      System Description: JD Edwards Instance

      System Type: JDE. (The type of system for example: JDE, SIEBEL, EBIZ and so forth. This value is used in the routing rules.)

      Application Type: MFG. (The type of application. For example: MFG, CRM, ERP and so forth.)

4. Add the entry in TARGET_ID DVM with the COMMON column pointing to the system defined in System Setting with PIM_01 column pointing to the system defined in OPH system (Step 1). Table 7-1 shows an example:

   COMMON: JDE_01

   PIM_01: JDE

   Entry in TARGET_ID DVM:

   Table 7-1 Sample DVMs

   COMMON	PIM_01
   EBIZ_01	EBSSS
   SEBL_01	Siebel
   BRM_01	BRM
   JDE_01	JDE

   
   

5. Add the entry in ENTITY_TO_TARGET_APPLICATION DVM, for processing Pricelist and BOM for the new instance. Here is an example:

   TARGET_ID: JDE_01 (Common ID of the application instance)

   RECEIVE_PRICELIST_FLAG: N

   RECEIVE_BOM_FLAG: Y

   Table 7-2 Examples for System Name & Codes

   System	System Name & Code in OPH	System Setting
   Ebiz	Name:Ebiz System Code:EBSSS	Internal Id: Ebiz System Code: EBIZ_01 System Type: EBIZ Application Type: EBIZ
   Siebel	Name:Siebel CRM Code:Siebel	Internal Id: Siebel System Code: SEBL_01 System Type: SIEBEL Application Type: SIEBEL
   BRM	Name:BRM System Code:BRM	Internal Id: BRM System Code: BRM_01 System Type: BRM Application Type: BRM
   JDE	Name JDE System Code:JDE	Internal Id: JDE System Code: JDE_01 System Type: JDE Application Type: JDE

   
   

   Note:

   In the System Setting values, System Code is the value used for cross-reference and DVM lookups. In the routing rules, the Application Type value is checked.

   Seeded DVM and cross-reference files are available in the build under the following directories:

   <AIAHOME>//AIAMetaData/dvm/

   <AIAHOME>//AIAMetaData/xref/

   They can also be looked at by logging into MDS.

6. Build and deploy the provider connector service for processing item/itemstructure/pricing for the new spoke system. Here is an example:

   SyncItemListJDEProvABCSImpl: For processing items.

   SyncPricelistJDEProvABCSImpl (if applicable): For processing pricelists.

   SyncBillOfMaterialsListJDEProvABCSImpl: For processing item structures.

7. Add the routing rules to the new instances.

   Example: Add routing rule in ItemEBSV2 for Invoking SyncItemListJDEProvABCSImpl

   Filter Expression:

   {aia:getServiceProperty('|lcb;|http://xmlns.oracle.com/EnterpriseServices/
   Core/Item/V2|rcb;|ItemEBSV2','Routing.ActiveRuleset',false())='DEFAULT' 
   and count(/ebo:SyncItemListEBM/ebo:DataArea) > 0 and 
   (/ebo:SyncItemListEBM/corecom:EBMHeader/corecom:MessageProcessingInstruction
   /corecom:EnvironmentCode='PRODUCTION' or not
   (/ebo:SyncItemListEBM/corecom:EBMHeader/corecom:MessageProcessingInstruction
   /corecom:EnvironmentCode/text())) and
   (aia:getSystemType(/ebo:SyncItemListEBM/corecom:EBMHeader/corecom:Target
   /corecom:ID)='MFG') and
   (aia:getSystemType(/ebo:SyncItemListEBM/corecom:EBMHeader/corecom:Sender
   /corecom:ID) !='MFG')};{namespace
   ebo=http://xmlns.oracle.com/EnterpriseObjects/Core/EBO/Item/V2 namespace
   aia=http://www.oracle.com/XSL/Transform/java/oracle.apps.aia.core.xpath.
   AIAFunctions namespace
   corecom=http://xmlns.oracle.com/EnterpriseObjects/Core/Common/V2}
   

8. Add similar rules for PriceListEBSV2 and BillOfMaterialsEBS.

9. Run the scripts to create the columns corresponding to the instance in the cross-reference tables. The new spoke system needs to be added to the cross-reference and DVM files and updated in MDS. To do this:

   1. Identify the cross-references and DVMs being used in the connectors for the new spoke system.

   2. For example: Add JDE_01 to the xref file ITEM_ITEMID.xref under <AIAHOME>/AIAMetaData/xref/ITEM_ITEMID.xref and to the DVM file DVM under <AIAHOME>/AIAMetaData/dvm/ITEM_TYPE.dvm

   3. Update MDS. Modify <AIAHOME>/aia_instances/MDM/config/UpdateMetaDataDP.xml to include the files modified in step b. Then navigate to the folder <AIAHOME>/Infrastructure/Install/config and run:

      ant -f UpdateMetaData.xml -DPropertiesFile<AIAHOME>/aia_instances/O2C/config/AIAInstallProperties.xml

   4. Once complete, login to the AIA console, navigate to setup\AIA Configuration and click the Reload button to load the changes.

7.2 Post Installation Configuration Set Up

Inventory organizations can be broadly classified as one that is associated as item validation organization for a specific operating unit, and the other as a list of all the various organizations that have been classified as inventory organization to which product can be associated.

Other aspects are:

• An operating unit in OPH is mapped to an Organization/Business Unit in Siebel CRM.

• An inventory organization in OPH is mapped to inventory location in Siebel CRM, which needs to be child of a business unit.

• If OPH and E-Business Suite co-exist, the organization and inventory organization needs to be set up in OPH exactly the same way as in E-Business Suite. You need to perform the steps mentioned here to extract data (IDs) for creating cross-references.

Note:

Creation of operating units or inventory organizations is beyond the scope of this document. See the Oracle E-Business guides for more information.

7.2.1 Extract Inventory Organization and Operating Unit IDs in Oracle E-Business Suite

Note:

In Oracle E-Business Suite order management, the visibility to an item as part of the order capture is based on the association with an organization that in turn is associated with the system parameter item-validation-organization. As the product synchronization into Siebel is done to support order capture in Siebel, it is recommended that the various organizations defined as item validation organizations are cross-referenced for Siebel (and are created in Siebel); however, not all other inventory organizations may have a cross-reference to Siebel. See Section 7.2.3, "Mapping Siebel CRM"

If Oracle E-Business Suite is one of the participating applications in your implementation and the Order to Cash: Siebel CRM - EBS integration also is part of the implementation, then you need to perform these steps. After these steps are complete, you need to implement a similar organization hierarchy setup in OPH. If the Order to Cash integration is not in the set of pre-built integrations, then this step is not required.

To extract inventory organization details in Oracle E-Business Suite:

1. Log in to Oracle E-Business Suite database.

2. Run a SQL statement to query for all the organizations classified as inventory organization. For example:

   select ORGANIZATION_ID from HR_ORGANIZATION_INFORMATION 
   where ORG_INFORMATION1='INV'
   

3. Use the IDs from step 2 for cross-referencing the data for inventory location using the XREF_TABLE_NAME: INVENTORY_LOCATION_ID.

To extract the operating unit details in Oracle E-Business Suite:

1. Log in to the Oracle E-Business Suite database.

2. Run a SQL statement to query for all the organizations classified as inventory organization. For example:

   select ORGANIZATION_ID from HR_ORGANIZATION_INFORMATION 
   where ORG_INFORMATION1='OPERATING_UNIT
   

3. Identify the Item Validation Organization for Oracle E-Business Suite for the operating unit you want.

7.2.1.1 Identify the Item Validation Organization for Oracle E-Business Suite

To identify the item validation organization from the names of the organizations you noted using Extract Inventory Organization and Operating Unit IDs in Oracle E-Business Suite:

1. Log in to Oracle E-Business Suite. The following page appears:

   Figure 7-1 Oracle applications home page example

   
   

2. Confirm that you have the responsibilities set up for your operating units of interest, for example, order management.

   Note:

   Vision Operations has been used as an example. You can use operating units of your choice.

3. Select Order Management Super User, Vision Operations (USA).

   Figure 7-2 System parameters

   
   

4. Perform these steps using the System Parameters screen for each of the order management responsibilities associated with various operating units that are of interest to you:

   1. Select Values from Setting Parameter Values.

   2. Enter Vision Operations in the name of the Operating Unit and Generic Parameters in Category.

   3. Write down the value that appears in Item ValidationOrganization. (Examples: Vision Operations, Vision Germany, and Vision France).

7.2.2 Extract Inventory Location and Operating Unit IDs in Oracle Product Hub

To extract inventory location IDs:

1. Log in to Oracle Product Hub database.

2. Run a SQL statement to query for all the organizations classified as inventory organization. For example:

   select A.ORGANIZATION_ID from HR_ORGANIZATION_INFORMATION A, INV_ORGANIZATION_NAME_V B where A.ORGANIZATION_ID = B.ORGANIZATION_ID and A.ORG_INFORMATION1='INV' and B.ORGANIZATION_CODE = 'V1'   
   

   Note:

   Replace the organization code specific to your installation.

3. Use the IDs from step 2 for cross-referencing the data for inventory location using the XREF_TABLE_NAME: INVENTORY_LOCATION_ID.

To extract operating unit IDs:

1. Log in to the Oracle Product Hub database.

2. Run a SQL statement to query for all the organizations classified as inventory organization. For example:

   select A.ORGANIZATION_ID from HR_ORGANIZATION_INFORMATION A, INV_ORGANIZATION_NAME_V B where A.ORGANIZATION_ID = B.ORGANIZATION_ID and A.ORG_INFORMATION1='OPERATING_UNIT' and B.ORGANIZATION_CODE = 'V1'
   

   Note:

   Replace the organization code specific to your installation.

3. Use the IDs from step 2 for cross-referencing the data for operating units using the XREF_TABLE_NAME: ORGANIZATION_ID.

4. Identify Item Validation Organization for Oracle Product Hub for the operating unit you want.

7.2.2.1 Identify Item Validation Organization for Oracle Product Hub

To identify the item validation organization from the names of the organizations you noted in Extract Inventory Organization and Operating Unit IDs in Oracle E-Business Suite.

Publishing a product is on-demand by a product administrator from OPH. As products can be associated with various inventory Organizations under a given operating unit, it is expected that the items associated with the Inventory Organization - Item Validation Org in OM is only published to Siebel.

1. Log in to Oracle Product Hub. The following page appears:

   Figure 7-3 Oracle applications home page example

   
   

2. Confirm that you have the responsibilities set up for your operating units of interest, for example, order management.

   Note:

   Vision Operations has been used as an example. You can use operating units of your choice.

3. Select Order Management Super User, Vision Operations (USA).

   Figure 7-4 System parameters

   
   

4. Perform these steps using the System Parameters screen for each of the order management responsibilities associated with various operating units that are of interest to you:

   1. Select Values from Setting Parameter Values.

   2. Enter Vision Operations in Operating Unit and GenericParameters in Category.

   3. Write down the value that appears in Item validation organization. (Examples: Vision Operations, Vision Germany, and Vision France).

7.2.3 Mapping Siebel CRM

To map Siebel organizations to Oracle E-Business Suite operating units:

1. Log in to Siebel Applications.

2. Click Site Map.

3. Select Administration-Groups, Organizations.

4. For every operating unit in Oracle E-Business Suite, create a corresponding organization in Siebel CRM. Figure 7-5 shows a screen shot:

Figure 7-5 Administration - Group tab in Siebel

For more information, see the Siebel product documentation.

Creating Inventory Locations in Siebel

To map Siebel Inventory Locations to Oracle E-Business Inventory Organizations:

1. Log into Siebel applications.

2. Click on Site Map.

3. Select Inventory, Inventory Locations.

For the Oracle Inventory Organizations against which orders will be validated and availability is checked and also from where items are shipped during order fulfillment have to be created in this screen in Siebel with Inventory Type 'Warehouse'. The corresponding operating unit should also be associated to the Inventory Location as 'Organization' as shown in Figure 7-6:

Figure 7-6 Creating Inventory Locations in Siebel

7.2.4 Extract Business Unit and Inventory Location IDs in Siebel CRM

To extract inventory location details for Siebel CRM:

1. Log in to the Siebel database as the table owner.

2. Run this query and note the IDs for the business unit from the search result:

   select row_id, name from s_org_ext where name like '%Vision%'
   

3. Run this query and note the IDs for the inventory locations:

   (select row_id, name from s_invloc where name like '%Vision%')
   

7.3 Setting Up Oracle BRM

These are the setups required for Oracle BRM:

• Install and configure BRM JCA adapter.

  For more information about installing and setting up the BRM JCA adapter, see "Installing the BRM JCA Resource Adapter" and "Service Integration Components, JCA Resource Adapter" in the Oracle BRM documentation.

• Set up all metadata required for creating products, pricelist data and discounting. For example: Create services; events; resources; G/L IDs; ratable usage metrics (RUMs); Tax code; Impact categories; Timezones; map event types to services; pipeline data, and so on.

  For more information about price lists, see 'About setting up a price list' in the Oracle BRM documentation.

• Set up pricing for friends and family functionality.

  For more information about setting up pricing, see 'Setting Up Pricing and Rating, Working with extended rating attributes' in the Oracle BRM documentation.

7.4 Setting Up Cross-References

Cross-references can be created after inventory locations have been set up in Siebel CRM, Oracle Product Hub, and Oracle E-Business Suite. The setup includes:

• Section 7.4.1, "Populating Seed Values in Cross-Reference Tables"

• Section 7.4.2, "Validating Cross-References"

• Section 7.4.3, "Creating a Pricelist in Siebel"

7.4.1 Populating Seed Values in Cross-Reference Tables

The cross-reference data for the ORGANIZATION_ID and INVENTORY_LOCATION_ID XRef entity must be added manually before you use the PIP, by using SQL insert statements. The following rows need to be created in the XRef data table:

• One row for Oracle Product Hub: PIM_01

• One row for Common: COMMON.

• One row for Oracle E-Business Suite: EBIZ_01 (if the Oracle E-Business Suite option is installed).

• One row for Siebel CRM: SEBL_01 (if the Siebel CRM option is installed).

The physical XRef table (XREF_DATA) can be located in the database configured for FMW/SOA and contains the following columns:

Table 7-3 XRef Table Format

Column Name	Description
XREF_TABLE_NAME	This column stores the XRef data types. For example: oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref
XREF_COLUMN_NAME	This column stores the values indicating the edge applications and COMMON value: PIM_01 EBIZ_01 COMMON SEBL_01
ROW_NUMBER	This column stores the GUID.
VALUE	This column stores the actual data that is cross-referenced.
IS_DELETED	This column indicates whether the column is deleted or not. For example, 'N'.
LAST_MODIFIED	This column stores last modified time.

Table 7-4 Organization_ID XRef Table Value Format

XRef_Column_Name	Value
COMMON	GUID
PIM_01	Organization Id from OPHFor example, 911
EBIZ_01	Ebiz Org IDFor example, 204
SEBL_01	Organization Id (Business Unit) from Siebel CRMFor example, 88-8KO98

Sample SQL Insert Statement for ORGANIZATION_ID Table

For PIM_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'PIM_01', 'BD618D40B30C11DEBFA5D9490F57512E', '911', 'N', SYSTIMESTAMP)

For EBIZ_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'EBIZ_01', 'BD618D40B30C11DEBFA5D9490F57512E', '204', 'N', SYSTIMESTAMP)

For SEBL_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref', 'SEBL_01', 'BD618D40B30C11DEBFA5D9490F57512E', '88-8KO98', 'N', SYSTIMESTAMP)

For COMMON:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/ ORGANIZATION_ID.xref', 'COMMON ', 'BD618D40B30C11DEBFA5D9490F57512E', '2d373037303636323539363632323735', 'N', SYSTIMESTAMP)

Table 7-5 Sample Data for XRef Oraganization_ID Table

XRef_Table	XRef_Column	Row_Number	Value	IS_Deleted	Last_Modified
oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref	EBIZ_01	BD618D40B30C11DEBFA5D9490F57512E	204	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref	SEBL_01	BD618D40B30C11DEBFA5D9490F57512E	88-8KO98	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref	PIM_01	BD618D40B30C11DEBFA5D9490F57512E	911	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/ORGANIZATION_ID.xref	COMMON	BD618D40B30C11DEBFA5D9490F57512E	2d373037303636323539363632323735	N	2012-4-11.11.29. 54. 210000000

Table 7-6 INVENTORY_LOCATION_ID XRef Table Value Format

XRef_Column_Name	Value
COMMON	GUID
PIM_01	INVENTORY_LOCATION_ID from OPHFor example, 911
EBIZ_01	Ebiz INV IDFor example, 204
SEBL_01	INVENTORY_LOCATION_ID from Siebel CRMFor example, 88-8KO98

Sample SQL Insert Statement for INVENTORY_LOCATION_ID Table

For PIM_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref', 'PIM_01', 'BD618D40B30C11DEBFA5D9490F57512E', '911', 'N', SYSTIMESTAMP)

For EBIZ_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref', 'EBIZ_01', 'BD618D40B30C11DEBFA5D9490F57512E', '204', 'N', SYSTIMESTAMP)

For SEBL_01:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref', 'SEBL_01', 'BD618D40B30C11DEBFA5D9490F57512E', '88-8KO98', 'N', SYSTIMESTAMP)

For COMMON:

INSERT INTO XREF_DATA (XREF_TABLE_NAME, XREF_COLUMN_NAME, ROW_NUMBER, VALUE, IS_DELETED, LAST_MODIFIED) VALUES (' oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref', 'COMMON ', 'BD618D40B30C11DEBFA5D9490F57512E', '2d373037303636323539363632323735', 'N', SYSTIMESTAMP)

Table 7-7 Sample Data for XRef INVENTORY_LOCATION_ID Table

XRef_Table	XRef_Column	Row_Number	Value	IS_Deleted	Last_Modified
oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID	EBIZ_01	BD618D40B30C11DEBFA5D9490F57512E	204	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID	SEBL_01	BD618D40B30C11DEBFA5D9490F57512E	88-8KO98	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID	PIM_01	BD618D40B30C11DEBFA5D9490F57512E	911	N	2012-4-11.11.29. 54. 210000000
oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID	COMMON	BD618D40B30C11DEBFA5D9490F57512E	2d373037303636323539363632323735	N	2012-4-11.11.29. 54. 210000000

7.4.2 Validating Cross-References

To validate cross-references:

1. Log in to the AIA XRef database.

2. Use this query on the table XREF_DATA to confirm there are three records each for organization and inventory location used in the XML Files.

   Example 7-1 Sample query to verify INVENTORY_LOCATION_ID:

   select value||'::'||Xref_column_name from xref_Data where
   row_number in (select row_number from xref_data where
   xref_table_name = 'INVENTORY_LOCATION_ID'
   and value in ('204'))
   

   Example 7-2 Sample query to verify ORGANIZATION_ID:

   select value||'::'||Xref_column_name from xref_Data where
   row_number in (select row_number from xref_data where
   xref_table_name = 'ORGANIZATION_ID'
   and value in ('204'))
   
   

3. Replace the value '204' in the above queries with the values from your system. (The number of operating units and inventory locations depends on your set up.)

7.4.3 Creating a Pricelist in Siebel

To create a pricelist in Siebel CRM:

1. Create a pricelist in Siebel CRM.

2. Extract the RowID of the pricelist in Siebel and update the Property PriceList.ID with the RowID of the pricelist in AIAConfigurationProperties for the following:

   1. SyncItemCompositionListSiebelCommsProvABCSImpl

   2. ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl

3. If these pricelist(s) are used in standard pricing offer or billing pricing offer (rate plan selector in billing products) model in OPH, then extract the RowID of the pricelist(s) in Siebel CRM and add data for each pricelist (in PRICELIST.dvm). Thereafter, update the PIM_01/BRM_01 columns to map the corresponding pricelist identifiers used in OPH/BRM.

For more information, see Section 7.8, "Setting Configuration Properties".

7.5 Working with Cross-References

Cross-references map and connect the records within the application network and enable these applications to communicate in the same language. The integration server stores the relationship in a persistent way so that others can refer to it.

For more information about cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite "Working with Cross References".

Table 7-8 lists the cross-references for the Product MDM integration:

Table 7-8 OPH cross-references

Table Name	Column Name	Description	Use
ITEM_ITEMID	EBIZ_01,COMMON, SEBL_01, PIM_01, BRM_01	Item/Product Ids	Used in item synchronization and various other flows.
ORGANIZATION_ID	EBIZ_01,COMMON, SEBL_01, PIM_01	Organization/ business unit IDs	Used in various flows.
INVENTORY_LOCATION_ID	EBIZ_01,COMMON, SEBL_01, PIM_01	Inventory location IDs	Used in various flows.
CLASSIFICATION_CLASSIFICATIONID	COMMON, SEBL_01, PIM_01	Mapping of product class-ids or catalog-category ids between applications.	Used in Item and ICC synchronization flows.
USER_NAME	EBIZ_01,COMMON, SEBL_01, PIM_01	User names of various applications	Used in various flows.
PRICELINE_ID	EBIZ_01,COMMON, SEBL_01, PIM_01	To cross reference pricelist Line Id	Mapping of pricelist line ids.
PRICELINETYPE_ID	EBIZ_01,COMMON, SEBL_01, PIM_01	To cross-reference Line Price Id.	To cross-reference BRM product's events with Siebel price line ID. Also links to the COMMON of ITEM_ID.
SIEBELPRODUCTEVENTXREF	ITEM_ID_COMMON,LINEPRICETYPECODE	To cross-reference Event Item that is Associated with the main Item.	To cross-reference BRM (Portal) Product's Event that is Associated with the main product in Siebel.
PROMOTION_PROMOTIONID	COMMON, SEBL_01	To cross-reference Promotion ID	During product synchronization Promotion Id is stamped in this xref based Entity Type. During Product Structure Synchronization this xref is looked up to determine Product is promotion.

7.6 Working with Domain Value Maps

Domain value maps (DVMs) are a standard feature of the Oracle SOA Suite that enables you to equate lookup codes and other static values across applications, for example, FOOT and FT or US and USA.

DVMs are static in nature though administrators can add additional maps as needed. Transactional business processes never update DVMs, they only read from them. They are stored in XML files and cached in memory at run-time.

The DVM data should be in synchronization with what the participating applications use. This synchronization should be done before running any initial loads or initiating any incremental transactional flows.

Seeded DVM and cross-reference files are available in the build under the following directories

<AIAHOME>//AIAMetaData/dvm/

<AIAHOME>//AIAMetaData/xref/

They can also be looked at by logging into MDS.

Table 7-9 lists the DVMs for the Product MDM integration:

Table 7-9 List of DVMs

DVM Type	DVM Column Name	Description
ADDRESS_COUNTRYID	COMMON, SEBL_01, PIM_01	Indicates ID of the countries.
BOM_EXPLODE_OPTION	SYSTEM, CURRENTFUTURE_FLAG	Exploding the BOM based on CURRENTFUTURE_FLAG (CURRENT, CURRENTFUTURE).
BOM_INDICATOR_NUM_TO_BOOL	EBIZ_01,COMMON	DVM to convert Boolean value to number.
DATA_TYPE_CODE	EBIZ_01,COMMON, SEBL_01	It specifies the data type of the valueset
DAYS_OF_WEEK	EBIZ_01,COMMON, SEBL_01, PIM_01, JDEE1_01, P6EPPM_01	Indicates the days of the week as Monday, Tuesday, and so on.
ENTITY_TO_TARGET_APPLICATION	TARGET_ID, RECEIVE_PRICELIST_FLAG , RECEIVE_BOM_FLAG	List of entities that each target application receives, for example, Oracle E-Business Suite receives Items and BOMs; Siebel receives item, pricelist and BOM; BRM receives items and pricelist.
ITEM_BILLING_SPECIAL_RATING_TYPE	COMMON, SEBL_01, PIM_01	Indicates the GL codes to record revenue.
ITEM_BOM_ITEMTYPE_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01	Cross-reference value: BOM item-type code.
ITEM_CONSIGNMENT_ITEM_INDICATOR	COMMON, EBIZ_01, PIM_01	Cross-reference value: ConsignmentItemIndicator.
ITEM_CONTRACT_TYPE_CODE	EBIZ_01,COMMON, PIM_01	Cross-reference value: Contract type code.
ITEM_CREATE_FIXED_ASSET_INDICATOR	EBIZ_01,COMMON, PIM_01	Cross-reference value CreateFixedAssetIndicator.
ITEM_CURRENTFUTUREPAST_STATUS	COMMON, SEBL_01, PIM_01	Status: Current, future, past.
ITEM_EFFECTIVITY_CONTROL_CODE	EBIZ_01,COMMON, PIM_01	Cross-reference value: EffectivityControlCode.
ITEM_INVENTORY_PLANNING_CODE	EBIZ_01,COMMON, PIM_01,JDEE1_01	Cross-reference value: InventoryPlanningCode.
ITEM_LOGISTICS_SHIP_CARRIER	COMMON, SEBL_01, PIM_01	This indicates carrier information, for example, DHL.
ITEM_LOGISTICS_SHIP_METHOD	COMMON, SEBL_01, PIM_01	This indicates mode of transport, for example, Air.
ITEM_MAKEORBUY_CODE	EBIZ_01,COMMON, PIM_01,JDEE1_01	Cross-reference value: MakeOrBuyCode.
ITEM_RECEIVING_ROUTING_CODE	EBIZ_01,COMMON, PIM_01	This indicates: ReceivingRoutingCode.
ITEM_REPLENISHMENT_SOURCE_CODE	EBIZ_01,COMMON, PIM_01, JDEE1_01	Cross-reference value: ReplenishmentSourceCode.
ITEM_RESERVATION_ALLOWED_INDICATOR	EBIZ_01,COMMON, PIM_01	Cross-reference value: ReservationAllowedIndicator.
ITEM_SERVICE_REQUEST_ENABLED_INDICATOR	EBIZ_01,COMMON	Cross-reference value: ServiceRequestEnabledIndicator.
ITEM_TARGET_INDUSTRY	COMMON, SEBL_01, PIM_01	Indicates the type of industry, for example, Manufacturing.
ITEM_TRACK_INSTANCE_INDICATOR	EBIZ_01,COMMON, PIM_01	Cross-reference value: TrackInstanceIndicator.
ITEM_TYPE	EBIZ_01,COMMON, SEBL_01, PIM_01, JDEE1_01, OTM_01, JDEW_01,CRMOD_01	Indicates item-type code.
ITEM_ENTITY_TYPE	SEBL_01, PIM_01, COMMON	Identifies the type of entity that OPH/PIM is publishing. Examples: Item, Promotion, Discount.
ITEM_UOM_CODE	EBIZ_01,COMMON, AGILE_01, SAP_01, JDEE1_01	Cross-reference value item unit-of-measure code.
ITEM_WIP_SUPPLY_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01, AGILE_01	Cross-reference value: WIPSupplyTypeCode.
LANGUAGE_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01, RETL_01,PSFT_01, JDEE1_01, SAP_01, OTM_01	Specifies the language codes of OPH/PIM, Siebel, and Common.
LINEPRICE_TYPECODE	COMMON, SEBL_01, PIM_01	Indicates the type of the list-price of the item, for example, Base Price, One-time, Activation, Quarterly, Monthly, or so on.
PLANTIER_RESTRICTIONTYPE	COMMON, SEBL_01, PIM_01	Indicates the kind of rate restriction used in the plan tier, for example, No Restrictions, Restriction based on days only, or Restriction based on days and time slots.
PRICE_BILLINGPERIODCODE	COMMON, SEBL_01, PIM_01	Indicates the frequency of applying the charge, for example, One-Time, Weekly, Monthly, Yearly.
PRICE_DISCOUNTTYPECODE	COMMON, SEBL_01, PIM_01	Indicates the type of discount, for example, Percent or Amount.
PRICE_MARKUPBASISCODE	COMMON, SEBL_01, PIM_01	Indicates the basis for calculating the price markup of the product from the covered product, for example, List Price, Net Price.
PRICE_OVERRIDETYPECODE	COMMON, SEBL_01, PIM_01	Indicates whether a discount override or a price override is defined for the charge, for example, Committed - Price override, Dynamic - Discount.
PRICE_TYPE	COMMON, SEBL_01, BRM_01	Indicates the type of price, for example, One-Time, Recurring, and so on.
PRICECHARGETYPE	EBIZ_01,COMMON, SEBL_01, PIM_01	Indicates the price-charge type, for example, Usage, Product Purchase Fee, Monthly Cycle Forward, and so on.
PRODUCT_STATUS	EBIZ_01,COMMON, SEBL_01, PIM_01,OTM_01, CRMOD_01	Cross-reference value: product status.
RATEPLAN_TYPECODE	COMMON, SEBL_01, PIM_01	Indicates the type of rate plan associated with the charge of the product, for example, Single Rate Plan, Rate Plan Selector, Custom event analysis, and so on.
RATEPLAN_UNITCODE	COMMON, PIM_01	Indicates the rate plan unit code.
STRUCTURE_NAME_ALTERNATE_BOM	EBIZ_01,COMMON,PIM_01	Mapping between structure name and alternate BOM.
TARGET_ID	COMMON, UCM_01, PIM_01	Specifies the common IDs of the systems to which synchronization is being done. This DVM is used to map the system defined in OPH/PIM for publication and system defined in OER.
UNIT_OF_MEASURE	EBIZ_01,COMMON, SEBL_01, PIM_01,OTM_01,JDEE1_01,JDEE1_01_RATECODE,P6EPPM_01_RATECODE,EBS_PROJECTS_01_UNIT_OF_MEASURE,SAP_01	Mapping of unit of measure (UOM) codes among various applications.
ITEM_DUAL_UOM_TRACKING_INDICATOR	COMMON, PIM_01,EBIZ_01, JDEE1_01	Dual UOM tracking indicator.
ITEM_UOM_CONVERSION_USAGE_CODE	COMMON, PIM_01,EBIZ_01	UOM conversion usage code.
ITEM_STATUS_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01	Value cross-reference item-status code.
ITEM_SERIALIZATION_EVENT_CODE	COMMON, PIM_01,EBIZ_01, JDEE1_01	Indicates serialization-event code.
ITEM_INDICATOR	COMMON, SEBL_01, PIM_01, EBIZ_01, OTM_01, AGILE_01, JDEE1_01	Value cross-reference Indicator as YES/NO.
ACTIVE_FLAG_SEBL	COMMON,SEBL_01	Indicates active status in Siebel as active, pending, or closed.
ITEM_PRIMARYCLASSIFICATIONCODE	COMMON,EBIZ_01	Used for mapping item catalog group code.
ITEM_BILLING_TYPE_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01, AGILE_01, BRM_01	This DVM maps the Billing Type of a product, for example, subscription, item, system, and so on.
APPLIES_TO	PIM_01, COMMON, BRM_01, SEBL_01	This DVM is used for mapping discount billing service type, for example, /service/telco/gsm/telephony.
PARTIAL_PURCHASE	PIM_01, COMMON, BRM_01	This DVM maps the partial purchase allowed indicator, for example, Y/N.
PROVISIONING_TAG	PIM_01, COMMON, BRM_01	This DVM maps the provisioning tag, for example, Voice, Corporate, Premium, and so on.
DISCOUNT_VALIDITY	COMMON, BRM_01	This DVM maps the discount validity, for example, PRORATED_DISCOUNT, NO_DISCOUNT, FULL_DISCOUNT.
MULTIPLE_DISCOUNT_PER_EVENT	PIM_01, COMMON, BRM_01	This DVM maps the multiple discount per event field, for example, PARALLEL, CASCADE, SEQUENTIAL
CURRENCY_CODE	EBIZ_01,COMMON, SEBL_01, PIM_01,PORTAL_01, UCM_01, PSFT_01, RETL_01, JDEE1_01, CRMOD_01, OTM_01, P6EPPM_01, JDEW_01, SAP_01, BRM_01	Indicates the currency codes, for example, USD, EUR, and so on.
RATEPLAN_UNITCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates the unit code of the rate plan, for example, days, month, and so on.
RATEDATA_PURCHASEPRORATIONCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates how to charge customers when they purchase the product in the middle of the accounting cycle, for example, Do not Charge for the cycle; Calculate Charge based on the amount used; and Charge for the entire cycle, and so on.
RATEDATA_CANCELATIONPRORATIONCODE	PIM_01, COMMON, BRM_01, SEBL_01	Maps rate data cancelation proration code. Indicates how to charge customers when they cancel the product in the middle of the accounting cycle, for example, Do not Charge for the cycle; Calculate Charge based on the amount used; Charge for the entire cycle; and so on.
RESOURCE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates non-currency resource codes, for example, minutes, loyalty points, and so on.
GL_CODE	PIM_01, COMMON, EBIZ_01, BRM_01	Identifies the set of products in general ledger.
PRICE_IMPACTCLASSIFICATIONCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates the impact category associated with the rate, for example, Default, Premium, Standard, Free, and so on.
PLANIMPACT_UNITCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates the scaled unit codes, for example, Second, Minute, Hour, and so on.
RATEDATA_DISCOUNTBRACKETCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates the discount brackets to charge different amounts based on quantity, for example, Continuous, Rate Dependent, Resource, and so on.
PLANTIER_EFFECTIVITYMODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates the effectivity mode associated with the date and time of the tier, for example, Absolute, Relative.
RATEPLAN_TAXAPPLICABILITYCODE	PIM_01, COMMON, BRM_01, SEBL_01	Indicates when the tax must be applied, for example, No Taxes, Event Time, End of Cycle, and so on.
PRICETYPE_EVENT	COMMON, SEBL_01, PIM_01, PRICECHARGETYPE, PRICECHARGETYPEUOM, PIM_01, COMMON, BRM_01	Maps the event name, for example, Purchase, Cancel, and so on.
LINEPRICE_UOMCODE	PIM_01, COMMON, BRM_01, SEBL_01	Maps the price unit of measure code. Indicates the ratable usage metric (RUM). RUM defines the quantity being measured and the units used, for example, Occurrence.
GRACE_PERIOD_UOM	SEBL_01, COMMON	Indicates Grace Period UOM for Promotion Ex.Per Day,Months,Years
ITEM_INSTANCES	COMMON, SEBL_01, PIM_01	Indicates Promotion Instances
ITEM_PROMOTION_TYPE	COMMON, SEBL_01, PIM_01	Indicate Promotion Type ex: Bundle Promotion
RECURRING_ADJUST_UOM	COMMON,SEBL_01,PIM_01	Indicate Recurring Adjust UOM
ITEM_CHARGE_CREDITS_TYPE	COMMON, SEBL_01, PIM_01	Indicate Item Charge Credit Type. For example: Penalty.
ITEM_PROMOTION_COMMITMENT_START	COMMON, SEBL_01, PIM_01	Indicate Promotion Commitment Start. For example: Now, Original Start, Original End.
ITEM_PROMOTION_DURATION	COMMON, SEBL_01, PIM_01	Indicates Promotion Duration. For example: New Duration.
PRICE_ADJUSTMENT_TYPE	COMMON, SEBL_01, PIM_01	Indicates price Adjustments in Promotion Ex. Price Override, Discount Amount.
PRICELIST	PIM_01, COMMON , SEBL_01, BRM_01	This DVM maps the pricelists created in Siebel/BRM from Ebiz / OPH instance to Siebel/BRM.

The considerations for setting up DVMs include:

• STRUCTURE_NAME_ALTERNATE_BOM: This is used to map the STRUCTURE_NAME in Oracle Product Hub to an ALTERNATE_BOM in Oracle E-Business Suite. There is no Siebel equivalent for STRUCTURE_NAME_ALTERNATE_BOM.

• STRUCTURE_TYPE: This is used to identify the type for every structure defined in Oracle Product Hub.

  For every structure name defined in Oracle Product Hub, an entry needs to be made in this DVM against STRUCTURE NAME column. In the STRUCTURE TYPE column, the structure name needs to be identified as SALES or Others. When a BOM Event is raised in Oracle Product Hub, the routing rule using the structure name associated with the BOM event and the corresponding type defined in this DVM is used to route the SALES BOM to Siebel.

  Table 7-10 provides sample data for the STRUCTURE_TYPE domain value map:

  Table 7-10 Sample Data for STRUCTURE_TYPE DVM:

  Structure Name	Structure Type
  Pbom	Sales
  Ebom	BOM
  PrimaryCommon	Sales

  
  

• An entry should be made in this DVM even for a primary BOM.

7.7 Handling Errors

Based on the roles defined for the services, email notifications are sent if a service errors out. There are no AIA-specific errors thrown by the services for this integration.

For more information about the errors thrown by Siebel CRM or Oracle E-Business Suite, see the respective product documentation.

For more information about AIA error handling, see the Oracle Fusion Middleware Infrastructure Components and Utilities User's Guide for Oracle Application Integration Architecture Foundation Pack "Setting Up Error Handling."

7.8 Setting Configuration Properties

Set these properties in the AIAConfigurationProperties.xml file. The file is located in AIA_HOME>/aia_instances/$INSTANCE_NAME/AIAMetaData/config/.

For more information about requirements for working with AIAConfigurationProperties.xml, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Building AIA Integration Flows," How to Set Up AIA Workstation.

7.8.1 Settings for the SyncItemListEbizProvABCSImpl service

Table 7-11 SyncItemListEbizProvABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.SyncItemListEbizAdapter.EBIZ_01.EndpointURI	Endpoint URI of the Oracle E-Business Suite adapter	--
Routing.ItemResponseEBSV2.SyncItemListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
ABCSExtension.PreXformEBMtoABMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSyncItemListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSyncItemListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
TRACE.LOG.ENABLED	This property is used enabling trace log	--
Routing.SWIProductIntegration.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.SWIProductIntegration.CAVS.EndpointURI	This property sets the endpoint URL for the CAVS simulator.	--
Routing.SWIPromotionIntegration.RouteToCAVS	false/true	Determines whether the endpoint URL should be routed to either the end application service or CAVS for simulating the service.
Routing.ItemResponseEBSV2.SyncItemListResponse.RouteToCAVS	false/true	Determines whether the endpoint URL should be routed to either the end application service or CAVS for simulating the service.

7.8.2 Settings for the SyncProductSiebelProvABCSImpl service

Table 7-12 SyncProductSiebelProvABCSImpl

Property Name	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
SIMPLE_PRODUCT_RELEASE_FLAG	Y/N	This property used for releasing simple product. To enable Siebel workspace auto release functionality, this flag must be set to N.
COMPLEX_PRODUCT_RELEASE_FLAG	Y/N	This property used for releasing complex product
Routing.SWIProductIntegration.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.SWIProductIntegration.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.SWIProductIntegration.CAVS.EndpointURI	This property sets the endpoint URL for the CAVS simulator.	--
Routing.SWIPromotionIntegration.RouteToCAVS	false/true	Determines whether the endpoint URL should be routed to either the end application service or CAVS for simulating the service.
Routing.SWIPromotionIntegration.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.ItemResponseEBSV2.SyncItemListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.ItemResponseEBSV2.SyncItemListResponse.RouteToCAVS	false/true	Determines whether the endpoint URL should be routed to either the end application service or CAVS for simulating the service.
ABCSExtension.PreXformEBMtoABMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSWIProductImportUpsertABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSWIProductImportUpsertABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
Product.Source.PIP	MDM/O2C	This property is updated during installation. For MDM integration, the value must be set to MDM.
ABCSExtension.PreInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
OPERATION_TYPE	Y/N; N	This property indicates whether Siebel web service is to be used in synchronize or upsert mode. OPERATION_TYPE ='Y': The elements in payload are updated if they already exist in the system. Else, are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from the system. OPERATION_TYPE ='N' (Default): The elements in payload are updated if they already exist. Else are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from system.
UTC_FORMAT_ENABLE	Y/N; N	Currently the default value is N. If the value is set to 'N', then the datetime elements are not changed to the UTC Format and the values are passed through. If the value is set to 'Y', then the datetime elements are changed to the UTC format.

7.8.3 Settings for the SyncBillOfMaterialsListEbizProvABCSImpl service

Table 7-13 SyncBillOfMaterialsListEbizProvABCSImpl

Property Name	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.SyncBillOfMaterialsListEbizAdapter.EBIZ_01.EndpointURI	Endpoint URI of the Oracle E-Business Suite adapter	--
Routing.BillOfMaterialsEBS.SyncBillOfMaterialsList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.BillOfMaterialsResponseEBS.SyncBillOfMaterialsListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
ABCSExtension.PreXformEBMtoABMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSyncBillOfMaterialsListEbizAdapterABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSyncBillOfMaterialsListEbizAdapterABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.

7.8.4 Settings for the SyncBillOfMaterialsListSiebelProvABCSImpl service

Table 7-14 SyncBillOfMaterialsListSiebelProvABCSImpl

Property Name	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.SWIProductIntegration.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.SWIProductIntegration.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.SWIPromotionIntegration.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.SWIPromotionIntegration.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.BillOfMaterialsResponseEBS.SyncBillOfMaterialsListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.BillOfMaterialsResponseEBS.SyncBillOfMaterialsListResponse.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
SIMPLE_PRODUCT_RELEASE_FLAG	This property used for Releasing Simple Product	--
COMPLEX_PRODUCT_RELEASE_FLAG	This property used for Releasing Complex Product	--
ABCSExtension.PreXformEBMtoABMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSWIProductImportUpsertABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSWIProductImportUpsertABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeSWIPromotionIntegrationABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
OPERATION_TYPE	Y/N; N	This property indicates whether Siebel web service is to be used in synchronize or upsert mode. OPERATION_TYPE ='Y': The elements in payload are updated if they already exist in the system. Else, are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from the system. OPERATION_TYPE ='N' (Default): The elements in payload are updated if they already exist. Else are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from system.
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.SWIProductIntegration.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
UTC_FORMAT_ENABLE	Y/N; N	Currently the default value is N. If the value is set to 'N', then the datetime elements are not changed to the UTC Format and the values are passed through. If the value is set to 'Y', then the datetime elements are changed to the UTC format.

7.8.5 Settings for the SyncItemListPIMReqABCSImpl service

Table 7-15 SyncItemListPIMReqABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.QueryItemListPIMAdapter.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.QueryBillOffMaterialsListPIMAdapter.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.GetListofTargetSystems.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.PublicationService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.ItemEBSV2.SyncItemList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.BillOfMaterialsEBS.SyncBillOfMaterialsList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.PriceListEBSV2.SyncPriceListList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
ABCSExtension. PreXformABMtoEBMItemListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvokeItemListEBSSyncItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PostXformEBMtoABMItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvolkePublicationServiceItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvokePriceListEBSSyncItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PostXformEBMtoABMPriceListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvolkePublicationServicePriceListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreXformABMtoEBMIBillOfMaterialsListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeBillOfMaterialsListEBSSyncBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformEBMtoABMBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvolkePublicationServiceBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
NUMBER_OF_PARALLEL_ITEM_TARGETS	This property controls number of parallel targets to be processed for Item when synchronizing items to multiple targets.	--
NUMBER_OF_PARALLEL_BOM_TARGETS	This property controls number of parallel targets to be processed for BOMs to multiple targets.	--

7.8.6 Settings for SyncSpecificationValueSetListSiebelProvABCSImpl service

Table 7-16 SyncSpecificationValueSetListSiebelProvABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	I	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA will select the default system ID from this configuration property.
ABCSExtension.PreXformEBMtoABMSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made, depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made, depending on whether it is true or false.
Routing.SWIAttributeImport.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.QueryBillOffMaterialsListPIMAdapter.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.GetListofTargetSystems.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.GetListofTargetSystems.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.PublicationService.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.PublicationService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.SWIAttributeImport.SEBL_01.EndpointURI		Siebel web service end-point location. This is a SOAP endpoint URL.
Routing.SWIAttributeImport.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.SpecificationValueSetResponseEBS.SyncSpecificationValueSetListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.SpecificationValueSetResponseEBS.SyncSpecificationValueSetListResponse.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
ABCSExtension.PreInvokeABSSyncAttributeDefinitionABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made, depending on whether it is true or false.
ABCSExtension.PostInvokeABSSyncAttributeDefinitionABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made, depending on whether it is true or false.
OPERATION_TYPE	Y/N; N	This property indicates whether Siebel web service is to be used in synchronize or upsert mode.OPERATION_TYPE ='Y': The elements in payload are updated if they already exist in the system. Else, are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from the system.OPERATION_TYPE ='N' (Default): The elements in payload are updated if they already exist. Else are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from system.
UTC_FORMAT_ENABLE	Y/N; N	Currently the default value is N. If the value is set to 'N', then the datetime elements are not changed to the UTC Format and the values are passed through. If the value is set to 'Y', then the datetime elements are changed to the UTC format.
ABCSExtension. PreXformABMtoEBMItemListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvokeItemListEBSSyncItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PostXformEBMtoABMItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvolkePublicationServiceItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvokePriceListEBSSyncItemListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PostXformEBMtoABMPriceListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreInvolkePublicationServicePriceListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension. PreXformABMtoEBMIBillOfMaterialsListABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeBillOfMaterialsListEBSSyncBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformEBMtoABMBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvolkePublicationServiceBOMListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
NUMBER_OF_PARALLEL_ITEM_TARGETS	This property controls number of parallel targets to be processed for Item when synchronizing items to multiple targets.	--
NUMBER_OF_PARALLEL_BOM_TARGETS	This property controls number of parallel targets to be processed for BOMs to multiple targets.	--

7.8.7 Settings for the SyncItemListBRMProvABCSImpl service

Table 7-17 SyncItemListBRMProvABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	BRM_01	The application is responsible for sending the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.
ABCSExtension.PreXformEBMtoABM	false/true	Used as an extension point before EBM is transformed to ABM. This property determines whether to make invocation of service at the extension point depending on whether it is true or false.
ABCSExtension.PostXformEBMtoABM	false/true	Used as an extension point before EBM is transformed to ABM. This property determines whether to make invocation of service at the extension point depending on whether it is true or false.
Routing.BRMPRICINGService_ptt.RouteToCAVS	false/true	Determines whether to route the endpoint URL to either the end application service or CAVS for simulating the service.
Routing.BRMPRICINGService_ptt.CAVS.EndpointURI	NA	Sets the endpoint URL for the CAVS simulator.
Routing.BRMPRICINGService_ptt.BRM_01.EndpointURI	eis/BRM1	Sets the endpoint URL for the target application.
Routing.BRMPRICINGService_ptt.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
ABCSExtension.PreInvokeABS	false/true	Used as an extension point before application business service is invoked. This property determines whether to make invocation of service at the extension point depending on whether it is true or false.
ABCSExtension.PostInvokeABS	false/true	Used as an extension point before application business service is invoked. This property determines whether to make invocation of service at the extension depending on whether it is true or false.

7.8.8 Settings for the SyncPriceListListBRMProvABCSImpl service

Table 7-18 SyncPriceListListBRMProvABCSImpl

Property Name	Property Value	Description
Default.SystemID	BRM_01	The application is responsible for sending the SystemID from which the request is being sent. If any requestor application fails to send this, AIA will pick the default SystemID from this config property.
ABCSExtension.PreXformEBMtoABM	false/true	Used as an extension point before EBM is transformed to ABM. This property determines whether to make invocation of service at the extension point depending on whether it is true or false
ABCSExtension.PostXformEBMtoABM	false/true	Used as an extension point After the EBM is transformed to ABM. This property determines whether to make invocation of service at the extension point depending on whether it is true or false
Routing.BRMPRICINGService_ptt.RouteToCAVS	NA	Determines whether to route the EndpointURI to either the end application service or CAVS for simulating the service.
Routing.BRMPRICINGService_ptt.CAVS.EndpointURI	NA	Sets the EndpointURI for the CAVS simulator
Routing.BRMPRICINGService_ptt.BRM_01.EndpointURI	eis/BRM1	Sets the EndpointURI for the target application
Routing.BRMPRICINGService_ptt.MessageProcessingInstruction.EnvironmentCode	PRODUCTION	Sets the EnvironmentCode element to the a value PRODUCTION.
ABCSExtension.PreInvokeABS	false/true	Used as an extension point before application business service is invoked. This property determines whether to make invocation of service at the extension point depending on whether it is true or false.
ABCSExtension.PostInvokeABS	false/true	Used as an extension point before application business service is invoked. This property determines whether to make invocation of service at the extension depending on whether it is true or false.

7.8.9 Settings for the QueryBillOfMaterialsListPIMAdapter service

Table 7-19 QueryBillOfMaterialsListPIMAdapter

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
BATCH_SIZE	<<any number>>	This property is used for defining the number of structures to be processed in sub batch (chunking)
Routing.ItemService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--

7.8.10 Settings for the QueryItemListPIMAdapter service

Table 7-20 QueryItemListPIMAdapter

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
BATCH_SIZE	<<any number>>	This property is used for defining the number of items to be processed in sub batch (chunking)
Routing.ItemService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--

7.8.11 Settings for the SyncSpecificationValueSetListPIMReqABCSImpl service

Table 7-21 SyncSpecificationValueSetListPIMReqABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
TRACE.LOG.ENABLED	This property is used enabling trace log	--
ABCSExtension.PreInvokeValueSetServiceABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeValueSetServiceABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeEBSSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeEBSSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
Routing.SpecificationValueSetEBS.SyncSpecificationValueSetList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.PublicationService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.ValueSetService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--

7.8.12 Settings for the SyncItemCatalogCategoryPIMReqABCSImpl service

Table 7-22 SyncItemCatalogCategoryPIMReqABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
ABCSExtension.PreXformABMtoEBMItemCatalogCategoryABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMItemCatalogCategoryABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeEBSSyncClassificationSchemeListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeEBSSyncClassificationSchemeListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
Routing.ItemCatalogCategoryService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.PublicationService.PIM_01.EndpointURI	OPH/PIM web service end-point location. This is a SOAP endpoint URL.	--
Routing.ClassificationSchemeEBS.SyncClassificationSchemeList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.SpecificationValueSetEBS.SyncSpecificationValueSetList.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
TRACE.LOG.ENABLED	This property is used enabling trace log	--

7.8.13 Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service

Table 7-23 SyncClassificationSchemeListSiebelProvABCSImpl

System Property	alue/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
REUSE_WORKSPACE	For reusing the workspace.	--
ABCSExtension.PreXformEBMtoABMClassificationSchemeListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PreInvokeABSSyncProductClassABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeABSSyncProductClassABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMClassificationSchemeListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
Routing.SyncProductClassService.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.ClassificationSchemeResponseEBS.SyncClassificationSchemeListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
TRACE.LOG.ENABLED	This property is used enabling trace log	--

7.8.14 Settings for the SyncClassificationSchemeListSiebelProvABCSImpl service

Table 7-24 SyncClassificationSchemeListSiebelProvABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	It is the responsibility of the application to send the system ID from which the request is being sent. If any requestor application fails to send this, AIA picks the default system ID from this configuration property.	--
Routing.SWIAttributeImport.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
Routing.SpecificationValueSetResponseEBS.SyncSpecificationValueSetListResponse.RouteToCAVS	false/true	Determines whether to invoke AIA session pool manager to retrieve / release sessions based on CAVS property. In case of simulating the service, a call to AIASessionPoolManager is unnecessary and it is ignored.
ABCSExtension.PreXformEBMtoABMSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostXformABMtoEBMSpecificationValueSetListEBM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
Routing.SWIAttributeImport.SEBL_01.EndpointURI	Siebel web service end-point location. This is a SOAP endpoint URL.	--
Routing.SWIAttributeImport.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
Routing.SpecificationValueSetResponseEBS.SyncSpecificationValueSetListResponse.MessageProcessingInstruction.EnvironmentCode	PRODUCTION/CAVS	Sets the environment code element to the value PRODUCTION.
ABCSExtension.PreInvokeABSSyncAttributeDefinitionABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
ABCSExtension.PostInvokeABSSyncAttributeDefinitionABM	false/true	This property is used as an extension point before EBM is transformed to ABM. It determines whether invocation of service at the extension point is to be made depending on whether it is true or false.
OPERATION_TYPE	Y/N; N	This property indicates whether Siebel web service is to be used in synchronize or upsert mode. OPERATION_TYPE ='Y': The elements in payload are updated if they already exist in the system. Else, are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from the system. OPERATION_TYPE ='N' (Default): The elements in payload are updated if they already exist. Else are inserted (if they do not already exist). If the element is not present in payload, but present in system then it is not deleted from system.
UTC_FORMAT_ENABLE	Y/N; N	Currently the default value is N. If the value is set to 'N', then the datetime elements are not changed to the UTC Format and the values are passed through. If the value is set to 'Y', then the datetime elements are changed to the UTC format.

7.8.15 Settings for the ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl service

Table 7-25 ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl

System Property	Value/Default Value	Description
Routing.Target.Default.SiebelProduct Service.SystemID	SEBL_01	Siebel system instance code (defined in BSR). This is used only if the request message does not contain the target system ID.
Routing.Target.Default.SiebelProductService.EndpointURI	No default value.	Siebel ProductImport web service end point location. This is a SOAP end point URL. If the request message contains the target URL, then that takes precedence.
Routing.SiebelProductService.RouteToCAVS	True/False. Default = false.	If true, it invokes the actual target system whose end point is indicated by the service-level property Routing.Target.Default.SiebelProductService.EndpointURI. If false, it invokes the verification system whose end point is indicated by the system-level property SyncResponseSimulator.Soap.EndpointURL.
Routing.Target.Default.SiebelPriceListService.SystemID	SEBL_01	Siebel system instance code (defined in BSR). This is used only if the request message does not contain the target system ID.
Routing.Target.Default.SiebelPriceListService.EndpointURI	No default value.	Siebel PriceList web service end point location. This is a SOAP end point URL. If the request message contains the target URL, then that takes precedence.
Routing.SiebelPriceListService.RouteToCAVS	True/False. Default = false.	If true, it invokes the actual target system whose end point is indicated by the service-level property Routing.Target.Default.SiebelPriceListService.EndpointURI. If false, it invokes the verification system whose end point is indicated by the system-level property SyncResponseSimulator.Soap.EndpointURL.
Siebel.BusinessUnit	No default value.	All the products created will belong to this business unit in the Siebel system. The value for this property should be the ID of the business unit in the Siebel system. This value must be set before product sync is run.
Siebel.Product.Workspace Name	Demo Workspace	Name of the workspace to be used by Siebel. Create a workspace and update this file with that workspace name.
Siebel.Product.Workspace ReleaseFlag	Y/N. Default = N	Indicates whether the workspace needs to be released after the product is synchronized.
Siebel.Product.WorkspaceReuseFlag	Y/N. Default = Y	Indicates whether the workspace needs to be reused for product to be synced.
Siebel.PriceList.ID	No default value.	All the products created by this sync belongs to this pricelist in the Siebel system. The value for this property should be the ID of the pricelist in the Siebel system. This value must be set before product sync is run.
Siebel.PriceList.Currency	USD	Currency code of the pricelist mentioned in the preceding property. If the currency of the prices in PriceListEBM does not match this currency, price in Siebel will be set to 0 (zero). This value must be set before the product sync is run.

7.8.16 Settings for the SyncItemCompositionListSiebelCommsProvABCSImpl service

Table 7-26 SyncItemCompositionListSiebelCommsProvABCSImpl

System Property	Value/Default Value	Description
Default.SystemID	SEBL_01	Siebel system instance code (defined in BSR).This is used only if the request message does not contain the target system ID.
Routing.CommunicationsItemCompositionResponseEBSV1.SyncItemCompositionListResponse.RouteToCAVS	true/false. Default = false	Controls whether CommunicationsItemCompositionResponseEB SV1 routes messages to the verification system or to the Provider ABCS implementation.
Routing.CommunicationsItemCompositionResponseEBSV1.SyncItemCompositionListResponse.CAVS.EndpointURI	http://$<http.hostname>:$<http.port>/AIAValidationSystemServlet/asyncresponserecipient	The endpoint URI of the CAVS simulator.
Routing.CommunicationsItemCompositionResponseEBSV1.SyncItemCompositionListResponse.MessageProcessingInstruction.EnvironmentCode	CAVS/PRODUCTION /Any ValueDefault = PRODUCTION	If CAVS, then the message is routed to CAVS. For other values, the message is routed to the Provider ABCS Implementation.
Routing.SiebelProductService.SEBL_01.EndpointURI	http://$<http.hostname>:$<http.port>/eai_enu/start.swe?SWEExtSource=SecureWebService&amp;SWEExtCmd=Execute&amp;WSSOAP=1	Siebel Product Import web service end point location. This is a SOAP end point URL. If the request message contains the target URL, then that takes precedence.
Routing.SiebelProductService.RouteToCAVS	true/false. Default = false	If true, it invokes the actual target system whose end point is indicated by theservice-level property Routing.SiebelProductService.SEBL_01.EndpointURI. If false, it invokes theverification system whose end point isindicated by the system-level propertySyncResponseSimulator.Soap.EndpointURL.
Routing.SiebelProductService.CAVS.EndpointURI	http://$<http.hostname>:$<http.port>/AIAValidationSystemServlet/asyncresponsesimulator	The endpointURI of the CAVS simulator.
Siebel.SEBL_01.BusinessUnit	No default value.	All the products created belong to this business unit in the Siebel system. The value for this property should be the ID of the business unit in the Siebel system. This value must be set before Product Sync is run.
Siebel.Product.WorkspaceName	Demo Workspace	Name of the workspace to be used by Siebel. Create a workspace and update this file with that workspace name.
Siebel.Product.WorkspaceReuseFlag	Y/N. Default = N	Indicates whether the workspace must be released after the product is synchronized.
Siebel.PriceList.ID	No default value.	All the products created by this sync belongs to this pricelist in the Siebel system. The value for this property should be the ID of the pricelist in the Siebel system. This value must be set before product sync is run.
ABCSExtension.PreXformEBMtoABM	true/false. Default = false	Value determines whether the ABCS should invoke the Extension service (before the EBMto ABM transformation.)
ABCSExtension.PostXformABMtoEBM	true/false. Default = false	Value determines whether the ABCS should invoke the Extension service (after the ABM to EBM transformation).
ABCSExtension.PreInvokeABS	true/false. Default = false	Value determines whether the ABCS should invoke the Extension service (PreInvokeApplication).
ABCSExtension.PostInvokeABS	true/false. Default = false	Value determines whether the ABCS should invoke the Extension service (PostInvokeApplication).

7.9 Setting Up the Data for Seeded Attributes of the Telecommunications Library

The entities in Table 7-27 have to be set up in target applications, and the corresponding attribute valueset must be updated with the values in OPH.

Table 7-27 Attributes

Attribute Group Name	Attribute Name
Product Details: Logistics	Vendor Part Number (Siebel)
Subject compatibility rules	Matrix Name (Siebel)
Pricing: Simple Pricelist (For non-billing products)	Pricelist Name (Siebel) Volume Discount (Siebel) Attribute Adjustment (Siebel)
Pricing: Mutiple Pricelist
Promotion: Commitment: Charges Credits	Plan (Siebel)
Billing Products Attributes General	Provisioning Tag (BRM) Supplier Tax ID (BRM)
Balance Impact	Pricelist Name (BRM) GL_ID (BRM) Impact Category (BRM)
Billing discount attributes	Provisioning Tag (BRM)

Table 7-28 lists the attributes and respective DVMs in which the values for these attributes must be added:

Table 7-28 DVM values

Attribute Name	DVM
GLID	GL_CODE
Provisioning Tag	PROVISIONING_TAG
Impact Category	PRICE_IMPACTCLASSIFICATIONCODE

7.10 Setting up List of Values in Siebel

Once the OPH integration is successfully installed and all the configuration setups are complete, these values need to be added to the PROD_CD list of values (LOV) in Siebel application:

• Commercial Bundle

• Discount

• Option Group

• Discount Model