My Oracle Support Banner

MSCFDDSR When Selecting Supplier Name With More Than 100 Characters In Sourcing Rule From Error Occurs FRM-40831 VENDOR_NAME But Allows To Save And Continue (Doc ID 2525332.1)

Last updated on JANUARY 27, 2021

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.5 to 12.2.8 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, User Interface in All Instance

Users are on 12.2.5 and have applied VCP 12.2.5.2 patch 22493520 Mandatory 12.2.5 VCP Consolidated Patch 2 for R12.SCP_PF.C.Delta.6 and have also applied 12.2.5.2 cum #18 patch 28705883 (latest is #20) - sourcing rule form is version MSCFDDSR.fmb 120.26.12020000.9 - Users use JDE E1 Integration with ASCP

users are trying to input supplier name with a lot of Chinese characters in it into the ASCP sourcing rule form. However when they save it, it gets the following error

ERROR
-----------------------
FRM-40831: Truncation occurred: value too long for field vendor_name

In trying to find out more information on this it's believed Chinese characters take 4 bytes per character but not certain. In reviewing the Properties of the ASCP sourcing rule form MSCFDDSR.fmb in 12.2.5 Donovan it shows Max Length = 100. The old MRP sourcing rule form MRPFDDSR in same instance shows Max Length = 240

Users have created supplier names with Chinese characters in JDE and collected those data into ASCP. Data collected into msc_trading_partners. They are trying to create sourcing rule with that supplier name but it shows the error when saving although the save takes place and the users is allowed to continue

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Created Supplier name in JDE that will total more than 100 characters in ASCP
2. Collect JDE data
3. Input supplier/site and rest of data in ASCP sourcing rule form
4. Save and get the error

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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.