AddToPromotion : Selecting The Promotion Failing At Step 'Filter Prom Related Asset List' (Doc ID 1953642.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel eConfigurator - Version 8.1.1.8 SIA [23012] and later
Information in this document applies to any platform.

Symptoms

Customer faces below error when trying to add promotion by clicking AddToPromotion option:
[1] Error invoking service 'ISS Promotion Management Service', method 'FilterListByActiveDoc' at step 'Filter Prom Related Asset List'.(SBL-BPR-00162)
[2] An end of file error has occurred.

When checked the logs we found a query on s_asset based on position with no where clause respected to asset/account.

Repro Steps:

  1. Create a promotion with 2 possible components product1 and product2 
  2. Login with sadmin which has 2 different positions 
  3. Create promotion with product 1 and create an appropriate asset 
  4. Create product2 as a separate asset
  5. Now change sadmin's position and drilldown into account 
  6. Under Account Summary right-click on product 2 and select Add to Promotion 
  7. A pickapplet is shown with upper promotion as candidate 
  8. Select the promotion
  9. Error

ObjMgrLog Error 1 00000581537a078d:0 2014-05-20 05:52:47 (stepexec.cpp (1573)) SBL-BPR-00162: Error invoking service 'ISS Promotion Management Service', method 'FilterListByActiveDoc' at step 'Filter Prom Related Asset List'.
PrcExec PropSet 4 00000581537a078d:0 2014-05-20 05:52:47 Error invoking service 'ISS Promotion Management Service', method 'FilterListByActiveDoc' at step 'Filter Prom Related Asset List'.(SBL-BPR-00162)
--
No records exist for the current query.(SBL-DAT-00468)
StpExec End 4 00000581537a078d:0 2014-05-20 05:52:47 Stopping step instance of 'Filter Prom Related Asset List' with an 'Error' status.

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms