R12 Generating Form WMSLABEL.fmx fails with 'FRM-30064: Unable to parse statement' after Patch has been applied
(Doc ID 761949.1)
Last updated on FEBRUARY 02, 2022
Applies to:
Oracle Applications DBA - Version 12.0.0 to 12.0.6 [Release 12]Information in this document applies to any platform.
Symptoms
Form WMSLABEL.fmb fails to generate, and the following errors occur:
...
Generating form "forms/US/WMSLABEL.fmx" with command:
<physical Path>/tech_st/10.1.2/bin/frmcmp_batch module=/$APPL_TOP/au/12.0.0/forms/US/WMSLABEL.fmb userid=APPS/***** \
output_file=/$APPL_TOP/wms/12.0.0/forms/US/WMSLABEL.fmx module_type=form batch=yes compile_all=special
FRM-30064: Unable to parse statement select upet.type_name EPC_type_name, upec.name category_name,
upet.type_id, upec.category_id
from mgd_idencoding_category upec,
mgd_idencoding_type upet
where upec.category_id = upet.category_id
and ((NVl(upet.partition_value,0)= 0 and upet.category_id = 1 ) or upet.category_id <> 1)
order by upec.category_id,type_name.
ORA-00942: table or view does not exist
Record Group EPC_RULE_RG
Form: WMSLABEL
FRM-30085: Unable to adjust form for output.
...
Generating form "forms/US/WMSLABEL.fmx" with command:
<physical Path>/tech_st/10.1.2/bin/frmcmp_batch module=/$APPL_TOP/au/12.0.0/forms/US/WMSLABEL.fmb userid=APPS/***** \
output_file=/$APPL_TOP/wms/12.0.0/forms/US/WMSLABEL.fmx module_type=form batch=yes compile_all=special
FRM-30064: Unable to parse statement select upet.type_name EPC_type_name, upec.name category_name,
upet.type_id, upec.category_id
from mgd_idencoding_category upec,
mgd_idencoding_type upet
where upec.category_id = upet.category_id
and ((NVl(upet.partition_value,0)= 0 and upet.category_id = 1 ) or upet.category_id <> 1)
order by upec.category_id,type_name.
ORA-00942: table or view does not exist
Record Group EPC_RULE_RG
Form: WMSLABEL
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 |