R12: AP: Performance Issue With Invoice Workbench (APXINWKB) After Database Upgrade

(Doc ID 2063670.1)

Last updated on NOVEMBER 14, 2016

Applies to:

Oracle Payables - Version 12.1.2 and later
Information in this document applies to any platform.
Performance Issue With Invoice Workbench (APXINWKB) After Database Upgrade

Symptoms

On : 12.1.2 version, Other-MiscIss & KeyIndReport

Upgraded our TEST R12.1.2 EBS database from 11.2.0.3 to 11.2.0.4

We found Invoice workbench APXINWKB.fmx becomes extremely slow after database upgrade.

  $AP_TOP/forms/US/APXINWKB.fmx 120.601.12010000.509

Verified statistics are good on related tables.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to APINWKB.fmx

Changes

 Database Upgrade

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