My Oracle Support Banner

Material Requirement Part Request On Depot WIP Job Fails When Item Description Is Too Long (Doc ID 1992475.1)

Last updated on NOVEMBER 25, 2020

Applies to:

Oracle Depot Repair - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Logistics Management

When Request Parts In Execute Repair, if an item with a shorter description, part request is successful and creates a purchase requisition.
For items with a long description (around 219 to 239 characters), part request fails with error message:

"oracle.apps.fnd.framework.OAException: java.sql.SQLException: Inserted value too large for column: "<ITEM_DESCRIPTION_OVER_220_CHARACTERS>"

The issue can be reproduced at will with the following steps:
1. Depot Repair responsibility,
2. Depot Workbench;
3. Create SR/SO/Receive RMA/WIP Job;
4. Add rows of material requirements; for test used one with a short part description, and one with a long description.
5. The one with the long description fails with java exception 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

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