Cannot Derive the Code Combination Id (CCID) For Order Type

(Doc ID 316592.1)

Last updated on SEPTEMBER 20, 2017

Applies to:

Oracle Order Management - Version 11.5.9 to [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):

Unable to get account for delivery detail id 10768

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.


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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms