• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Data selection Not working

salik

Active Member
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
 

salik

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