Interface Trip Stop Completes With Error It Can't Derive Account For Delivery ID Get_Cost_Sale_Item_Derived (Doc ID 2133826.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms


Interface Trip Stop completes with error it can't derive account for delivery ID :

ERROR
-----------------------
Initilizing Workflow Item Attributes
Calling FND_ELEX_WORKFLOW.GENERATE from START_PROCESS
Entering OE_Flex_Cogs_Pub.GET_COST_SALE_ITEM_DERIVED
 Item Type : OECOGS
 Item Key : #SYNCH
 
Exiting from OE_Flex_COGS_Pub.Get_Cost_Sale_Item_Derived
Return CCID : 0
Concat Segments :
Concat Id :
Concat Descriptions :
Error Message :
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
  CONCAT_IDS IS
  CONCAT_DESCRS IS
  L_CONGS_RETURN_CCID IS 0
  Cost Of Goods Sold Account Generation Failed with error :




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Using the OM Super User Responsibility, navigate to Shipping> Interfaces> Interface Trip Stop.
2. Using the delivery or trip stop id, run the process.
3. Process fails with the errors.


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