Sub-Template in Oracle Fusion

For creating the Sub Template in Oracle Fusion follow below steps:

Step 1: Login to Oracle Fusion Instance.

Step 2: Navigate to Catalog page using the Navigation, Navigator — Reports and Analytics — Browse Catalog.

Step 3: Create the Data Model. For creating the Data Model follow bellow steps,

Step 3A: On catalog page Go To — New — Data Model.

Step 3B: On Data Model screen create the new Data Set by clicking on the Plus icon(+).

Step 3C: Give the Name for the Data Set and select the respective data source.

Step 3D: Write the query in the query block and click on OK button. You can use below query.

SELECT

a.po_header_id Po_header,

b.po_header_id,

b.po_line_id,

b.item_id,

b.unit_price,

b.quantity,

b.base_unit_price

FROM

po_headers_all a,

po_lines_all b

WHERE

a.po_header_id = b.po_header_id

AND a.segment1 = 162352

Step 3F: Now save the Data Model. You can save the Data Model to My Folder or Shared Folder anywhere as per your requirement.

Step 4: Now we have to create the Layout, for that follow bellow steps,

Step 4A: For Creating the layout you can click on Create Layout button which is on the Data Model page or you can go by using navigation New — Report from the catalog page.

Step 4B: In top left corner we have option to upload the Data Model. Upload the Data Model there by browsing it.

Step 4C: Now click on Generate RTF layout based on selected Data Model Button.

Step 4D: After this step the RTF fill will get created automatically.

Step 4E: Now save the Layout at the same location where we had save the Data Model.

Step 5: We had done with the report creation now we have to create the sub-template, for that follow below steps.

Step 5A: We will call the logo from sub template on main template for that create the sub template with below format.

 < ?Template:ORACLE? >

 {LOGO_IMAGE}

 < ?end template? >

 

4. Upload the subtemplate to oracle fusion instance.

5. Download Main template on local Machine and call the subtemplate.

 Syntax to import the sub-template:

  <?import:xdoxsl:///path_of_sub_template/sub_template_name.xsb?>

 E.g: <?import:xdoxsl:///Custom/Test/SubTemplate.xsb? > 

 Syntax to call the template:

  <?call-template:template_name?> 

  Eg: <?call-template:ORACLE?> 

6. Upload the Main Template in Oracle Fusion Instance.

7. Run the report and validate the output.