Unable To Set primary_per_type To 'Y' When Using Hz_party_site_v2pub.Update_party_site_use (Doc ID 1276931.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version: 11.5.10.2 and later   [Release: 11.5 and later ]
Information in this document applies to any platform.

Symptoms

Unable to set the primary_per_type = 'Y' using the TCA API apps.hz_party_site_v2pub.update_party_site_use.

The TCA API runs successfully but the record is set with primary_per_type = null.

There is no issue when updating primary_per_type from 'N' to 'Y'.

The issue only happens when updating primary_per_type from NULL to N OR from NULL to Y.

 


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