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 laterInformation 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.
'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.
'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.
'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
Symptoms |
Cause |
Solution |
References |