Interface Trip Stop Error No Data Found In Package Oe_order_pvt Procedure Lines. (Doc ID 464516.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Oracle Shipping Execution - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 17-MAR-2015***



Symptoms

Checked for relevance on 10-Sep-2013

When attempting to submit the Interface Trip Stop - SRS program, the following error occurs:

ERROR

error in split_line User-Defined Exception

error in Ship_Confirm_Line User-Defined Exception

error in handle_nonbulk_mode User-Defined Exception

ship_confirm_new UNEXPECTED ERROR : User-Defined Exception

LEAVING OE_MSG_PUB.COUNT_AND_GET 1

rollback to om_ship_confirm :

          After OE_Shipping_Integration_PUB.Ship_Confirm_New TIME: ==> 09/24/2007 12:29:14 PM

          l_return_status  ==> U

          NO. OF OE MESSAGES :1

no. of OE messages :1

          Calling program unit OE_MSG_PUB.GET

          ORA-01403: no data found in Package OE_Order_PVT Procedure Lines

Error msg: ORA-01403: no data found in Package OE_Order_PVT Procedure Lines

          ERROR

          Rollback to savepoint its_process_order_non_bulk

          No DCP Error

 

 

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