2 Replies Latest reply: May 9, 2011 8:12 AM by 792754 RSS

    :system.last_record in Oracle Apps Forms

    Jegan
      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
          user12044936
          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
            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;