Welcome Guest Login SignUp

Home

Technical

Functional

CNC

AS400

DB2

    Citrix

JDE News

Live Radio

Feedback

JDE Forum Comments/Reviews/Queries
1766 day(s) ago   #202
Name: Nick
Category: Technical
Location: Singapore
Date: 2015-07-30 22:37:29
Replies(1)

Status:
  #202

Using XML Publisher in JDE EnterpriseOne

From tool release 8.97 onwards, Oracle has embedded the XML Publisher into JDE.
This is a big improvement to the existing JDE reporting tool.

Oracle has a product called BI Publisher (formerly know as XML Publisher), it can be standalone or server running on OAS. The XML Publisher in JDE used the same methodology (so called embedded), without the need to install the BI Publisher. The BI Publisher becoming the Oracle de-facto reporting technology for all the applications under the Fusion technology stacks.

Two new objects type for XML Publisher, RPDF and XMLP
- Report Definition: define the link to existing UBE report and version, define the output document type and delivery method. It can contains multiple XML Publisher objects (template). (One time printing that output to few different reports format but with same set of data)
- XML Publisher Object: The template created using Ms.Word (RTF format), require install the XML Publisher Desktop (plugin for Ms.Word). It acts similar to Mail Merge, the different is where it pulls the data from.

XML Publisher related application
The program used to define the XML Publisher Object is P95600.
The program used to define the Report Defination is P95620.
The program that view the Report Defination output is P95630.
The P986116`s exit bar has added few links to view the RD source (XML file), RD output, etc.

Application Server JDE.INI
New kernel for XML Publisher service:-
[JDENET_KERNEL_DEF31]
krnlName=XMLPUBLISHER KERNEL
dispatchDLLName=xmlpublisher.dll
dispatchDLLFunction=_XMLPDispatch@28
maxNumberOfProcesses=5
numberOfAutoStartProcesses=0


How it works
  1. Identify the UBE to use. It can be a simple report with columnar section that contains all the require fields.
  2. Create the XML Publisher Object using P95600 or OMW (records are stored in control tables, same to Solution Explorer), and upload the blank RTF document. (created using Ms.Word)
  3. Create the Report Definition. Here enter the UBE name and version(can leave blank and choose when print), the XML Publisher Object that created, output document type, and delivery method, either enter the AB number (system will get the email address in Address book), or enter a email address, or a group of email address.
  4. Submit the Report Definition to print.
  5. View the Report Definition Source. Save the XML file. (to be use as sample data when authoring the template)
  6. Open the blank template (RTF format), load the XML file, and start authoring the document to the desire format. (just like mail merge)
  7. Re-upload the completed RTF file using P95600.
  8. Submit the Report Definition to print, view the output.

The P95600, P95620 and P95630 can be run using web client, therefore, development workstation is an optional here.
1205 day(s) ago   #253
Name: Willsqualge
Category: Technical
Location:
Date: 2017-02-10 00:50:24
Replies(1)

Status:
  #253

Using XML Publisher in JDE EnterpriseOne

Metronidazole For Purchase
Post Comments/Queries
Email:*
Name:*
Details:*
 
   
* Required Entry Field(s).  * Your comments may subject to varification.  * Your email ID will not appear in the forum.
 
Disclaimer: Most of the posts in this blog cater solutions/suggestions/workaround to issues for specific tools release or JDE E1 version and are just information only. Please be carefule while applying it in your environment. JDEthread will not be responsible for any data loss or spec corruption (if any).
Copyright © 2010 - 2020 JDEthread.in