BI Publisher PDF Templates

BI Publisher can populate PDF Forms with information from your database. Some of these forms are business or industry related while many of them are official government forms.
BI Publisher enables your system to populate data on the actual PDF form instead of creating and maintaining a separate, custom versions of that form as an RTF template. The savings in time and resources can be enormous.
BI Publisher PDF Template Documentation
Oracle Middleware: docs.oracle.com/middleware/12...
PeopleBooks: docs.oracle.com/cd/F70249_01/...
Jump to specific sections:
00:00 Intro
00:12 What is a PDF Template
00:25 Why use a PDF Template?
01:16 Build Steps
02:02 PDF Template Tools
02:36 OPM 71 Example
03:40 Intro to the OPM 71
04:36 Optmize the PDF
05:39 Prepare the PDF
06:59 Development Test Tool
08:03 PeopleTools BIP Data Source
08:17 PeopleTools BIP Report Definiion
09:00 Map Name to an existing field
10:28 Map to a new Text Field
11:45 Check Boxes
14:12 Date Fields
15:21 Number Fields
16:32 Long Text Feilds
18:15 Finish - PeopleTools BIP Report Definition
19:05 Invoke BIP Report from the PeopleTools Page
19:25 Extro
Adobe Acrobat Pro: www.adobe.com/acrobat/free-tr...
CZcams link: • BI Publisher Pivot Tables
PeopleTools Tech Tips: peopletoolstechtips.com/bi-pu...
Github: github.com/PeopleToolsTechTip...
Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki
Music: Vlad Gluschenko - Overseas
License: CC BY 3.0: creativecommons.org/licenses/...
/ @vladgluschenkomusic

[@HarikaKadali-ox7vp]

In Video there is no looping/repeating condition added but still we are getting repeating fields (Employee Name) is repeating handled in any other way ?

[@PeopleToolsTechTips]

A challenge with PDF templates is that we have to work with a defined, fixed space as apposed to RTF templates where we can loop forever and let the document page break. Try and put too much into a PDF field and the data just gets cut off.
I handle looping in PDF templates in my XML file.
if there is a grid on the PDF document, I assign a unique XML tag to each cell of the grid.
The rules of many government forms with too much data for one field is to either attach an addendum page at the end of add another copy of the same form with the overflow data in the same field of the next page. This is handled in the XML file creation, not the template.
With the use of an addendum page, you may want to make that a separate report and do a PDF Join afterward.
In the case of a milt-page report where one page may be inserted multiple times for large data sets, create that page separately and PDF join afterwards.

[@amankumarshaw5407]

is it not possible to add signatures to it?

[@PeopleToolsTechTips]

How do you mean signatures? I don't think you can add document signatures such as DocuSign or Adobe e-sign since we need to strip down the templates to Acrobat 5.0.
However, if the user already electronically signed in PeopleSoft, you may be able to represent that signature with an image on the printed PDF