Oracle Apps Interview Questions文档格式.docx
- 文档编号:7508407
- 上传时间:2023-05-08
- 格式:DOCX
- 页数:43
- 大小:41.55KB
Oracle Apps Interview Questions文档格式.docx
《Oracle Apps Interview Questions文档格式.docx》由会员分享,可在线阅读,更多相关《Oracle Apps Interview Questions文档格式.docx(43页珍藏版)》请在冰点文库上搜索。
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)?
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'
v_request_id:
=fnd_request.submit_request(applicationshortname,concurrentprogramshortname,description,paramers)
commit;
ifv_request_id>
0then
dbms_output.put_line('
Successfullysubmitted'
else
NotSubmitted'
∙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,
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Oracle Apps Interview Questions