ARCHIVE: Pick applet returning no records from smartscript
(Doc ID 486211.1)
Last updated on JULY 16, 2021
Applies to:Siebel SmartScript - Version 184.108.40.206  and later
z*OBSOLETE: Microsoft Windows 2000
Version: 220.127.116.11 
Database: Oracle 8.1.7
Application Server OS: Microsoft Windows 2000 Server
Database Server OS: Microsoft Windows 2000 Server
This document was previously published as Siebel SR 38-922093479.
We have a smartscript with a question that saves its answer to a business component with a picklist on it. We have specified a pick applet on the smartscript question.
Our problem is that the whenever we invoke the pick applet, the pick applet pops up with no records returned. If we manually query within the pick applet after the initial load, the correct set of records are returned. Furthermore, the SQL generated during the initial invoke of the pick applet returns the correct recordset in SQL*PLUS. The smartscript is positioning itself and saving the data correctly once we pick the answer. All that seems to be happening is that the pick applet is not rendering the a recordset on its initial load, which we obviously need it to do.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document