Interface Trip Stop Ends In Warning And Log Shows Error(s) Occured In Oracle Pricing (Doc ID 2461448.1)

Last updated on DECEMBER 04, 2019

Applies to:

Symptoms

When attempting to run the interface trip stop
the following error occurs.

ERROR
The Interface Trip Stop log file shows:

WSHINTERFACES module: Interface Trip Stop - SRS
---------------------------------------------------------------
...
Exception Price Request GRP:
Exception Price Request: User-Defined Exception
LEAVING OE_MSG_PUB.ADD
EXITING PRICE_LINE WITH EXC ERROR
Setting prcing error flag for mass change
Exiting oe_order_Adj_pvt.Price_line
...
ship_confirm_new EXC 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: ==> 10/02/2018 06:33:53 PM
  l_return_status ==> E
  NO. OF OE MESSAGES :1
no. of OE messages :1
  Calling program unit OE_MSG_PUB.GET
  Error(s) occured in Oracle Pricing:
Error msg: Error(s) occured in Oracle Pricing:

STEPS
The issue can be reproduced at will with the following steps:
1. Run interface trip stop
  P_MODE ==> ALL
  P_STOP_ID ==> 89443
  P_DELIVERY_ID ==> 2812
  P_LOG_LEVEL ==> 1
  p_organization_id ==> XXXXX

Cause

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