SBL-DAT-00500 On view load

SBL-DAT-00500 error is displayed when Quote Item List View is opened. 

View has Quote Header Form Applet and Quote Line Item List Applet. Usually this will work most of the times, however when number of records is more than 10K 'Hirarchy Parent Field' property causes this error.


Solution 1: Clong Quote Item List Applet and disable hierarchy functionality by adding a user property :

Name: Disable Buscomp Hierarchy
Value : TRUE

Solution 2: Disable hierarchy functionality on quote item business component, by disabling

User property : 'Hierarchy Parent Field' from Business Component.

This would remove hierarchy from entire application.

This error is duly recorded in case of execution thread is a business service or workflow. However it confuses a bit when it happen just after view is accessed. 

https://support.oracle.com/knowledge/Siebel/524329_1.html




Hope this helps. 

What is Dynamic picklist in Siebel?

To answer this question let me explain you what is picklist in Siebel first.

What is a picklist in Siebel?

Picklist is a field is field with a drop down in Siebel. For example status field on order is a pick list field. User is allowed to pick values only from available list of values. These list of values are decided at the time of development of application. Any changes to the list needs change to be made by developer and needs to be tested.

Static PickList in Siebel

And mostly all drop down values are stored in S_LIST_OF_VAL table.

What is dynamic picklist in Siebel?

Dynamic picklist is a field in Siebel which can accept values from a ever changing dynamic list. For example price list field on order BC. This field will accept any price list from Pricelist BC. Some users are allowed to create new price list in Siebel without developer's help. As soon as price list is created in adminstration pricing screen that price list becomes available to pick on any order record.

Dynamic Pick List in Siebel

Another example of dynamic picklist could be agreement pick list on opportunity BC. Any available agreement can be selected by user in opportunity record, and this list of agreement keep growing as users keep on creating agreements.

Hope it clears the doubt. Feel free to ask any questions related to picklist in comments below.