How to manage empty last page when there is not enough space to print the footer

Question

Hello guys

Currently we are developing RTF templates to use with Oracle EBS R12 12.2 instance, to address a government requirement to show Arabic labels on all documents given out to customers (Sales Order invoices, delivery notes…)

We've already achieved a major part of it, however having a minor issue when the current page doesn't have enough space to print the footer that has all the vital details like invoice totals, terms and conditions etc. This forces a new page, having only the footer printed in the last page. Is there way we could assess whether the current page has enough room for the footer, else, insert a page break manually so that last one or two rows of data prints on a new page along with the footer information?

Thanks in advance!

rthampi · Answer

Hi Rajasekhar

The documentation doesn't satisfy my query. My requirement is bit complex. We are printing the sales invoices showing the descriptions for the items, and the descriptions are not of standard length and the sales department wants to show the entire description for the item on printed document.

Here item A could have a short description like "BELT A Size 1" while item B could be "This items uses a long description with model number and other vital information". This makes the description cell to dynamically stretch vertically and there are few instances when the report engine is forced to insert a page break because after the last item, there is not enough room left for the footer to be printed. Please check the attached image(s).

First page is printing all the items that were invoiced, without having room for the footer. This happens only to few invoices, however, makes the customers bit of upset. Is it possible to know the available print region before hand and if it falls beyond couple of inches, to trigger a page break?

Rajasekhar Bandaru-Oracle · Answer

Hi

Please review the given help center documentation link about RTF(Define Headers and Footers).

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/define-headers-and-footers.html#GUID-2822BE14-49B7-42E9-AA52-8284D5BD8E4E