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 11.5.10.3 [Release 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 22-OCT-2013***

Symptoms

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

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

Changes

Modified the seeded COGS workflow as noted above.

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