UPGRADE R9 - Error When Create An Account Or A Contact

(Doc ID 1980745.1)

Last updated on AUGUST 30, 2016

Applies to:

Oracle Fusion Customer Center Cloud Service - Version 11.1.9.2.0 and later
Oracle Fusion Customer Center - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.9.2.0 version, Manage Accounts

After uopgrade
When attempting to create contacts
the following error occurs.

ERROR
-----------------------
ADF error


Note that there in a trigger on account with script
 This is the customer's script:
 .
======= .
 // The below block of code is to get the Primary Organization value of the
// signed in user from the User information table

 .
  def UserOrg
 def ResourceVO = newView('Resource')
 def vc = ResourceVO.createViewCriteria();
 def vcr = vc.createRow();
 vc.insertRow(vcr)
 def vci0 = vcr.ensureCriteriaItem('PartyName');
  println("Party");
 println(Organization?.PartyId);
 vci0.setOperator('=');
 vci0.setValue(PartyName);
 ResourceVO.appendViewCriteria(vc)
 ResourceVO.executeQuery();
 if(ResourceVO.first() != null)
 {
 def ResRow = ResourceVO.first()
 UserOrg = ResRow.getAttribute("PrimaryOrganization")
 }
  def NuviaOrg = 'Nuvia';
 println("Org");
 println(UserOrg);
 if (UserOrg != null || UserOrg != '')
 {
 //This block of code will execute when the Organization value begins with the
 value Nuvia and it will add the Classifications record for the particular
 Sales Account
 if (startsWith(UserOrg,NuviaOrg))
 {
  def UserPartyId = adf.util.getUserPartyId();
 def CodeAssignmentView = newView('CodeAssignment')
 if (CodeAssignmentView != null)
  {
 def Code = CodeAssignmentView.createRow()
 println("CreateRow")
  Code.setAttribute('CreatedByModule','ZCM')
  Code.setAttribute('OwnerTableName','HZ_PARTIES')
 Code.setAttribute('ClassCategory','CUSTOMER_WORLD')
 Code.setAttribute('ClassCode', 'Nuclear')
 Code.setAttribute('StartDateActive', today())
 Code.setAttribute('PrimaryFlag', 'Y')
 Code.setAttribute('OwnerTableId', PartyId)
 CodeAssignmentView.insertRow(Code)
 println("Nuclearinsert")
  }
 }
 //This block of code will execute when the Organization value does not begins
 with the value Nuvia and it will add the Classifications record for the
 particular Sales Account
  else
 {
 def UserPartyId = adf.util.getUserPartyId();
 def CodeAssignmentView = newView('CodeAssignment')
 if (CodeAssignmentView != null)
  {
 def Code = CodeAssignmentView.createRow()
 println("CreateRow")
 Code.setAttribute('CreatedByModule','ZCM')
 Code.setAttribute('OwnerTableName','HZ_PARTIES')
 Code.setAttribute('ClassCategory','CUSTOMER_WORLD')
 Code.setAttribute('ClassCode', 'Construction')
 Code.setAttribute('StartDateActive', today())
 Code.setAttribute('PrimaryFlag', 'Y')
 Code.setAttribute('OwnerTableId', PartyId)
 CodeAssignmentView.insertRow(Code)
 println("Constructioninsert")
  }
 }
 }
=======


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

1. Navigator\Customer
2. Click on Create Contact\ Creation Contact Page
3. Fill the fields = Fisrt Name, Last Name
4. Click on the loop "Customer", search a Customer and select one + OK
5. Select "Use Account Address"
6. Click on Save and Edit ==> 2 errors messages, please see the attached document.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Contacts

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms