ORA-06502 and ORA-06512 Error While Loading Orders Into DOO (Doc ID 2128093.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.8.0.0 to 11.1.9.2.0 [Release 1.0]
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance - Release 9 Specific***

Symptoms

While loading orders into DOO using the DOOTransformService web service, the process fails with an error. The following is seen in the response payload from InvokeOrderTransformation activity.

ORA-06502: PL/SQL: character to number conversion error ORA-06512: "FUSION.DOO_FLINE_SECURITY", line 1501 ORA-06512: line 1

There is an Extensible Flexfield (EFF) on the Fulfillment line that stores the description of an item. The EFF is defined as character (100 chars) and uses a format only value set.
The problem occurs when the order payload contains a comma (,) in the EFF attribute value. There is no error if the comma is removed.


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