1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Paper layout without footer(oracle Report )

Discussion in 'Oracle Apps Technical' started by neelambhumij, Jan 23, 2014.

  1. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi All

    I have an issue with a .rdf report. I need to customize it and I am unable to cuomize the footer note.
    Actually the paper layout is not showing any footer note .. so unable to find where to customize it.


    The attached image will show the footer note. Please suggest possible ways of where to change it.


    Thanx

    Many Regards
    Neelam
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Generally footer notes are displaying trailer section in rdf. Go to layout and click on trailer section icon, there you can see the footer notes.
     
  3. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi

    Thanx for the reply.
    But unfortunattely there is nothing in the trailer section of paper layout. Any other sugession plz.

    Thanx
    Kind Regards
    Neelam
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi can you send me the rdf?
     
  5. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi

    Please Find the attachment.


    thanx

    Kind Regards
    Neelam
     

    Attached Files:

  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Neelam in Main Section click on Edit Margin and come down there you can see that part
     
  7. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi Jagadekara

    Sorry I am bit confuse about how to edit it..
    I only found this code..

    function M_2FormatTrigger return boolean is

    l_page_number Number := 0;


    begin

    srw.get_page_num(l_page_number);
    --srw.message (100,'Data count is ' || :CP_Data_COUNT);

    IF nvl:)CP_Data_COUNT,0) = 0
    THEN
    RETURN (FALSE);
    ELSE
    IF (MOD:)CP_Data_COUNT,16) = 0 AND TRUNC(:)CP_Data_COUNT/16)) = l_page_number)
    THEN
    RETURN (TRUE);
    ELSE
    IF (MOD:)CP_Data_COUNT,16) > 0 AND TRUNC(:)CP_Data_COUNT/16)) = l_page_number - 1 )
    THEN
    RETURN (TRUE);
    ELSE
    RETURN(FALSE);
    END IF;
    END IF;
    END IF;

    end;


    Thanx
     
  8. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Just click on layout in that click on Edit margin icon, then scroll down there you can see below
    footer note.

    Claims for Shortages, Discrepancies and / or Damage must be submitted in writing to BATEMAN, and will be accepted no later than 7 (seven) days after the date of this document. Goods supplied to order and returned will be subject to a handling charge. Bateman Standard Terms & Conditions of Sale apply. Available on Request.

    Here what you want modify?
     
    neelambhumij likes this.
  9. neelambhumij

    neelambhumij Active Member

    Messages:
    51
    Likes Received:
    2
    Trophy Points:
    160
    Location:
    JOHANNESBURG
    Hi Jagadekara

    Thanx so much. I finally got it.
    It is a very initial step of mine in oracle ebs and i really appreciate your help.

    Thanx

    Kind Regards
    Neelam