VerifyMembership When Executed As Background Process Causes Unconstrained Query On S_ORDER_ITEM (Doc ID 2014444.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11.10 [IP2013] and later
Information in this document applies to any platform.

Symptoms

When running 'VerifyMembership' method in the background. An additional unconstratined SQL statement is getting executed for S_ORDER_ITEM.

'VerifyMembership' method should yield the same results when run directly in the UI or in the background without additional SQL statements getting executed.

Reproduction Steps:
1) Set the System Preference "Enable Promotion Group" to Yes in the application.
2) Find a suitable Product Structure with Promotion Groups to test with.
3) Create a new Order and add the Product.

A) Test From UI -
   i. Hit 'Verify' on the Order Header and check the logs to see that VerifyMembership method was called with NO SQL statement on S_ORDER_ITEM

B) Test From Siebel Tools -
   i. Import the workflow "CRMT External Verify - Vanilla Test.xml".
      The Workflow simply invokes the Named Method on the Business Component = Order Entry - Orders, using:

      Business Service = SIA BC Utility Service
      Method = BCInvokeMethod

       Please note that the Default String assigned to ProcessProperty = Object Id needs to be changed to reflect the 'Order Header Id' in your environment for which you wish to invoke the Signal
       i.e. the Order that was used in the UI test above.

  ii. In Tools show the Simulate Toobar and start to simulate the Workflow "CRMT External Verify - Vanilla Test.xml"
 iii. Check the log and note that this time VerifyMembership method has an additional unconstrained  SQL statement on S_ORDER_ITEM



In the log you may also see the following error: "SBL-DAT-00500 There were more rows than could be returned. Please refine your query to bring back fewer rows."

 


 

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