My Oracle Support Banner

R12.1 OKEKAUWB OKE_CUSTOMER_CONTACTS_V RETURNS DOUBLE RECORDS FOR EACH ID (Doc ID 1936630.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

When entering the name for a contact role, the Contracts Organizer - Authoring Workbench gives an error - "Invalid value for the column Expenditure Item Date CONTACT.ID1, .ID2". User is unable to save the contact.

The navigation is: Contracts Organizer --> Authoring Workbench --> Parties and Contacts tab.

The data is NOT duplicated but the query that is used to build the OKE_CUSTOMER_CONTACTS_V returns double records for each ID. This behavior occurs for all the contact records that the view is expected to display.

The LOV also shows records with a ", " along with the actual contact name record.

The customer believes the OKE_CUSTOMER_CONTACTS_V is not fully qualifying the use of the HZ_RELATIONSHIPS table, which in R12 stores both "sides" of the relationship in separate records.
The trace file is attached. Based on the trace, the form is returning a message after the following query which does not return data:

SELECT 'x'
 FROM OKC_CONTACTS
WHERE CPL_ID = :B8
  AND CRO_CODE = :B7
  AND NVL (JTOT_OBJECT1_CODE, 'X') = NVL ( :B6, 'X')
  AND NVL (OBJECT1_ID1, 'X') = NVL ( :B5, 'X')
  AND NVL (OBJECT1_ID2, 'X') = NVL ( :B4, 'X')
  AND ID <> NVL ( :B3, -9999)
  AND ( ( ( :B2 BETWEEN TRUNC (START_DATE) AND TRUNC (END_DATE))
  OR ( (TRUNC (START_DATE) BETWEEN :B2 AND :B1)
  OR (TRUNC (END_DATE) BETWEEN :B2 AND :B1))
  OR ( :B1 BETWEEN TRUNC (START_DATE) AND TRUNC (END_DATE)))
  OR ( (END_DATE IS NULL AND ( :B1 = START_DATE))
  OR ( :B1 IS NULL AND ( :B2   OR ( :B1 IS NULL AND END_DATE IS NULL)))

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.