This discussion is archived
3 Replies Latest reply: Dec 11, 2012 8:15 AM by CraigB RSS

Forms migration error from 11.5.10 to R12

968711 Newbie
Currently Being Moderated
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
    user34800 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Could you tell me....where i can set the property.
  • 3. Re: Forms migration error from 11.5.10 to R12
    CraigB Guru
    Currently Being Moderated
    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 EBS General 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...

Legend

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