E1: BSFN : Table Handle doesn't Work With Interactive Application Over Web

(Doc ID 2354649.1)

Last updated on MAY 21, 2018

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


Open table handle doesn't work with an interactive application to fetch the records from a different environment (other than login environment) when application is running on HTML web client. But the same piece of code works fine from UBE when UBE is submitting to the server. Following error is captured on the web screen

Error : "ERROR null Button clicked Line number 8 PSMA10_WSMA10C"

Sample Code for Duplication :

// Fetch and Insert

VA frm_Environment_ENV = FC CMX
// Open Handle
VA frm_FSMA10_Handle_HFSMA10 = FSMA10.Open Handle
// Select All
FSMA10(VA frm_FSMA10_Handle_HFSMA10).Select All

FSMA10(VA rpt_FSMA10_Handle_HFSMA10).Fetch Next

While SV File_IO_Status is equal to CO SUCCESS


FSMA10(VA rpt_FSMA10_Handle_HFSMA10).Fetch Next

End While




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