Distribution - JDE1 (MOSC)

MOSC Banner

UDC values with leading zeros fail to validate during R4101Z1I Item Upload

edited Jan 2, 2020 4:04AM in Distribution - JDE1 (MOSC) 4 commentsAnswered

Hi,

Whilst processing some item uploads via P4101Z1 and R4101Z1I, I noticed that I was getting failures due to the failed validation of some UDC values.

Example:

Cat Code SRP1 - UDC 41/S1 has values:

001

010

100

In P4101Z1, I add three items for upload:

Item A has SRP1 = 001

Item B has SRP1 = 010

Item C has SRP1 = 100

When running R4101Z1I, Items A and B will fail, but Item C will work.

Checking the log, I see that the leading zeros are being dropped for validation which results in the failure:

Item A:

  SELECT  *  FROM CRPCTL.F0005  WHERE  ( DRSY = '41' AND DRRT = 'S1' AND DRKY = '      1' )

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