R12: AP: When Attempting To Modify an Invoice Validation / Apply / Unapply Notice Poor Performance After Clicking Tax Details To Round Off Amount (Doc ID 2998302.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

When attempting to modify an invoice validation / apply / unapply notice poor performance after clicking tax details to round off amount:

Steps to reproduce the issue:

1. Using Payables Responsibility
2. Navigate to Invoice > Enter > Invoice
3. Click on Tax Details and try to round off the tax amount
4. Click (B) Actions…1
5. Try to modify the invoice: Apply / Unapply / Validate
6. Notice the performance

This issue is  related to the ZX_LINES table statistics

Changes

 Gathering statistics is a part of performance monitoring and tuning. Regularly collecting and reviewing statistics is a proactive approach to identifying and addressing performance issues.

Cause

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