Home Discussions Questions & Answers Forms Compilation Failure due to Invalid Database Objects

Forms Compilation Failure due to Invalid Database Objects

Avatar photoCustomer January 13, 2022 at 1:46 pm

During installation, we get the error Form: XXEN_REPORTS FRM-30085: Unable to adjust form for output. Form not created. Does this mean the form file is corrupt?

Viewing 2 reply threads
  • Author
    Replies
    • Support January 15, 2022 at 7:57 am  

      Not necessarily the form file itself. This error most commonly indicates that the required database packages (like XXEN_REPORT, XXEN_UTIL, XXEN_API) are in an invalid state, preventing the form compilation from succeeding.

    • Avatar photoCustomer January 15, 2022 at 3:02 pm  

      What is the procedure to fix all the invalid packages?

    • Support January 16, 2022 at 10:01 am  

      You need to run a mass recompile script as APPS user, executing `alter package [package_name] compile;` and `alter package [package_name] compile body;` for all XXEN packages. After successful compilation, you must then rerun the `frmcmp_batch.sh` command to compile the `XXEN_REPORTS.fmb` form.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: