My Oracle Support Banner

ARCHIVE: Pick applet returning no records from smartscript (Doc ID 486211.1)

Last updated on JULY 16, 2021

Applies to:

Siebel SmartScript - Version 7.0.4.22 [14087] and later
z*OBSOLETE: Microsoft Windows 2000
Version: 7.0.4.22 [14087]

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.


Symptoms

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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.