My Oracle Support Banner

E1: XMLP: Creating XML Publisher Reports Using Excel Templates (Doc ID 1326347.1)

Last updated on SEPTEMBER 25, 2024

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.97 and Prior and later
Information in this document applies to any platform.

Purpose

An Excel template is a report layout that you design in Microsoft Excel for retrieving and formatting your enterprise reporting data in Excel. Excel templates provide a set of special features for mapping data to worksheets and for performing additional processing to control how your data is output to Excel workbooks.

This document describes how XML/BI Publisher reports can be created using Excel Templates. It provides information on any special settings needed in EnterpriseOne to use Excel Templates.

Scope

 This document is intended for JDE report definition developers who wish to use excel templates to get excel outputs from Embedded BI Publisher Reports. 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Overview
 Features of Excel Templates
 Limitations of Excel Templates
 Prerequisites
 Supported Output
 Desktop Tools
 Concepts
 Identifying Data Field Placeholders and Groups
 Use of Excel Defined Names
 About XDO_ Defined Names
 Using Native Excel Functions
 About XDO_METADATA Sheet
 Building a Simple Template
 P95600 Add BI Publisher Object To Repository
 E1 UDC Codes needed for Excel Templates
 Sample E1 Excel Template created from R014021
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.