5 Replies Latest reply on Jul 5, 2012 9:14 AM by g_user

    APP-FND-01564: ORACLE error 942 in fdmload

    g_user
      Hi,

      getting this error after uploading menu, form,function,user when i try to access
      APP-FND-01564: ORACLE error 942 in fdmload
      cause : fdmload failed due to ORA-00942 : TABLE OR view does not exist.

      initially i fndload downloaded all the above from one instance and uploaded in to another instance

      user ,menu all are visible but when i access the responsibility and click the function getting this error.

      what am missing
      thanks in advance
      userg
        • 1. Re: APP-FND-01564: ORACLE error 942 in fdmload
          Hussein Sawwan-Oracle
          Please post the details of the application release, database version and OS.
          getting this error after uploading menu, form,function,user when i try to access
          APP-FND-01564: ORACLE error 942 in fdmload
          cause : fdmload failed due to ORA-00942 : TABLE OR view does not exist.

          initially i fndload downloaded all the above from one instance and uploaded in to another instance

          user ,menu all are visible but when i access the responsibility and click the function getting this error.
          Please post the commands you used to download/upload the menus using FNDLOAD. Also, post the contents of the log files for the download/upload.

          Thanks,
          Hussein
          • 2. Re: APP-FND-01564: ORACLE error 942 in fdmload
            g_user
            Hi ,
            Please find the commands and other details, downloaded & uploaded corresponding form functions also
            thanks
            user g


            $FND_TOP/bin/FNDLOAD $un/$pw O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct ./XXSI_CONV_MENU.ldt MENU MENU_NAME="XXSI_CONV_MENU"


            $FND_TOP/bin/FNDLOAD un/pw O Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct ./XXSI_CONV_MENU.ldt MENU MENU_NAME="XXSI_CONV_MENU"


            # $Header$

            # dbdrv: exec fnd bin FNDLOAD bin &phase=daa+51 checkfile:~PROD:~PATH:~FILE &ui_apps 0 Y UPLOAD @FND:patch/115/import/afsload.lct @~PROD:~PATH/~FILE
            LANGUAGE = "US"
            LDRCONFIG = "afsload.lct 120.2.12010000.1"

            #Source Database VIS

            #RELEASE_NAME 12.1.1

            # -- Begin Entity Definitions --

            DEFINE MENU
            KEY MENU_NAME VARCHAR2(4000)
            BASE TYPE VARCHAR2(30)
            BASE LAST_UPDATE_DATE VARCHAR2(10)
            TRANS USER_MENU_NAME VARCHAR2(80)
            TRANS DESCRIPTION VARCHAR2(240)
            CTX OWNER VARCHAR2(4000)

            DEFINE ENTRY
            TRANS PROMPT VARCHAR2(60)
            TRANS DESCRIPTION VARCHAR2(240)
            BASE GRANT_FLAG VARCHAR2(1)
            BASE LAST_UPDATE_DATE VARCHAR2(10)
            CTX SUBMENU REFERENCES MENU
            CTX FUNCTION REFERENCES FUNCTION
            CTX OWNER VARCHAR2(4000)
            END ENTRY
            END MENU

            DEFINE FUNCTION
            KEY FUNCTION_NAME VARCHAR2(4000)
            BASE FORM REFERENCES FORM
            BASE TYPE VARCHAR2(30)
            BASE PARAMETERS VARCHAR2(4000)
            BASE WEB_HOST_NAME VARCHAR2(4000)
            BASE WEB_AGENT_NAME VARCHAR2(4000)
            BASE WEB_HTML_CALL VARCHAR2(4000)
            BASE WEB_ENCRYPT_PARAMETERS VARCHAR2(4000)
            BASE WEB_SECURED VARCHAR2(4000)
            BASE WEB_ICON VARCHAR2(4000)
            BASE FUNC_OBJECT REFERENCES OBJECT
            BASE OBJECT_NAME REFERENCES OBJECT
            BASE REGION_APPLICATION_SHORT_NAME VARCHAR2(50)
            BASE REGION_APPLICATION_NAME VARCHAR2(50)
            BASE REGION_CODE VARCHAR2(4000)
            BASE LAST_UPDATE_DATE VARCHAR2(10)
            BASE MAINTENANCE_MODE_SUPPORT VARCHAR2(8)
            BASE CONTEXT_DEPENDENCE VARCHAR2(8)
            BASE JRAD_REF_PATH VARCHAR2(4000)
            TRANS USER_FUNCTION_NAME VARCHAR2(80)
            TRANS DESCRIPTION VARCHAR2(240)
            CTX OWNER VARCHAR2(4000)
            END FUNCTION

            DEFINE OBJECT
            KEY OBJ_NAME VARCHAR2(4000)
            BASE APPLICATION_SHORT_NAME VARCHAR2(50)
            BASE DATABASE_OBJECT_NAME VARCHAR2(30)
            BASE PK1_COLUMN_NAME VARCHAR2(30)
            BASE PK2_COLUMN_NAME VARCHAR2(30)
            BASE PK3_COLUMN_NAME VARCHAR2(30)
            BASE PK4_COLUMN_NAME VARCHAR2(30)
            BASE PK5_COLUMN_NAME VARCHAR2(30)
            BASE PK1_COLUMN_TYPE VARCHAR2(8)
            BASE PK2_COLUMN_TYPE VARCHAR2(8)
            BASE PK3_COLUMN_TYPE VARCHAR2(8)
            BASE PK4_COLUMN_TYPE VARCHAR2(8)
            BASE PK5_COLUMN_TYPE VARCHAR2(8)
            BASE LAST_UPDATE_DATE VARCHAR2(10)
            TRANS DISPLAY_NAME VARCHAR2(240)
            TRANS DESCRIPTION VARCHAR2(2000)
            CTX OWNER VARCHAR2(4000)
            END OBJECT

            DEFINE FORM
            KEY APPLICATION_SHORT_NAME VARCHAR2(4000)
            KEY FORM_NAME VARCHAR2(4000)
            BASE AUDIT_ENABLED_FLAG VARCHAR2(1)
            BASE LAST_UPDATE_DATE VARCHAR2(10)
            TRANS USER_FORM_NAME VARCHAR2(80)
            TRANS DESCRIPTION VARCHAR2(240)
            CTX OWNER VARCHAR2(4000)
            END FORM


            log

            -------------------------------------------------------------------------+

            Uploading from the data file XXSI_CONV_MENU.ldt
            Altering database NLS_LANGUAGE environment to AMERICAN
            Dump from LCT/LDT files (/d01/applvis/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afsload.lct(120.2.12010000.1), XXSI_CONV_MENU.ldt) to stage tables
            Dump LCT file /d01/vis/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afsload.lct(120.2.12010000.1) into FND_SEED_STAGE_CONFIG
            Dump LDT file XXSI_CONV_MENU.ldt into FND_SEED_STAGE_ENTITY
            Dumped the batch (MENU NULL , MENU XXSI_CONV_MENU ) into FND_SEED_STAGE_ENTITY
            Upload from stage tables

            ---------------------------------------------------------------------------
            Concurrent request completed successfully
            Current system time is
            • 3. Re: APP-FND-01564: ORACLE error 942 in fdmload
              Hussein Sawwan-Oracle
              What about the upload command and log file?

              Please consider using "CUSTOM_MODE=FORCE" option when you upload -- Please see these docs for details.

              Tips About FNDLOAD [ID 735338.1]
              How to Upload the 'ldt' files Manually [ID 1092694.1]

              Thanks,
              Hussein
              • 4. Re: APP-FND-01564: ORACLE error 942 in fdmload
                g_user
                hi

                thanks a lot for the help. after including the custom_mode=force am getting one more er msg
                APP-FND-01564 oracle error 942 in fdsrsp
                cause fdsrsp failed due to ora00942 table or view does not exist


                LOG file details

                Uploading from the data file XXSI_CONV_MENU.ldt
                Altering database NLS_LANGUAGE environment to AMERICAN
                Dump from LCT/LDT files (/d01/applvis/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afsload.lct(120.2.12010000.1), XXSI_CONV_MENU.ldt) to stage tables
                Dump LCT file /d01/applvis/apps/apps_st/appl/fnd/12.0.0/patch/115/import/afsload.lct(120.2.12010000.1) into FND_SEED_STAGE_CONFIG
                Dump LDT file XXSI_CONV_MENU.ldt into FND_SEED_STAGE_ENTITY
                Dumped the batch (MENU NULL , MENU XXSI_CONV_MENU ) into FND_SEED_STAGE_ENTITY
                Upload from stage tables

                ---------------------------------------------------------------------------
                Concurrent request completed successfully
                Current system time is 05-JUL-2012 13:08:52

                this the the log msg for menu

                thanks
                userg
                • 5. Re: APP-FND-01564: ORACLE error 942 in fdmload
                  g_user
                  hi Hussein ,

                  i tried with change in the data group application , from xxcustom to standard (with application appln obj lib)
                  it started opening the page . able to access the pages.
                  thing there might be some mismatch between the custom applns of the 2 instances (pls correct me if my guess is not correct)

                  thanks a lot for the help,
                  guser

                  Edited by: g_user on Jul 5, 2012 2:43 PM

                  Edited by: g_user on Jul 5, 2012 2:43 PM