Order Creation Fails with:- ORA-06510: PL/SQL: unhandled user-defined exception -- ORA-06512: at "FUSION.DOO_LINE_SECURITY" (Doc ID 1470074.1)

Last updated on MAY 10, 2017

Applies to:

Oracle Fusion Distributed Order Orchestration - Version 11.1.8.0.0 and later
Oracle Fusion Order Management Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.
***KM Review - Dec 2016 - Checked for Relevance***

Symptoms

We are unable to create an order in Order Management, Order Creation fails with:

env:ServerThe creation of an orchestration order failed due to a system error.: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "FUSION.DOO_LINE_SECURITY", line 350
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "FUSION.DOO_LINE_SECURITY", line 260
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at line 1

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