Total Pageviews

Friday, April 5, 2013


XML Publisher in Oracle Apps

  1. Drawbacks of Oracle Reports Layout design is Complicated.
  2. Normal text Output.
  3. The user cannot change output format (PDF, Excel, HTML, .rtf) at run time.

Difference Between Rdf report and XML Publisher?

         Oracle Report (.rdf)                   XML Publisher(11i) BI Publisher (R12)
1.  Develop .rdf file as per client           1. Develop .rdf report as per client
   Requirement                                      
Requirement
   a. Build Data modal(SQL Query)           a. Build Data modal(SQL Query)
   b. Deign Layout Model

2. Transfer .rdf file from local machine  2. Transfer .rdf file from local machine
    to server.                                         to server.

3. Define Executable.                         3. Define executable.

4. Define Concurrent Program.             4. Define Concurrent Program.

5. Attach Concurrent Program to          5. Attach Concurrent Program to
   the Request Group.                            the Request Group.

6. Run Concurrent Program through      6. Run Concurrent Program through
    SRS Window.                                    SRS Window. 
                                                       7. Download XML output to Local                                                               Machine.
                                                       8. Open Msword document and load
                                                           XML output and design layout and
                                                           save as ".rtf".                  

                                                       9. Register data definition using the
                                                           responsibility "XML publisher
                                                         Administrator"(code=CP Shortname).

                              
                                                       10. Register Template and upload .rtf
                                                            file using the responsibility
                                                            
"XML publisher Administrator".



Step1: Develop .rdf report

Open Report Builder --> Cancel

Create user parameter:
 Navigation: Data modal -> user parameter


click on create button --> 
     go to Property pallet rename to P_CONC_REQUEST_ID


go to report triggers F11 of Before report 

        SRW.USER_EXIT('FND SRWINIT');


click on compile button -> close inner window.


go to report trigger F11 of After report

     SRW.USER_EXIT('FND SRWEXIT');

click on compile button -> close inner window.


go to Data modal


 click on SQL place on Report editor.


select * from emp ->ok


give me user credentials  
user name: apps
password:  apps
host name: vis

save as "AVI_EMP_XML_REPORT.rdf".                                      
  
Step2: 
      Transfer file from local machine to server.


 Path: .../PO/11.5.0/reports/US




Step3: 
            Define Executable --> Executable Method (Oracle Reports).
 
Step4:   define Concurrent program 


                              output:
                                 format : XML
                                 Style:    A4


Step5: Attach Concurrent program to the Request Group.


Step6: click on Switch Responsibility button select Required Responsibility.

Step7:  Run Concurrent program through SRS window.

click on view output button
   file -> save as "AVI_EMP_XML_REP.xml"

save.

Step8:  Open msword document
          go to data --> load xml data --> select xml file --> click on open button --> ok.



Step9: Design layout insert all fields -> click on preview --> click pdf --> ok

           
         then save as     "AVI_EMP_XML_TEMPLATE.rtf"

Step10: Register data definition 


     Navigation: XML Publisher Administrator --> Home --> Data Definitions.

click on create data definition button --> Name: AVI_XML_DD
                                                      code: C.P short Name in upper case.


--> click on apply


--> copy name


select * from XDO_DS_DEFINITIONS_TL 
where  DATA_SOURCE_NAME='AVI_XML_DD'

Step11: define template and upload (.rdf) file.


Navigation: XML Publisher Administrator --> Home --> Templates
               
--> click on create template button.


Name: AVI_XML_TEMPLATE
Code:  AVI_EMP_XML_REPORT


Application: purchasing --> Data Definition: Data definition name


select type as .rtf
default output type pdf.


click on browse button select .rtf file --> click on open


--> select language as English
territory: United States

--> click on apply button --> copy name

select * from XDO_TEMPLATE_TL
where ='AVI_XML_TEMPLATE'

go to switched to required responsibility --> Run Concurrent Program. 

No comments:

Post a Comment