A Cross-References for the Process Integration for Product Lifecycle Management

This appendix describes the cross-references used in the process integration for Product Lifecycle Management (PLM) and provides information about the product synchronization flow and the discount synchronization flow between Oracle Communications Billing and Revenue Management (BRM) and Siebel customer relationship management (Siebel CRM).

Cross-References for the Process Integration for Product Lifecycle Management

Table A-1 lists the cross-references for the process integration for PLM.

Table A-1 Cross-References for Product Lifecycle Management

Operation	Entity	Siebel CRM ID	BRM ID
Inserts/Refers	ITEM_ITEMID	Product ID	Product ID
Inserts/Refers	PRICELINE_ID (main products only)	Price Line ID to Common ITEM_ITEMID of main product	Product ID
Inserts/Refers	PRICELINETYPE_ID (for event/special type products)	Price Line ID to Common ITEM_ITEMID	Generated Product ID for Event products (ProductIDEvent Name)
Inserts/Refers	SIEBELPRODUCTEVENTXREF	Common ITEM_ITEMID for the parent product to Common PRICELINETYPE_ID for event product	$--

Cross-Reference Values

Table A-2 shows the values for the cross-reference entries for PLM.

Table A-2 Values of the Cross-References for Product Lifecycle Management

Entry	Description	COMMON Value	BRM_01 Value	SEBL_01 Value	ITEM_ID_COMMON Value	LINEPRICETYPECODE Value
ITEM_ITEMID	Cross-references the BRM ProductID and the Siebel CRM ProductID.	Auto-generated GUID	POID of BRM Product ABM	ProductID of Siebel CRM Product ABM	NA	NA
PRICELINE_ID	Cross-references the BRM Product ID and the Siebel CRM PriceLineID. Also links to the COMMON column of the ITEM_ITEMID entry.	Auto-generated GUID	POID of BRM Product ABM	Siebel PriceListItemID for the main product	From ITEM_ID.COMMON	NA
PRICELINETYPE_ID	Cross-reference BRM Product's Event and the Siebel CRM PriceLineID. Also links to the COMMON column of the ITEM_ITEMID entry.	Auto-generated GUID	POID of BRM Product ABM and Event Name	Siebel CRM PriceListItemID for the event product	From ITEM_ID.COMMON	NA
SIEBELPRODUCTEVENTXREF	Cross-references BRM Product's Event that is associated with the main product in Siebel CRM.	NA	NA	NA	From ITEM_ID.COMMON	From PRICELINETYPE_ID.COMMON

Product Synchronization Flow

Figure A-1 illustrates the events that occur for product synchronization. Tables Table A-3, Table A-4, Table A-5, Table A-6, Table A-7, Table A-8, and Table A-9 describe the entries that are made in the XREF_DATA table for each event.

Figure A-1 Product Synchronization Flow

1. Before the SyncProductBRMCommslReqABCSImpl service makes the call to the SyncItemCompositionListSiebelCommsProvABCSImpl service, the entries listed in Table A-3 are made in the XREF_DATA table.

   Table A-3 XREF_DATA

   XREF_TABLE_NAME	VALUE
   ITEM_ITEMID	POID of BRM product
   ITEM_ITEMID	COMMON GUID1

   
   

2. During the response back from Siebel CRM to the SyncItemCompositionListSiebelCommsProvABCSImpl service, the entry listed in Table A-4 is made in the XREF_DATA table.

   Table A-4 XREF_DATA

   XREF_TABLE_NAME	VALUE
   ITEM_ITEMID	Siebel CRM ProductID

   
   

3. Before the SyncProductBRMCommslReqABCSImpl service makes the call to the ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl service, the entries listed in Table A-5 are made in XREF_DATA table.

   Table A-5 XREF_DATA

   XREF_TABLE_NAME	VALUE
   PRICELINE_ID	POID of BRM product
   PRICELINE_ID	COMMON GUID2
   PRICELINETYPE_ID	POID of BRM Event product
   PRICELINETYPE_ID	COMMON GUID2

   
   

4. Before the ProductOptimizedSyncPriceListListSiebelProvABCSImpl service calls the SyncItemCompositionListSiebelCommsProvABCSImpl service, the entries listed in Table A-6 are made in the XREF_DATA table.

   Table A-6 XREF_DATA

   XREF_TABLE_NAME	VALUE
   SIEBELPRODUCTEVENTXREF	LINEPRICETYPECODE GUID2
   SIEBELPRODUCTEVENTXREF	ITEM_ID_COMMON GUID1

   
   

5. During the response from the SyncItemCompositionListSiebelCommsProvABCSImpl service, the entries listed in Table A-7 are made in the XREF_DATA table.

   Table A-7 XREF_DATA

   XREF_TABLE_NAME	XREF_COLUMN_NAME
   ITEM_ITEMID	COMMON GUID2
   ITEM_ITEMID	Siebel CRM ProductID of Event Product >

   
   

   Note:

   For the simple product synchronization, the previous call is not made because the main product is synchronized as an Item.

6. Before the ProductOptimizedSyncPriceListListSiebelProvABCSImpl service calls Siebel CRM, the entries listed in Table A-8 are made in the XREF_DATA table.

   Table A-8 XREF_DATA

   XREF_TABLE_NAME	VALUE
   PRICELINE_ID	ITEM_ID_COMMON
   PRICELINETYPE_ID (in case of multi-event product)	ITEM_ID_COMMON

   
   

7. During the response from Siebel CRM to the ProductOptimizedSyncPriceListListSiebelProvABCSImpl service, the entries listed in Table A-9 are made in the XREF_DATA table.

   Table A-9 XREF_DATA

   XREF_TABLE_NAME	VALUE
   PRICELINE_ID	Siebel CRM ProductID for Event Product
   PRICELINETYPE_ID (in case of multi-event product)	Siebel CRM ProductID for Event Product

   
   

Example of Simple Product Synchronization

In the following example, a simple product is being synchronized from BRM to Siebel CRM.

1. Create a simple product in BRM to be synchronized to Siebel CRM, as shown in Figure A-2.

   Figure A-2 Creating a Simple Product in BRM

   
   Description of "Figure A-2 Creating a Simple Product in BRM"
   
   

2. Verify the synchronized records in Siebel CRM, as shown in Figure A-3.

   Figure A-3 Synchronized Simple Product Records in Siebel CRM

   
   Description of "Figure A-3 Synchronized Simple Product Records in Siebel CRM"
   
   

3. Verify the data entered into the XREF_DATA table is correct as shown in table Table A-10.

Table A-10 Data in XREF_DATA Table for Synchronized Example Simple Product

XREF_TABLE_NAME	XREF_COLUMN_NAME	ROW_NUMBER	VALUE
ITEM_ID	BRM_01	ROWNUM_1	BRM_PROD_01
ITEM_ID	COMMON	ROWNUM_1	COMMON_PROD_01
ITEM_ID	SEBL_01	ROWNUM_1	CRM_PROD_01
PRICELINE_ID	BRM_01	ROWNUM_2	BRM_PROD_01
PRICELINE_ID	COMMON	ROWNUM_2	COMMON_PRICE_ID1
PRICELINETYPE_ID	BRM_01	ROWNUM_3	BRM_PROD_01_EVENT1
PRICELINETYPE_ID	COMMON	ROWNUM_3	COMMON_PRICETYPE_ID1
SIEBELPRODUCTEVENTXREF	LINEPRICETYPECODE	ROWNUM_4	COMMON_PRICETYPE_ID1
SIEBELPRODUCTEVENTXREF _ID	ITEM_ID_COMMON	ROWNUM_4	COMMON_PROD_01
PRICELINE_ID	ITEM_ID_COMMON	ROWNUM_2	COMMON_PROD_01
PRICELINE_ID	SEBL_01	ROWNUM_2	CRM_PRICE_01

Example of Complex Product Synchronization

In the following example, a complex product is being synchronized from BRM to Siebel CRM.

1. Create a complex product in BRM to be synchronized to Siebel CRM, as shown in Figure A-4.

   Figure A-4 Creating a Complex Product in BRM

   
   Description of "Figure A-4 Creating a Complex Product in BRM"
   
   

2. Verify the synchronized records in Siebel CRM, as shown in Figure A-5.

   Figure A-5 Synchronized Complex Product Records in Siebel CRM

   
   Description of "Figure A-5 Synchronized Complex Product Records in Siebel CRM"
   
   

3. Verify the data entered into the XREF_DATA table is correct as shown in table Table A-11

Table A-11 Data in XREF_DATA Table for Synchronized Example Complex Product

XREF_TABLE_NAME	XREF_COLUMN_NAME	ROW_NUMBER	VALUE
ITEM_ID	BRM_01	ROWNUM_1	BRM_PROD_01
ITEM_ID	COMMON	ROWNUM_1	COMMON_PROD_01
ITEM_ID	SEBL_01	ROWNUM_1	CRM_PROD_01
PRICELINE_ID	COMMON	ROWNUM_2	BRM_PROD_01
PRICELINE_ID	BRM_01	ROWNUM_2	COMMON_PRICE_01
PRICELINETYPE_ID	COMMON	ROWNUM_3	COMMON_PRICETYP_01>
PRICELINETYPE_ID	BRM_01	ROWNUM_3	BRM_PROD_01_EVENT1
PRICELINETYPE_ID	BRM_01	ROWNUM_4	BRM_PROD_01_EVENT2
PRICELINETYPE_ID	COMMON	ROWNUM_4	COMMON_PRICETYPE_02
SIEBELPRODUCTEVENTXREF	LINEPRICETYPECODE	ROWNUM_4	COMMON_PRICETYPE_01
SIEBELPRODUCTEVENTXREF _ID	ITEM_ID_COMMON	ROWNUM_4	COMMON_PROD_01
ITEM_ID	COMMON	ROWNUM_5	COMMON_PRICETYPE_02
ITEM_ID	SEBL_01	ROWNUM_5	CRM_PROD_02
PRICELINE_ID	ITEM_ID _COMMON	ROWNUM_3	COMMON_PRICETYPE_01
PRICELINE_ID	SEBL_01	ROWNUM_3	CRM_ITEM_PRICE_01
PRICELINETYPE_ID	ITEM_ID _COMMON	ROWNUM_4	COMMON_PRICETYPE_02
PRICELINETYPE_ID	SEBL_01	ROWNUM_4	CRM_ITEM_PRICE_02

Figure A-6 shows a high-level overview of how the mappings are maintained in the cross-reference table.

Figure A-6 Maintaining Mappings in the Cross-Reference Table

Description of "Figure A-6 Maintaining Mappings in the Cross-Reference Table"

Discount Synchronization Flow

Figure A-7 illustrates the events that occur for the discount synchronization flow.

Figure A-7 Discount Synchronization Flow

1. Before the SyncDiscountBRMCommsReqABCSImpl service makes the call to the SyncItemCompositionListSiebelCommsprovABCSImpl service, the entries listed in Table A-12 are made in the XREF_DATA table.

   Table A-12 XREF_DATA

   XREF_TABLE_NAME	VALUE
   ITEM_ITEMID	COMMON GUID
   ITEM_ITEMID	POID Of BRM Product

   
   

2. During the response from Siebel CRM to the SyncItemCompositionListSiebelCommsProvABCSImpl service, the entry listed in Table A-13 is made in the XREF_DATA table.

   Table A-13 XREF_DATA

   XREF_TABLE_NAME	VALUE
   ITEM_ITEMID	Siebel CRM PRODUCTID

   
   

Example of Discount Synchronization

In this example, a discount is being synchronized from BRM to Siebel CRM.

1. Create a discount in BRM to be synchronized to Siebel CRM, as shown in Figure A-8.

   Figure A-8 Creating a Discount in BRM

   
   Description of "Figure A-8 Creating a Discount in BRM"
   
   

2. Verify the synchronized records in Siebel CRM, as shown in Figure A-9.

   Figure A-9 Synchronized Example Discount Records in Siebel CRM

   
   Description of "Figure A-9 Synchronized Example Discount Records in Siebel CRM"
   
   

3. Verify the data entered into the XREF_DATA table is correct as shown in Table A-14.

   Table A-14 Data in XREF_DATA Table for Synchronized Example Discount

   XREF_TABLE_NAME	XREF_COLUMN_NAME	ROW_NUMBER	VALUE
   ITEM_ID	BRM_01	ROWNUM_1	BRM_PROD_01
   ITEM_ID	COMMON	ROWNUM_1	COMMON_PROD_01
   ITEM_ID	SEBL_01	ROWNUM_1	CRM_PROD_01

   
   

   Table A-15 shows an example of the values for the cross-reference data in the ITEM_ID entry.

   Table A-15 Example of Discount Cross-Reference Values

   XREF_TABLE_NAME	XREF_COLUMN_NAME	ROW_NUMBER	VALUE
   ITEM_ID	BRM_01	2E60E99F02D11DCBFCA/F1F293F06D61	0.0.0.1 /discount 60048 0
   ITEM_ID	COMMON	2E60E99F02D11DCBFCA/F1F293F06D61	2d313734373134383431383534303233
   ITEM_ID	SEBL_01	2E60E99F02D11DCBFCA/F1F293F06D61	88-26YR5