CTO: Unable To Create Configuration Item (Star Item) As CTO_CONFIG_ITEM_PK Invalid Due to ORA-00904: "M"."IB_ITEM_TRACKING_LEVEL": invalid identifier

(Doc ID 2170348.1)

Last updated on AUGUST 15, 2016

Applies to:

Oracle Configure to Order - Version 12.2.4 and later
Information in this document applies to any platform.


On : 12.2.4 version, Transaction Entry

After upgrading from 11.5.10 to release 12.2.4 when attempting to configuration item it fails with an error

Create_And_Link_Item API failed for this model line'.

The issue can be reproduced at will with the following steps:
1. Log into Order management responsibility
2. Navigate to Sales orders, returns, Sales orders.
3. Create a Sales Order for ATO Model and select the options.
4.Book the Sales Order
5.Progress Order.

Expected functionality is - Configure item has to be created (Star tem) and Bill should be created for configure item. Also CTO cost roll-up should happen.
Current behavior - Configuration item is not created.


Missing Dependencies for IB tracking changes made in 12.2.5 code was causing the Invalid packages.


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