Data selection Not working

[GauriP24]

Hi All,
I am new the BI Publisher and developed my first JDE/BIP report(not new to JDE).
The report is pretty straight forward works fine on fat client, produces XML output. I load that XML output in the rtf file to create template. The xml has data and the output pdf is fine too.
However on the web, the XML shows "No data selected" when ran for same shipment number as of fat client. I looked into the log and the data selection doesn't seem to take place.
The value i entered of Shipment number in the data selection is not taken, the data selection still shows is Shipment number = '9999999' instead of shipment number =12525.
The log doesn't say much apart from sql query.

SELECT SDKCOO, SDDOCO, SDDCTO, SDLNID, SDMCU, SDCO, SDAN8, SDSHAN, SDPDDJ, SDADDJ, SDIVD, SDVR01, SDITM, SDLITM, SDNXTR, SDLTTR, SDEMCU, SDSOQS, SDCRCD, SDSHPN, SDBCRC
FROM JDE_DEVELOPMENT.TESTDTA.F4211
WHERE ( ( SDMCU = ' 1300' AND SDSHPN = 99999999.000000 ) )
ORDER BY SDSHPN ASC,SDLITM ASC

I tried rebuilding the version thinking if the version specs were corrupt.
Any help is really appreciated.

Thanks,
Salik
JDE 9.1
Tool : 9.1.4.3

 

[GauriP24]

Never mind, created another object with same spec and its working... Not sure why that specific object refused to work on web.