My Oracle Support Banner

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:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

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

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.