My Oracle Support Banner

R12: Getting Error at Tax Calculation While trying to Modify Requisition Line during Autocreate (Doc ID 2376987.1)

Last updated on JULY 27, 2022

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.
POXVDCAB.pls
PO_TAX_INTERFACE_PVT.plb
PO_TAX_INTERFACE_PVT.pls

Symptoms

On : 12.2.6 version, Purchase Order

When trying to split a Requisition line during autocreate, the following error occurs

"An error occurred during tax calculation. Please correct the problem or contact your system administrator."


Error

In the debug log the following error message is seen:
p_message_text = po.plsql.PO_TAX_INTERFACE_PVT.CALCULATE_TAX_REQUISITION.#40:-1ORA-00001: unique constraint (ZX.ZX_TRANSACTION_LINES_GT_U1) violated
l_length= 1
End of subprogram.
-1ORA-00001: unique constraint (ZX.ZX_TRANSACTION_LINES_GT_U1) violated;SQLERRM = ORA-00001: unique constraint (ZX.ZX_TRANSACTION_LINES_GT_U1) violated


Steps to reproduce:


1. Create a requisition and approve
2. Navigate to:  AutoCreate
3. Query the requisition
4. Select the requisition line and go to
    Menu > Tools > Modify
5. Split the line and click OK

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.