R11 AP: Performance Issue on Payables Invoice Workbench (APXINWKB) (Doc ID 1594589.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Payables - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 11-Jan-2016***

Symptoms

Performance issue on Payables Invoice Workbench (APXINWKB)

Steps to Reproduce

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

1. Using Payables Manager responsibility
2. Navigate to Invoices > Entry > Invoices
3. Enter the header and line information

 

The following SQL statement is taking a long time.

 


select rsh.receipt_num , /* Removed Fix 5288763 5916985 5651721 */
 rsh.shipment_header_id , /* Added fix 6236883 */ rsl.to_organization_id,
 (select od.organization_name
from
org_organization_definitions od where od.organization_ID =
 RSL.to_organization_id) organization_name, rtxn.currency_code,
 plt.matching_basis from rcv_shipment_headers rsh, rcv_shipment_lines rsl,
 po_line_locations pll, /*bug: 2662505

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