My Oracle Support Banner

After Patch 20740731, Create Customer Error-Column Site_Use_Code Must Have A Bill_To Purpose Entered (Doc ID 2016271.1)

Last updated on FEBRUARY 14, 2019

Applies to:

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


On : 12.2.4 version, Customers Module

Patch application for Business Purpose's -(Address usage) - error in new customer creation

When creating a new customer or new site, the Business Purpose > Purpose defaults to Bill To in R12.
But the default value needs to be blank, forcing the user to select the appropriate usage for the address.
Some customers, in few regions, do not have a Bill-To Site Usage and should be restricted from unknowingly creating one.
By leaving the purpose blank, the system requires the user to select a purpose in order to save save the new site.

As a resolution, you applied <Patch 20740731>, but after the patch application, you receive the following error:

No party site was found for ID 3562366

Steps to Reproduce:
New customer without initial business purpose assigned
a. Enter customer information
b. Click Save and Add Details
c. Error message “Column site_use_code must have a value” received (expected)
d. Select business purpose. On saving, you receive error “You cannot pass the account number because account number auto-generation is enabled.”
e. Press Save and Add Details again
f. Error message “No party site was found for ID 3562366” received
The error messages continue and you are not able to save the customer details.




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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