--Developed By Sainaatth--
XML Publisher Reports :
----------------------------
-- Is a Template based solustion for Oracle Reports
-- Template based Reporting Tool
-- This is an Independent (Not depend on any Code)
Depency on .xml data file
-- template builder to add add-ins
we can generate the .xml data file using many methods.
1. Using .rdf
2. PLSQL Method
3. Data Templates / BI
4. HTML Commands
5. Note pad Methods
6. PDF Method
Process :
-----------
1. We have to generate the .xml data file
2. Use the file as input source to the LayOut
(Layout will be designed in the MS Word -> .rtf)
3. Will see the Output in required format
Process : (Registration) (Using .rdf)
----------
1. We have to develope the .rdf by placing our code in Data Model
(i.e., No need to design the Lay Out in .rdf)
2. Move the .rdf file in to server ($Custom_TOP/reports/US/)
3. Login to Applications
Go to System Administrator to create Executable
Create Concurrent Program by attaching the Executable
** Concurrent Program Output method should be XML
4. Add the Conc Program to the Request Group
Navigate the Responsibility, Submit the Request
Get the xml data file.
5. Design the Layout in MS Word by using the .xml data file as source
6. Save the File as .rtf (Rich Text Format)
7. Go to XML Publisher Administrator Responsibility to create Data Definition
While creating Data Definition,
we have to give Conc Program Short Name to the "Code" Field.
8. Create Template by giving the Data Definition Details
and Attach the .rtf file
Diff. b/n .rdf and .rtf :
--------------------------
RDF RTF
----- -----
1. Layout Model is dependent on |1. Layout Model is independent
Data model Code | (It will look for .xml data file)
2. We can see output in one |2. can see the output in different output
format (by default) | formats
System parameters
3. we can not use SQL Functions | 3. We can use SQL Functions at Source
in rdf Lay out source field field define level
define level
4. Only one Layout will be there | 4. we can define multiple .rtf files
(Multiple .rtf files can be attached
against to the Single Template)
(while submitting the conc prog
we have to select the .rtf file)
5. Not User Friendly | 5. User Friendly
AP Invoice Report Using .rdf Method :
--------------------------------------------
OU Name Invoice Number Invoice Type Supplier Name Supp Site
Invoice Amount
Parameter :
--------------
* OU Name
Supplier Name
Query :
---------
SELECT HOU.NAME OU_NAME,
AIA.INVOICE_NUM,
AIA.INVOICE_TYPE_LOOKUP_CODE,
APS.VENDOR_NAME,
ASSA.VENDOR_SITE_CODE,
AIA.INVOICE_AMOUNT
FROM HR_OPERATING_UNITS HOU,
AP_INVOICES_ALL AIA,
AP_SUPPLIERS APS,
AP_SUPPLIER_SITES_ALL ASSA
WHERE 1=1
AND HOU.ORGANIZATION_ID = AIA.ORG_ID
AND AIA.VENDOR_ID = APS.VENDOR_ID
AND APS.VENDOR_ID = ASSA.VENDOR_ID
AND ASSA.VENDOR_SITE_ID = AIA.VENDOR_SITE_ID
AND ASSA.ORG_ID = HOU.ORGANIZATION_ID
AND ORGANIZATION_ID = :P_ORG_ID
AND AIA.VENDOR_ID = NVL(:P_VENDOR_ID, AIA.VENDOR_ID);
XML Publisher Reports :
----------------------------
-- Is a Template based solustion for Oracle Reports
-- Template based Reporting Tool
-- This is an Independent (Not depend on any Code)
Depency on .xml data file
-- template builder to add add-ins
we can generate the .xml data file using many methods.
1. Using .rdf
2. PLSQL Method
3. Data Templates / BI
4. HTML Commands
5. Note pad Methods
6. PDF Method
Process :
-----------
1. We have to generate the .xml data file
2. Use the file as input source to the LayOut
(Layout will be designed in the MS Word -> .rtf)
3. Will see the Output in required format
Process : (Registration) (Using .rdf)
----------
1. We have to develope the .rdf by placing our code in Data Model
(i.e., No need to design the Lay Out in .rdf)
2. Move the .rdf file in to server ($Custom_TOP/reports/US/)
3. Login to Applications
Go to System Administrator to create Executable
Create Concurrent Program by attaching the Executable
** Concurrent Program Output method should be XML
4. Add the Conc Program to the Request Group
Navigate the Responsibility, Submit the Request
Get the xml data file.
5. Design the Layout in MS Word by using the .xml data file as source
6. Save the File as .rtf (Rich Text Format)
7. Go to XML Publisher Administrator Responsibility to create Data Definition
While creating Data Definition,
we have to give Conc Program Short Name to the "Code" Field.
8. Create Template by giving the Data Definition Details
and Attach the .rtf file
Diff. b/n .rdf and .rtf :
--------------------------
RDF RTF
----- -----
1. Layout Model is dependent on |1. Layout Model is independent
Data model Code | (It will look for .xml data file)
2. We can see output in one |2. can see the output in different output
format (by default) | formats
System parameters
3. we can not use SQL Functions | 3. We can use SQL Functions at Source
in rdf Lay out source field field define level
define level
4. Only one Layout will be there | 4. we can define multiple .rtf files
(Multiple .rtf files can be attached
against to the Single Template)
(while submitting the conc prog
we have to select the .rtf file)
5. Not User Friendly | 5. User Friendly
AP Invoice Report Using .rdf Method :
--------------------------------------------
OU Name Invoice Number Invoice Type Supplier Name Supp Site
Invoice Amount
Parameter :
--------------
* OU Name
Supplier Name
Query :
---------
SELECT HOU.NAME OU_NAME,
AIA.INVOICE_NUM,
AIA.INVOICE_TYPE_LOOKUP_CODE,
APS.VENDOR_NAME,
ASSA.VENDOR_SITE_CODE,
AIA.INVOICE_AMOUNT
FROM HR_OPERATING_UNITS HOU,
AP_INVOICES_ALL AIA,
AP_SUPPLIERS APS,
AP_SUPPLIER_SITES_ALL ASSA
WHERE 1=1
AND HOU.ORGANIZATION_ID = AIA.ORG_ID
AND AIA.VENDOR_ID = APS.VENDOR_ID
AND APS.VENDOR_ID = ASSA.VENDOR_ID
AND ASSA.VENDOR_SITE_ID = AIA.VENDOR_SITE_ID
AND ASSA.ORG_ID = HOU.ORGANIZATION_ID
AND ORGANIZATION_ID = :P_ORG_ID
AND AIA.VENDOR_ID = NVL(:P_VENDOR_ID, AIA.VENDOR_ID);
No comments:
Post a Comment