My Oracle Support Banner

Need to Increase Size of ATTRIBUTE Columns in CSP_REQUIREMENT_HEADERS (Doc ID 2309434.1)

Last updated on MARCH 01, 2019

Applies to:

Oracle Spares Management - Version 12.1.3 and later
Oracle Field Service - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Need to increase the size of the ATTRIBUTE columns in CSP_REQUIREMENT_HEADERS table.

The current attribute column size is 150 characters.

Steps:

Enable Descriptive Flexfield:
. Appl = Spares Management
. Title = Spares Requirement Headers
. Segment = ATTRIBUTE2
. Value Set = XXXXXXXXXX

Parts Requirements form:
- Enter value in field "Packing/Shipping Instructions", which is a Descriptive FlexField segment mapped to column ATTRIBUTE2.

=> There issue while moving the 'Additional Information' value to the attribute column, specially when the data is in local languages as it is taking multi-bytes.
 
Expected Behavior:

Need to increase the size of the ATTRIBUTE columns in CSP_REQUIREMENT_HEADERS table.
The current Attributes column size is 150 characters which is less than other base tables. 

Changes

Modifying the column size in the environment is NOT recommended.
      i.e.:   alter table csp.csp_requirement_headers modify (attribute2 varchar2(2000));

This will cause a new issue, as the standard API CSP_PARTS_REQUIREMENT.Process_Requirement will fail with the below error message:

               ORA-06502: PL/SQL: numeric or value error:
               character string buffer too small.

There is a private package 'csp_requirement_headers_pvt' called in the CSP_PARTS_REQUIREMENT package.
This has the ATTRIBUTE2 size defined as 150.

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.