Customer Form Issue: Discrepancy of Primary_Per_Type Flag between Party Site Uses and Customer Site Uses
Last updated on JULY 12, 2017
Applies to:Oracle Trading Community - Version 22.214.171.124 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
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