E1: 76M: No Data Selected R76M411 - Error Definition Report (Doc ID 1948804.1)

Last updated on MARCH 21, 2016

Applies to:

JD Edwards EnterpriseOne Accounts Payable - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

On : 9.1 version, Localizations - LATAM - AP

No data selected when running R76M411 Assign Withholding Concept to Unpaid Vouchers report

This report has a wrong SQL defintion:
SELECT RPKCO, RPDOC, RPDCT, RPSFX, RPSFXE, RPDCTA, RPAN8, RPPYE, RPSNTO, RPDIVJ, RPDSVJ, RPDDJ, RPDDNJ, RPDGJ, RPFY, RPCTRY, RPPN, RPCO, RPICU, RPICUT, RPDICJ, RPBALJ,
 RPPST, RPAG, RPAAP, RPADSC, RPADSA, RPATXA, RPATXN, RPSTAM, RPTXA1, RPEXR1, RPCRRM, RPCRCD, RPCRR, RPACR, RPFAP, RPCDS, RPCDSA, RPCTXA, RPCTXN, RPCTAM, RPGLC, RPGLBA,
 RPPOST, RPAM, RPAID2, RPMCU, RPOBJ, RPSUB, RPSBLT, RPSBL, RPBAID, RPPTC, RPVOD, RPOKCO, RPODCT, RPODOC, RPOSFX, RPCRC, RPVINV, RPPKCO, RPPO, RPPDCT, RPLNID, RPSFXO,
RPOPSQ, RPVR01, RPUNIT, RPMCU2, RPRMK, RPRF, RPDRF, RPCTL, RPFNLP, RPU, RPUM, RPPYIN, RPTXA3, RPEXR3, RPRP1, RPRP2, RPRP3, RPAC07, RPTNN, RPDMCD, RPITM, RPHCRR, RPHDGJ,
 RPURC1, RPURDT, RPURAT, RPURAB, RPURRF, RPTORG, RPUSER, RPPID, RPUPMJ, RPUPMT, RPJOBN, RPTNST, RPYC01, RPYC02, RPYC03, RPYC04, RPYC05, RPYC06, RPYC07, RPYC08, RPYC09,
 RPYC10, RPDTXS, RPBCRC, RPATAD, RPCTAD, RPNRTA, RPFNRT, RPTAXP, RPPRGF, RPGFL5, RPGFL6, RPGAM1, RPGAM2, RPGEN4, RPGEN5, RPWTAD, RPWTAF, RPSMMF, RPPYWP, RPPWPG,
RPNETTCID, RPNETDOC, RPNETRC5, RPNETST, RPCNTRTID, RPCNTRTCD, RPWVID, RPBLSCD2, RPHARPER, RPHARSFX, RPDDRL, RPSEQN FROM TESTDTA/F0411
WHERE ( ( RPCO = '00006' AND RPPST = 'A' ) AND ( RPPST <> 'P' AND RPPST <> '#' AND RPDGJ >= 114001 AND RPDGJ
The sentences of the WHERE has a mistake : AND RPDGJ >= 114001 AND RPDGJ <= 0


ERROR given: No data selected




Cause

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 hundreds of Community platforms