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.
On : 12.2.5 version, User Interface in All Instance
Users are on 12.2.5 and have applied VCP 18.104.22.168 patch 22493520 Mandatory 12.2.5 VCP Consolidated Patch 2 for R12.SCP_PF.C.Delta.6 and have also applied 22.214.171.124 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
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
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
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