This discussion is archived
9 Replies Latest reply: Dec 13, 2012 8:49 AM by Hussein Sawwan-Oracle RSS

Unable to generate form CSTFVTLC.fmx even after Patch 8528194

user558643 Newbie
Currently Being Moderated
Hell EBS Gurus,

We have recently upgraded from 11i to 12.1.3 EBS and adadmin is failing on gerating form CSTFVTLC.fmx. I have followed Note 130686.1 and applied Patch 8528194 and a manual compilation:
frmcmp userid=apps/apps module=CSTFVTLC.fmb output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=special
or

$ORACLE_HOME/bin/frmcmp_batch.sh module=$AU_TOP/forms/US/CSTFVTLC.fmb userid=APPS/APPS@OFD1 output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=special
or
$ORACLE_HOME/bin/frmcmp.sh module=$AU_TOP/forms/US/CSTFVTLC.fmb userid=APPS/APPS@OFD1 output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=special

all still get the same error:
FRM-91500: Unable to start/complete the build.

I manually edited $TNS_ADMIN/tnsnames.ora adding:
OFD1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=ofindev03.macott.com)(PORT=1528))
(CONNECT_DATA=
(SERVICE_NAME=OFD1)
(INSTANCE_NAME=OFD1)
)
)

and then had a different error:
$ORACLE_HOME/bin/frmcmp.sh module=$AU_TOP/forms/US/CSTFVTLC.fmb userid=APPS/APPS@OFD1 output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form batch=no compile_all=special
Errors:
Compiling KEY-NXTBLK trigger on MTL_MATERIAL_TXNS_VAL_QF data block...
Compilation error on KEY-NXTBLK trigger on MTL_MATERIAL_TXNS_VAL_QF data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 3, column 1
bad bind variable 'parameter.G_query_find'

Compiling KEY-LISTVAL trigger on FROM_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on FROM_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling KEY-LISTVAL trigger on TO_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on ITEM item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on TRANSACTION_SOURCE_TYPE item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-VALIDATE-ITEM trigger on TRANSACTION_SOURCE item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on CLEAR item in MTL_MATERIAL_TXNS_VAL_QF data block...
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on FIND item in MTL_MATERIAL_TXNS_VAL_QF data block...
Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in MTL_MATERIAL_TXNS_VAL_QF data block:
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 1
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 4, column 1
bad bind variable 'parameter.G_query_find'

Compiling ON-POPULATE-DETAILS trigger on MTL_MATERIAL_TXNS_VAL_V data block...
No compilation errors.

Compiling ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block...
Compilation error on ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block:
PL/SQL ERROR 905 at line 10, column 19
object APPS.CST_LAYER_ACTUAL_COST_DTLS_V is invalid
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored

Compiling PRE-QUERY trigger on MTL_MATERIAL_TXNS_VAL_V data block...
Compilation error on PRE-QUERY trigger on MTL_MATERIAL_TXNS_VAL_V data block:
PL/SQL ERROR 49 at line 1, column 4
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 1, column 4
bad bind variable 'parameter.G_query_find'
PL/SQL ERROR 49 at line 10, column 10
bad bind variable 'parameter.g_query_find'
PL/SQL ERROR 49 at line 10, column 10
bad bind variable 'parameter.g_query_find'

Compiling QUERY_FIND trigger on MTL_MATERIAL_TXNS_VAL_V data block...
No compilation errors.
Compilation errors have occurred.

Form not created

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Has anyone encountered and resolved this problem?

thanks
Mathias
  • 1. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    user558643 wrote:
    Hell EBS Gurus,

    We have recently upgraded from 11i to 12.1.3 EBS and adadmin is failing on gerating form CSTFVTLC.fmx. I have followed Note 130686.1 and applied Patch 8528194 and a manual compilation:
    Please see these docs.

    R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1]
    Unable To Compile Custom Form Using Frmcmp Utility Receive FRM-91500 [ID 563655.1]

    Thanks,
    Hussein
  • 2. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    user558643 Newbie
    Currently Being Moderated
    Hello Hussein,

    I am unable to resolve generate this form (CSTFVTLC.fmx) after following all the steps in the Notes you referenced. With help mostly from you, I have finished my TEST Server installation and this seems to be the only only resolved installation issue so far.

    Following Note 431324.1, I have applied Patch 8528194 and to fix the TNS_ADMIN entry in the frmcmp_batch.sh.
    Patch 5456500 failed with
    "MISSING_COMPONENT : oracle.developer.forms, 10.1.2.2.1 (found a component with higher version)"

    I did echo $FORMS_PATH and it is missing $AU_TOP/forms/US as recommended by note 1085928.1
    echo $FORMS
    /u02/applfint/apps/apps_st/appl/au/12.0.0/resource:/u02/applfint/apps/apps_st/appl/au/12.0.0/resource/stub

    I then did
    FORMS_PATH=$AU_TOP/resource:$AU_TOP/resource/stub:$AU_TOP/forms/US

    and executed:
    frmcmp_batch.sh module=$AU_TOP/forms/US/CSTFVTLC.fmb userid=APPS/APPS output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form compile_all=special

    Almost everything executed with " No compilation errors." except

    Compiling ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block...
    Compilation error on ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block:
    PL/SQL ERROR 905 at line 10, column 19
    object APPS.CST_LAYER_ACTUAL_COST_DTLS_V is invalid
    PL/SQL ERROR 0 at line 10, column 5
    SQL Statement ignored

    Following Note 563655.1 (second you mentioned), I did:

    cd $AU_TOP/forms/US
    frmcmp userid=apps/apps module=CSTFVTLC.fmb output_file=$AU_TOP/forms/US/CSTFVTLC.fm
    x module_type=form batch=no compile_all=special
    and it gave the error:
    FRM-91500: Unable to start/complete the build.

    On this same terminal, frmcmp_batch.sh above gave a different error as mentioned above.

    thanks
    Mathias
  • 3. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Hi Mathias,
    FRM-91500: Unable to start/complete the build.
    Please review these docs, it should be helpful in fixing the issue.

    R12: Manual Forms compilation In R12 fails With: FRM-91500: Unable to start/complete the build [ID 431324.1]
    R12: "FRM-91500: UNABLE TO START/COMPLETE THE BUILD" Error When Compiling Forms via FRMCMP [ID 753135.1]
    Unable To Compile Custom Form Using Frmcmp Utility Receive FRM-91500 [ID 563655.1]

    Thanks,
    Hussein
  • 4. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    user558643 Newbie
    Currently Being Moderated
    I have reviewed and followed instructions in all those docs except 753135.1 and following this note
    when I enter:
    export DISPLAY=172.17.3.224:0.0
    frmcmp help=y
    gives me "FRM-91500: Unable to start/complete the build."
    but
    frmcmp_batch.sh help=y - is active and when executed to generate the form, it gives
    "Compilation error on ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block:"

    What can I do next?
    Mathias
  • 5. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    frmcmp_batch.sh help=y - is active and when executed to generate the form, it gives
    "Compilation error on ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block:"

    What can I do next?
    Mathias
    Is this the complete error message?

    Thanks,
    Hussein
  • 6. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    user558643 Newbie
    Currently Being Moderated
    Hello Hussein,

    I was focussing on an SR (3-6322036041) I opened on this but there has been no solution from that end.

    When I executed
    $ORACLE_HOME/bin/frmcmp_batch.sh

    The complete error output is:

    Compiling KEY-NXTBLK trigger on MTL_MATERIAL_TXNS_VAL_QF data block...
    Compilation error on KEY-NXTBLK trigger on MTL_MATERIAL_TXNS_VAL_QF data block:
    PL/SQL ERROR 49 at line 1, column 1
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 1, column 1
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 3, column 1
    bad bind variable 'parameter.G_query_find'

    Compiling KEY-LISTVAL trigger on FROM_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-VALIDATE-ITEM trigger on FROM_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling KEY-LISTVAL trigger on TO_DATE item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-VALIDATE-ITEM trigger on ITEM item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-VALIDATE-ITEM trigger on TRANSACTION_SOURCE_TYPE item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-VALIDATE-ITEM trigger on TRANSACTION_SOURCE item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-BUTTON-PRESSED trigger on CLEAR item in MTL_MATERIAL_TXNS_VAL_QF data block...
    No compilation errors.

    Compiling WHEN-BUTTON-PRESSED trigger on FIND item in MTL_MATERIAL_TXNS_VAL_QF data block...
    Compilation error on WHEN-BUTTON-PRESSED trigger on FIND item in MTL_MATERIAL_TXNS_VAL_QF data block:
    PL/SQL ERROR 49 at line 1, column 1
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 1, column 1
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 4, column 1
    bad bind variable 'parameter.G_query_find'

    Compiling ON-POPULATE-DETAILS trigger on MTL_MATERIAL_TXNS_VAL_V data block...
    No compilation errors.

    Compiling ON-CHECK-DELETE-MASTER trigger on MTL_MATERIAL_TXNS_VAL_V data block...
    No compilation errors.

    Compiling PRE-QUERY trigger on MTL_MATERIAL_TXNS_VAL_V data block...
    Compilation error on PRE-QUERY trigger on MTL_MATERIAL_TXNS_VAL_V data block:
    PL/SQL ERROR 49 at line 1, column 4
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 1, column 4
    bad bind variable 'parameter.G_query_find'
    PL/SQL ERROR 49 at line 10, column 10
    bad bind variable 'parameter.g_query_find'
    PL/SQL ERROR 49 at line 10, column 10
    bad bind variable 'parameter.g_query_find'

    Compiling QUERY_FIND trigger on MTL_MATERIAL_TXNS_VAL_V data block...
    No compilation errors.

    Compilation errors have occurred.

    Form not created


    With this form not being created, there is also a bunch of about 45 views and 4 packages that are invalid.

    I will apreciate anyhelp on this form.
    Thanks
    Mathias

    Edited by: user558643 on Nov 27, 2012 8:24 AM
  • 7. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please see (After patch 12966880:R12.JL.B APP-JL-62058: You Can Define Only One Bank Occurrence For A Standard Occurrence [ID 1451418.1]).
    With this form not being created, there is also a bunch of about 45 views and 4 packages that are invalid.
    Are those related to the form you are trying to compile?

    Thanks,
    Hussein
  • 8. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    user558643 Newbie
    Currently Being Moderated
    Hello Hussein,

    Your guidance helped me compiled the form. After patch 8528194 I had to add $AU_TOP/forms/US into the FORMS_PATH i.e.
    FORMS_PATH =$AU_TOP/resource:$AU_TOP/resource/stub:$AU_TOP/forms/US
    and then the form was created with:
    frmcmp_batch.sh module=$AU_TOP/forms/US/CSTFVTLC.fmb userid=APPS/xxx output_file=$AU_TOP/forms/US/CSTFVTLC.fmx module_type=form compile_all=special

    I will continue to investigate why I have so many invalid objects (49):
    SQL> select OWNER, OBJECT_TYPE, COUNT(*) FROM DBA_OBJECTS WHERE STATUS = 'INVALID' GROUP BY OWNER, OBJECT_TYPE;

    OWNER OBJECT_TYPE COUNT(*)
    ------------------------------ ------------------- ----------
    APPS PACKAGE BODY 1
    OWAPUB PACKAGE BODY 2
    APPS PROCEDURE 1
    APPS TYPE BODY 1
    APPS VIEW 44

    Thanks again for your help.
    Mathias
  • 9. Re: Unable to generate form CSTFVTLC.fmx even after Patch 8528194
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    I will continue to investigate why I have so many invalid objects (49):
    Please compile those objects manually and see what error you get.

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points