3 Replies Latest reply: Dec 11, 2012 10:15 AM by CraigB RSS

    Forms migration error from 11.5.10 to R12

    968711
      Hi,

      I'm moving 11i form into R12.

      Copied all the .pll files.
      Opened the form in form builder, and in PREFORM trigger i made changes to code.
      Got below compilation errors, could you advice.

      Changes made
      -------------------

      FND_STANDARD.FORM_INFO('$Revision: 120.0 $',
      'Template Form', 'FND',
      '$Date: 2012/12/07 11:02 $', '$Author: appldev $');
      app_standard.event('PRE-FORM');
      app_window.set_window_position('BLOCKNAME', 'FIRST_WINDOW');


      MO_GLOBAL.INIT('XXCTOAR');

      Compilation errors
      ------------------------
      FRM-30100: Block must have at least one primary key item.
      Block: CTOAR_CASHBOOK_PARAMETERS
      FRM-30087: Unable to create form file C:\Users\docs\Desktop\CTO Docs\R12\FORMS\CTOARCBP.fmx.


      Thanks.
        • 1. Re: Forms migration error from 11.5.10 to R12
          user12183546
          you need to set property(Primary key) of an item(or a set of items) of the block(CTOAR_CASHBOOK_PARAMETERS
          ) to yes.

          Regards,
          Alok Dubey
          • 2. Re: Forms migration error from 11.5.10 to R12
            968711
            Could you tell me....where i can set the property.
            • 3. Re: Forms migration error from 11.5.10 to R12
              CraigB
              First and foremost, your question is not just related to Oracle Forms - it is more specific to the Oracle Enterprise Business Suite (EBS) so you really should have asked your question in the General EBS Discussion forum. Not everyone in this forum is familiar with or have worked with the EBS (although some of us have). :)

              Is the CROARCBP.fmx an Oracle supplied form or custom form? If it is an Oracle supplied form - then you need to contact Oracle Support to get this fixed.
              If it is a Custom form, then you need to open the form - go to the CTOAR_CASHBOOK_PARAMETERS Data Block and determine which database column should be the Primary Key. You will need to look at the Base Table of the block to figure out which column should have the PRIMARY KEY property set to yes. If the primary key column is not part of your Data Block, then I suggest you add the PK column. If the table doesn't have a PK defined, then pick the column that is the most unique and designate it as the PK column in your form's data block.
              Could you tell me....where i can set the property.
              As I mentioned above, you set the Primary Key property on the correct Item in your Form's Data Block.

              Hope this helps,
              Craig...