XML Publisher

How to Develop XML Publisher Report (XMLP) or BI Publisher Reports

hey Guys Now adays BI Publisher is in Boom technology formally it know as XMLP means XML Publisher.
We can develop this by using following steps:

1)Develop the Report(.rdf) Only DataModel

2)Save the report and Compoile and Generate the data in .xml
           Format File=>Generate to File => XML

3)Open the Ms-Word document Design the Layout include the follwing Tool Bar options called Form and Templete builder

4)Define the Table and Specify the Titles and Labels whatever we would like to print

5)Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax : Here G_USER_ID is Group name from .rdf Data Model Note: It means Indirectley Repeating Frame starting

6)Define the Fields which we would like to display Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax ?
Note: Define all the fields like this

7)We have to close the Repeating Frame (For each Loop) Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax

8)Save the document in .rtf(Rich Text File format)

9)Load the .xml file data and generate the Output in pdf Format Data=>Load XMl Data=>Load the .xml File=>Once Data is Loaded succesfully

10)Generate the Preview as per this Preview=>PDF

Registering in Apps

1)Develop the .rdf file and .rtf file

2)Register both .rdf and .rtf file


.rdf File Registration

1)Move the .rdf file into CUS_TOP\11.5.0\Reports\US

2)Create Execuiteable

Concurrent Program Output = XML

Request Group

Responsibility

User

SRS

3)Copy the Concurrent Program Short name .rtf File


RTF Registration:

1)Goto the XML Publisher Administrator Responsibility

2) Creation of Data Defination
Select Data Definations form Enter Data Defination

Name = Enter Any Name

Code = Concurrent Program Short Name

Application = Any application

startdate = Current Date

3)Copy the DataDefination name we have to add this to the Templete

4)Creation of Template form

Open the Templete Form

Enter Templete Name : Any Name

DataDefination : enter data defination whatever we have created

Code : Concurrent Program Short Name

Type : rtf

application : any Application

File : Upload the .rtf file

Laguage : English

Territory : United States

5)Select Apply button

After register the .rtf file submit concurrent Program from SRS window system will automatically pick the .rtf file and generates the Output.

If we want to customze the .rtf file we have to download by using templete , Customize thenupload the .rtf templeteme, a.sal, b.sal, b.empno, b.ename from emp a, emp b where a.mgr=b.empno and a.sal>b.sal

Steps to create a XML Publisher Report

1] Add the “Xml Publisher Administrator” Responsibility to the user through the front end.
2] Create the Report(Data Model or we can say the .Rdf file) using Oracle Report Builder.
3] Set the user parameter as p_conc_request_id.
4] Add the default values to the Before Report and After Report triggers(not mandatory)
5] Ftp the Report to the Cust_Top/Report/Us.
6] Open the Oracle E-Business Suite then go to Sysadmin>Concurrent>Program>Executables, Here we have to create one executable file for that Rdf.
7] Then go to Sysadmin>Concurrent>Program>Define, Here we have to make a Concurrent Program for that Executable. Make sure that the output format must be XML.
8] Goto the Sysadmin>Security>Responsibility>Define. Query for the Xml Publisher Administrator. See the Request Group attached to this. Attach the Concurrent Program to this Request Group.
9] Design the template in Ms Word(Using the .Rtf file).
10] Goto responsibility XML PUBLISHER ADMINISTRATOR. Then Goto HOME>DATA DEFINITION>CREATE DATA DEFINITION and create a new data definition. Make sure that your Data Definition’s Code should be same as Concurrent Program’s Short Name used by you to create the Rdf file.
11] Now go to Xml publisher administrator>Home>Template. Create a new template with template type=’Rtf’. Then upload the RTF File by browsing the path.
12] Now go to the Responsibility and run the request.

Setting the Password for PDF File sent through XML Publisher

Open the rtf for which you want to set password and do the following things

1) Open the .rtf
2) Go to File - > Properties
Create a new custom property
a) Name : xdo-pdf-open-password
Type : text
Value : Either Hard Code the value / or get the value for xml data
b) Name : xdo-pdf-security
Type : text
Value : true

Note : property name should always start with xdo- .

Helpful Queries For XML PUBLISHER

/***********CODE TO DELETE XML TEMPLATE***************/

BEGIN
DBMS_OUTPUT.PUT_LINE('INSIDE BEGIN');
xdo_templates_pkg.DELETE_ROW (
X_APPLICATION_SHORT_NAME => 'XX',
X_TEMPLATE_CODE => 'XXRSDWIPSR-P'
) ;
DBMS_OUTPUT.PUT_LINE('DELETE SUCCESSFULL');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('EXCEPTION CAUGHT');
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;

/***********CODE TO DELETE XML DATA DEFINITION *******************/

BEGIN
DBMS_OUTPUT.PUT_LINE('INSIDE BEGIN');
XDO_DS_DEFINITIONS_PKG.DELETE_ROW (
X_APPLICATION_SHORT_NAME => 'XX',
X_DATA_SOURCE_CODE => 'XXRSDWIPSR-P'
);
DBMS_OUTPUT.PUT_LINE('DELETE SUCCESSFULL');
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('EXCEPTION CAUGHT');
DBMS_OUTPUT.PUT_LINE(SQLERRM);
END;

/******************* DELETING TEMPLATES AND FILES ********************/

SELECT * FROM XDO_LOBS WHERE LOB_CODE = 'XXRSDWIPSR-P';

DELETE FROM XDO_LOBS
WHERE LOB_TYPE = 'TEMPLATE_SOURCE'
AND APPLICATION_SHORT_NAME = 'XX'
AND LOB_CODE = 'XXRSDWIPSR-P'
AND FILE_NAME = 'XX_PICK_SLIP_REPORT_PARENT.rtf'

DELETE FROM XDO_LOBS
WHERE LOB_TYPE = 'TEMPLATE'
AND APPLICATION_SHORT_NAME = 'XX'
AND LOB_CODE = 'XXRSDWIPSR-P'
AND FILE_NAME = 'XX_PICK_SLIP_REPORT_PARENT.xsl'




/************** ADDING LAYOUT TO A REQUEST FROM BACKEND ************/

ln_layout := fnd_request.add_layout (template_appl_name => 'SQLAP',
template_code => 'XXRPGICICIEFT',
template_language => 'en',
template_territory => 'US',
output_format => 'EXCEL');