My Oracle Support Banner

Customer Form, Sites Issue: Customers Records Created in Release 12, Don't Have Same Value For LOCATION and SITE_USE_ID in HZ_CUST_SITE_USES (Doc ID 753765.1)

Last updated on OCTOBER 13, 2022

Applies to:

Oracle Receivables - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

Noticed that in release 12, when you create a customer and define a site for it, the values populated in HZ_CUST_SITE_USES.LOCATION and HZ_CUST_SITE_USES.SITE_USE_ID no longer match like they did in release 11.5.8.

Why do these fields no longer contain the same value?

Steps to Reproduce:
Responsibility: Receivables Manager
Navigation: Customers > Standard

Query an existing customer or create a new one, for example: My Name Org Number
Create a new Account Site for the customer

The following illustrates the internal representation of the created data:


NEXTVAL
----------
13549

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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