My Oracle Support Banner

FA: SCM: OM: Order Cancellation Fails With: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.DOO_FLINE_SECURITY" (Doc ID 2835890.1)

Last updated on JANUARY 26, 2022

Applies to:

Oracle Fusion Order Management Cloud Service - Version 11.13.21.10.0 and later
Information in this document applies to any platform.

Symptoms

An error is raised when canceling a Sales Order:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.DOO_FLINE_SECURITY", line 1915 ORA-06512: at "FUSION.DOO_FLINE_SECURITY", line 1791 ORA-06512: at "FUSION.DOO_PC_CONSTRAINTS_ADMIN_PVT", line 2521 ORA-06512: at "FUSION.DOO_PC_CONSTRAINTS_ADMIN_PVT", line 2060 ORA-06512: at "FUSION.DOO_SOURCE_ATTRIBUTE_VAL", line 237 ORA-06512: at "FUSION.DOO_SOURCE_ATTRIBUTE_VAL", line 150 ORA-06512: at line 1 ORA-06512: at "FUSION.DOO_PC_CONSTRAINTS_ADMIN_PVT", line 1953 ORA-06512: at "FUSION.DOO_PC_CONSTRAINTS_ADMIN_PVT", line 2447 ORA-06512: at "FUSION.DOO_FLINE_SECURITY", line 1682 ORA-06512: at "FUSION.DOO_FLINE_SECURITY", line 1867 ORA-06512: at line 1

 

The issue can be reproduced at will with the following steps:
1) Log into Fusion Order Management.
2) Search for the sales order.
3) Navigate to Actions->Create Revision.
4) Select the line to be canceled.
5) Click the drop down menu at the end of the line.
6) Select "Cancel Line".
7) Select the cancellation reason and enter comments.
8) Click on Submit.

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.