Last updated on SEPTEMBER 20, 2017
Applies to:Oracle Order Management - Version 11.5.9 to 18.104.22.168 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 22-OCT-2013***
Inventory Interface Fails with an error in OM Cost of Goods Sold (COGS):
The seeded OM Cost of Goods Sold (COGS) workflow was modified to change the default node from Get CCID for a line to Get CCID from the Order Type ID.
The Account Generator was modified to point to the new OM COGS workflow process. Account Generator Processes form: Setup > Financials > Flexfields > Key. Structure: Operations Accounting Flex. For the Item Type: OM: Generate Cost of Goods Sold Account, the Process Name must point to the new OM COGS Process.
The diagnostic script in <Note 220973.1> Cost of Goods Sold Account Setup displays the following error:
Error occurred ORA-01403: no data found while getting workflow process name and X_ERRMSG = Cost Of Goods Sold Account Generation Failed with error : Cannot derive the Code
Combination id for Order Type Id value 1005.
STEPS TO REPRODUCE
1. Modify the OM Cogs workflow as above.
2. Ship an order.
3. Inventory interface will fail: Unable to get account for delivery detail id 10768
Modified the seeded COGS workflow as noted above.
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