Unique Constraint Error for Intercompany AR Invoices Import (Doc ID 2136471.1)

Last updated on MAY 10, 2016

Applies to:

Oracle Fusion Receivables - Version 11.1.7.0.0 and later
Oracle Fusion Receivables Cloud Service - Version 11.1.7.0.0 and later
Information in this document applies to any platform.

Symptoms

The AutoInvoice Import process ends in error with the below error message for Intercompany AR Invoices.


ERROR
-----------------------
AutoInvoice fails with the following error:
AFDICT_APP_PREFIX-AR-855636: ORA-00001: unique constraint
(FUSION.ZX_TRX_HEADERS_GT_U1) violated
OR
begin arp_etax_autoinv_util . calculate_tax ( :request_id , :phase , :
AFDICT_APP_PREFIX-AR-855636: c/src/autoinv/raaebt.lpc 214
Error calling raaebt().
Error calling raapic().



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Approve Intercompany transaction
2. Run the program Transfer to Receivables
3. Ensure that the "Run Receivables Invoice Import" criteria is set to yes
4. No Import AutoInvoice program is submitted
5. Run Import AutoInvoice manually
6. Import process ends in error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create Intercompany AR invoices.

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