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:
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 OPH.
Navigate to the responsibility OPH 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. (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 OPH.
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 value must match the name value defined above).
Description: New Target System JD Edwards.
Add the entry for the instance in the System Setting in 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 OPH 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 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.
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 <AIAHOME>/AIAMetaData/xref/ITEM_ITEMID.xref and to the DVM file DVM under <AIAHOME>/AIAMetaData/dvm/ITEM_TYPE.dvm
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
Once complete, login to the 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 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.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 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.
Log in to Oracle Product Hub. The following page appears:
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 organizations to Oracle E-Business Suite operating units:
Log in to Siebel Applications.
Click Site Map.
Select Administration-Groups, Organizations.
For every operating unit in Oracle E-Business Suite, create a corresponding organization in Siebel CRM. Figure 7-3 shows a screen shot:
For more information, see the Siebel product documentation.
Creating Inventory Locations in Siebel
To map Siebel Inventory Locations to Oracle E-Business Inventory Organizations:
Log into Siebel applications.
Click on Site Map.
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-4:
To extract inventory location details for Siebel CRM:
Log in to the Siebel 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 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.
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 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 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:
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 OPHFor example, 911 |
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 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 |
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 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.
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 RowID of the pricelist in Siebel and update the Property PriceList.ID with the RowID of the pricelist in AIAConfigurationProperties for the 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 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 Up Configuration Properties".
To support 100 characters for product names during synchronization between OPH and Siebel, refer to the following assumptions and perform the setup in AIA as described below:
Consider these assumptions to support 100 character product names:
In OPH, Vision Operations is the default or master organization where products must be first defined. Users can create new organization and configure as Master Organization in OPH.
In Siebel, Default Organization is the default or master organization where products must be first defined. Do not to change the configuration of the Default Organization.
The name of the master organizations in Siebel and OPH can be different and the integration needs to maintain the same mapping.
You can create additional organization in OPH and Siebel. Associate the products to these additional organizations as secondary organizations. However, the integration does not support multiple organization at this time.
In the AIA xref for Organization, map the master organization ID in OPH to master organization ID in Siebel. For example:
Table 7-8 Master Organization Mapping - OPH to Siebel
Common | PIM_01 | SEBL_01 |
---|---|---|
3242424a3f313 |
12345 (Vision Operations ID) |
0-R9NH (Default Organization ID) |
With the above assumptions and setup done in AIA, in Siebel, set the Product Business Unit to Default Organization, and the Primary Organization to Default Organization. Given that Product Business Unit and Primary Organization values will be identical, we can support 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 cross-references, see Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite ”Working with Cross References”.
Table 7-9 lists the cross-references for the Product MDM integration:
Table 7-9 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. |
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-10 lists the DVMs for the Product MDM 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 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-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, 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."
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.
Table 7-12 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. |
-- |
Table 7-13 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. |
-- |
Table 7-14 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. |
Table 7-15 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. |
Table 7-16 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. |
-- |
Table 7-17 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. |
-- |
Table 7-18 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. |
-- |
Table 7-19 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 |
-- |
Table 7-20 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 |
-- |
Table 7-21 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. |
Table 7-22 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. |
Table 7-23 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&SWEExtCmd=Execute&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). |
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 OPH.
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-25 lists the attributes and respective DVMs in which the values for these attributes must be added:
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