This chapter provides information on configuring Oracle Product Hub, Siebel CRM, and Oracle E-Business Suite for integration.
To add a new spoke or target instance for the integration:
Add the instance name to the destination system to pick target systems while publishing.
Login to Oracle Product Hub.
Navigate to the responsibility Oracle Product Hub Data Librarian.
Under Batch Import, navigate to Import Workbench.
Click the System Setup tab.
Click Define Source System.
Provide the Name and Code for the new Target Instance. For example, if the new target system is JD Edwards:
Name: JD Edwards
Code: JDE
Add the same entry on the destination system valueset Destination_System in Oracle Product Hub.
Select the responsibility Setup Workbench (Setup)
Click the Value Sets tab.
Search for the valueset Destination_System.
In values section, click Create.
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 must match the name previous value).
Description: New Target System JD Edwards.
Add the entry for the instance in the System Setting in Oracle AIA.
Login to the System Setting page.
Click the Setup tab.
Click the System tab.
Click Create.
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.)
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 Oracle Product Hub system (Step 1). Table 7-1 shows an example:
COMMON: JDE_01
PIM_01: JDE
Entry in TARGET_ID DVM:
Add the entry in ENTITY_TO_TARGET_APPLICATION DVM, for processing Pricelist and Bill of Materials (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 and Codes
| System | System Name and Code in Oracle Product Hub | System Setting |
|---|---|---|
|
Ebiz |
Name: Ebiz System Code: EBSSS |
Internal Id: Ebiz |
|
Siebel |
Name: Siebel CRM Code: Siebel |
Internal Id: Siebel |
|
BRM |
Name: BRM System Code: BRM |
Internal Id: BRM |
|
JDE |
Name: JDE System Code: JDE |
Internal Id: 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:
Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/dvm
Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/xref
They can also be looked at by logging into MDS.
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.
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}
Add similar rules for PriceListEBSV2 and BillOfMaterialsEBS.
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:
Identify the cross-references and DVMs being used in the connectors for the new spoke system.
For example: Add JDE_01 to the xref file ITEM_ITEMID.xref under Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/xref/ITEM_ITEMID.xref and to the DVM file DVM under Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/dvm/ITEM_TYPE.dvm
Update MDS. Modify domain_home/soa/aia/MDSUtils/UpdateMetaDataDP.xml to include the files modified in step b. Then navigate to the folder MW_home/soa/aiafp/Install/AID/ and run:
ant -f MW_home/soa/aiafp/Install/AID/UpdateMetaData.xml -DdeploymentPlan=domain_home/soa/aia/MDSUtils/UpdateMetadataDP.xml -DPropertiesFile=domain_home/soa/aia/bin/AIAInstallProperties.xml
Once complete, login to the Oracle AIA console, navigate to setup\AIA Configuration and click the Reload button to load the changes.
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 Oracle Product Hub is mapped to an Organization/Business Unit in Siebel CRM.
An inventory organization in Oracle Product Hub is mapped to inventory location in Siebel CRM, which needs to be child of a business unit.
If Oracle Product Hub and E-Business Suite co-exist, the organization and inventory organization needs to be set up in Oracle Product Hub 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:
For more information on operating units or inventory organizations, see the Oracle E-Business guides.To extract inventory location IDs:
Log in to Oracle Product Hub database.
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.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:
Log in to the Oracle Product Hub database.
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.Use the IDs from step 2 for cross-referencing the data for operating units using the XREF_TABLE_NAME: ORGANIZATION_ID.
Identify Item Validation Organization for Oracle Product Hub for the operating unit you want.
To identify the item validation organization from the names of the organizations you noted in Extract Inventory Organization and Operating Unit IDs in E-Business Suite.
Publishing a product is on-demand by a product administrator from Oracle Product Hub. 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 Order Management is only published to Siebel CRM.
Log in to Oracle Product Hub. The Oracle Applications home page will appear.
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.Select Order Management Super User, Vision Operations (USA).
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:
Select Values from Setting Parameter Values.
Enter Vision Operations in Operating Unit and GenericParameters in Category.
Write down the value that appears in Item validation organization. (Examples: Vision Operations, Vision Germany, and Vision France).
To map Siebel CRM organizations to E-Business Suite operating units:
Log in to Siebel CRM Applications.
Click Site Map.
Select Administration-Groups, Organizations.
For every operating unit in E-Business Suite, create a corresponding organization in Siebel CRM.
For more information, see the Siebel CRM product documentation.
Creating Inventory Locations in Siebel CRM
To map Siebel CRM Inventory Locations to E-Business Inventory Organizations:
Log into Siebel CRM applications.
Click on Site Map.
Select Inventory, Inventory Locations.
Make sure to create a 'Warehouse' Inventory Type for the Oracle Inventory Organizations which will validate, check availability for orders, and ship items during order fulfillment. The corresponding operating unit should also be associated to the Inventory Location as 'Organization'.
To extract inventory location details for Siebel CRM:
Log in to the Siebel CRM database as the table owner.
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%'
Run this query and note the IDs for the inventory locations:
(select row_id, name from s_invloc where name like '%Vision%')
These are the setups required for Oracle Communications Billing and Revenue Management (BRM):
Install and configure BRM JCA adapter.
For more information about installing and setting up the BRM JCA adapter, see the 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 Oracle Communications Billing and Revenue Management Setting Up Pricing and Rating.
Set up pricing for friends and family functionality.
For more information about setting up pricing, see Oracle Communications Billing and Revenue Management Setting Up Pricing and Rating.
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:
The cross-reference data for the ORGANIZATION_ID and INVENTORY_LOCATION_ID XRef entity must be added manually before you use the Pre-built Integration Pack, 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 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 columns listed in Table 7-3 and Table 7-4:
| Column Name | Description |
|---|---|
|
XREF_TABLE_NAME |
This column stores the XRef data types. For example:
|
|
XREF_COLUMN_NAME |
This column stores the values indicating the edge applications and COMMON value:
|
|
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 Organizational XRef Table Value Format
| XRef_Column_Name | Value |
|---|---|
|
COMMON |
GUID |
|
PIM_01 |
Organization Id from Oracle Product Hub. For example, 911 |
|
SEBL_01 |
Organization Id (Business Unit) from Siebel CRM. For 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/ORGANIZATION_ID.xref','PIM_01','BD618D40B30C11DEBFA5D9490F57512E','911','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 Organization_ID Table
| XRef_Table | XRef_Column | Row_Number | Value | IS_Deleted | Last_Modified |
|---|---|---|---|---|---|
|
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 Oracle Product Hub. For example, 911. |
|
EBIZ_01 |
Ebiz INV ID. For example, 204. |
|
SEBL_01 |
INVENTORY_LOCATION_ID from Siebel CRM. For 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 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 |
To validate cross-references:
Log in to the AIA XRef database.
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.
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 like '%INVENTORY_LOCATION_ID%' and value in ('911'))
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 like '%ORGANIZATION_ID%' and value in ('911'))
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.)
To create a pricelist in Siebel CRM:
Create a pricelist in Siebel CRM.
Extract the pricelist RowID in Siebel CRM and update the Property PriceList.ID with the pricelist RowID of AIAConfigurationProperties for following:
SyncItemCompositionListSiebelCommsProvABCSImpl
ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl
If these pricelist(s) are used in standard pricing offer or billing pricing offer (rate plan selector in billing products) model in Oracle Product Hub, 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 Oracle Product Hub/BRM.
For more information, see "Setting Up Configuration Properties".
To support 100 characters for product names during synchronization between Oracle Product Hub and Siebel CRM, refer to the following assumptions and perform the setup in Oracle AIA as described below:
Consider these assumptions to support 100 character product names:
In Oracle Product Hub, Vision Operations is the default or master organization where products must be first defined. You can create new organization and configure as Master Organization in Oracle Product Hub.
In Siebel CRM, Default Organization is the master organization where products must first be defined. Do not to change the configuration of Default Organization.
The name of the master organizations in Siebel CRM and Oracle Product Hub can be different and the integration needs to maintain the same mapping.
You can create additional organization in Oracle Product Hub and Siebel CRM. Associate the products to these additional organizations as secondary organizations. However, the integration does not support multiple organization at this time.
In the Oracle AIA xref for Organization, map the master organization ID in Oracle Product Hub to master organization ID in Siebel CRM. For example:
Table 7-8 Master Organization Mapping - Oracle Product Hub to Siebel CRM
| Common | PIM_01 | SEBL_01 |
|---|---|---|
|
3242424a3f313 |
12345 (Vision Operations ID) |
0-R9NH (Default Organization ID) |
With the above assumptions and setup done in Oracle AIA, in Siebel CRM, set the Product Business Unit to Default Organization, and the Primary Organization to Default Organization. If the Product Business Unit and Primary Organization values are identical, Oracle can support a 100 chars long product name through Product WS.
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 working with cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite.
Table 7-9 lists the cross-references for Product Master Data Management integration:
Table 7-9 Oracle Product Hub cross-references
| Table Name | Column Name | Description |
|---|---|---|
|
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 item catalog category 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 |
Used to cross reference pricelist Line Id. |
|
PRICELINETYPE_ID |
EBIZ_01,COMMON, SEBL_01, PIM_01 |
Used 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 BRM Product's Event that is Associated with the main product in Siebel CRM. |
|
PROMOTION_PROMOTIONID |
COMMON, SEBL_01 |
During product synchronization Promotion Id is stamped in this cross-reference based Entity Type. During Product Structure Synchronization, this cross-reference is looked up to determine Product is promotion. |
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:
Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/dvm
Oracle_home/comms_home/source/soainfra/apps/AIAMetaData/xref
They can also be looked at by logging into MDS.
Table 7-10 lists the DVMs for the Product Master Data Management integration:
| 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 received by target applications, for example, Oracle E-Business Suite receives Items and BOMs; Siebel CRM 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_CURRENTFUTURE PAST_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 Oracle Product Hub 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 Oracle Product Hub, Siebel CRM, 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 rate restriction used in the plan tier, for example, No Restrictions, Restriction based on days only, Restriction based on days/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, PIM_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 for sync. This DVM is used to map the system defined in Oracle Product Hub and OER for publication. |
|
UNIT_OF_MEASURE |
EBIZ_01,COMMON, SEBL_01, PIM_01,OTM_01,JDEE1_01,JD EE1_01_RATECODE, P6EPPM _01_RATECODE, EBS_PROJEC TS_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_CONVERSIO N_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 CRM as active, pending, or closed. |
|
ITEM_PRIMARYCLASSIFI CATIONCODE |
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 to map 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, 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_PURCHASEP RORATIONCODE |
PIM_01, COMMON, BRM_01, SEBL_01 |
Indicates how to charge customers when they purchase the product during the accounting cycle, for example, Do not Charge for the cycle; Calculate Charge based on the amount used, etc. |
|
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, BRM_01, SEBL_01 |
Identifies the set of products in general ledger. |
|
PRICE_IMPACTCLASSIFIC ATIONCODE |
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_DISCOUNTBR ACKETCODE |
PIM_01, COMMON, BRM_01, SEBL_01 |
Indicates the discount brackets to charge different amounts based on quantity, for example, Rate Dependent, Continuous, Resource, and so on. |
|
PLANTIER_EFFECTIVITYMODE |
PIM_01, COMMON, BRM_01, SEBL_01 |
Indicates the associated effectivity mode for the tier's date and time, for example, Absolute, Relative. |
|
RATEPLAN_TAXAPPLICABILITYCODE |
PIM_01, COMMON, BRM_01, SEBL_01 |
Indicates when to apply the tax, 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 CRM/ BRM from E-Business Suite / Oracle Product Hub instance to Siebel CRM/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 E-Business Suite. There is no Siebel CRM equivalent for STRUCTURE_NAME_ALTERNATE_BOM.
STRUCTURE_TYPE: Used to identify type for structures 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 CRM.
Table 7-11 provides sample data for the STRUCTURE_TYPE domain value map:
An entry should be made in this DVM even for a primary BOM.
Based on the roles defined for the services, the program sends email notifications if a service errors out. There are no Oracle AIA-specific errors thrown by the services for this integration. For more information about the errors thrown by Siebel CRM or E-Business Suite, see the respective product documentation.
For more information about Oracle AIA error handling, see the discussion of setting up error handling in Oracle Fusion Middleware Infrastructure Components and Utilities User's Guide for Oracle Application Integration Architecture Foundation Pack.
Set these properties in the Comms_home/source/soainfra/apps/AIAMetaData/config/AIAConfigurationProperties.xml file.
For more information about requirements for working with AIAConfigurationProperties.xml, see the discussion of how to set up Oracle AIA Workstation in Oracle Fusion Middleware Developer's Guide for Oracle SOA Core Extension.
Table 7-12 shows the properties for the SyncItemListPIMReqABCSImpl service.
Table 7-12 SyncItemListPIMReqABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
Routing.QueryItemListPIMAdapter.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.QueryBillOffMaterialsListPIMAdapter.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.GetListofTargetSystems.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.PublicationService.PIM_01.EndpointURI |
- |
Oracle Product Hub 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeItemListEBSSyncItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABMItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvolkePublicationServiceItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokePriceListEBSSyncItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABMPriceListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvolkePublicationServicePriceListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreXformABMtoEBMIBillOfMaterialsListABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeBillOfMaterialsListEBSSyncBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABMBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvolkePublicationServiceBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
NUMBER_OF_PARALLEL_ITEM_TARGETS |
- |
When synchronizing items to multiple targets, this property controls Item processing for parallel targets |
|
NUMBER_OF_PARALLEL_BOM_TARGETS |
- |
This property controls number of parallel targets to be processed for BOMs to multiple targets |
Table 7-13 shows the properties for the SyncSpecificationValueSetListSiebelProvABCSImpl service.
Table 7-13 SyncSpecificationValueSetListSiebelProvABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
I |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformABMtoEBMSpecificationValueSetListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
Routing.SWIAttributeImport.RouteToCAVS |
false/true |
Determines whether to invoke Oracle 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 |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.GetListofTargetSystems.RouteToCAVS |
false/true |
Determines whether to invoke Oracle 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 |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.PublicationService.RouteToCAVS |
false/true |
Determines whether to invoke Oracle 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 |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.SWIAttributeImport.SEBL_01.EndpointURI |
- |
Siebel CRM web service end-point location (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 Oracle 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostInvokeABSSyncAttributeDefinitionABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
OPERATION_TYPE |
Y/N; N |
This property indicates whether Siebel CRM web service is to be used in synchronize or upsert mode. OPERATION_TYPE ='Y': Updates elements in payload if they already exist. If not, they are inserted. If the element is not present in payload, but is present in system then it is not deleted. OPERATION_TYPE ='N' (Default): Updates elements in payload if they already exist. If not, they are inserted. If the element is not present in payload, but is present in system then it is not deleted. |
|
UTC_FORMAT_ENABLE |
Y/N; N |
If the value is set to 'N' (Default), 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PreInvokeItemListEBSSyncItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PostXformEBMtoABMItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PreInvolkePublicationServiceItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PreInvokePriceListEBSSyncItemListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PostXformEBMtoABMPriceListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PreInvolkePublicationServicePriceListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension. PreXformABMtoEBMIBillOfMaterialsListABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeBillOfMaterialsListEBSSyncBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABMBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvolkePublicationServiceBOMListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if 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. |
Table 7-14 shows the properties for the SyncItemListBRMProvABCSImpl service.
Table 7-14 SyncItemListBRMProvABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
BRM_01 |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
ABCSExtension.PreXformEBMtoABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if 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.MessageProcessingIn struction.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 if 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 if it is true or false. |
Table 7-15 shows the properties for the SyncPriceListListBRMProvABCSImpl service.
Table 7-15 SyncPriceListListBRMProvABCSImpl Properties
| Property Name | Property Value | Description |
|---|---|---|
|
Default.SystemID |
BRM_01 |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
ABCSExtension.PreXformEBMtoABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformEBMtoABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if 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.MessageProcessingIns |
PRODUCTION |
Sets the EnvironmentCode 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 if 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 if it is true or false. |
Table 7-16 shows the properties for the QueryBillOfMaterialsListPIMAdapter service.
Table 7-16 QueryBillOfMaterialsListPIMAdapter Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
BATCH_SIZE |
any integer |
This property is used for defining the number of structures to be processed in sub batch (chunking) |
|
Routing.ItemService.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location (SOAP endpoint URL). |
Table 7-17 shows the properties for the QueryItemListPIMAdapter service.
Table 7-17 QueryItemListPIMAdapter Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requester application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
BATCH_SIZE |
any integer |
Used for defining the number of sub-batch process items (chunking) |
|
Routing.ItemService.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location (SOAP endpoint URL). |
Table 7-18 shows the properties for the SyncSpecificationValueSetListPIMReqABCSImpl service.
Table 7-18 SyncSpecificationValueSetListPIMReqABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostInvokeValueSetServiceABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeEBSSpecificationValueSetListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if 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 |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.ValueSetService.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
Table 7-19 shows the properties for the SyncItemCatalogCategoryPIMReqABCSImpl service.
Table 7-19 SyncItemCatalogCategoryPIMReqABCSImpl Properties
| System Property | 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 requester application fails to send this, Oracle 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformABMtoEBMItemCatalogCategoryABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeEBSSyncClassificationSchemeListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostInvokeEBSSyncClassificationSchemeListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
Routing.ItemCatalogCategoryService.PIM_01.EndpointURI |
- |
Oracle Product Hub web service end-point location. This is a SOAP endpoint URL. |
|
Routing.PublicationService.PIM_01.EndpointURI |
- |
Oracle Product Hub 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. |
Table 7-20 shows the properties for the SyncClassificationSchemeListSiebelProvABCSImpl service.
Table 7-20 SyncClassificationSchemeListSiebelProvABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PreInvokeABSSyncProductClassABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformABMtoEBMClassificationSchemeListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
Routing.SyncProductClassService.SEBL_01.EndpointURI |
- |
Siebel CRM 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. |
Table 7-21 shows the properties for the SyncClassificationSchemeListSiebelProvABCSImpl service.
Table 7-21 SyncClassificationSchemeListSiebelProvABCSImpl Properties
| System Property | Default Value | Description |
|---|---|---|
|
Default.SystemID |
- |
It is the responsibility of the requestor application to send the system ID. If any requester application fails to send this, Oracle AIA picks the default system ID from this configuration property. |
|
Routing.SWIAttributeImport.RouteToCAVS |
false/true |
Determines whether to invoke Oracle 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 Oracle 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostXformABMtoEBMSpecificationValueSetListEBM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
Routing.SWIAttributeImport.SEBL_01.EndpointURI |
- |
Siebel CRM 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 to determine whether to invoke service depending on if it is true or false. |
|
ABCSExtension.PostInvokeABSSyncAttributeDefinitionABM |
false/true |
This property is used as an extension point before EBM is transformed to ABM to determine whether to invoke service depending on if it is true or false. |
|
OPERATION_TYPE |
Y/N; N |
This property indicates whether Siebel CRM web service is to be used in synchronize or upsert mode. OPERATION_TYPE ='Y': Updates elements in payload if they already exist. If not, they are inserted. If the element is not present in payload, but present in system then it is not deleted. OPERATION_TYPE ='N' (Default): Updates elements in payload if they already exist. If not, they are inserted. If the element is not present in payload, but present in system then it is not deleted. |
|
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. |
Table 7-22 shows the properties for the ProductOptimizedSyncPriceListListSiebelCommsProvABCS service.
Table 7-22 ProductOptimizedSyncPriceListListSiebelCommsProvABCS Properties
| System Property | Default Value | Description |
|---|---|---|
|
Routing.Target.Default.SiebelProduct Service.SystemID |
SEBL_01 |
Siebel CRM 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 CRM system instance code (defined in BSR). This is used only if the request message does not contain the target system ID. |
|
Routing.SiebelProductService.RouteToCAVS |
True/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. |
|
Siebel.BusinessUnit |
No default value. |
All the products created will belong to this business unit in the Siebel CRM system. The value for this property should be the ID of the business unit in the Siebel CRM system. Set this before running product sync. |
|
Siebel.Product.Workspace Name |
Demo Workspace |
Name of the workspace to be used by Siebel CRM. 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 CRM system. The value for this property should be the ID of the pricelist in the Siebel CRM system. Set this before running product sync. |
|
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 CRM will be set to 0(zero). Set this before running product sync. |
Table 7-23 shows the properties for the SyncItemCompositionListSiebelCommsProvABCSImpl service.
Table 7-23 SyncItemCompositionListSiebelCommsProvABCSImpl Properties
| System Property | Value/Default Value | Description |
|---|---|---|
|
Default.SystemID |
SEBL_01 |
Siebel CRM 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 CommunicationsItem CompositionResponseEB 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 Value Default = 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>/eaienu/start.swe?SWEExtSource=SecureWebService&SWEExtCmd=Execute&WSSOAP=1 |
Siebel CRM 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 the service-level property Routing.SiebelProductService.SEBL_ 01.EndpointURI. If false, it invokes the verification system whose end point is indicated by the system-level property SyncResponseSimulator.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 Siebel CRM system. The value for this property should be the ID of the business unit in Siebel CRM system. Set this before running product sync. |
|
Siebel.Product.WorkspaceName |
Demo Workspace |
Name of the workspace used by Siebel CRM. Create a work space and update it 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 Siebel CRM system. The value for this property should be the ID of the Siebel CRM system pricelist. Set this before running product sync. |
|
ABCSExtension.PreXformEBMtoABM |
true/false. |
Value determines whether the ABCS should invoke the Extension service (before the EBM to ABM transformation.) |
|
ABCSExtension.PostXformABMtoEBM |
true/false. |
Value determines whether the ABCS should invoke the Extension service (after the ABM to EBM transformation). |
|
ABCSExtension.PreInvokeABS |
true/false. |
Value determines whether the ABCS should invoke the Extension service (PostInvokeApplication). |
|
ABCSExtension.PostInvokeABS |
true/false. |
Value determines whether the ABCS should invoke the Extension service (PostInvokeApplication). |
The entities in Table 7-24 have to be set up in target applications, and the corresponding attribute valueset must be updated with the values in Oracle Product Hub.
| Attribute Group Name | Attribute Name |
|---|---|
|
Product Details: Logistics |
Vendor Part Number (Siebel CRM) |
|
Subject compatibility rules |
Matrix Name (Siebel CRM) |
|
Pricing: Simple Pricelist (For non-billing products) |
Pricelist Name (Siebel CRM), Volume Discount (Siebel CRM), Attribute Adjustment (Siebel CRM) |
|
Pricing: Mutiple Pricelist |
- |
|
Promotion: Commitment: Charges Credits |
Plan (Siebel CRM) |
|
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-25 lists the attributes and respective DVMs in which the values for these attributes must be added:
Once the Oracle Product Hub integration is installed and the configuration setup is complete, add these values to the PROD_CD list of values (LOV) in Siebel CRM application:
Commercial Bundle
Discount
Option Group
Discount Model