Oracle EBS面試問題大全

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

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 d?
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 ?Whatis drop ship in OM?
27. 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’sGive me some pO tablesWhat is purchase order workflowHow pO approval is organizedWhat 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 iprocurementWhat 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 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 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 GLWhat 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 itemCan 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?

Oracle Reports Interview Questions

Name the report triggers.
CV9Q}3tSD0Before parameterITpUB個人空間 Gw3v\"_+C BB;d6y
After parameterITpUB個人空間 XF$c1U+o~w
Before Report
d\\+pa1^3v4hy0Between pagesITpUB個人空間VQ C
M|4TA
After ReportITpUB個人空間r\\\f7A\^$zh
e(h? Bw4gBn(iq0What are bind parameter and lexical parameter used for?ITpUB個人空間0l?IA9U#_9ivr
A 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 G
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 (&).ITpUB個人空間-_&Ts? He
ITpUB個人空間 s,e-J0d&u-|1b+|:`N{
Give an example of the implementation of between pages trigger in reports.ITpUB個人空間&j+Y
Tv M
The 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+g2R4Z0Use Between pages trigger to copy the value from previous page to current page.ITpUB個人空間_u F v!J{1Gpq?(m
How 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 displayed, 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(zTm
SRW.INIT
/Z%d{jzq0What do you know about placeholder column, formula columns, and summary columns?
z-EH-S&akJmw4T0 A summary column performs a computation on another column\s data.ITpUB個人空間?} ^}.gz\"d/]a
A formula column is a user-created column that gets its data from a pL/SQL
+?:q(|uqo9}D:H0 function or expression, a SQL statement, or a combination of these. A formula
)? eH1z:O*v0 column performs a user-defined computation on the data of one or moreITpUB個人空間 _
V$I1cY
column(s), including placeholder columns.
x e|]!g6T+? Y0 A placeholder is a column for which you set the datatype and value in pL/SQL t
\p+g!I^4_5w#s0 that you define. placeholder columns are useful when you want to selectively setITpUB個人空間`!F*e SA|?
the value of a columnITpUB個人空間#[M2mR,qs-F7Af,t
What are user exits in reports and name a few?ITpUB個人空間HcS5r\"i~-A
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.ITpUB個人空間j-I4H8p&U)l mB
SRW.DO_SQL, SRW.USER_EXIT
? l J,m)|T0How do you display only one record on each page in a report?ITpUB個人空間
Y3Q$`H~:~
Give page Break in the Format trigger of the repeating frame.ITpUB個人空間p U#c.O^S
ITpUB個人空間v/M_q,` { h
How do you print barcode in the reports?
r1eNr6F9t?o0By installing the Barcode Font and using the Chart field in the Layout.ITpUB個人空間\\:w,K\"px?e3~f-[
ITpUB個人空間*~l%?S3c)ic#Xx2[
What is SRW package and some procedures in SRW?ITpUB個人空間]k(s/Y-TWv iSBGt
It is the standard reports package and it has many procedures like USER_EXITS, DO_SQL, RUN_REpORT, MESSAGE,TRACE, BREAK, SET_ATTR.ITpUB個人空間:? E&O\"jU
x:~\Mn!d?x+d0How do you write the report output to Excel file or text file?
:\\CI h*X9X6r:?0Use TEXT_IO package
]\\Qz3K0@D0Use SpOOL in After Report triggerITpUB個人空間~ f%nf-|
Use UTL packageITpUB個人空間@ m*h5C#z J
ITpUB個人空間4t+t0V6`%fm t
How do you call a concurrent program or another report from a report?
KI~}4k
J+w0Use FND_SUBMIT.REQUEST() to call a concurrent program or a report.ITpUB個人空間(jQ)N0q$W\\.I^%e6Z
Use SRW.RUN_REpORT() to run a report directly without registering it as a concurrent program.
4h;u9K }J_@0
%O%hOM.`-B+sY0How do you mail the output of a report?
IvW pe0Use UTL_SMTp (refer to Scripts tab for more details)
3B])~9bd?j3|0Use MAILX called in a shell script. registered as a concurrent program with parameters File name and path.ITpUB個人空間$z|:HV:A\y\"IiC^%|
ITpUB個人空間 Dfk%u1f
What are the different sections in the Layout?ITpUB個人空間 Q2]7eK`zKC-h
Header, Main, Trailer
$k\\
Z{(b n0
3Lg4nC [{` bw7x!sX0How can you grey out/ highlight/hide some records based on conditions in a report?
9M(W6kE$?.{7A0N0Use Conditional formatting
4Q2EF+u D6Yr?s0
J
f@&N9S
{ DN QN0What is Anchor in reports?ITpUB個人空間 ^&wxg9W7s6gx
Anchors fasten an edge of one object to an edge of another object, ensuring that ITpUB個人空間k
JKN`\\\l
they maintain their positions relative to its parent.
%q?T:s S\v| z0ITpUB個人空間!A~fw)u#tk
What is the difference between Conditional Formatting and format trigger?ITpUB個人空間#S Vx0wqnXY
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.ITpUB個人空間 h]$T+E U.p/r
ITpUB個人空間,W3H#LBe&r\V5f
Definitions:
pC2eZ!C6~5GI0
*m-Y M Jf.\\ EV1o7]5b%C0Using 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.ITpUB個人空間zL @J R2u
*@ Q#T g1cs0Format 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.
Bi;B4p D01. 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?ITpUB個人空間:[ HI2{o5]
2. What is meant by \Top Line\ and \Bottom Line\?ITpUB個人空間2x&jW4v0~+]%W
3. In p&L, what is \Gross profit\, What is \EBIDTA\, What is \cash profit\?ITpUB個人空間d\\7Nz9W$b\NA
4. What is the concept of \Bill in Advance\ and \Bill in arrears\ in AR?ITpUB個人空間wx3l0\\k7^
6. What is profitability? How do you map \segment wise profitability\ in Oracle?ITpUB個人空間9Q3d%Q%~#Hv+{d1M&w
7. Explain the accounting flow in p2p Cycle, O2C cycle etc
1e(]Cyfn5u%Q08. Foreign currency accounting: Explain conversion, revaluation, translation and remeasurement
o?|/p4b$YuE09. How do you get the account description in FSG reports?ITpUB個人空間7p+TI&u(C1A
10. What is mass allocation?
h&k
} `7N-[oSy |?F011. 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?
Vt5UGcf)Uu.\\O012. What are the different ways in which you can map intercompany transactions in apps? which one you prefer and why?ITpUB個人空間&u&iU M1Xaxs6fcN9]/I
13. What is a ledger in R12? What are the four Cs of a ledger?

Oracle HRMS payroll Interview QuestionsDear Learners and Job hunters for Oracle HRMS and payroll. please find some basic level questions that you
qR
m8a|TL0might be asked in an Interview.
\\)W;K |ep.WMa0
p9]!C`H[)i0
mk:]k] SQ0Qns 1. Can you call pl/sql package functions from within a Fast Formula?
w:z!@ fpw0Ans 1. Yes you canITpUB個人空間-G8Q D`)bC3x
-->How do we do this?
J zj Kj}0-->There is a Define Function screen in HR. In this screen you will register the pl/sql as “External Function”.ITpUB個人空間Sim4e?X/l&pE
.R|j-y.H0-->If we want to pass a parameter pAYROLL_ID to this external pl/sql Function, how do we do it ?ITpUB個人空間cp)D8z\"D6M n
-->The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you canITpUB個人空間 aB[ naQ!Q
register the parameters.
e#G&_!Tx2MG;r0ITpUB個人空間Q`O)i J
U4\\[A6hge0Qns 2: p35 report is run after the “End Of Year (EOY)” process.
0eu+oC\"{5_j-u0Do you know which tables does EOY process populate.ITpUB個人空間2I4x&o.~KwI8A
p35 and p60 reports uses these tables which get populated by EOYITpUB個人空間bmD(cFk
Ans2: FF_ARCHIVE_ITEMSITpUB個人空間4d~? X+t%BT C
FF_ARCHIVE_ITEM_CONTEXTS
5tX4G&Qc9G+u5h!_0
Z8aL\Vb\?4V0Qns 3: How do you Debug a Fast Formula?
8l-UK6m}\e B(m0Ans 3: You can create a message variable in Fast Formula.ITpUB個人空間 v h{c#U7\\:U
This message variable must also be registered as a Formula Result( In “Formula Result Rule” window).
o K(\\ZS4A t([6X0ITpUB個人空間x!J%`f
b$h[\\\\
ITpUB個人空間 X,cR[oO{L@m\"V
Qns 4: What are the various levels where you can Set up payroll Costing Accounts?ITpUB個人空間;_)N$H:O%gE
Which levels take the highest precedence? **Assume Labor Distributions is not implemented**
0o.^.qq!l0Ans4;
.|.S#mec/e!af0Element Entry => Highest
~4p`p_0Assignment => Second HighestITpUB個人空間;?Y ?*S)]O+{$Q
rganization => Third Highest
i\"lV%f!Lz0Element Link => Fourth Highest
\"zb7b};L$z0payroll => Fifth Highest
\\:k7](\\a
b0ITpUB個人空間4r&Q V`TZ3J
p9O/Y&cA&cL:h%g1J[0Qns5: Technically speaking, how do you know from tables that an Employee has been terminated?
7g6e+n,R2~0{o!Q0Ans 5:
Y7l;K0])a0(a) The person_Type_ID in pER_pERSON_TYpE_USAGES_F will correspond to System person Type EX_EMpITpUB個人空間7u0F!evY%nq
(b) A record gets created in table pER_pERIODS_OF_SERVICE with Actual_Termination_date being not nullITpUB個人空間F9@dW;p b+gq_~
ITpUB個人空間5j\d,]nxGT
Qns6: How can you make Employee Number generation Automated based on business rule etc.ITpUB個人空間.Wq-t7V.t6v/g/t
Ans6: Use Fast Formula.
+Sf-{RA0
_
j`8|u6l[0Qns7: What is the difference between per_people_f and per_all_people_fITpUB個人空間B,o,{IT
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.ITpUB個人空間tU;q-OEh$O A`l
This ApI internally checks for an entry in table pER_pERSON_LIST for the logged in person\s security profile. A concurrent
-d~$p2t`0program named \"Security List Maintainence program\" will records in pER_pERSON_LISTITpUB個人空間9O3L1N4Vz
ITpUB個人空間-L2NE:D}-K2w|(H
ITpUB個人空間zG&Cv kK_
Oracle HRMS Self Service Interview Some Simple Questions
\"\\\\
s9Om0Qns 1 :ITpUB個人空間yyRxN+`D,x @
If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?ITpUB個人空間D&n
l%ww#@L1B
Ans 1:ITpUB個人空間q&Ez }+s5o e
Responsibility level. Responsibility level will override FUNCTION level personalizations.
{+vIN9l~o%h0ITpUB個人空間VMH?W
v wqFx
Qns 2:ITpUB個人空間kv3R_1e0a}
Say you have done a lot of personalizations to Self Service Screens.ITpUB個人空間K-Q+s z2Yf
But all these personalizations were done in DEVELOpMENT environment.
_\exR\Q0How will you migrate these personalizations to pRODUCTION environment?ITpUB個人空間h(b0x+R2M2k!|
Ans2:ITpUB個人空間7J l8`ftS
Before 11.5.7…Use AKLoadITpUB個人空間5}wj~o,XR
This is a java program given by Oracle. This is the only way you can script. it.ITpUB個人空間XJ8{nr
R4_
In DEV you will do è akdload DOWNLOAD ( & other parameters)ITpUB個人空間In:?3{y%iHs
In pRD you will do è akdload UpLOAD ( & other parameters)
:M)DvR~)FHWE0On or after 11.5.10 Use responsibility “Functional Administrator”, then click
IHKA%yo0on personalization Tab, and then click on Import/Export.
3_}sG\n?c,jl.i0Next select the documents to be exported.
;~+F!{\q q:[}[-|0Go to the UNIX box and tar the personalizations into a .tar file.ITpUB個人空間`
w _7x
[*T\"LEp
On the production environment unzip this tar file in location as entered in profile “FND: personalization Document Root path”.ITpUB個人空間[A)i`n8z
Setting up of this profile is mandatory or else Oracle Framework would’nt know where to search for the files to be imported.ITpUB個人空間S?DLl C$iF

【Oracle EBS面試問題】相關(guān)文章：

面試經(jīng)典問題11-11

面試的經(jīng)典問題及答案03-16

面試經(jīng)典問題及答案06-20

關(guān)于面試的問題05-20

面試問題與回答11-27

銷售人員面試的經(jīng)典問題06-13

采購的面試問題06-14

面試問題及答案05-23

軍校面試問題06-30

奇葩面試問題03-29