My Oracle Support Banner

Customer Form Issue: Discrepancy of Primary_Per_Type Flag between Party Site Uses and Customer Site Uses (Doc ID 1324486.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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


User manually entered a customer with customer has two party/customer sites, namely: PERM and LEGAL REP. LEGAL REP is the primary site.  

When checking the Primary Per Flag of the site use LEGAL REP, the Primary flag in HZ_CUST_ACCT_SITES_ALL is set as 'Y' and the BILL_TO_FLAG is set as 'Y'.  But the Primary_Per_Type flag is set as 'N' for the same customer site (LEGAL REP) in HZ_PARTY_SITE_USES.

The issue is that after entering the second site for a customer and set it as Primary site, the primary_per_type in HZ_PARTY_SITE_USES is set to 'N'.  It should have been set to 'Y'.

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Customers : Customers
-Enter a new customer
-Enter a bill-to site address and set it as Primary.
-Note that the primary_per_type = Y in HZ_PARTY_SITE_USES
-Inactivate this site.
-Enter a new bill-to site address and set it as Primary.
-Note that for both sites, primary_per_type = N in HZ_PARTY_SITE_USES:

party_site_id party_site_use_id primary_per_type status
------------- ----------------- ---------------- ------
88203         65108                              I
88204         65109             N                A
88205         65110             N                A 




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

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