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

Last updated on MARCH 08, 2017

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

Symptoms

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.

ERROR
-----------------------
Validation failed for the field - Item Type

STEPS
-----------------------
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.initialize;
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);
end;
---

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_TYPE_CODE= 'ORDER' (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

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

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