My Oracle Support Banner

Delete Records from Order Import Interface Tables for Document Reference = ORDIMP_<Number> (Doc ID 2787821.1)

Last updated on JUNE 28, 2021

Applies to:

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

Symptoms

On : 12.1.3 version

Corrections form - record not visible but in backend it is for document
reference - ORDIMP_<number>, Corrections forms show the
following Error Message.

OBSERVATION
--------------
Need script to delete records from these interface tables for this
specific referenced document <number>
 

ERROR
-----------
Error: FRM-40212: Invalid value for field ORIG_SYS_DOCUMENT_REF_LOV?

STEPS
-----------------------
1. Responsibility: Order Management Super User
2. Order > Import Order > Corrections
3. Popup Window:
    Operating Unit: <Number>
    Order Reference: ORDIMP_<number> > FIND
4. Observe:  Error: FRM-40212: Invalid value for field ORIG_SYS_DOCUMENT_REF_LOV


Changes

 Data corruption

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.