R12: Unexpected Error Occurred While Applying Prepayment to Standard Invoice: ZX_LINES_DET_FACTORS_U1 (Doc ID 1625735.1)

Last updated on APRIL 15, 2014

Applies to:

Oracle Payables - Version 12.0.1 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, Invoice Issues & MassAdd

Getting error while applying Prepayment to Standard Invoice.


ERROR
-----------------------
APP-SQLAP-10000: An unexpected error has occurr occurred in Apply_Prepay_Line Call to calculate tax.

FND debug contain the following Errors:

   INSERTING in ELSE...
   ORA-00001: unique constraint (ZX.ZX_LINES_DET_FACTORS_U1) violated
   RETURN_STATUS = U
   ZX_API_PUB: CALCULATE_TAX:ZX_SRVC_TYP_PKG.calculate_tax returned errors
   ZX_API_PUB: DUMP_MSG()+
   0 Error Message(s) dumped into Zx_Errors_GT.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

   Create an Invoice and apply Prepayment to it.


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