修改客户地址别名报错APP-AR-294464

问题:修改客户地址别名报错APP-AR-294464

处理:

  1. Navigation: Setup > System Options
  2. Go to the Trans and Customers (TAB)
  3. Check "Allow Change to Printed Transactions"
参考:https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=353921262706296&id=779034.1&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=12qe4m61cw_77

转到底部转到底部

In this Document

Symptoms
 Cause
 Solution
 References

APPLIES TO:

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:

  1. Responsibility: Receivables Responsibility.
    Navigation: Setup > System Options
  2. Go to the Trans and Customers (TAB)
  3. 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.
  4. 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

Fixed Files:

11i.AR.N: 
ARHADDRB.pls 115.32.15103.3

11i.AR.O:
 
ARHADDRB.pls     115.38.15104.7 
ARHADDRS.pls     115.13.15104.3 


Recommended Patches:
11i.AR.N:
 Patch 4992256
11i.AR.O: Patch 8324406

 

4 11.5

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

Fixed Files:
11i.AR.O:
 ARHADDRB.pls 115.38.15104.5

Recommended Patches:
11i.AR.O: 
Patch 5531906

Workarounds:
1. On-site fix
: You can make the following changes to the .pls file

  1. navigate to $AR_TOP/patch/115/sql/
  2. Edit ARHADDRB.pls
  3. Run a string search for:
    l_location_rec.language := ar_miss_char;
  4. 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;
     
  5. You need to change the line:
    addr_line_aloneupdt := 'N';
     
    to make it:
    addr_line_aloneupdt := 'Y';
     
  6. 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


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值