Financial - JDE1 (MOSC)

MOSC Banner

R09616

edited May 27, 2018 10:05PM in Financial - JDE1 (MOSC) 4 commentsAnswered

Hi Experts

When we run R09616  the system is not doing the RECONCILIATION   through the log what we found is that the below query is not successful

SELECT GLKCO, GLDCT, GLDOC, GLDGJ, GLJELN, GLEXTL, GLICUT, GLCO, GLAID, GLMCU, GLLT, GLCRCD, GLAA, GLR1, GLR3, GLDKC, GLRCND, GLALT1, GLPYID, GLUSER, GLPID, GLJOBN, GLUPMJ, GLUPMT, GLBCRC, GLCRRM, GLTXA1, GLEXR1, GLACR, GLCKNU FROM ZMPYDTA.F0911  WHERE  ( GLAID = '06391628' AND GLRCND = ' ' AND GLLT = 'AA' AND GLR1 = '118/03-0' AND GLR1 > ' ' AND GLICUT = 'RB' ) 

In the above query the system is checking GLR1 = '118/03-0' However in f0911 the glr1 fields has the batch no as default.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center