Performance Issue Noted in Trading Partner Field of Invoice Workbench (Doc ID 1343489.1)

Last updated on AUGUST 31, 2016

Applies to:

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

Symptoms

In Release 12, While navigation from Trading partner field on Invoice workbench, system hangs.

Trace file shows the costliest sql is:
select vendor_name, segment1 vendor_number, vendor_id, hzp.party_number
registry_id, vendor_type_lookup_code, num_1099, type_1099, pv.employee_id,
awt_group_id, allow_awt_flag, hold_all_payments_flag, hzp.party_id,/*bug
8225059*/emp.employee_num employee_number, /*9507429*/
pv.vat_registration_num
from
ap_suppliers pv, hz_parties hzp,/*bug 8225059 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=8225059] */ per_employees_x emp where
(VENDOR_NAME LIKE :1) AND ( pv.party_id = hzp.party_id and pv.enabled_flag =
'Y' and /*bug 8225059 [http://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=8225059] */ pv.employee_id = emp.employee_id(+) and
trunc(sysdate) < nvl(trunc(pv.end_date_active), trunc(sysdate+1)) and
nvl(trunc(pv.start_date_active), trunc(sysdate)) <= trunc(sysdate) and
po_vendors_ap_pkg.get_num_active_pay_sites(vendor_id, :2) >0 ) order by
upper(vendor_name)

When attempting to Gather Schema Statistics, the following error occurs.

ERROR
-----------------------

In GATHER_SCHEMA_STATS , schema_name= AP percent= 10 degree = 8 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JE_FR_DAS_010***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JE_FR_DAS_010_NEW***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=AP.JG_ZZ_SYS_FORMATS_ALL_B***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt***


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot created invoices in system.

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