Printing Multiple Copies of same output in XML Publisher

Let us assume that client required 4 copies of Report output.

Following is the Work around.

1. Create a new Lookup type.

Navigation: Application Developer Responsibility -> Application -> Lookups -> Application Object library.

Lookup type name is 'REPORT COPIES' and enter the details like below.

2. Use fnd_lookup_values_vl table in the Oracle Reports data model query group. It will create Cartesian product.

Add the following two conditions at the Where clause section.

AND flvv.lookup_type ='REPORT COPIES'

AND flvv.ENABLED_FLAG = 'Y'

3. Order by flvv.MEANING