My Oracle Support Banner

COGS WORKFLOW FAILING DURING INTERFACE TRIP STOP - OECOGS/#SYNCH (Doc ID 1072959.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Order Management - Version 11.5.10.2 and later
Information in this document applies to any platform.
Concurrent Program: WSHINTERFACES - Interface Trip Stop - SRS

Symptoms

On : 11.5.10,
When attempting to submit the Interface Trip Stop - SRS program for the delivery, the following error occurs in the Interface Trip Stop - SRS log file.

ERROR
-----------------------
Error Message : ORA-20002: 3109: Attribute VALUE1 does not exist for activity xxxxxx in item OECOGS/#SYNCH.

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
Cost Of Goods Sold Account Generation Failed with error : ORA-20002: 3109: Attribute VALUE1 does not exist for activity xxxxxx in item OECOGS/#SYNCH.

l_account ==> 1069
Exiting WSH_SHIP_CONFIRM_ACTIONS.GET_ACCOUNT (03/05/2010 03:01:37 PM, .05 seconds)
RET_STATUS:E ACCOUNT_ID:1069
Unable to get account for delivery detail id 61104620

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Shipping->Interfaces->Run.
2. Select the program Interface Trip Stop - SRS.
3. Enter the delivery 8275414 and submit the program.

Changes

Applied custom code to instance that was not expected to touch COGS.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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