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.
FND_STANDARD.FORM_INFO('$Revision: 120.0 $',
'Template Form', 'FND',
'$Date: 2012/12/07 11:02 $', '$Author: appldev $');
FRM-30100: Block must have at least one primary key item.
FRM-30087: Unable to create form file C:\Users\docs\Desktop\CTO Docs\R12\FORMS\CTOARCBP.fmx.
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,