Creating an Item Instance with a Warranty from Either Order Management (OM) or Install Base (IB) Error: "OKC_CONTRACTS_UNEXP_ERROR SQLcode 100 SQLerrm ORA 01403 No Data Found"
Last updated on JANUARY 06, 2017
Applies to:Oracle Service Contracts - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Oracle Installed Base - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
When creating an Item on the Create Item page in Install Base, or attempting to process a shipping transaction for an Install Base (IB) trackable item from Order Management (OM), the following error is encountered on the screen or in the Transactions Error Processing form:
Steps to Reproduce:
In both cases the Item must have a Warranty attached to it in the Bill of Materials (BOM).
1. Manually creating an item in Install Base.
a. Create an inventory item
b. Create a bom for this inventory item such that there are inactive warranty component lines.
c. Create an item instance from IB pages for this item.
d. An error is thrown with the following error OKC_CONTRACTS_UNEXP_ERROR
2. Shipping an Item from a Sales Order.
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