OracleEBS面试问题Word下载.docx

1、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

2、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 Setups 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

3、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 d?13.What is order type?14.What are primary and secondary price lists?15.What is pick s

4、lip? 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

5、 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 ?Whatis drop ship in OM?27.What

6、 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 dif

7、ferent 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.Whe

8、re can you find the Customer payment terms? - hz_customer_profiles Oracle purchasing Interview Questions What is a Blanket pO?What are different types of pOsGive me some pO tablesWhat is purchase order workflowHow pO approval is organizedWhat is dollar limit and how can you change it?What is differe

9、nce 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 iprocurementWhat is the difference between purchasing module and iprocurement module? Oracle Application payable

10、s 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?Whats the difference between the payables Open Interface Import program and the payables Invoice

11、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 Accoun

12、ting periods?What is a Hold? Explain the types of HoldHow many key flexfields are there in payables?Explain the set up used for Automatic or Manual Supplier Numbering.Can youhold the partial payment if yes then how?Can you cancel the invoice? If yes, at what stages? Explain?What are the different in

13、terface 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 GLWhat program is used to transfer Ap transactions to GL?Tell me about pO cycle?How many types of purchase Order Ty

14、pes/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 d

15、irect 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? A

16、t 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 i

17、s 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 fun

18、ctions?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 notificatio

19、n. 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?Wh

20、at 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 di

21、fference 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 itemCan you store pictures in database? How?What are property classe

22、s? 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 navigat

23、e 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 ?Wha

24、t are savepoint mode and cursor mode properties ? level?What are OpEN_FORM,CALL_FORM,NEW_FORM? diff? Oracle Reports Interview Questions Name the report triggers.CV9Q3tSD0Before parameterITpUB个人空间 Gw3v_+C BB;d6yAfter parameterITpUB个人空间 XF$c1U+owBefore Reportd+pa13v4hy0Between pagesITpUB个人空间VQ CM|4TAA

25、fter ReportITpUB个人空间rf7A$zhe（h? Bw4gBn（iq0What are bind parameter and lexical parameter used for?ITpUB个人空间0l?IA9U#_9ivrA bind reference replaces a single value or expression. To create a bind reference in a query, prefix the parameter name with a colon .ITpUB个人空间ln3tk%K GA lexical reference is a tex

26、t 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 （&）.ITpUB个人空间-_&Ts? HeITpUB个人空间 s,e-J0d&u-|1b+|:NGive an example of the impl

27、ementation of between pages trigger in reports.ITpUB个人空间&j+YTv MThe total printed at the bottom of first page has to be carried to the top of the nextpage.4I 4? n|F）q0The 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?v#B+g2R4Z0U

28、se Between pages trigger to copy the value from previous page to current page.ITpUB个人空间_u F v!J1Gpq?（mHow do you resolve the following layout issues in reports?8Nwd&A,ZE 0There are 14 columns altogether in a report, in reports developer all 14 columns are printed, but in apps only 10 columns are dis

29、played, how can u solve this?&x.IH7i9VB*i0While 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?ITpUB个人空间 f x|K C+A-Where in reports do you set the context information （like org_id）?ITpUB个人空间wpy6C（zTmSRW.INIT/Z%djzq0What do you know about placeholder column, formula columns, and summary columns?z-EH-S&akJmw4T0 A summary column performs a computation on anothe