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

Last updated on AUGUST 22, 2016

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 8275414, 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 '186394' 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 '186394' 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

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