Upgrade Promotion Gives Error For Assets Containing Inactive Promotional Assets, SBL-BPR-00162, SBL-BPR-00183 (Doc ID 508711.1)

Last updated on DECEMBER 15, 2016

Applies to:

Siebel eConfigurator - Version 7.8.2.3 SIA [19221] to 8.1.1.6 SIA [21233] [Release V7 to V8]
Oracle Solaris on SPARC (64-bit)
**Checked for relevance on 15-Dec-2016**

Product Release: V7 (Enterprise)
Version: 7.8.2.3 [19221] Com/Med
Database: Oracle 10.1.0.2
Application Server OS: Sun Solaris 9
Database Server OS: Sun Solaris 9

This document was previously published as Siebel SR 38-3525786661.


***Checked for relevance on 30-Jun-2015***

Symptoms

The customer found that if assets for a promotion are disconnected, and then the promotion is upgraded, the workflow ISS Promotion Upgrade Process will fail because it tries to process the asset that was disconnected. The following error occurs:

[1] Error running sub-process ISS Promotion Disconnect Process at step Disconnect Old Promotion. (SBL-BPR-00183)
[2] Error invoking service SIS OM PMT Service, method Iterate Process For Selected Rows at step Edit Related Item.(SBL-BPR-00162)
[3] An end of file error has occurred.

This can be reproduced against the Sample database as follows:

1. Create 3 products, Test 1, Test 2, Test 3.
2. Create Product promotion Promo Test 1 with products Test 1 and Test 2.
3. Create Product promotion Promo Test 2 with products Test 1 and Test 2 and Test 3. Set Promo Test 1 as an upgrade option.
4. Create order for Parker Heathcare System.
5. Add Promo Test 1. Set order to submitted. Set all lines to have status completed.
6. Click Auto-Asset button for each line item.
7. Navigate to account view and can see 3 installed assets, Promo Test 1, Test 1, Test 2.
8. Select Test 1 and click Disconnect. This creates a quote.
9. Process this through to an order, completed it and click Auto-Asset.
10. Navigate to the account view and now Test 1 has disappeared from the installed asset list.
11. Select the asset record for the promotion and select the Upgrade Promotion menu option.
12. Select Promo Test 2.
13. The following error appears:

[1] Error running sub-process ISS Promotion Disconnect Process at step Disconnect Old Promotion. (SBL-BPR-00183)
[2] Error invoking service SIS OM PMT Service, method Iterate Process For Selected Rows at step Edit Related Item.(SBL-BPR-00162)
[3] An end of file error has occurred.

The workflow ISS Promotion Upgrade Process has the step Load Related Assets. This calls the business service ISS Promotion Management Service, method LoadPromRelatedAssets, and this returns all assets rather than only the active assets.

 

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