Oracle EBS面试问题大全

 

Oracle Applications General Questions
1. How can you restrict the access (to oracle apps) to A GROUP OF users using personalization?
2. How do you enable trace/debug in APPS?
3. What are custom events in apps and how to you enable/disable it?
4. What is diagnostics in apps? How do you enable/disable it?
5. What are folders? How do you modify them?
6. What is personalization and what features can be achieved through personalization?
7. How do you run diagnostics for a particular module to send it to Oracle support.
8. What are global variables? How they can be used?
9. Can you send direct oracle form. link in workflow notifications? If How?
10. How can you achieve ZOOM functionality using Personalization?
11. What is custom.pll used for?
12. What is the difference between Key flex field and Descriptive flex field?
13. Tell me about Multi Org?
14. If the business entity has 5 Operating Units,How many times do you have to implement Apps?
15. What is the difference between org_id and organization_id?
16. What is FNDLOADER used for its syntax?
17. What is profile option in APPS?
18. What are the steps to register Concurrent Program, Form, Report?
19. Explain the Order to Cash cycle and the underlying tables.
20. Explain the Procure to Pay cycle and the underlying tables.
21. What is difference between concurrent program and concurrent request
Order Management Interview Questions
1. What are the Base Tables and Interface Tables for Order Management?
2. What is Order Import and what are the Setup's involved in Order Import?
3. What are different Order Types?
4. Explain the Order Cycle?
5. Explain the Order to Cash Flow?
6. What are the Process Constraints?
7. What are validation templates?
8. What are different types of holds?
9. What is Document Sequence?
10. What are Defaulting Rules?
11. When an order cannot be cancelled?
12. When an order cannot be deleted?
13. What is order type?
14. What are primary and secondary price lists?
15. What is pick slip? Types?
16. What is packing slip?
17. What are picking rules?
18. Where do you find the order status column?
19. When the order import program is run it validates and the errors occurred can be seen in?
20. What is a Pick Slip Report?
21. Name some tablesin shipping/order/move order/inventory?
22. How is move order generated?
23. What is the difference between purchase order (PO) and sales order?
24. What is ONT stands for?
25. What are the required fields when entering an order in the Order Entry Screen?
26. When you run the Auto Invoice, where does it get the order details from ?
27. Whatis drop ship in OM?
28. What does Back ordered mean in OM?
29. What isAdvanced Shipping Notice?
Oracle Applications Receivables Interview Questions
1. What are the different Invoice matching types?
2. Explain the different steps in implementing Autolockbox?
3. What is the dbnumber of a particular cusotmer TCA?
4. Tell me about TCA?
5. What are the different Transaction types in AR?
6. Name some Flexfields in AR.
7. What is the link between OM and AR?
8. What kind of transactions can be created using AutoInvoice?
9. What are the underlying tables and validations required during AutoInvoice Interface?
10. Explain the steps involved in Transfer to GL from AR and AP.
11. Where can you find the Customer payment terms? -- hz_customer_profiles
Oracle Purchasing Interview Questions
1. What is a Blanket PO?
2. What are different types of PO’s
3. Give me some PO tables
4. What is Purchase order workflow
5. How PO approval is organized
6. What is dollar limit and how can you change it?
7. What is difference between positional hierarchy and supervisor hierarchy?
8. How does workflow determines whom to send the PO for approval?
9. Can you create PO number in iProcurement?
10. What functions you do from iProcurement
11. What is the difference between purchasing module and iProcurement module?
Oracle Application Payables Interview Questions
1. What are the different types of Invoices?
2. What is prepayment & steps to apply it to an Invoice?
3. What are the Prepayment types?
4. What is the Distribution Type while entering the Invoice?
5. What's the difference between the "Payables Open Interface Import" Program and the "Payables Invoice Import" program?
6. What is Debit Memo & Credit Memo in Payables?
7. What is Proxima Payment Terms?
8. What will accrue in Payables?
9. What is Tolerance?
10. What is Aging Periods?
11. What is a Payable Document?
12. What are 2 way, 3 way and 4 way matching?
13. How you will transfer payables to general ledger?
14. What is use of AP Accounting Periods?
15. What is a Hold? Explain the types of Hold
16. How many key flexfields are there in Payables?
17. Explain the set up used for Automatic or Manual Supplier Numbering.
18. Can you hold the partial payment if yes then how?
19. Can you cancel the invoice? If yes, at what stages? Explain?
20. What are the different interface programs in AP?
21. What is the process/steps for Vendor Conversion?
22. Which module is the owner of Vendor/Supplier tables?
23. Give the cycle from creating an invoice to transferring it to GL
24. What program is used to transfer AP transactions to GL?
25. Tell me about PO cycle?
26. How many types of Purchase Order Types/Agreements are there? What are they?
27. What is Blanker PO?
28. What is Contract PO?
29. What is Planned PO?
30. In which table we can find the vendor number?
31. You have created a new SOB. How will you attach this SOB to AP?
Workflow Interview Questions
1. What is the access level in workflow used for?
2. How can you send direct oracle form. link through workflow notifications?
3. What are roles in workflow and how they are used?
4. What is the difference between a function and notification in workflow?
5. How can you send a notification to multiple users? Can you change the list dynamically?
6. What is Runnable option in workflow? At what level it exists?
7. What is item type and item key in workflow?
8. How can you run/start/kickoff workflow?
9. What functions can you perform. from workflow administrator responsibility?
10. How do you reassign a notification?
11. What is delegating a notification?
12. How many processes can each workflow contain?
13. What is process in workflow?
14. How do you use lookups in workflow?
15. How do you use attribute values in workflow messages?
16. Can you send html code in workflow notification?
17. What are different types of attributes in workflow?
18. How do you define start and end functions in workflow? How does they differ from normal functions?
19. I have sent two different notifications to two different users and I want to wait till both they are approved to send 3rd notification. How can you achieve it?
20. I have sent two different notifications to two different users and I want to wait till atleast one is approved to send 3rd notification. How can you achieve it?
21. What are steps to customize the workflow?
22. How do you download or upload a workflow from a server?
23. To send an email to the user workflow notification is the only way or is there any other ways to send it?
24. Give me some workflow tables?
25. Give me some workflow standard procedures?
26. What is wf_engine package used for?
Forms Interview Questions
1. What triggers are available in Forms?
2. How do you attach a library to a form?
3. What are Object Groups?
4. How do you build a popup menu?
5. What are program units in forms? How to do you use them?
6. What are different Visual Attributes in Forms?
7. What is difference between PL/SQL library and object library in Forms?
8. Give some Built in Package Names?
9. Can you issue DDL in forms? If so how do you?
10. What is SECURE property?
11. What are the types of triggers and how the sequence of firing in text item
12. Can you store pictures in database? How?
13. What are property classes? Can property classes have trigger?
14. If you have property class attached to an item and you have same trigger written for the item. Which will fire first?
15. What are record groups?
16. Can record groups created at run-time?
17. What is ALERT?
18. Can a button have icon and lable at the same time?
19. What is mouse navigate property of button?
20. What is FORMS_MDI_WINDOW?
21. Can object group have a block?
22. How many types of canvases are there?
23. What are user-exits?
24. Can you call WIN-SDK thruo' user exits?
25. Does user exits supports DLL on MSWINDOWS ?
26. What is path setting for DLL?
27. What are key-mode and locking mode properties? level ?
28. What are savepoint mode and cursor mode properties ? level?
29. What are OPEN_FORM,CALL_FORM,NEW_FORM? diff?
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
rganization => 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.

摘自http://www.dweye.net/thread-2274-1-1.html