Oracle Applications Interview Questions (FAQS)

Q1. Is it possible to show more than two decimal places in the "PRICE" column that is currently being printed on the 'Printed Purchase Order Report - (Landscape or Portrait)'?

A: Currently, it is not possible to print more than two decimals in the 'PRICE' field without customizing the reports. There is currently an enhancement request (628857) under review that will, if approved, bring this desired functionality to future releases. This answer holds true to Releases 10.7, 11.0, and 11.5 (11i).

  

Q2. When I print out a purchase order from the Document Approval window, does it only print in Portrait style?

A: Currently this is the only way it will print from the Document Approval window. An enhancement request (466551) has been filed to allow the choice of either Portrait or Landscape as the format when printing purchase orders from the Document Approval window.

  

Q3. Why does the blanket purchase agreement print every time a release is printed?

A: This is the current functionality of the application. The blanket purchase agreement will be printed every time you choose to print an associated release. An enhancement request (432017) has been filed to allow only the release to be printed.

  

Q4. What is the name of the file that controls printing of reports related to Oracle Purchasing, and where is it located on the system?

A: The name of the file is porep.odf. This file creates the Oracle Purchasing views which generate the data that is printed by the reports. The file can be found in the following locations:

$PO_TOP/admin/odf This is where the base release version of the file is seeded by the install.
$PO_TOP/patch/110/odf This is where the most current version of the file resides on your system for Release 11.
$PO_TOP/patchsc/107/odf This is where the most current version of the file resides on your system for Release 10.7.
For Windows NT, it is best to use the FIND FILE utility to locate the various versions of the file.

  

Q5. How can a report file name and version be located?

A: There are two methods that can be used to find the report short (file) name:

1. Please see Note 106968.1, titled "Purchasing: PO Report Short Names". This note contains an alphabetical listing of all Oracle Purchasing reports and lists the short name for each one.

2. Each report is a concurrent process that can be found in System Administration.
- Responsibility: System Administrator
- Navigation: Concurrent > Program > Define
- Select the Program Name
Under the Program Name field, you will see a field called Short Name. This is the name of the report file. This name should be the same as the name of the file in the Executable field.

To find the version of the file:

For Unix
********
For Release 10.7, go to $PO_TOP/srw
For Release 11, go to $PO_TOP/reports

Type the following command at a Unix prompt:
strings -a <FILENAME.rdf>|grep Header:

For Windows NT
**************
Use the FIND FILE utility to locate the file. Use MS-DOS to navigate to the
file and type the following command at the prompt:
find /i "Header:" <FILENAME.rdf>

 

Q6. Why do asterisks (******) appear on report output in place of the quantity? 

A: Oracle Reports will allow a maximum of 13 characters to be printed in the Quantity column. These characters include a -/+ sign at the beginning and then a combination of 12 more characters, including commas, periods, and digits. Therefore, if the quantity on a report contains more than 13 characters, you will see the asterisks show in place of the quantity.

Examples: 
9,999,999.00 actually contains 13 characters and will be displayed. Remember, the + sign is holding the first character position in the database.
-1.2245833524335 would print asterisks, as more than 13 characters are involved.

You do have the ability to change the way your reports print out the numbers in the Quantity region; this may make the difference in allowing you to see the actual quantity. You cannot change the number of characters in the field, but you can change the way they display. This will give you more options. To do this:
Responsibility: System Administrator
Navigation: Profiles/System
Query the profile 'INV: Dynamic Precision Option for Quantity on Reports'
Click on the List of Values and you will see the different options available for you to use on your reports. You will notice that all options still only represent 13 characters; it just changes the way they are represented.

See Note 1072855.6 for further clarification.

 

Q7. When a report has been submitted to print, the output can be viewed by using the View Output button, but no hard copies of the report print out. What causes this to occur?? 

A: The number of copies Oracle Reports will print is controlled in System Administration.
Responsibility: System Administrator
Navigation: Profiles/System
Query the profile 'Concurrent: Report Copies'
If this profile is not populated, Oracle will not print any copies of any report.