CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Sec query

edited Jul 31, 2026 7:30PM in CNC, DB and Operating System - JDE1 (MOSC) Question

Hi,

We are working on a security issue,the debug log shows a query on the CRPDTA.F0006 table:

SELECT  *  FROM CRPDTA.F0006  WHERE  ( MCMCU = '        2901' )  AND  ( MCMCU NOT BETWEEN '          01' AND '          27' AND MCMCU NOT BETWEEN '          30' AND '          99' AND MCMCU NOT BETWEEN '        0101' AND '        2989' AND MCMCU NOT BETWEEN '        3001' AND '        9999' AND MCMCU NOT BETWEEN '       01000' AND '       28999' AND MCMCU NOT BETWEEN '       0101T' AND '       2899T' AND MCMCU NOT BETWEEN '

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