R12: AP: Poor Performance When Trying To Validate A Single Invoice Via OnLine Validation In The Invoice Workbench Form - APXINWKB (Doc ID 2722434.1)

Last updated on SEPTEMBER 21, 2022

Applies to:

Symptoms

Poor Performance When Trying To Validate A Single Invoice Via OnLine Validation In The Invoice Workbench Form - APXINWKB

When attempting to validate invoice the time it takes is from 1 minute to 1:30 to validate one single invoice via OnLine validation

EXPECTED BEHAVIOR
-----------------------
Do not expect validation to take that long ( from 1 minute to 1:30 to validate)

The issue can be reproduced at will with the following steps:

1. Log into application using a Payables Responsibility.
2. Enter the Invoice Workbench form - APXINWKB.fmb
3. Query an invoice.
4. Use the [Actions...] button to open the "Invoice Actions" window
5. In the actions window, select [x] Validate and [OK] to validate the invoice
6. Notice a performance issue, it takes from 1 minute to 1.5 minutes to validate the invoice.
   
   
   

Changes

The current version of the Invoice Workbench form executable, APXINWKB.fmx(fmb) is as follow:

Cause

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