• 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!

Customer ledge inquiry not working after upgrade to 92 oracle from aS400

zackhu9

Member
We recently upgraded from 900 on as400 to 920 on oracle.Customer ledge inquiry does not work in the new version. I traced the sqlstatement to the following:
Notice the where clause has a double address book number and to make it worse, they are bound to different values. Hence, nothing is retrieved. I check the log for our 900 environment, it's only showing one address book in the where clause.
We are on tools release 9.2.2.4
Any guidance is appreciated.


SELECT RPSDCT,RPACR,RPCDS,RPVINV,RPFAP,RPNETTCID,RPJCL,RPVR01,RPCDSA,RPDIVJ,RPCTL,RPAAP,RPADSA,RPPST,RPAR10,RPOMOD,RPMCU,RPRMDS,RPRYIN,RPRF,RPPO,RPAR04,RPAG,RPDCT,RPDDJ,RPDDEX,RPPYID,RPAR05,RPDGJ,RPDRF,RPCO,RPSHPN,RPNETST,RPKCO,RPPWPG,RPADSC,RPAN8,RPDDNJ,RPAR03,RPAR09,RPSFX,RPSFXO,RPCRCD,RPISTR,RPPA8,RPPOST,RPODOC,RPGLC,RPCRR,RPRMK,RPNETDOC,RPNETRC5,RPSDOC,RPAR06,RPOKCO,RPOSFX,RPICU,RPPKCO,RPAR07,RPVDGJ,RPAR01,RPSMTJ,RPSKCO,RPPYR,RPDOC,RPAR08,RPDICJ,RPCRRM,RPBCRC,RPICUT,RPODCT,RPRMR1,RPURRF,RPPDCT,RPAR02,RPAID,RPKCOO FROM TESTDTA.F03B11 WHERE (((RPAN8 = ? AND RPAN8 = ? ))) ORDER BY RPAN8 ASC , RPDCT ASC , RPDOC ASC , RPKCO ASC , RPSFX ASC
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] SQL statement parameter marker values are :
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param1 : 1_Types.NUMERIC,
23 May 2018 11:53:22,471 [Line -1] [ Worker Thread - OWVirtual_Thread_Group9 Assigned To com.jdedwards.runtime.virtual.OWVirtual@63dfed31] [APP ] JDE - [JDBJ] Param2 : 11386316_Types.NUMERIC,
 
Top