[applmgr@ebshost ~]$ echo $FORMS_PATH /u01/oracle/apps/fs1/EBSapps/appl/au/12.0.0/resource:/u01/oracle/apps/fs1/EBSapps/appl/au/12.0.0/resource/stub [applmgr@ebshost ~]$ export FORMS_PATH=/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/resource:/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS:/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/resource/ZHS [applmgr@ebshost ~]$ /u01/oracle/apps/fs2/EBSapps/10.1.2/bin/frmcmp_batch module=/u01/oracle/apps/fs2/EBSapps/appl/au/12.0.0/forms/ZHS/WMSLABEL.fmb output_file=/u01/oracle/apps/fs2/EBSapps/appl/wms/12.0.0/forms/ZHS/WMSLABEL.fmx module_type=form compile_all=special userid=apps/apps Forms 10.1 (Form Compiler) Version 10.1.2.3.0 (Production) Forms 10.1 (Form Compiler): Release - Production Copyright (c) 1982, 2005, Oracle. All rights reserved. Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options PL/SQL Version 10.1.0.5.0 (Production) Oracle Procedure Builder V10.1.2.3.0 - Production Oracle Virtual Graphics System Version 10.1.2.0.0 (Production) Oracle Multimedia Version 10.1.2.0.2 (Production) Oracle Tools Integration Version 10.1.2.0.2 (Production) Oracle Tools Common Area Version 10.1.2.0.2 Oracle CORE 10.1.0.5.0 Production Compiling package specification APP_CUSTOM... No compilation errors. Compiling package specification LABEL_FORMAT... No compilation errors. Compiling package specification CONTROL... No compilation errors. Compiling package specification LABEL_FIELDVARS... No compilation errors. Compiling package specification LABEL_SET_FORMAT... No compilation errors. Compiling package specification JAF... No compilation errors. Compiling package specification APP_CUSTOM... No compilation errors. Compiling package body APP_CUSTOM... No compilation errors. Compiling procedure CHECK_PACKAGE_FAILURE... No compilation errors. Compiling procedure QUERY_MASTER_DETAILS... No compilation errors. Compiling procedure CLEAR_ALL_MASTER_DETAILS... No compilation errors. Compiling package specification LABEL_FORMAT... No compilation errors. Compiling package body LABEL_FORMAT... No compilation errors. Compiling package body LABEL_FIELDVARS... No compilation errors. Compiling package specification CONTROL... No compilation errors. Compiling package body CONTROL... No compilation errors. Compiling package specification LABEL_FIELDVARS... No compilation errors. Compiling package specification LABEL_SET_FORMAT... No compilation errors. Compiling package body LABEL_SET_FORMAT... No compilation errors. Compiling package body JAF... No compilation errors. Compiling package specification JAF... No compilation errors. Compiling KEY-F9 trigger on form... No compilation errors. Compiling KEY-F0 trigger on form... No compilation errors. Compiling KEY-F1 trigger on form... No compilation errors. Compiling KEY-F2 trigger on form... No compilation errors. Compiling KEY-F3 trigger on form... No compilation errors. Compiling KEY-F4 trigger on form... No compilation errors. Compiling KEY-F5 trigger on form... No compilation errors. Compiling KEY-F6 trigger on form... No compilation errors. Compiling KEY-F7 trigger on form... No compilation errors. Compiling KEY-F8 trigger on form... No compilation errors. Compiling APPCORE_TO_CALENDAR trigger on form... No compilation errors. Compiling EXPORT trigger on form... No compilation errors. Compiling LASTRECORD trigger on form... No compilation errors. Compiling CLOSE_THIS_WINDOW trigger on form... No compilation errors. Compiling ZOOM trigger on form... No compilation errors. Compiling STANDARD_ATTACHMENTS trigger on form... No compilation errors. Compiling WHEN-FORM-NAVIGATE trigger on form... No compilation errors. Compiling MENU_TO_APPCORE trigger on form... No compilation errors. Compiling PRE-POPUP-MENU trigger on form... No compilation errors. Compiling WHEN-WINDOW-RESIZED trigger on form... No compilation errors. Compiling FOLDER_ACTION trigger on form... No compilation errors. Compiling FOLDER_RETURN_ACTION trigger on form... No compilation errors. Compiling KEY-HELP trigger on form... No compilation errors. Compiling KEY-DUPREC trigger on form... No compilation errors. Compiling KEY-EXIT trigger on form... No compilation errors. Compiling KEY-EDIT trigger on form... No compilation errors. Compiling KEY-COMMIT trigger on form... No compilation errors. Compiling KEY-CLRFRM trigger on form... No compilation errors. Compiling KEY-MENU trigger on form... No compilation errors. Compiling KEY-LISTVAL trigger on form... No compilation errors. Compiling WHEN-WINDOW-CLOSED trigger on form... No compilation errors. Compiling POST-FORM trigger on form... No compilation errors. Compiling PRE-FORM trigger on form... No compilation errors. Compiling ON-ERROR trigger on form... No compilation errors. Compiling WHEN-NEW-FORM-INSTANCE trigger on form... No compilation errors. Compiling WHEN-NEW-RECORD-INSTANCE trigger on form... No compilation errors. Compiling WHEN-NEW-ITEM-INSTANCE trigger on form... No compilation errors. Compiling WHEN-NEW-BLOCK-INSTANCE trigger on form... No compilation errors. Compiling QUERY_FIND trigger on form... No compilation errors. Compiling CLOSE_WINDOW trigger on form... No compilation errors. Compiling ACCEPT trigger on form... No compilation errors. Compiling ON-CLEAR-DETAILS trigger on form... No compilation errors. Compiling PRE-QUERY trigger on form... No compilation errors. Compiling POST-QUERY trigger on form... No compilation errors. Compiling PRE-INSERT trigger on form... No compilation errors. Compiling PRE-UPDATE trigger on form... No compilation errors. Compiling WHEN-VALIDATE-RECORD trigger on form... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on form... No compilation errors. Compiling WHEN-CUSTOM-ITEM-EVENT trigger on PJC item in BLK_PJC data block... No compilation errors. Compiling KEY-NXTBLK trigger on LABEL_FORMATS_HDR data block... No compilation errors. Compiling POST-BLOCK trigger on LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on LABEL_TYPE_NAME item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on ENTITY_TYPE item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on LABEL_TYPE_NAME_MIR item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on DOCUMENT_ID item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on FIND_LABEL_TYPES item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on LABEL_TYPE_MIR_SET item in LABEL_FORMATS_HDR data block... No compilation errors. Compiling PRE-INSERT trigger on LABEL_FORMATS data block... No compilation errors. Compiling PRE-UPDATE trigger on LABEL_FORMATS data block... No compilation errors. Compiling WHEN-NEW-BLOCK-INSTANCE trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-INSERT trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-UPDATE trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-LOCK trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-DELETE trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-POPULATE-DETAILS trigger on LABEL_FORMATS data block... No compilation errors. Compiling ON-CHECK-DELETE-MASTER trigger on LABEL_FORMATS data block... No compilation errors. Compiling CHECK_DEFAULT_FORMAT trigger on LABEL_FORMATS data block... No compilation errors. Compiling KEY-NXTBLK trigger on LABEL_FORMATS data block... No compilation errors. Compiling POST-QUERY trigger on LABEL_FORMATS data block... No compilation errors. Compiling KEY-DELREC trigger on LABEL_FORMATS data block... No compilation errors. Compiling KEY-COMMIT trigger on LABEL_FORMATS data block... No compilation errors. Compiling WHEN-NEW-ITEM-INSTANCE trigger on DRILLDOWN_RECORD_INDICATOR item in LABEL_FORMATS data block... No compilation errors. Compiling KEY-PREV-ITEM trigger on LABEL_FORMAT_NAME item in LABEL_FORMATS data block... No compilation errors. Compiling KEY-LISTVAL trigger on FORMAT_DISABLE_DATE item in LABEL_FORMATS data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on FORMAT_DISABLE_DATE item in LABEL_FORMATS data block... No compilation errors. Compiling KEY-NEXT-ITEM trigger on DEFAULT_FORMAT_FLAG item in LABEL_FORMATS data block... No compilation errors. Compiling WHEN-CHECKBOX-CHANGED trigger on DEFAULT_FORMAT_FLAG item in LABEL_FORMATS data block... No compilation errors. Compiling PRE-INSERT trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling PRE-UPDATE trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling ON-INSERT trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling ON-UPDATE trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling ON-LOCK trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling ON-DELETE trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling WHEN-VALIDATE-RECORD trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling KEY-CLRREC trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling KEY-DELREC trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling PRE-RECORD trigger on LABEL_FIELD_VARS data block... No compilation errors. Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in LABEL_FIELD_VARS data block... No compilation errors. Compiling PRE-INSERT trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling ON-INSERT trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling ON-UPDATE trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling ON-LOCK trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling ON-DELETE trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling PRE-UPDATE trigger on LABEL_SET_FORMATS data block... No compilation errors. Compiling WHEN-NEW-ITEM-INSTANCE trigger on CURRENT_RECORD_INDICATOR item in LABEL_SET_FORMATS data block... No compilation errors. Compiling KEY-DELREC trigger on LABEL_FIELD_EPC_VARS data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on EPC_RULE_MIR item in LABEL_FIELD_EPC_VARS data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on FILTER_VALUE_MIR item in LABEL_FIELD_EPC_VARS data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on REGENERATE_EPC_FLAG_MIR item in LABEL_FIELD_EPC_VARS data block... No compilation errors. Compiling WHEN-CHECKBOX-CHANGED trigger on LABEL_FORMATS_FIELD_VARS item in CONTROL data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on LABEL_FIELD_VARS item in CONTROL data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on LABEL_FORMAT_IN_SET_BTN item in CONTROL data block... No compilation errors. Compiling WHEN-CHECKBOX-CHANGED trigger on LABEL_SET_FORMAT_CO item in CONTROL data block... No compilation errors. Compiling WHEN-RADIO-CHANGED trigger on CALENDAR data block... No compilation errors. Compiling KEY-OTHERS trigger on CALENDAR data block... No compilation errors. Compiling KEY-NEXT-ITEM trigger on CALENDAR data block... No compilation errors. Compiling KEY-PREV-ITEM trigger on CALENDAR data block... No compilation errors. Compiling KEY-ENTER trigger on CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on CALENDAR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on CALENDAR data block... No compilation errors. Compiling WHEN-MOUSE-CLICK trigger on CALENDAR data block... No compilation errors. Compiling KEY-DOWN trigger on CALENDAR data block... No compilation errors. Compiling KEY-UP trigger on CALENDAR data block... No compilation errors. Compiling KEY-NXTREC trigger on CALENDAR data block... No compilation errors. Compiling KEY-PRVREC trigger on CALENDAR data block... No compilation errors. Compiling WHEN-MOUSE-DOUBLECLICK trigger on CALENDAR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on TIMEZONE_NAME item in CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on SHOW_TIMEZONES_DATETIME item in CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block... No compilation errors. Compiling KEY-EXIT trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-DOWN trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-CREREC trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-COMMIT trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-CLRREC trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-CLRBLK trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-NXTREC trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-CLRFRM trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-UP trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling KEY-PRVREC trigger on PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on OBJECT_TYPE item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on OBJ1 item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on OBJ2 item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on OBJ4 item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-VALIDATE-ITEM trigger on OBJ3 item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-LIST-CHANGED trigger on PROP item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on UPDATE_PROPERTIES item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on REFRESH item in PROGRESS_INDICATOR data block... No compilation errors. Compiling WHEN-BUTTON-PRESSED trigger on CANCEL_PROPERTIES item in PROGRESS_INDICATOR data block... No compilation errors. 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. Form not created [applmgr@ebshost ~]$ [oracle@ebshost ~]$ sqlplus apps/apps SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 18 09:08:03 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Thu Jan 18 2018 09:06:32 +08:00 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select * from mgd_idencoding_category ; select * from mgd_idencoding_category * ERROR at line 1: ORA-00942: table or view does not exist SQL> select * from mgd_idencoding_type ; select * from mgd_idencoding_type * ERROR at line 1: ORA-00942: table or view does not exist