My Oracle Support Banner

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

Last updated on JULY 15, 2023

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)
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.


*** ***

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 a Order.
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.

 

Changes

 

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
Changes
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.