APXINWKB: Performance issue when trying to change TAX AMOUNT on TAX SUMMARY Page (Doc ID 1334348.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.
APXINWKB: Performance issue when trying to change TAX AMOUNT on TAX SUMMARY Page

Symptoms

When trying to change the Tax Amount on an already existing Tax Summary line, It takes around 12-15 minutes to reverse the old tax lines and create and allocate the new line.

SELECT TAX_LINE_ID
FROM
ZX_LINES WHERE APPLICATION_ID = :B4 AND ENTITY_CODE = :B3 AND
EVENT_CLASS_CODE = :B2 AND OFFSET_LINK_TO_TAX_LINE_ID = :B1


call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 2 0.00 0.00 0 0 0 0
Fetch 2 86.51 636.72 4432080 50331309 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 5 86.51 636.72 4432080 50331309 0 0

Changes

None

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