Sales Order has Incorrect Salespersons Causing Interface Trip Stop To Error With Cost Of Goods Sold Account Generation Failed with error : No CCID found for Sales Rep -3

(Doc ID 1342321.1)

Last updated on DECEMBER 18, 2017

Applies to:

Oracle Order Management - Version 11.5.9 to 12.2.5 [Release 11.5 to 12.2]
Oracle Shipping Execution - Version 11.5.9 to 12.2.5 [Release 11.5 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Oct-2014***
Shipping Transaction
Interface Trip Stop
ITS
COGS
Cost Of Goods Sold Account
Sales Rep Id
CCID

Symptoms

When attempting to run Interface Trip Stop, the following error occurs:


ERROR
-----------------------

Cost Of Goods Sold Account Generation Failed with error : No CCID found for Sales Rep Id -3
l_account ==> 0
Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (07/12/2011 05:10:28 PM, .26 seconds)
RET_STATUS:E ACCOUNT_ID:0
Unable to get account for delivery detail id XXXXX
x_return_status ==> W
Unable to get account for delivery detail id XXXX==>
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV (07/12/2011 05:10:28 PM, .34 seconds)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super User
2. Navigate: Run Interface Trip Stop >
3. See error in Interface Trip Stop log

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