My Oracle Support Banner

Encountered an Error - "You cannot update column location to NULL" on Clicking Details Button for the Newly Added Ship To Business Purpose for a Customer. (Doc ID 2746511.1)

Last updated on JANUARY 25, 2021

Applies to:

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

Symptoms

On clicking Details button for the newly added Ship To Business Purpose for a customer, the following error is encountered:


ERROR
-----------------------
You cannot update column location to NULL.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Receivables responsibility > Customers > Create/Maintain Customers
2) Query the customer name > create a new site address with purpose = Bill To and apply.
3) Click on + button and add a purpose = Ship To keeping column - 'Bill To Location' as blank.
4) Add Bill To Location in Ship To there after and click on Details button to provide other values
5) The above mentioned error is shown to the user.

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


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