My Oracle Support Banner

Unable To Receive from HTML Receiving Pages when Category Length is More than 80 (Doc ID 2701271.1)

Last updated on AUGUST 19, 2020

Applies to:

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

Symptoms

On : 12.2.8 version, Receiving Functions

Unable to receive against Purchase Orders whose line category length is more than 80 characters

ERROR
-----------------------
Value XYZ exceeds the maximum allowed value (VARCHAR (81,-127))

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
 
1) Inventory > Setup > Items > Categories > Category Codes
     Structure Name: PO Item Category
     Add Category whose length is greater than 80 characters

2) Inventory > Setup > Items > Categories > Category Sets
    Query for "Purchasing" Category Set
    Add  Category created above

3) Create PO with the category and Approve
         
4) Try to receive PO from HTML Receiving UI
     Inventory > Inbound >Receiving

 

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.