My Oracle Support Banner

Create Hold Source Errors With FRM-40831: Truncation Occurred Value Too Long For Field HOLD_ENTITY_DESCRIPTION (Doc ID 2782060.1)

Last updated on JULY 20, 2021

Applies to:

Oracle Order Management - Version 12.2.8 and later
Information in this document applies to any platform.

Symptoms

ISSUE
-----------------------

Creating a hold source for import/export compliance at the order header level at booking activity and then when attempting to apply newly created hold raises the following errors:


ERROR
-----------------------

First Error when creating a hold source:

FRM-40831: Truncation occurred value too long for field HOLD_ENTITY_DESCRIPTION when they click apply hold button.

The text that user is attempting to input in the description is the following:

'SEMICONDUCTOR MANUFACTURING, XXXXXXXXXXXX CORPORATION,18 WEN'



2nd Error when applying hold:

APP-ONT-251445: An order header activity hold has been selected that is not compatible with the hold criteria.




STEPS
-----------------------

The issue can be reproduced at will with the following steps:

1. Order Management Super User Responsibility
2. Navigate: Orders, Returns > Order Organizer.
3. Tools (menu) > Create Hold Source
4. Enter Hold Name
5. Hold Criteria = Ship To Site
6. Enter a ship to site address in Criteria Value
7. Enter Operating Unit = XXX

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.