Custom variables in RTF template in XML

Custom variables in RTF template

Custom variables in RTF template is nothing but declaring a variable in one group and using that variable in another group which is shown below.Our RTF looks

XML output for above RTF is

Here we are going to declare one custom variable in parent group by taking one form filed which is shown below

Now add one more column to the RTF for displaying running totals as shown below.

Place the cursor in Inv_Amt column Right click to create one more column.

Click ok.

Do the same step to create one more cell .

Give the name of the column and take one form field which is shown below

Click ok.

Now our RTF looks

Now we have to publish the report

Click on Template Builder => Preview => HTML/PDF/Excel/RTF (any format).

We can get below output

Page breaks in XML

Page breaks

Here we are using the template which we had used in the lesson Understanding XML and identifying Groups of repeating elements.

Our RTF looks

If we execute the above RTF or publish the above report we can see below output

By seeing above output we can say that All Vendors Invoices is coming one after the other in the same page.

If we want to display each vendor invoices in each page and another vendor invoices in the next page then we can go to page break.

Syntax for page break is: -

<?split-by-page-break:?>

We should have to use the page break before closing the parent group which is shown below.

For that we have to place one form field before parent group which is shown below

Provide proper default text and in the Add Help Text we are going to write below command

<?split-by-page-break:?>

Which is shown below

Click on ‘OK’.

Now we have to publish the report

Click on Template Builder => Preview => HTML/PDF/Excel/RTF (any format).

We can get below output

From the above output we can see that only one vendor invoices got in the output.

In the Next page

From the above output we can say that another vendor invoice output in the next page.

In this way we can use page break

Displaying Page Totals

Displaying Page Totals

Displaying Page Totals

XML Publisher allows you to display calculated page totals in your report. Because the page is not created until publishing time, the totaling function must be executed by the formatting engine.

Note: Page totaling is performed in the PDF-formatting layer. Therefore this feature is not available for other outputs types: HTML, RTF, Excel. Because the page total field does not exist in the XML input data, you must define a variable to hold the value. When you define the variable, you associate it with the element from the XML file that is to be totaled for the page. Once you define total fields, you can also perform additional functions on the data in those fields. To declare the variable that is to hold your page total, insert the following syntax immediately following the placeholder for the element that is to be totaled:

<?add-page-total:TotalFieldName;’element’?>

where TotalFieldName is the name you assign to your total (to reference later) and

’element’ is the XML element field to be totaled. You can add this syntax to as many fields as you want to total. Then when you want to display the total field, enter the following syntax:

<?show-page-total:TotalFieldName;’number-format’?>

where TotalFieldName is the name you assigned to give the page total field above and

number-format is the format you wish to use to for the display. The following example shows how to set up page total fields in a template to display total credits and debits that have displayed on the page, and then calculate the net of the two fields.

Here we are going to take same RTF which is shown below

This example uses the following XML:

Now we are going to take one field in Inv_Amt which is shown below

Give double click on the field and Provide proper default text and in Add Help Text and in that we are going to write below command

<?add-page-total:pagetot;’INVOICE_AMOUNT’?>

Which is shown below

Now we have to display this pagetot(total field name) by using below syntax: -

<?show-page-total:TotalFieldName;’number-format’?>

Example: -<?show-page-total:pagetot;’999G999D99’?>

For that we have to place one form field which is shown below

Provide proper default text and in Add Help Text we are going to write below code which is shown below

<?show-page-total:pagetot;’999G999D99’?>

Now our RTF looks

Now we have to publish the report

Click on Template Builder => Preview => HTML/PDF/Excel/RTF (any format).

We can get below output

From the above output we can see that page total. If there is two or more pages then we can see page total for every page.

Oracle Apps Fresher Interview Questions

1. Which modules you trained in oracle apps?

A: Financial modules : AP,AR,GL

         SCM Modules : PO,OM,INV

2.Which reports you've done? 

i. Stack Summary Report

ii.Return to Vendor Reprot

iii.Goods Receipt Note (GRN)

iv.Approved Requisition Report

v.Back Order Report

vi.GL Report

vii.Sales OrderReport.

viii.Vendorwise PO Approved Report

ix.AR Receipt Information Report.

3.Which Interfaces have you done?

AP Interface

PO Interface

GL Interface

4.What is Interface?

Interface is the process of transferring data from one system to another system.

5.what is the use of Inbound Interface?

It is used to transfer the data from legacy system to oracle applications.

6.Explain about AP Interface?

Client give us data file

Then we have design 2  temporary staging tables one for invoices and another one for invoices lines.

Then we dump the data from data/f lat file to staging tables through SQL *loader.

Then we will create one Package with 2 procedures, In that we create 2 cursors one for invoices and another one for invoices lines.

Take 2 variables and validate mandatory columns and send data into variables.

Then insert the data into  Interface tables.

Run Standard Concurrent Program "Payables Open Interface Import " through SRS window.

Then finally we will see data in base tables.

7.What are mandatory columns in AP Interface?

Invoice Header level.

Operating Unit, Vendor, Invoice Number, Vendor Site, Invoice type, Invoice amount, Invoice Date, Invoice Source

Invoice Line Level.

Invoice line Type, Account, Line Number, Line Amount.

8.Which tables did you used in AP Interface?

Interface Tables :

AP_INVOICES_INTERFACE

AP_INVOICE_LINES_INTERFACE

AP_INTERFACE_REJECTIONS

Base Tables :

AP_INVOICES_ALL

AP_INVOICE_DISTRIBUTIONS_ALL

9.Difference between Conversion and Interface?

Interface                                                                                                             Conversion

To transfer daily transactions from Legacy system to Oracle Apps	To transfer old data from Legacy  system to oracle Apps or Lower Version to Higher version (11i -->R12)
It is on demand process/scheduled process	It is one time process
It is applicable in After Implementation	It is applicable in Conversion Projects and Up gradation Projects.
We don't know data volume	We know the data volume

10.When will we use conversion?

11.How to display vendor details in GL Report and what is the link?

We will display vendor details in GL Report by taking AP tables.

link is PO_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID = AP_INVOICE_DISTRIBUTIONS_ALL.PO_DISTRIBUTION_ID

Then

AP_AE_LINES.GL_SL_LINK_ID=GL_JE_LINES.GL_SL_LINK_ID

12.What is Procedure?

 is a named pl/sql block to perform a specific task.

    ----    A procedure may have DML statements.

    ----    It may or may not return a value.

    ----    Procedure can return more than one value.

13.What is Function? When will we use it?

is a named pl/sql block to perform a specific task, is mainly used for calculation purpose.

   ---- A function is called as part of an exception.

   ---- Every function should return a value

If u want to do any calculations then we will use Function.

14.XML Registration steps?

1.                   Register the E-business suite report as a Data Definition in the Template Manager.

                                       Create a Data definition in the Template Manager for E-business Suite reports that

                                       We wish to customize using XML Publisher. When you create the Data Definition

                                       Code must match the E-Business Suite report short name.

2.                   Design our template

                  Our template files can be either in Rich Text Format (RTF) or Portable Document.

                  RTF is a specification used by many word processing applications, such as

                  Microsoft word. We design the template using our desktop word processing

                  Application and save the file as an RTF file type (.rtf extension). Insert basic

                  Markup tags to the document to prepare it for merging with the XML data. XML

                  Recognizes the formatting features that we apply and converts them to XSL-FO.

                  Use Adobe Acrobat to apply markup tags to your custom-designed or

                  Downloaded PDF template

3.                   Register out template in the Template Manager

                  When we create the Template Manager, we register and upload our RTF

                  Or PDF template files. The template must be assigned to the Data definition

                  Code of the E-Business Suite report with which it will be merged.

4.                   Add desired translations of your RTF template

                  XML Publisher’s translation utility allows us to extract the translatable strings

                  From your template into an XLIFF file. Translate the strings in this file and re-

                  upload to the Template Manager to make translation available at runtime.

Run Time: -

1.        Set the concurrent program to generate XML.

2.        Run the concurrent program using standard request submission to obtain the XML

Output.

3.        Run the XML Publisher Concurrent Request .

The XML Publisher Concurrent Request will prompt us to enter the Request ID from the previous step, and t select a template, template locale, and output type. Available templates are those associated to the report Data Definition in the Template Manager. XML Publisher merges our design template with the XML data to generate your customized output.

15.PO Process?

16.RDF Registration steps?

17.What is Form Personalization? Which pages you personalize?

18.Which triggers you use in Form Personalization?

19.What is exception? How many types?

20. Difference between Predefined exceptions and User defined exceptions?

21.If we write any exception after when others then what will be the error?

22.Can we create Package Body without specification?

23.Can we create Package Specification without Body?

24.Form Customization steps? When will we give form name in Registration?

25.What is Profile? How many levels?

26.Whar are Site level Profiles?

27.Which profile in GL?

28.Which Profile added in R12?

29.What is Sql*loader? Which command used in Sql*loader to load data?

30.What is TCA? What are the changes made in TCA in R12?

31. What are PO Tables?

31. What are Inventory Tables?

33.What are Sub ledger Accounting Tables?

                                                         

 If you know any answer of the above Question please type in comment box by giving Question no.