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.

Symptoms

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

ERROR
-----------------------
Create_And_Link_Item API failed for this model line'.

STEPS
-----------------------
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.

Changes

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

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