Oracle Receivables - Version 11.5.10.2 to 12.2 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.
ARXCUDCI - Customer Form
SYMPTOMS
This note consolidated reported issues wherein the customer form, when you attempt to change customer address details, the following error occurs:
APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
CAUSE
Multiple
SOLUTION
Seq
Release
Symptom/Presentation
Cause
Fix
1
11.5
You navigate into the Customer Form, and you get the error:
APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
Setup
To implement the solution, please execute the following steps:
Responsibility: Receivables Responsibility. Navigation: Setup > System Options
Go to the Trans and Customers (TAB)
Check "Allow Change to Printed Transactions". In some cases the checkbox is already checked and yet the error is raised, it is suggested that you uncheck, save the changes, then re-check the checkbox to reset it.
Save and Retest the Issue
2
11.5
You want to define the Language for a customer record, when you query it up you get the error:
APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
This appears to happen for non-English customers, for example: Russian customer names.
Setup
Same as Seq#1 above.
3
11.5
Navigation within Customer Standard Form results in the below error. Clicking on the Open button to navigate to the Customer Addresses raises the following error: APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
Not all customer records raise this error.
Bug 6343319 DATAFIX - POST UPGRADE GETTING APP-AR-294464 QUERYING A CUSTOMER.
The error is due to trailing space in the some of the Address fields
The solution would be to trim the extra spaces from Address fields. Please log an SR to get the data correction script.
3
11.5
When changing Address Line1-4 for a customer, the following error is raised:
APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
Bug 8324406 UNABLE TO UPDATE ADDRESS LINE1 FOR NON-USA ADDRESSES
Changing Language of a Customer Address raises error:
Responsibility: Receivables Manager Navigation: Customer > Standard - Query the Customer - Go to Address Window - Go to Characteristic tab > Select Language and Save, the following error is raised:
APP-AR-294464: You cannot update this address. A Printed, posted, or applied transaction with an associated tax line exists for this address.
Bug 5531906 - 1OFF:5204029:AR.O:11510:ARXCUDCI -CAN NOT UPD THE CUST LANGUAGE ON SITE LEVEL
Bug 5065308 - CODFIX: ARXCUDCI -CAN NOT UPD THE CUST POSTAL CODE ON SITE LEVEL
Workarounds: 1. On-site fix: You can make the following changes to the .pls file
navigate to $AR_TOP/patch/115/sql/
Edit ARHADDRB.pls
Run a string search for:
l_location_rec.language := ar_miss_char;
Review the lines above the text you searched, it should look like:
IF NVL(p_location_rec.language,fnd_api.g_miss_char) <> NVL(l_location_rec.language,fnd_api.g_miss_char) THEN
loc_modified := 'Y';
addr_line_aloneupdt := 'N';
ELSE
l_location_rec.language := ar_miss_char;
END IF;
You need to change the line:
addr_line_aloneupdt := 'N';
to make it:
addr_line_aloneupdt := 'Y';
Save the file, apply the package to the database and re-test.
2. Temporary change to System Options setting
If you do not need to change the language for too many customers, or you don't need to change it often, and your current setting for Allow Change to Printed Transactions is unchecked, you can temporarily set it to checked to enable you to make changes to the customer record. Responsibility: Receivables Manager Navigation: Setup > System > System Options
Go to the Trans and Customers tab Check the checkbox "Allow Change to Printed Transactions" Save the change. Make necessary changes to the customer language in Customer Standard Form. Go back to System Options Form and uncheck the checkbox "Allow Change to Printed Transactions" Save the change.
The following notes have been set to Archived/Internal and merged into this note: -------------------------------------------------------------------------------------------------------------- 1279697.1 ARXCUDCI - Error APP-AR-294464 When Define Language For Customer Ship-To Address In Customers Form KDCOLLIN.US 1057441.1 ARXCUDCI - APP-AR-294464 WHEN SIMPLY NAVIGATING TO CUSTOMER ADDRESSES WINDOW KDCOLLIN.US 352983.1 APP-AR-294464 Changing a Customer Address Line in the Customer Form TJENNING.US 577721.1 APP-AR-294464: Error When Modify Language Option For Customer Bill-To Address KTOTA.US 1093005.1 Error Message APP-AR-294464 If Trying To Update Address Line 1-4 JACLI.US