Material Requirement Part Request On Depot WIP Job Fails When Item Description Is Too Long
(Doc ID 1992475.1)
Last updated on MARCH 09, 2019
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