My Oracle Support Banner

Invalid Value for the Column OKX_RESOURCES_V OKX_RESOURCE.ID1, ID2 (Doc ID 2588727.1)

Last updated on FEBRUARY 05, 2021

Applies to:

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

Symptoms

When attempting to add Vendor Contracts to a Service Contract, the following error occurs.

Error
Invalid Value for the column OKX_RESOURCES_V OKX_RESOURCE.ID1, ID2

Steps
Create or open a Service Contract.
Under Vendor Party attempt to add a new contact
Enter the contact Role and add a resource (must be a resource with both active and inactive records in OKX_RESOURCE_V to cause issue)
Attempt to Save changes, Error is received.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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