My Oracle Support Banner

Improper Referencing Of Service_Reference_line_id In Oe_order_lines_all Table During Order Import (Doc ID 1480081.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.
Not Able To Import Closed Service Lines To OM Via Order Import


On : 12.1.3 version, Transaction Entry

When attempting to Run the Order Import for a closed Order which has a Service associated, the following error occurs.

Validation failed for the field - Item Type

The issue can be reproduced at will with the following steps:
1.Enter an order manually in the sales order form with one order line and one service line attached to it.
2. Do all the Processing on the Order i.e. ship, fulfill and invoice and then close it.
3.Note down the order number and order_source_id ( from help < examine) for this order.
4.Now run following script as apps user in the sqlplus or toad or Sql developer.
declare l_return_status varchar2(1);
l_order_number_from number;
l_order_source_id number;
begin oe_debug_pub.debug_on;
oe_debug_pub.add('Before oe_inf_populate_pub call',1);
oe_inf_populate_pub.populate_interface ( p_api_version_number => 1.0 , x_return_status => l_return_status , p_order_number_from => &order_number_from , p_order_source_id => &order_source_id );
oe_debug_pub.add('Before oe_inf_populate_pub call',1);

Commit it.

5.This script will load data of this order into the Interface table.

6.Query this order in the order import corrections screen.

7.go to the lines and in other tab there is filed(hidden) org sys document reference , it will be same as order number (append this with XX)
8.Go to the header of this order and there also append org sys document reference with XX.
9. Check the closed_flag both at header and line.

You must populate the new service item line being imported with the following data in OE_LINES_IFACE_ALL :

ITEM_TYPE_CODE = 'SERVICE' (Hardcoded Literal)
SERVICE_REFERENCE_ORDER= <the ORIG_SYS_DOCUMENT_REF value of the sales order of the serviceable item>
SERVICE_REFERENCE_LINE= <the ORIG_SYS_LINE_REF value of the serviceable item line>

Save it.

10. run the Order Import program

The issue has the following business impact:
Due to this issue, users cannot import a closed order which has the service associated..


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.