Duplicate Item Was Created and New Item Is Now Active but the Contract Lines Are Still Referencing the Old Item (Doc ID 2301481.1)

Last updated on AUGUST 31, 2017

Applies to:

Oracle Service Contracts - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

Duplicate Item was created in Inventory. The new Item is now Active but the contract lines are still referencing the Old item which results in AutoInvoice program failing with this error message:

"This inventory item has Invoice Enabled flag set to No.  Please set the Invoice Enabled flag in the Items window to Yes for this inventory item. (99999999)"

Is there a data fix to update the OKS lines where inventory_item_id = <Old Item ID> and set the new inventory_item_id to <New Item ID> for all contract lines NOT terminated or Expired.

Solution

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