Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Save only changed records in Forms 6i

804891Nov 16 2010 — edited Nov 22 2010
I am using Oracle Forms 6i in Oracle EBS 11.5.10. Say I have 1000 records displayed in detail block. For some records I change the quantity field for some I will not, it will be NULL. When I press the Execute button I am calling an API, passing required fields and API saves the records.

currently, I am using this method to do that.

lb_result := TRUE ;
li_currec := 1;

GO_BLOCK('DETAIL');
first_record ;
lv_isLastRecord := 'N' ;

IF :detail.qty IS NOT NULL
THEN
CALL API.......
ELSE
NULL;

EXIT WHEN :SYSTEM.last_record = 'TRUE';
li_currec := li_currec + 1 ;
next_record;

This works but Form is taking lot of time to do this.

My question is how can I figure out only changed records
(Qty changed) in form and only call the API for those records. Can I use :System.record_status='CHANGED'? Or is there any better way to do than my method.

Please Help.Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2010
Added on Nov 16 2010
7 comments
5,023 views