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