Interface Trip Stop Errors with Cost Of Goods Sold Account Generation Failed with Error : Value secured (Doc ID 304189.1)

Last updated on MAY 16, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.0 and later
Information in this document applies to any platform.
EXECUTABLE:WSHINTERFACE - Interface Trip Stop

Symptoms

Interface trip stop fails during inventory interface portion with the following error:

Error Message : Value secured: You can only post to Company value 200 (SMI) in the SM UK Operating Unit.
LEAVING OE_MSG_PUB.ADD
Exiting OE_Flex_Cogs_Pub.Start_process : E
User-Defined Exception:80
NO. OF OE MESSAGES :1
RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
CONCAT_SEGS IS <concatenated DFF segments for COGS account>
CONCAT_IDS IS
CONCAT_DESCRS IS
L_CONGS_RETURN_CCID IS 0
Cost Of Goods Sold Account Generation Failed with error : Value secured: You can only post to Company value 200 (SMI) in the SM UK Operating Unit.
l_account ==> 0
Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (04/06/2005 10:29:09 AM, .36 seconds)
RET_STATUS:E ACCOUNT_ID:0
Unable to get account for delivery detail id <problematic delivery details id>
Warning at line ==> <warning line number>
l_delivery_detail_tbl.count ==> 0
l_opm_delivery_detail_tbl.count ==> 0
FND_API.G_EXC_ERROR exception has occurred.
Exiting WSH_SHIP_CONFIRM_ACTIONS.INTERFACE_DETAIL_TO_INV - EXCEPTION:FND_API.G_EXC_ERROR (04/06/2005 10:29:09 AM, .54 seconds)
Interface_Detail_To_Inv l_inv_inter_status ==> E
Batch_id <batch_id> pass Inventory interface with errors ==>
Exiting WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP (04/06/2005 10:29:09 AM, .74 seconds)
INTERFACETRIPSTOP: RESULT OF INVENTORY INTERFACING BATCH_ID <batch id> = ERROR

Changes

Security rule is defined in the financials key flexfield.

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