R12P : Unable To Discard Line If The Tax Is Associated With It (Doc ID 1500036.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Responsibility:  Payables
Navigation:  Create invoice Manually > Match to PO and then add the tax line to item by going "TAX detail" and attach tax > Save the data

Query the invoice and try to discard the item line type >> Get Caution note and then system hangs:

The invoice line you wish to discard has charges that were manually allocated by applying a user-defined amount or percent rule. These manually
created lines will be deleted if you discard the line. DO you wish to continue?

Trace file shows an SQL which is running forever:

SELECT ZD.REC_NREC_TAX_DIST_ID, GT.REVERSING_APPLN_ID,
GT.REVERSING_ENTITY_CODE, GT.REVERSING_EVNT_CLS_CODE, GT.REVERSING_TRX_ID,

GT.REVERSING_TRX_LINE_ID, GT.REVERSING_TRX_LEVEL_TYPE, ZL.TAX_LINE_ID,
GT.REVERSING_TRX_LINE_DIST_ID, ZL.SUMMARY_TAX_LINE_ID, ZL.TRX_NUMBER,
ZD.INTERNAL_ORGANIZATION_ID, ZD.GL_DATE
FROM
ZX_REC_NREC_DIST ZD, ZX_REVERSE_DIST_GT GT, ZX_LINES ZL WHERE
ZD.APPLICATION_ID = GT.REVERSED_APPLN_ID AND ZD.ENTITY_CODE =
GT.REVERSED_ENTITY_CODE AND ZD.EVENT_CLASS_CODE =
GT.REVERSED_EVNT_CLS_CODE
AND ZD.TRX_ID = GT.REVERSED_TRX_ID AND ZD.TRX_LINE_ID =
GT.REVERSED_TRX_LINE_ID AND ZD.TRX_LEVEL_TYPE = GT.REVERSED_TRX_LEVEL_TYPE

AND ZD.TAX_LINE_ID = NVL(GT.REVERSED_TAX_LINE_ID, ZD.TAX_LINE_ID) AND
ZD.TRX_LINE_DIST_ID = GT.REVERSED_TRX_LINE_DIST_ID AND
NVL(ZD.REVERSE_FLAG,
'N') = 'N' AND ZL.APPLICATION_ID = GT.REVERSING_APPLN_ID AND
ZL.ENTITY_CODE
= GT.REVERSING_ENTITY_CODE AND ZL.EVENT_CLASS_CODE =
GT.REVERSING_EVNT_CLS_CODE AND ZL.TRX_ID = GT.REVERSING_TRX_ID AND
ZL.TRX_LINE_ID = GT.REVERSING_TRX_LINE_ID AND ZL.TRX_LEVEL_TYPE =
GT.REVERSING_TRX_LEVEL_TYPE AND ((ZL.REVERSED_TAX_LINE_ID IS NOT NULL AND
ZL.REVERSED_TAX_LINE_ID = ZD.TAX_LINE_ID ) OR ( ZL.REVERSED_TAX_LINE_ID IS

NOT NULL AND ZL.TAX_LINE_ID = GT.REVERSING_TAX_LINE_ID ) OR
(ZL.REVERSED_TAX_LINE_ID IS NULL AND ZL.TAX_LINE_ID =
GT.REVERSING_TAX_LINE_ID ) ) AND NOT EXISTS (SELECT 1 FROM
ZX_REC_NREC_DIST
ZXD WHERE ZXD.APPLICATION_ID = ZD.APPLICATION_ID AND ZXD.ENTITY_CODE =
ZD.ENTITY_CODE AND ZXD.EVENT_CLASS_CODE = ZD.EVENT_CLASS_CODE AND
ZXD.TRX_ID = ZD.TRX_ID AND ZXD.TRX_LINE_ID = ZD.TRX_LINE_ID AND
ZXD.TRX_LEVEL_TYPE = ZD.TRX_LEVEL_TYPE AND ZXD.TAX_LINE_ID =
ZL.TAX_LINE_ID
AND ZXD.TRX_LINE_DIST_ID = GT.REVERSING_TRX_LINE_DIST_ID AND
ZXD.REC_NREC_TAX_DIST_NUMBER = ZD.REC_NREC_TAX_DIST_NUMBER)

Cause

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