VerifyMembership When Executed As Background Process Causes Unconstrained Query On S_ORDER_ITEM
Last updated on MARCH 02, 2017
Applies to:Siebel CRM - Version 220.127.116.11.10 [IP2013] and later
Information in this document applies to any platform.
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.
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."
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