Vendor Reassignment Job Is Not Accepting The New Case Information Back From RDN (Doc ID 2696729.1)

Last updated on AUGUST 06, 2020

Applies to:

Symptoms

Vendor reassignment job is not accepting the new case information back from RDN

The error logs suggest the reason a new case is not created due to the comment "Null" error seen in error logs.

ERROR
-----------------------
ORA-01400: cannot insert NULL into ("COMMENTS"."ACM_COMMENT")

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

1. Run the SET-GRI1 --> AUTOMATIC CASE STATUS CHANGE Batch Job

2. Verify the accounts for vendor re-assignment and the comments 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, Vendor reassignment job is not accepting any new cases 

Changes

Cause

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