My Oracle Support Banner

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.