Oracle Apps Interview Questions.docx

Oracle Apps Interview Questions.docx

《Oracle Apps Interview Questions.docx》由会员分享，可在线阅读，更多相关《Oracle Apps Interview Questions.docx（43页珍藏版）》请在冰点文库上搜索。

OracleAppsInterviewQuestions

AOLInterviewQuestions （24）

∙WhatsoyoumeanbyHierarchicalandnonHierarchicalsecuritytypeinvalueset?

YouidentifyeachsecurityruleelementaseitherIncludeorExclude,whereIncludeincludesallvaluesinthespecifiedrange,andExcludeexcludesallvaluesinthespecifiedrange.EveryrulemusthaveatleastoneIncluderuleelement,sincearuleautomaticallyexcludesallvaluesunlessyouspecificallyincludethem.ExcluderuleelementsoverrideIncluderuleelements.

∙Whatisthedifferencebetweenorganizationidandmasterorganizationid?

Masterorganizationidisalegalentityonwhichyearlyreportingdoneitisalevel2inmulti-orgstrandorganization-idisaorganizationunitundermasterorganization,itisjustasale'sunit,inventoryunitetc...itisonlevel3inmultiorgstr.

Org_idatoperatingunitlevel,organization_idisatinventoryorgunitlevel.

∙Whatis'$flex$and'$profile$,whatistheuseof'$flex$'?

$Flex$:

-Willbeusedtoretrievepreviousparametervalueintablevaluesets.Syntax:

-:

$flex$.valuesetname;

$profile$:

-willbeusedattimes1.Tablevaluesets2.Concurrentprogramparametersdefaultvalues.

∙HowcanIimplementingandmanagingthecustomschema?

Pleasegivemequickreply.

Basicallyaschemaiscollectionofobjects（tables,views,indexes,sequences）belongingtoparticularuser,hereincaseofOracleappseverymoduleisimplementedasauserforexampleOrderManagementisimplementedasauserONT,sotocreateacustomschema,weneedtocreateauserandregistertheuserwithAOL.

 Checkthislinkforstepbystepprocesstocreateacustommodule（Application）andregisterwithoracleAOL.

∙HowcamIchangesincustom.pll?

AfterchangeshowcanIsendontheserverandwhat'seffectinthiscondition?

RE:

howcamIchangesincustom.pll?

Afterchangeshow...

1. FTP theCustom.pllfrom$AU_TOP/resource

2.OpentheCustom.pllinForms6i

3.IncludethefollowingcodeforyourFormlogic:

 begin

    Form_Namevarchar2（50）:

=name_in（'system.current_form'）;

    IfForm_Name='YOURCUSTOMFORM"then

   begin   

   includeyourlogic   

   end;

 end;

 4.Oncechangesover,usingthefollowingcommandtogeneratethe CUSTOM.plx 

f60genmodule=CUSTOM.plluserid=apps/apps@mfgdevmodule_type=LIBRARY

togeneratethelatestCUSTOM.plxandmovethisCUSTOM.plxto$AU_TOP/resource

∙HowcanIdisabledandenabledthestandardbutton'sinappswindow?

YoucandothiswithCustom.pllandifyou’reusingappsversiongreaterthat11.5.9thenyoucandothiswithformpersonalizationtoo

∙HowdoIrecovertheresponsibilityinappsifitisdisabled?

IfyourresponsibilityisenddatedthenasktheappsDBAtoremovethe datefromEffectiveDate（To） field.

thefollowing:

step1:

SELECTRESPONSIBILITY_NAMEFROMFND_RESPONSIBILITY_VL,FND_RESPONSIBILITYWHEREFND_RESPONSIBILITY.END_DATE>SYSDATEANDFND_RESPONSIBILITY_VL.RESPONSIBILITY_ID=FND_RESPONSIBILITY.RESPONSIBILITY_ID;

step2:

updatetheend_datefieldsforyourresponsibilities（querybyIDinthefnd_responsibilitytable）.

∙Wheredoconcurrentrequestlogfilesandoutputfilesgo?

∙$APPLLOGand$APPLOUT

Logfilesgoto:

/u01/appl/po/11.5.0/log

Outputfilesto:

/u01/appl/po/11.5.0/out

∙

Whatarethelogfileandoutputfilenamingconventions?

Logfiles:

l.req

Outputfiles:

If$APPCPNAMisnotset:

.

If$APPCPNAM=REQID:

o.out

If$APPCPNAM=USER:

.out

∙HowdoIcheckifMulti-orgisinstalled?

SELECTMULTI_ORG_FLAGFROMFND_PRODUCT_GROUPS

IfMULTI_ORG_FLAGissetto'Y',thenit’sMultiOrg.

∙HowdoIfindoutwhatthecurrentlyinstalledreleaseofApplicationsis?

SELECTrelease_nameFROMfnd_product_groups

WecanalsofindoutthroughHelp>AboutOracleApplications

∙HowdoIfindthenameofaform?

GUI:

UseHelp->AboutOracleApplications

Scrolldowntofindtheformname

∙HowdoIlookupORAerrors?

（andTNSerrors）

Use:

oerroraXXXX

or:

oerrtnsXXXX

whereXXXXistheerrornumber

（Thisalsosupportsanumberofothererrortypes.Usethe3-lettererrorprefixinplaceof'ora'）

∙HowdoIgenerateamessagefile（usaeng.msb）?

Use:

FNDMDCMFapplsys/pwd0YAPPusaeng

where:

applsys/pwdistheAPPLSYSuserandpassword

andAPPistheshortnameoftheapplication（likePOorINV）

useadadmin

∙HowdoIsubmitaconcurrentrequestfromPL/SQL?

usingfnd_request.submit_request（'cpname','parameters'）;

Example:

req_id:

=FND_REQUEST.SUBMIT_REQUEST（'FND','FNDSCARU'）;

begin

v_request_id:

=fnd_request.submit_request（applicationshortname,concurrentprogramshortname,description,paramers）

commit;

ifv_request_id>0then

  dbms_output.put_line（'Successfullysubmitted'）

else

 dbms_output.put_line（'NotSubmitted'）;

end;

∙HowdoIcancelarunningconcurrentrequest?

InGUI,usetheCancelorHoldbuttons

TheSysadminresponsibilitycancancelorholdanyrunningrequest

WhydoesHelp->Tools->Examineaskforapassword?

∙TheprofileoptionUtilities:

DiagnosticsissettoNO

ThisprofileoptioncontrolswhetheruserscanusetheExamineutility.

ThepasswordshouldbetheAPPSpassword.

∙HowdoIopenaforminquery-onlymode?

NavigatetotheFormFunctionsform（Application->Function）

QuerytheparticularformandaddtheparameterQUERY_ONLY=YES

Notallformswillacceptthisparameterhowever.

OracleAppsTechnicalInterviewQuestions （67）

∙Whataredifferentperiodtypes?

Year,Quarter,Month&Week

∙WhataredifferenttypesofJournalentries?

Encumbrance,Stats,Actual

TherearemainlytwotypesofJournalentries:

1.SimpleJournalEntry

2.RecurringJournalEntry

Journalsareof 3types 

A-Actual

B-Budget

E-Encumbrance

SelectDistinctACTUAL_FLAGfromGL_JE_HEADERS...willshowthedifferenttypesofJournalstoredintheJournalHeadertable.

JournalEntriescanalsobecategorizedonthebasisofJECategoryaswell.Youcanrefer allthe JournalCategorizesdefinedin theenvbyusingthefollowingquery:

Selectdistinctje_categoryfromGL_JE_HEADERS

JE_CATEGORY

--------------

Accrual

Adjustment

Allocation

BalanceSheetClose

Chargeback

Consolidation

CreditMemos

CrossCurrency

DebitMemos

Depreciation

IncomeStatementClose

LaborCost

MTL

MiscellaneousTransaction

Other

Payments

PurchaseInvoices

Receiving

Revenue

SalesInvoices

Tax

TradeReceipts

ADebitorCredittoaGeneralLedgerAccountiscalledJournalEntry...

TypesofJournalEntries:

-

1）GeneralJournalEntry.

2）RecurringJournalEntry.

3）MassAllocationJournalEntry.

4）ReversingJournalEntry.

∙WhatareUserExits?

UserexitsareProCcodelibrary.UserExitsisaprogramwhichisusedtopassthecontrolfromtheReportBuildertoathirdgenerationlanguageforperformingcomplexcalculationsandreturningthevaluebacktotheReportBuilder.

1.fndsrwinit

2.fndsrwexit

3.fndflexsql

4.fndflexidval

5.fndformatcurrency

∙WhatisanInvoice?

HowmanytypesofinvoicesarethereinAPandAR?

AninvoiceisaDocumentcreatedwheneveraproductorservicearesold.AndifthesaleismadeoncredittheinvoiceremainsopenintheReceivablesModuleuntiltheFundsforitarereceived.AndoncetheFundsarereceivedtheinvoiceisclosedwiththereceipt.

Thereare10typesofInvoicesinAP:

Standard,CreditMemo,DebitMemo,Prepayment,WithholdingTax,MixedInvoice,ExpenseReport,POdefaultand QuickMatch,RecurringInvoice

Thereare6typesof InvoiceinAR:

Invoice,CreditMemo,DebitMemo,Chargeback,DepositandGuarantee.

∙Whatisrecurringinvoices?

Recurringinvoicesarethoseinvoiceswhichreoccursafteraspecifictimeintervale.g.MonthlyRent

Invoicesfortheperiodicexpensesarecalledasrecurringinvoices

e.g.,electricitybill,

∙WhatareAPsetupsteps?

Setup---->suppliers....>invoices...>payments.....>reports......>periods.....>transfertoGL

∙Ifthevaluesetisoftype–TABLEthenhowmanytablescanweattachinthevalueset?

NNumberoftablescanbe used inTabletypevaluesets.

∙CanyouaddadescriptiveFlexFieldtoatablewhichalreadyhasdatainit?

Yes,youcanaddDFFtotablewhichisalreadyhavingData.

∙HowtotakecareofnullvaluesinSQLLoader?

TRAILINGNULLCOLS

∙WhatisICA（InternetComputingArchitecture）?

InICAwehave desktopClient,ApplicationServerandDatabaseServer.

∙WhatisSetofBooks?

WhatarethefourconditionswhenyouchangeyourSOBs?

ChartofAccounts,Currency&Calendar

∙WhatisMultipleOrganizationtechnicalarchitecture?

MultiOrganization:

Usingasingleinstallationofanyoracleapplicationproduct,tosupportanynumberofanorganizationevenithasdifferentSetOfBooks 

BusinessLevel（ItSecuresHumanTransactionInformation） 

|| 

SetOfBooks（ItsecuresallTransactionInformationInOracleGeneralLedger） 

|| 

LegalEntry（AlllegalInformationintheOrganization） 

|| 

OperatingUnit（ItUsesOrdermanagement,Cashmanagement,AR,AP...itmaybeSalesOffice,Division,Department） 

|| 

InventoryOrganization（InventoryDetails）

∙WherecanwefindTEMPLATE.FMBfile?

Template.fmbfilecanbefoundinAU_TOPresourcedirectory.ThisfilecontainsalltheCommoncharacteristicsalltheforms.AndalsoContains Differentlibraries.LikeCUSTOM.pll,APPCORE,APPCOREE2,FNDSQF,JE,JL,JA,VERT,GLOBEetc.AndTemplate.fmbcontainsDifferentpropertyclassesforalltheobjects.ThisTemplate.fmbcanbeusedfordevelopingthenewform.

∙Whatisthedifferencebetweencross-validationrulesandsecurity-rules?

Securityrulesapply atValueSetlevel whileCrossValidationRuleappliesonSegmentvalues.

∙InhowmanywayscanyouenterajournalinGL?

2waysofjournalentry1）.Standardentrymethod,2）.Importmethodusinginterfaces.

∙WhatarethesetupstepsforAP,AR,