oracle reports interview questions(转载)

Oracle Reports Interview Questions

Oracle Reports Interview Questions

Name the report triggers.
Before Parameter
After Parameter
Before Report
Between Pages
After Report

What are bind parameter and lexical parameter used for?
A bind reference replaces a single value or expression.To create a bind reference in a query, prefix the parameter name with a colon (.
A lexical reference is a text string and can replace any part of a SELECT statement, such as column names, the FROM clause, the WHERE clause, or the ORDER BY clause. To create a lexical reference in a query, prefix the parameter name with an ampersand (&).

Give an example of the implementation of between pages trigger in reports.
   The total printed at the bottom of first page has to be carried to the top of the next  
   page
The total printed at the bottom of first page has to be carried to the top of the next page. How do u do this technically?
Use Between pages trigger to copy the value from previous page to current page.
How do you resolve the following layout issues in reports?
There are 14 columns altogether in a report, in reports developer all 14 columns are printed, but in apps only 10 columns are displayed, how can u solve this?
While printing, 10 columns are printing in first page and the next 4 cols in next page, how do u resolve this to accommodate all the 14 columns in a single page?
Where in reports do you set the context information (like org_id)?
SRW.INIT
What do you know about Placeholder column, formula columns, and summary columns?
A summary column performs a computation on another column's data.
      A formula column is a user-created column that gets its data from a PL/SQL
      function or expression, a SQL statement, or a combination of these. A formula
          column performs a user-defined computation on the data of one or more
          column(s), including placeholder columns.
      A placeholder is a column for which you set the datatype and value in PL/SQL t  
      that you define. Placeholder columns are useful when you want to selectively set  
      the value of a column
What are user exits in reports and name a few?
   User exits provided a way to pass control from Reports Builder to a program you have written, which performs some function, and then returns control to Reports Builder.
SRW.DO_SQL, SRW.USER_EXIT
How do you display only one record on each page in a report?
Give Page Break in the Format trigger of the repeating frame.

How do you print barcode in the reports?
By installing the Barcode Font and using the Chart field in the Layout.

What is SRW package and some procedures in SRW?
It is the standard reports package and it has many procedures like USER_EXITS, DO_SQL, RUN_REPORT, MESSAGE,TRACE, BREAK, SET_ATTR.

How do you write the report output to Excel file or text file?
Use TEXT_IO package
Use SPOOL in After Report trigger
Use UTL Package

How do you call a concurrent program or another report from a report?
Use FND_SUBMIT.REQUEST() to call a concurrent program or a report.
Use SRW.RUN_REPORT() to run a report directly without registering it as a concurrent program.

How do you mail the output of a report?
Use UTL_SMTP (refer to Scripts tab for more details)
Use MAILX called in a shell script registered as a concurrent program with parameters File name and path.

What are the different sections in the Layout?
Header, Main, Trailer

How can you grey out/ highlight/hide some records based on conditions in a report?
Use Conditional formatting
   
What is Anchor in reports?
   Anchors fasten an edge of one object to an edge of another object, ensuring that
   they maintain their positions relative to its parent.

What is the difference between Conditional Formatting and format trigger?
   Both provide the same functionality, used to format the output based on particular conditions. Format triggers provide a wide variety of options when compared to conditional formatting.

Definitions:

Using the Conditional Formatting and Format Exception dialog boxes, you can specify output formatting attributes (font and color) for a selected layout object based on conditions that exist. The conditions that you define are called format exceptions.

Format triggers are PL/SQL functions executed before the object is displayed. The trigger can be used to dynamically change the formatting attributes of the object. The function must return a Boolean value (TRUE or FALSE).

 

 

Oracle Apps Financials: Some Interview questions

I am giving below some of the interview questions relating to Oracle Financials that I have come across.
1. Oracle financials talk of Set of Books. However at the beginning of an implementation, when you talk of set of books to the CFO, he will most likely tell you that 'He has just an accounting book for the organization'. So he feels that he does not need 'Set of Books'. How can you reconcile the above two statements?
2. What is meant by 'Top Line' and 'Bottom Line'?
3. In P&L, what is 'Gross Profit', What is 'EBIDTA', What is 'cash profit'?
4. What is the concept of 'Bill in Advance' and 'Bill in arrears' in AR?
6. What is profitability? How do you map 'segment wise profitability' in Oracle?
7. Explain the accounting flow in P2P Cycle, O2C cycle etc
8. Foreign currency accounting: Explain conversion, revaluation, translation and remeasurement
9. How do you get the account description in FSG reports?
10. What is mass allocation?
11. Suppose I am paying rent regularly on the premises that I occupy. The amount and the account is the same for each month. What are the two ways in which I can map this requirement in Oracle so that the data entry is simplified. Which approach would you prefer? Why?
12. What are the different ways in which you can map intercompany transactions in apps? which one you prefer and why?
13. What is a ledger in R12? What are the four Cs of a ledger?

 

Oracle HRMS Payroll Interview Questions

Dear Learners and Job hunters for Oracle HRMS and Payroll. Please find some basic level questions that you
might be asked in an Interview.


Qns 1. Can you call pl/sql package functions from within a Fast Formula?
Ans 1. Yes you can
-->How do we do this?
-->There is a Define Function screen in HR. In this screen you will register the pl/sql as “External Function”.

-->If we want to pass a parameter PAYROLL_ID to this external pl/sql Function, how do we do it ?
-->The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you can
register the parameters.


Qns 2: P35 report is run after the “End Of Year (EOY)” process.
Do you know which tables does EOY process populate.
P35 and P60 reports uses these tables which get populated by EOY
Ans2: FF_ARCHIVE_ITEMS
FF_ARCHIVE_ITEM_CONTEXTS

Qns 3: How do you Debug a Fast Formula?
Ans 3: You can create a message variable in Fast Formula.
This message variable must also be registered as a Formula Result( In “Formula Result Rule” window).


Qns 4: What are the various levels where you can Set up Payroll Costing Accounts?
Which levels take the highest precedence? **Assume Labor Distributions is not implemented**
Ans4;
Element Entry => Highest
Assignment => Second Highest
Organization => Third Highest
Element Link => Fourth Highest
Payroll => Fifth Highest


Qns5: Technically speaking, how do you know from tables that an Employee has been terminated?
Ans 5:
(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP
(b) A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

Qns6: How can you make Employee Number generation Automated based on business rule etc.
Ans6: Use Fast Formula.

Qns7: What is the difference between per_people_f and per_all_people_f
Ans7: PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person.
This API internally checks for an entry in table PER_PERSON_LIST for the logged in person's security profile. A concurrent
program named "Security List Maintainence program" will insert records in PER_PERSON_LIST



Oracle HRMS Self Service Interview Some Simple Questions
Qns 1 :
If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?
Ans 1:
Responsibility level. Responsibility level will override FUNCTION level personalizations.

Qns 2:
Say you have done a lot of Personalizations to Self Service Screens.
But all these Personalizations were done in DEVELOPMENT environment.
How will you migrate these personalizations to PRODUCTION environment?
Ans2:
Before 11.5.7…Use AKLoad
This is a java program given by Oracle. This is the only way you can script it.
In DEV you will do è akdload DOWNLOAD ( & other parameters)
In PRD you will do è akdload UPLOAD ( & other parameters)
On or after 11.5.10 Use responsibility “Functional Administrator”, then click
on Personalization Tab, and then click on Import/Export.
Next select the documents to be exported.
Go to the unix box and tar the personalizations into a .tar file.
On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.
Setting up of this profile is mandatory or else Oracle Framework would’nt know where to search for the files to be imported.