My Oracle Support Banner

E1: FDA : Table I/O Handle on Alternate Environment Does Not Work With Interactive Application On Web Client (Doc ID 2354649.1)

Last updated on JULY 25, 2018

Applies to:

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


Open table handle does not work with an interactive application to fetch the records from alternate 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 submitted 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




To view full details, 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 a vibrant support community of peers and Oracle experts.