COGS WORKFLOW FAILING DURING INTERFACE TRIP STOP - 'OECOGS/#SYNCH'
Last updated on JANUARY 31, 2018
Applies to:Oracle Order Management - Version 18.104.22.168 and later
Information in this document applies to any platform.
Concurrent Program: WSHINTERFACES - Interface Trip Stop - SRS
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 Message : ORA-20002: 3109: Attribute 'VALUE1' does not exist for activity '186394' in item 'OECOGS/#SYNCH'.
Exiting OE_Flex_Cogs_Pub.Start_process : E
NO. OF OE MESSAGES :1
RETURN STATUS FROM OE_FLEX_COGS_PUB.START_PROCESS IS E
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)
Unable to get account for delivery detail id 61104620
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.
Applied custom code to instance that was not expected to touch COGS.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms