My Oracle Support Banner

Workflow SIS OM Suspend / Resume Products & Services Process Queries with Position Id (Doc ID 2444007.1)

Last updated on SEPTEMBER 30, 2018

Applies to:

Siebel CRM - Version 15.18 [IP2015] and later
Information in this document applies to any platform.

Symptoms

The Workflow "SIS OM Suspend / Resume Products & Services Process" at step "Suspend/ Resume Related Item" invokes the BS "SIS OM PMT Service" method "Iterate Process For Selected Rows".

One of the inputs to the step is ViewMode = 3.

However, while performing Suspend of a promotion asset , the query uses Position Id as visibility filter and not the ViewMode = 3.



STEPS
-----------------------
1) Create a Promotion with below products 

Mur_Prom1 
|_ Mur_Root1 default cardinality = 1 
|_Mur_Root2 default cardinality = 1 

2) Create a residential account Mur_acount1 

3) Create a sales order and in the line items Select Mur_Prom1 

4)Complete the line items and asset them 

5) Select the Promotion asset and click on Suspend from Account summary view 

6) New Order gets created. Check the logs details, it shows the vis

Log Entries 
============== 


SELECT /*+ ALL_ROWS */ 
      T14.CONFLICT_ID, 
      T14.LAST_UPD, 
      T14.CREATED, 
      T14.LAST_UPD_BY, 
      T14.CREATED_BY, 
      T14.MODIFICATION_NUM, 
      T14.ROW_ID, 
      T14.ASSET_VAL_CURCY_CD, 
      T14.DESC_TEXT, 
      T14.ASSET_NUM, 
      T14.ASSET_VAL_EXCH_DT, 
      T9.NAME, 
      T14.BILL_ACCNT_ID, 
      T1.ONL_PAGESET_ID, 
      T14.CFG_STATE_CD, 
      T14.CFG_TYPE_CD, 
      T8.CMPND_PROD_NUM, 
      T14.COST_LST_ID, 
      T14.EXTD_QTY, 
      T14.INTEGRATION_ID, 
      T14.ASSET_MEM_INTEG_ID, 
      T14.PR_ACCNT_ID, 
      T14.OWNER_ACCNT_ID, 
      T14.OWNER_CON_ID, 
      T14.OWNERSHIP_TYPE_CD, 
      T14.PAR_ASSET_ID, 
      T14.PR_CON_ID, 
      T14.PR_EMP_ID, 
      T14.BU_ID, 
      T14.PR_POSTN_ID, 
      T14.PORT_VALID_PROD_ID, 
      T14.PROM_INTEG_ID, 
      T1.PROD_TYPE_CD, 
      T1.DESC_TEXT, 
      T14.PROD_ID, 
      T1.NAME, 
      T14.ASSEMBLY_PORT_ID, 
      T7.NAME, 
      T1.PR_PROD_LN_ID, 
      T1.SERIALIZED_FLG, 
      T1.PROD_CD, 
      T14.XA_CLASS_ID, 
      T14.PROM_GROUP_ID, 
      T14.PROM_GROUP_ITEM_ID, 
      T1.PROMO_TYPE_CD, 
      T14.QTY, 
      T14.REGISTERED_DT, 
      T14.ROOT_ASSET_ID, 
      T11.CFG_TYPE_CD, 
      T11.INTEGRATION_ID, 
      T3.PROD_TYPE_CD, 
      T11.PROD_ID, 
      T14.SERIAL_NUM, 
      T4.NAME, 
      T14.SERV_ACCT_ID, 
      T14.SP_NUM, 
      T14.STATUS_CD, 
      T14.VERSION, 
      T10.PAR_BU_ID, 
      T8.ROW_ID, 
      T8.PAR_ROW_ID, 
      T8.MODIFICATION_NUM, 
      T8.CREATED_BY, 
      T8.LAST_UPD_BY, 
      T8.CREATED, 
      T8.LAST_UPD, 
      T8.CONFLICT_ID, 
      T8.PAR_ROW_ID, 
      T5.ROW_ID, 
      T12.ROW_ID, 
      :1 
   FROM 
       SIEBEL.S_PROD_INT T1, 
       SIEBEL.S_PARTY T2, 
       SIEBEL.S_PROD_INT T3, 
       SIEBEL.S_ORG_EXT T4, 
       SIEBEL.S_ASSET_BU T5, 
       SIEBEL.S_ORG_EXT T6, 
       SIEBEL.S_PROD_LN T7, 
       SIEBEL.S_ASSET_OM T8, 
       SIEBEL.S_ORG_EXT T9, 
       SIEBEL.S_ORG_EXT T10, 
       SIEBEL.S_ASSET T11, 
       SIEBEL.S_PARTY T12, 
       SIEBEL.S_ASSET_POSTN T13, 
       SIEBEL.S_ASSET T14 
   WHERE 
      T14.BILL_ACCNT_ID = T9.PAR_ROW_ID (+) AND 
      T14.OWNER_ACCNT_ID = T6.ROW_ID AND 
      T14.ROOT_ASSET_ID = T11.ROW_ID (+) AND 
      T11.PROD_ID = T3.ROW_ID (+) AND 
      T14.PROD_ID = T1.ROW_ID (+) AND 
      T1.PR_PROD_LN_ID = T7.ROW_ID (+) AND 
      T14.SERV_ACCT_ID = T4.PAR_ROW_ID (+) AND 
      T14.ROW_ID = T8.PAR_ROW_ID (+) AND 
      T13.POSITION_ID = :2 AND ------------------------------- Checks the Position Id. 

T14.ROW_ID = T13.ASSET_ID AND 

      T2.ROW_ID = T13.POSITION_ID AND 
      T14.BU_ID = T5.BU_ID (+) AND T14.ROW_ID = T5.ASSET_ID (+) AND 
      T5.BU_ID = T12.ROW_ID (+) AND 
      T5.BU_ID = T10.PAR_ROW_ID (+) AND 
      (T6.MASTER_OU_ID = :3) 
   ORDER BY 
      T14.REGISTERED_DT 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.