8 Replies Latest reply: Nov 9, 2006 2:20 AM by 544086 RSS

    Error when using Form Builder

    544086
      When using Form Builder to create a new form from TEMPLATE.fmb, there is an error like this:

      FRM-18108:Failed to load the following objects:

      Source Module:APPSTAND
      Source object:STANDARD_PC_AND_VA
      Source Module:APPSTAND
      Source object:STANDARD_TOOLBAR
      Source Module:APPSTAND
      Source object:STANDARD_CALENDAR

      Then, I found an file incuding the error message in the directory where I placed the TEMPLATE.fmb and APPSTAND.fmb.
      Here is the main point:

      FRM-30064: Unable to parse statement select timezone_code,name
      ,to_char(trunc(gmt_offset),'S09') || ':' || to_char(abs(gmt_offset - trunc(gmt_offset))
      *60,'FM900') offset
      ,decode(daylight_savings_flag,'Y','*',null) dst_flag
      from fnd_timezones_vl
      where enabled_flag = 'Y'
      order by gmt_offset.
      ORA-00942: table or view does not exist
      Record Group TIMEZONES
      Form: STANDARD_OBJECTS
      FRM-30085: Unable to adjust form for output.

      How can I fix this error?

      Thanks a lot,
      Mike Cui

      PS: I have intalled the Oracle EBS VIS, and the OS is WinXP(ZHS).
        • 1. Re: Error when using Form Builder
          Hussein Sawwan-Oracle
          A similar issue can be found at Metalink (Note: 287442.1)
          • 2. Re: Error when using Form Builder
            544086
            Thank you for your attention.
            But I have no CSI Number, I cann't access to metalink.
            Now, I learn Oracle development all by myself.
            • 3. Re: Error when using Form Builder
              317243
              Check whether the following file is present
              $FND_TOP/patch/115/odf/aftmz.odf

              If present then run the command after logon as applmgr and setting the environment using
              $APPL_TOP/APPSORA.env

              adodfcmp odffile=$FND_TOP/patch/115/odf/aftmz.odf userid=apps/apps
              changedb=yes priv_schema=system/manager
              mode=views touser=apps/apps
              • 4. Re: Error when using Form Builder
                Hussein Sawwan-Oracle
                Check whether the following file is present
                $FND_TOP/patch/115/odf/aftmz.odf

                If present then run the command after logon as
                applmgr and setting the environment using
                $APPL_TOP/APPSORA.env

                adodfcmp odffile=$FND_TOP/patch/115/odf/aftmz.odf
                userid=apps/apps
                changedb=yes priv_schema=system/manager
                mode=views touser=apps/apps
                This is exactly what the note instruct to do ..

                Can we post the contents of Metalink notes here directly? If so, then what is the use of having a CSI number?

                Please advise :-)
                • 5. Re: Error when using Form Builder
                  544086
                  Thanks a lot.

                  According to the Note, I have run the command in the computer. And the View of FND_TIMEZONES_VL has been created.

                  But the problem is still here. The error message is:

                  FRM-18108:Failed to load the following objects:

                  Source Module:APPSTAND
                  Source object:STANDARD_PC_AND_VA
                  Source Module:APPSTAND
                  Source object:STANDARD_TOOLBAR
                  Source Module:APPSTAND
                  Source object:STANDARD_CALENDAR
                  • 6. Re: Error when using Form Builder
                    Hussein Sawwan-Oracle
                    This is because Apps forms depend on other forms/libraries ..

                    Copy $AU_TOP/resource to your local disk and add the path to FORMS60_PATH in the registry
                    • 7. Re: Error when using Form Builder
                      user531037
                      You need to add the Libraries to your form and they are found in $AU_top/resource/US directory.

                      some of the important libraries are APPDAYPK,FNDSQF,APPCORE,APPCORE2,CUSTOM,GLOBE,JA,JL,JE,VERT,HRKPI,etc.

                      Make sure APP_CUSTOM package is created in your PROGRAM UNITS.

                      Cheers....

                      FUBU
                      • 8. Re: Error when using Form Builder
                        544086
                        Yes, that's right.
                        I have fixed this error.
                        At the same time, I found a bug when installing Oracle EBS DEMO. That is,

                        FORM60_PATH in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE,is $AU_TOP\11.5.0\resource;$AU_TOP\11.5.0\form\us; But another one in HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME2 is $AU_TOP\11.5.0\resource;$AU_TOP\11.5.0\plsql. I think the second one is the working path used by Form Builder. Correcting it to be same with the first one will be OK. Or you can change all of them to your own working path.

                        PS: Form builder is installed in the server PC which I only have:)

                        Message was edited by:
                        Mike Cui