Generating report using Java Concurrent Program

While browsing through a standard Cocurrent program, found a interesting and unusual way of generating report using Java Concurrent program.

Program Name : CLE: AP Purchasing Ledger Report
Short Name : CLEF224PVR
Java code called : JCP4XDODataEngine.java
Data template attached in Data Definition : CLEF224PVR.xml
RTF Template representing the design : CLEF224PVR.rtf

The java program calls the data template which has the main SQL query. This file is a xml file and it internally also refers to database package. Later this is processed with RTF template to generate the output. Besides check out the java program to know how to write into log file and access concurrent program parameters and other context values.

XML Publisher - Developing reports printed on Pre-Printed Stationary

Click on this beautiful article by Mr Darshan Bhavsar, explaining how to develop XML Publisher Reports to be printed on Pre-Printed Stationary.

XML Publisher Configuration File

•Customize the behavior of XML Publisher by setting properties in a configuration file.
•The configuration file is optional.
• No default configuration file is provided.
•The file is primarily used for: Setting properties for PDF, RTF, and HTML o/pSetting PDF security propertiesSetting font locations and substitutions Setting translation properties

Filename: xdo.cfg.
Location: /jre/lib

XML Publisher Tags

1. Sort Tag :> "sort:VOUCHER_NUM;'ascending';data-type='number'"

2. Row Column Highlighting :> "if@row:position() mod 2=0"

3. Creation of page total Elements : "add-page-total:TotalFieldName;'element'"

4. Displaying Page Total: "show-page-total:TotalFieldName;'Oracle-number-format'"

5. Re grouping: "for-each-group:BASE Group;Grouping Element" , "for-each:current-group(); GROUPING-ELEMENT"

6. Last Page Only : "start@last-page:body" "end body"

7. Variable Declaration : :variable name="lpp" select="number(5)"

8. Assigning Value to Variable : "xdoxslt:set_variable($_XDOCTX, 'variable name', value)"

9. Get Value from Variable : "xdoxslt:get_variable($_XDOCTX, 'variable name')"

10. MICR font can be linked by moving it to a UNIX directory and referencing the location in the Template

11. Extended SQL and XSL Functions : xdofx:expression

12. Dynamic Data Column header : split-column-header:group element name

13 Dynamic Data Column Data : split-column-data:group element name

For reference go through link

http://blogs.oracle.com/xmlpublisher/

http://www.scribd.com/doc/210892/XML-Publisher-17th-July-07

XML Data : loading xml data into xml table and retrieving the same

LOAD DATA
INFILE *
INTO TABLE po_tab
APPEND
XMLTYPE (xmldata)
FIELDS
(xmldata CHAR(2000))

create table abc (a xmltype)

select * from abc

insert into abc values (xmltype('234tt'))

select extractvalue(a,'/st/b') "aaa" from abc

How to Submit A XML Publisher Report from Script

Follow the steps to Submit A XML Publisher Report from Script

1. Select and assign the layout before submitting the request as below.
l_attached := fnd_request.add_layout ( template_appl_name => 'XXXX'
,template_code => 'MFG_LABEL_PRN'
,template_language => 'US'
,template_territory => 'en'
,output_format => 'PDF'
);

2. Call the Submit_Request API next.
ln_req_id := fnd_request.submit_request (
'mfg', 'MFG_LABEL_PRN ', 'MFG Label', TO_CHAR(SYSDATE), TRUE);

XML Publisher Coooool Links

Some links of XML Publisher

Click here

How to find XML Publisher Version

Two ways to find XML Publisher versions.

Easy Way : After the output of the report is generated, open the output document file. Go to properties and the version will be visible at that point.

Harder Way : Log in to the server and open for the file MetaInfo.class using more command. This file is available at the following location :
$OA_JAVA/oracle/apps/xdo/common/MetaInfo.class