Need to Increase Size of ATTRIBUTE Columns in CSP_REQUIREMENT_HEADERS

(Doc ID 2309434.1)

Last updated on SEPTEMBER 20, 2017

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 which is very less when compared to other base tables.

Steps:

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

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 very less when compared to other base tables.
 
Business Impact:

This may impact transactions having 'Additional Information' field value with multi-language data involving special characters (i.e. Japanese).

The contents of ATTRIBUTE values in the CSP table might be receiving or transferring data to other module's table columns which are bigger in size.
(i.e. SHIPPING_INSTRUCTIONS column in OE_ORDER_HEADERS_ALL table - 2000 characters).

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms