R12 AP: Forms Not Generating After Applying Patch 17176017 (Doc ID 1617989.1)

Last updated on JULY 15, 2023

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In R12, encountered errors after applying patch 17176017

The following Oracle Forms objects did not generate successfully:

ap forms/US APXPWALL.fmx
ap forms/US APXIISIM.fmx
ap forms/US APXPAWKB.fmx

APXPAWKB.fmx

FRM-30064: Unable to parse statement select decode(sup.vendor_type_lookup_code, /* Bug 15966842*/
'EMPLOYEE', NVL(alc.displayed_field, a.vendor_site_code),
a.vendor_site_code) vendor_site_code,
a.vendor_site_id, a.vendor_id, a.vendor_name, a.vendor_number, a.num_1099, a.address_line1, a.city, a.state, a.province, a.zip, a.county, a.country, a.org_id, mo_global.get_ou_name(a.org_id) operating_unit, a.party_site_id
,a.payment_function, a.bank_charge_bearer, a.settlement_priority
from po_vendor_sites_ap_v a
, ap_suppliers sup /* Bug 15966842 */
, ap_lookup_codes alc /* Bug 15966842*/
where sup.vendor_id = a.vendor_id /* Bug 15966842*/
and alc.lookup_type(+) = 'VENDOR_SITE_CODE' /* Bug 15966842 */
and alc.lookup_code(+) = a.vendor_site_code /* Bug 15966842*/
order by upper(a.vendor_site_code).
ORA-00600: internal error code, arguments: [qctVCO:csform], [98], [0], [0], [0], [1], [1], [0], [], [], [], []
Record Group ALL_VENDOR_SITES
Form: APXPAWKB
FRM-30085: Unable to adjust form for output.

APXIISIM.fmx

FRM-30064: Unable to parse statement select decode(sup.vendor_type_lookup_code,/* Bug 15966842*/
'EMPLOYEE', nvl(alc.displayed_field, pov.vendor_site_code),
pov.vendor_site_code) vendor_site_code,
pov.vendor_site_id, pov.vendor_id, pov.vendor_name, pov.vendor_number, pov.num_1099, '', '', pov.hold_all_payments_flag, pov.address_line1, pov.city, pov.state, pov.province, pov.zip, pov.county, pov.country, pov.org_id,
mo_global.get_ou_name(pov.org_id) operating_unit
from po_vendor_sites_ap_v pov, financials_system_params_all fsp
, ap_lookup_codes alc, ap_suppliers sup /* Bug 15966842 */
where pov.org_id = fsp.org_id
and sup.vendor_id = pov.vendor_id /* Bug 15966842 */
and alc.lookup_type(+) = 'VENDOR_SITE_CODE' /* Bug 15966842 */
and alc.lookup_code(+) = pov.vendor_site_code /* Bug 15966842*/
order by upper(vendor_site_code).
ORA-00600: internal error code, arguments: [qctVCO:csform], [98], [0], [0], [0], [1], [1], [0], [], [], [], []
Record Group ALL_VENDOR_SITES
Form: APXIISIM
FRM-30085: Unable to adjust form for output.

APXPWALL.fmx

FRM-30064: Unable to parse statement select decode(sup.vendor_type_lookup_code, /* Bug 15966842 */
'EMPLOYEE', NVL(alc.displayed_field, pov.vendor_site_code),
pov.vendor_site_code) vendor_site_code,
pov.vendor_site_id, pov.vendor_id, pov.vendor_name, pov.vendor_number, pov.num_1099, pov.address_line1, pov.city, pov.state, pov.province, pov.zip, pov.county, pov.country , pov.org_id , mo_global.get_ou_name(pov.org_id) operating_unit
from po_vendor_sites_ap_v pov, financials_system_params_all fsp
, ap_suppliers sup, ap_lookup_codes alc /* Bug 15966842*/
where pov.org_id = fsp.org_id
and sup.vendor_id = pov.vendor_id /* Bug 15966842*/
and alc.lookup_type(+) = 'VENDOR_SITE_CODE' /* Bug 15966842 */
and alc.lookup_code(+) = pov.vendor_site_code /* Bug 15966842*/
order by upper(vendor_site_code).
ORA-00600: internal error code, arguments: [qctVCO:csform], [98], [0], [0], [0], [1], [1], [0], [], [], [], []
Record Group ALL_VENDOR_SITE_CODE_QF
Form: APXPWALL
FRM-30085: Unable to adjust form for output.

Cause

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

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

R12 AP: Forms Not Generating After Applying Patch 17176017 (Doc ID 1617989.1)

Applies to:

Symptoms

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!