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.
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."
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
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
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