This content has been marked as final. Show 3 replies
you need to set property(Primary key) of an item(or a set of items) of the block(CTOAR_CASHBOOK_PARAMETERS1 person found this helpful
) to yes.
Could you tell me....where i can set the property.
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,