OracleEBS面试问题Word下载.docx

OracleEBS面试问题Word下载.docx

《OracleEBS面试问题Word下载.docx》由会员分享，可在线阅读，更多相关《OracleEBS面试问题Word下载.docx（8页珍藏版）》请在冰豆网上搜索。

WhatisFNDLOADERusedforitssyntax?

WhatisprofileoptioninAppS?

WhatarethestepstoregisterConcurrentprogram,Form,Report?

ExplaintheOrdertoCashcycleandtheunderlyingtables.Explaintheprocuretopaycycleandtheunderlyingtables.WhatisdifferencebetweenconcurrentprogramandconcurrentrequestOrderManagementInterviewQuestions

1.WhataretheBaseTablesandInterfaceTablesforOrderManagement?

2.WhatisOrderImportandwhataretheSetup\sinvolvedinOrderImport?

3.WhataredifferentOrderTypes?

4.ExplaintheOrderCycle?

5.ExplaintheOrdertoCashFlow?

6.WhataretheprocessConstraints?

7.Whatarevalidationtemplates?

8.Whataredifferenttypesofholds?

9.WhatisDocumentSequence?

10.WhatareDefaultingRules?

11.Whenanordercannotbecancelled?

12.Whenanordercannotbed?

13.Whatisordertype?

14.Whatareprimaryandsecondarypricelists?

15.Whatispickslip?

Types?

16.Whatispackingslip?

17.Whatarepickingrules?

18.Wheredoyoufindtheorderstatuscolumn?

19.Whentheorderimportprogramisrunitvalidatesandtheerrorsoccurredcanbeseenin?

20.WhatisapickSlipReport?

21.Namesometablesinshipping/order/moveorder/inventory?

22.Howismoveordergenerated?

23.Whatisthedifferencebetweenpurchaseorder（pO）andsalesorder?

24.WhatisONTstandsfor?

25.WhataretherequiredfieldswhenenteringanorderintheOrderEntryScreen?

26.WhenyouruntheAutoInvoice,wheredoesitgettheorderdetailsfrom?

WhatisdropshipinOM?

27.WhatdoesBackorderedmeaninOM?

WhatisAdvancedShippingNotice?

OracleApplicationsReceivablesInterviewQuestionsWhatarethedifferentInvoicematchingtypes?

ExplainthedifferentstepsinimplementingAutolockbox?

WhatisthedbnumberofaparticularcusotmerTCA?

TellmeaboutTCA?

WhatarethedifferentTransactiontypesinAR?

NamesomeFlexfieldsinAR.WhatisthelinkbetweenOMandAR?

WhatkindoftransactionscanbecreatedusingAutoInvoice?

WhataretheunderlyingtablesandvalidationsrequiredduringAutoInvoiceInterface?

ExplainthestepsinvolvedinTransfertoGLfromARandAp.WherecanyoufindtheCustomerpaymentterms?

--hz_customer_profilesOraclepurchasingInterviewQuestionsWhatisaBlanketpO?

WhataredifferenttypesofpO’sGivemesomepOtablesWhatispurchaseorderworkflowHowpOapprovalisorganizedWhatisdollarlimitandhowcanyouchangeit?

Whatisdifferencebetweenpositionalhierarchyandsupervisorhierarchy?

HowdoesworkflowdetermineswhomtosendthepOforapproval?

CanyoucreatepOnumberiniprocurement?

WhatfunctionsyoudofromiprocurementWhatisthedifferencebetweenpurchasingmoduleandiprocurementmodule?

OracleApplicationpayablesInterviewQuestionsWhatarethedifferenttypesofInvoices?

Whatisprepayment&

stepstoapplyittoanInvoice?

Whataretheprepaymenttypes?

WhatistheDistributionTypewhileenteringtheInvoice?

What\sthedifferencebetweenthe\"

payablesOpenInterfaceImport\"

programandthe\"

payablesInvoiceImport\"

program?

WhatisDebitMemo&

CreditMemoinpayables?

WhatisproximapaymentTerms?

Whatwillaccrueinpayables?

WhatisTolerance?

WhatisAgingperiods?

WhatisapayableDocument?

Whatare2way,3wayand4waymatching?

Howyouwilltransferpayablestogeneralledger?

WhatisuseofApAccountingperiods?

WhatisaHold?

ExplainthetypesofHoldHowmanykeyflexfieldsarethereinpayables?

ExplainthesetupusedforAutomaticorManualSupplierNumbering.Canyouholdthepartialpaymentifyesthenhow?

Canyoucanceltheinvoice?

Ifyes,atwhatstages?

Explain?

WhatarethedifferentinterfaceprogramsinAp?

Whatistheprocess/stepsforVendorConversion?

WhichmoduleistheownerofVendor/Suppliertables?

GivethecyclefromcreatinganinvoicetotransferringittoGLWhatprogramisusedtotransferAptransactionstoGL?

TellmeaboutpOcycle?

HowmanytypesofpurchaseOrderTypes/Agreementsarethere?

Whatarethey?

WhatisBlankerpO?

WhatisContractpO?

WhatisplannedpO?

Inwhichtablewecanfindthevendornumber?

YouhavecreatedanewSOB.HowwillyouattachthisSOBtoAp?

WorkflowInterviewQuestionsWhatistheaccesslevelinworkflowusedfor?

Howcanyousenddirectoracleform.linkthroughworkflownotifications?

Whatarerolesinworkflowandhowtheyareused?

Whatisthedifferencebetweenafunctionandnotificationinworkflow?

Howcanyousendanotificationtomultipleusers?

Canyouchangethelistdynamically?

WhatisRunnableoptioninworkflow?

Atwhatlevelitexists?

Whatisitemtypeanditemkeyinworkflow?

Howcanyourun/start/kickoffworkflow?

Whatfunctionscanyouperform.fromworkflowadministratorresponsibility?

Howdoyoureassignanotification?

Whatisdelegatinganotification?

Howmanyprocessescaneachworkflowcontain?

Whatisprocessinworkflow?

Howdoyouuselookupsinworkflow?

Howdoyouuseattributevaluesinworkflowmessages?

Canyousendhtmlcodeinworkflownotification?

Whataredifferenttypesofattributesinworkflow?

Howdoyoudefinestartandendfunctionsinworkflow?

Howdoestheydifferfromnormalfunctions?

IhavesenttwodifferentnotificationstotwodifferentusersandIwanttowaittillboththeyareapprovedtosend3rdnotification.Howcanyouachieveit?

IhavesenttwodifferentnotificationstotwodifferentusersandIwanttowaittillatleastoneisapprovedtosend3rdnotification.Howcanyouachieveit?

Whatarestepstocustomizetheworkflow?

Howdoyoudownloadoruploadaworkflowfromaserver?

Tosendanemailtotheuserworkflownotificationistheonlywayoristhereanyotherwaystosendit?

Givemesomeworkflowtables?

Givemesomeworkflowstandardprocedures?

Whatiswf_enginepackageusedfor?

FormsInterviewQuestionsWhattriggersareavailableinForms?

Howdoyouattachalibrarytoaform?

WhatareObjectGroups?

Howdoyoubuildapopupmenu?

Whatareprogramunitsinforms?

Howtodoyouusethem?

WhataredifferentVisualAttributesinForms?

WhatisdifferencebetweenpL/SQLlibraryandobjectlibraryinForms?

GivesomeBuiltinpackageNames?

CanyouissueDDLinforms?

Ifsohowdoyou?

WhatisSECUREproperty?

WhatarethetypesoftriggersandhowthesequenceoffiringintextitemCanyoustorepicturesindatabase?

How?

Whatarepropertyclasses?

Canpropertyclasseshavetrigger?

Ifyouhavepropertyclassattachedtoanitemandyouhavesametriggerwrittenfortheitem.Whichwillfirefirst?

Whatarerecordgroups?

Canrecordgroupscreatedatrun-time?

WhatisALERT?

Canabuttonhaveiconandlableatthesametime?

Whatismousenavigatepropertyofbutton?

WhatisFORMS_MDI_WINDOW?

Canobjectgrouphaveablock?

Howmanytypesofcanvasesarethere?

Whatareuser-exits?

CanyoucallWIN-SDKthruo\userexits?

DoesuserexitssupportsDLLonMSWINDOWS?

WhatispathsettingforDLL?

Whatarekey-modeandlockingmodeproperties?

level?

Whataresavepointmodeandcursormodeproperties?

level?

WhatareOpEN_FORM,CALL_FORM,NEW_FORM?

diff?

OracleReportsInterviewQuestions

Namethereporttriggers.

CV9Q}3tSD0BeforeparameterITpUB个人空间Gw3v\"

_+CBB;

d6y

AfterparameterITpUB个人空间XF$c1U+o~w

BeforeReport

d\\+pa1^3v4hy0BetweenpagesITpUB个人空间VQCM|4TA

AfterReportITpUB个人空间r\\\f7A\^$zh

e（h?

Bw4gBn（iq0Whatarebindparameterandlexicalparameterusedfor?

ITpUB个人空间0l?

IA9U#_9ivr

Abindreferencereplacesasinglevalueorexpression.Tocreateabindreferenceinaquery,prefixtheparameternamewithacolon.ITpUB个人空间ln3tk%]KG

AlexicalreferenceisatextstringandcanreplaceanypartofaSELECTstatement,suchascolumnnames,theFROMclause,theWHEREclause,ortheORDERBYclause.Tocreatealexicalreferenceinaquery,prefixtheparameternamewithanampersand（&

）.ITpUB个人空间-_&

Ts?

He

ITpUB个人空间s,e-J0d&

u-|1b+|:

`N{

Giveanexampleoftheimplementationofbetweenpagestriggerinreports.ITpUB个人空间&

j+YTvM

Thetotalprintedatthebottomoffirstpagehastobecarriedtothetopofthenextpage.

4I@4?

n|F）q0Thetotalprintedatthebottomoffirstpagehastobecarriedtothetopofthenextpage.Howdoudothistechnically?

v`#^B+g2R4Z0UseBetweenpagestriggertocopythevaluefrompreviouspagetocurrentpage.ITpUB个人空间_uFv!

J{1Gpq?

（m

Howdoyouresolvethefollowinglayoutissuesinreports?

8Nwd&

A,ZE]0Thereare14columnsaltogetherinareport,inreportsdeveloperall14columnsareprinted,butinappsonly10columnsaredisplayed,howcanusolvethis?

&

\\x.IH7i9VB*i0Whileprinting,10columnsareprintinginfirstpageandthenext4colsinnextpage,howdouresolvethistoaccommodateallthe14columnsinasinglepage?

ITpUB个人空间}fx|KC+A-\\

Whereinreportsdoyousetthecontextinformation（likeorg_id）?

ITpUB个人空间wpy6C（zTm

SRW.INIT

/Z%d{jzq0Whatdoyouknowaboutplaceholdercolumn,formulacolumns,andsummarycolumns?

z-EH-S&

akJmw4T0Asummarycolumnperformsacomputationonanothe