This discussion is archived
2 Replies Latest reply: May 9, 2011 6:12 AM by 792754 RSS

:system.last_record in Oracle Apps Forms

Jegan Explorer
Currently Being Moderated
Hi all,

My requirement is when I give order number in header level in Oracle Apps Form, i want the lines to be displayed in lines block.

I have written the query and a cursor.

The Query returns 6 lines when passing the Order Number.

But when i use the following code in forms, the form returns only one line in the lines block.

BEGIN
first_record;
for i in xx_cur
loop
:REQUEST.CUSTOMER_NUMBER := i.party_number;
:REQUEST.CUSTOMER_NAME := i.party_name;

If :system.last_record = 'TRUE'
Then
Exit;
ELSE
next_record;
End if;
end loop;

END;

If i use the above code only the first line gets displayed in the form.

If i didnt use the system_last_record condition the 6 lines are displaying.
--If :system.last_record = 'TRUE'
--Then
--Exit;
--ELSE
next_record;
--End if;
end loop;

END;

Y the :system.last_record is not working.

Please help me to solve this issue.

Thanks in Advance,
Jegan
  • 1. Re: :system.last_record in Oracle Apps Forms
    860490 Newbie
    Currently Being Moderated
    Hi All, I have core i5 and Intel graphics with 1.3.1.21 jinitiator - making the java.exe compat with XP SP3 did the trick. How to do:- right click on the java.exe>properties for your version of jinit, this is found in bin directory. Example: C:\program files x86\Oracle\Jinitiator 1.3.1.21\bin, make compatible with XP Service pack 3. Brilliant no more refresh issues – perfect 
    All the best
    Glen Whelan
    whelan_glen@hotmail.com
  • 2. Re: :system.last_record in Oracle Apps Forms
    792754 Pro
    Currently Being Moderated
    i'm assuming this is a non-database block? if so, you don't need FIRST_RECORD and :SYSTEM.LAST_RECORD is always true ...
    try
    BEGIN
        FOR i IN xx_cur
        LOOP
            IF :request.customer_number IS NOT NULL THEN
               CREATE_RECORD;
            END IF;
               
            :request.customer_number := i.party_number;
            :request.customer_name := i.party_name;
    
        END LOOP;
    END;

Legend

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