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 SEPTEMBER 09, 2016

Applies to:

Oracle Applications DBA - Version 12.0.0 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Checked for relevance on 28JUL2014

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.
...

 

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