R12 AP: Forms Not Generating After Applying Patch 17176017

(Doc ID 1617989.1)

Last updated on JANUARY 16, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 25-Dec-2015***

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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
, ap_lookup_codes alc /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
where sup.vendor_id = a.vendor_id /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and   alc.lookup_type(+) = 'VENDOR_SITE_CODE' /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and   alc.lookup_code(+) = a.vendor_site_code /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
where pov.org_id = fsp.org_id
and sup.vendor_id = pov.vendor_id             /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and alc.lookup_type(+) = 'VENDOR_SITE_CODE'   /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and alc.lookup_code(+) = pov.vendor_site_code /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
where pov.org_id = fsp.org_id
and sup.vendor_id = pov.vendor_id /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and alc.lookup_type(+) = 'VENDOR_SITE_CODE' /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=15966842] */
and alc.lookup_code(+) = pov.vendor_site_code /* Bug 15966842 [https://bug.oraclecorp.com/pls/bug/webbug_edit.edit_info_top?rptno=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

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