OEOIMP: Order Import Fails to Import Cancelled/Closed Orders with Header Level Global Attributes populated (Doc ID 2213152.1)

Last updated on JULY 16, 2017

Applies to:

Oracle Order Management - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Transaction Entry

When attempting to use Order Import to import Cancelled/Closed orders , with valid Header Level Global Attributes
the following error occurs.

ERROR
-----------------------
FLEXFIELDS SERVER-SIDE VALIDATION package reports error:

validate_desccols() exception: ORA-20005: DVLB.get_default_context() failed. SQLERRM: ORA-01403: no data found
ORA-06512: at "APPS.FND_FLEX_DESCVAL", line 1050
ORA-01403: no data found


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate the Order Import Interface tables with Cancelled/Closed Orders with Header Level Global Attributes

2. Run Order Import


Changes

 

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