Incomplete Instance In 'Get Row Set' Step Output When Adding Product With Structure Type=None From Catalog (Doc ID 2939166.1)

Last updated on MAY 14, 2023

Applies to:

Symptoms

In a custom implementation where SPN (Smart Part Number) was calculated based on an algorithm using joined fields from the product ( e.g [Product Type] ), it was found that on first "Add Item" the SPN was correctly calculated, but on second "Add Item" the SPN was wrongly calculated.

On further investigation it was found that wrong calculation occurred because of the following:  When 'PSP Driver Workflow Process' workflow was executed during each "Add Item", the output of the ''Get Row Set''  step was  incomplete in the second "Add Item", some of the fields were empty.

Issue was reproduced in standard application using steps:

1. Create a product with Structure Type= None. Product should be based on a class with an attribute.
2. Create a price list in Administration pricing.
3. Add product "c" to the price list and set some prices. Refresh cache.
4. Navigate to Amdinistration Catalaog  and add  product "c" to a  public catalog and category. Refresh cache.
5. Navigate to Sales order and create new order. Associate to the order the price list created in step 2.
6. Drilldown on the order number , this navigates to "Sales Order-Browse Catalog View". Product "c" should be displayed in "Category products" applet.
7. Push 'Add Item' button once. After product is added in basket, push 'Add Item' again and wait to see 2 products in the basket.
8. Logout.
9. In the object manager log it can be seen that: 
   
   During each "Add Item",  'PSP Driver Workflow Process' workflow is executed.  The output of the "Get Row Set"  step is incomplete in the second "Add Item": "Product Type" is 'BEO Item'  during the first AddItem , then on the second AddItem is empty.
   
   

First "Add Item":

Issue was occurring only  for products with  Structure Type = None. If  'Structure Type'  is  'Customizable' , then the output of the ''Get Row Set'' step does not have empty fields, and consequently, SPN is calculated correctly.

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.