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

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

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