My Oracle Support Banner

When Modify Some Customer Contact Status APP-AR-96282 : Error: The following SQL error occurred : ORA-01407: cannot update (AR.HZ_RELATIONSHIPS.START_DATE) to NULL (Doc ID 1446290.1)

Last updated on MAY 25, 2019

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On modifying customer status for some customer following error message is shown:-


APP-AR-96282 : Error: The following SQL error occurred :
ORA-01407: cannot update
(AR.HZ_RELATIONSHIPS.START_DATE) to NULL

 STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Re-produce steps
1. Login Customer Support window
2. Open Contact Center
3. query this customer contact ‘方星明’, open ‘Relationships’ Tab page, as below:
4. change the status into ‘Inactive’ from ‘Active’
5. save
6. show error

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.