当前位置:好职网>职场指南>面试>Oracle EBS面试问题

Oracle EBS面试问题

时间:2021-01-23 12:25:48 面试 我要投稿

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 CM|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+YTv 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~}4kJ+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
Jf@&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个人空间kJKN`\\\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 EBS面试问题大全

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
qRm8a|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%`fb$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](\\ab0ITpUB个人空间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&nl%ww#@L1B
Ans 1:ITpUB个人空间q&Ez }+s5o e
Responsibility level. Responsibility level will override FUNCTION level personalizations.
{+vIN9l~o%h0ITpUB个人空间VMH?Wv 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{nrR4_
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面试问题大全】相关文章:

采购面试问题大全!10-19

面试问题大全B10-19

面试问题大全1110-16

人事面试问题大全10-15

英语面试问题大全10-11

面试问题大全及答案10-21

英文面试常问问题大全11-06

常见教师面试问题大全11-03

面试官经典常见面试问题大全10-25