My Oracle Support Banner

E1: 43: DESCRIPTION LENGTH TOO SMALL FOR UNSPSC COMMODITY CODES (Doc ID 2389793.1)

Last updated on APRIL 23, 2018

Applies to:

JD Edwards EnterpriseOne Inventory Management - Version 9.1 and later
JD Edwards EnterpriseOne Procurement and Subcontract Management - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

In P40241 (Work With UNSPSC Commodity Codes), the description size is 40 (alias UNSPSCDS). Based on United Nation List (the authority who issue standard UNSPSC code), the Description length is up to 165 characters.

The requirement is to have 200 characters for UNSPSC Code Description Alias: UNSPSCDS. Same requirement for UNSPSC Code Alternate Description UNSPSCDS1.

Note: This field is also in P4101 Item Master -> Additional Info. Tab : Field: UNSPSC Code and Description.

STEPS TO REPRODUCE
1. Go to P40241 Work With UNSPSC Commodity Codes
2. Add a new record and try to populate a description with a length more than 40 characters. This is not possible, the field mask has a maximum of 40 chars only.

DESIRED OUTCOME
Increase the size of UNSPSCDS from 40 to 200 characters for UNSPSC Code Description UNSPSCDS. Same for UNSPSC Code Alternate Description UNSPSCDS1.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.