Order Import Fails Without an Error Message When Importing Return Orders When 'Customer Order Enabled' Flag at Master Items Setup Is Unchecked (Doc ID 3035349.1)

Last updated on JULY 16, 2024

Applies to:

Symptoms

One is trying to import a return (RMA) order with valid and invalid part numbers.
For example, for an order with two lines, one line item is customer order enabled and the other line item is not. So the order failed in order import as expected.

But the invalid part(s) (no customer orderable flag enabled at master item form) are supposed to have an error message.
This error message alerts the order admin, which will need to manually remove those lines from the RMA's before import.
No error message was generated and after a manual review of each part number, parts were determined as to which had to be removed.
It results in a considerable delay in processing the sales order as one needs to manually scan through each order line status to determine which line item causes the order to fail.
The standard order has 50+ lines. This was working fine in before in 12.2.3 instance, whereas an error message was presented in the correction screen.

The issue can be reproduced at will with the following steps:
1. Insert records into the OM Interface tables
2. Select responsibility: Order Management Super User (or equivalent)
3. Navigate to: Orders, Returns > Import Orders > Order Import Request
   - Select your Order Source from the LOV in the parameters form.
   - Submit the concurrent request.

Changes

 Recently upgraded Oracle Applications to Release 12.2.11 from 12.2.3.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.