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

Last updated on JANUARY 12, 2016

Applies to:

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


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
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


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