Customer Merge Failing Due To Staged Deliveries (Doc ID 1997073.1)

Last updated on NOVEMBER 17, 2016

Applies to:

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

Symptoms

On :  12.1.3 version, Shipping Execution

Account/Customer Merge failing  

ERROR
-----------------------
MSG-00001: create_same_sites:create_acct_site_uses ERROR The following SQL error occurred:
ORA-20002: 3825: Error '-6503 - ORA-06503: PL/SQL: Function returned without value' encountered during execution of Rule function 'tnv_ar_custsite_update_tax.update_site_tax 02-MAR-2015 08:34:34


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot merge these 2 accounts

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms