'Error Saving Data Changes During Activity Processing' Message During CopyToSegmentField Transaction (Doc ID 2907450.1)

Last updated on NOVEMBER 07, 2022

Applies to:

Symptoms

On : 11.3.1.14 version, Activity

When a Transaction has both Multifields in the CopyToSegmentFields and a Segment loop contained within the Transaction.
the following message is reported when attempting to add/update the Fields:


ERROR
-----------------------
HTTP Status 500 - Internal Server Error

Error Message: com.adminserver.utl.exception.AsExceptionUtl: Error saving data changes during activity processing.

java.lang.RuntimeException: com.adminserver.utl.exception.AsExceptionUtl: Error saving data changes during activity processing.
at com.adminserver.pas.uip.aspects.UipExtensibilityAspect.extendUipMethod(UipExtensibilityAspect.java:65)
at com.adminserver.pas.uip.PolicyActivityUip.processProcessAction(PolicyActivityUip.java:1017)
at com.oracle.pas.page.PolicyActivityPage.processProcessAction(PolicyActivityPage.java:63)
at com.oracle.pas.service.delegate.PolicyActivityServiceDelegate.processPolicyActivity(PolicyActivityServiceDelegate.java:87)
at com.oracle.pas.service.PolicyActivityService.processActivity(PolicyActivityService.java:56)
at sun.reflect.GeneratedMethodAccessor2823.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)


Caused by: Error : 1, Position : 0, Sql = INSERT INTO AsSegmentMultiValueField ( SegmentGUID, FieldName, FieldIndex, FieldTypeCode, TextValue, OptionTextFlag, OptionText, CurrencyCode ) VALUES ( :1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 ) , OriginalSql = INSERT INTO AsSegmentMultiValueField ( SegmentGUID, FieldName, FieldIndex, FieldTypeCode, TextValue, OptionTextFlag, OptionText, CurrencyCode ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ? ) , Error Msg = ORA-00001: unique constraint (OIPA.PK_ASSEGMENTMULTIVALUEFIELD) violated

Cause

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