Issue with 9.1 Web Server

JDE Trainee

Member
Hi All,

I am having an issue with the an application that works fine on local web but not on web server.

From P4210, to check the price details, row exit from P4210 is done, whereby the grid of P4074 is filled with pricing details.
P4074 is running fine on local web environment that is its grid is being populated with price details accordingly when the row exit is done.

However, when the same is done on web server, the grid of P4074 is not being populated.
Actually, B4200310 edit line calls many functions internally which finally call B4500090 to do an insert into F40UI74.
A customized NER has been created to retrieve OGID from F40943, after which other pricing values and OGID are being inserted in F40UI74.

In our case(on web Server) , the insert in F40UI74 is not being done because the NER to retrieve OGID is failing.
After further investigation, we found the select statement from F40943 is not being executed correctly.

The select on local web is being done as below:
SELECT * FROM TS_INTDTA.F40943 WHERE ( OKSDGR = 'VAGRONLY' AND OKSDV1 = 'xxx ' AND OKSDV2 = ' ' AND OKSDV3 = ' ' )

The select on web server is being done as below:

SELECT * FROM TS_INTDTA.F40943 WHERE ( OKSDGR = 'VAGRONLY' AND OKSDV1 = ' ' AND OKSDV2 = ' ' AND OKSDV3 = ' ' )

The SDV1 value is not being passed to the function on Web server although it is passed on local web.

Note: Same scenarios and test data have been used on both local and web server.

Can anyone advise or suggest why the SDVI value is not being passed to the function?

Thanks
 
Back
Top