忙裏偷閑
很多事情很多心情寫了也就記下了; 不寫，以後可能就忘了.
博文
(2009-02-25 13:52:16)
1)Commandstodownloadconcurrentprogramdefinitions.FNDLOADapps/$p_apps_pass0YDOWNLOAD$FND_TOP/patch/115/import/afcpprog.lctLUCY0074.ldtPROGRAMAPPLICATION_SHORT_NAME=LUCYCONCURRENT_PROGRAM_NAME=LUCYACCLINEDETFileLUCY0074.ldtwillbecreatedandcontainsalldefinitionandinformationrelatedtoprogramLUCYACCLINEDETunderapplicationLUCY.DatabasePasswordforappswillberequiredandpassto$p_apps_pass.0074iscemlinumber....[閱讀全文]
(2009-02-24 14:35:03)
1)CEMLI
CEMLIDefinedasConfigurations,Extensions,Modifications,LocalizationsandIntegrations,allofwhichrefertorecommendedwaysinwhichthestandardsolutionscouldbemodified,ifrequired.OracledefinedtheCEMLIFramework,whichtranslatesinto20classesofextensionsthatcustomerscanaddtotheirOraclesystems.ToSimplify,CEMLIisOracle'spublishedguidelinesfordevelopingandimplementingcustomextensionstoOracleApplication...[閱讀全文]
CEMLIDefinedasConfigurations,Extensions,Modifications,LocalizationsandIntegrations,allofwhichrefertorecommendedwaysinwhichthestandardsolutionscouldbemodified,ifrequired.OracledefinedtheCEMLIFramework,whichtranslatesinto20classesofextensionsthatcustomerscanaddtotheirOraclesystems.ToSimplify,CEMLIisOracle'spublishedguidelinesfordevelopingandimplementingcustomextensionstoOracleApplication...[閱讀全文]
(2009-02-23 14:16:15)
I’mworkingthe‘ViewAccountingLinesDetailedReport’andneedtoaddanadditionalfieldwiththelogicbasedonfieldPA_ADDITION_FLAGofAP_INVOICE_DISTRIBUTIONS_ALLtabletospecifyifprojectrelatedinvoicedistributionshavebeentransferredintoOracleProjects.Thisistheoriginalquerywhichhasbeenworkingfine:select
NVL(ai.invoice_num,APC.CHECK_NUMBER)doc_num,
pov.vendor_nameSupplier,
al.ae_line_type_codeline_ty...[閱讀全文]
NVL(ai.invoice_num,APC.CHECK_NUMBER)doc_num,
pov.vendor_nameSupplier,
al.ae_line_type_codeline_ty...[閱讀全文]
(2009-02-23 09:59:32)
早就聽人說：七歲八歲狗都不理。知道這個年齡的孩子不好管，心理已有準備，但我是還心存僥幸，想著順順以前一直讓我們比較省心，在他terribletwo的年齡也沒怎麽讓我們煩惱過，可這次我錯了，看來是躲不過了。好多人也許認為我實在偏心，博客裏的文章大多關於妮妮的，順順的並不多。每次寫妮妮時，我也心存慚愧，總覺得應該寫寫順順。可腦海裏都是順順不聽話惹我生[閱讀全文]
(2009-02-20 07:00:29)
TomakechangesontheOracleForm,weneedtoknowtheoriginalformnameOracleprovided.
Toknowthis,
1)opentheform,gotomenu:Help->AboutOracleApplications.Scrolldown,youwillfindthecurrentformnameinthelastsection.
2)gotomenu:Help->Diagnostics->CustomCode->Personalize[閱讀全文]
Toknowthis,
1)opentheform,gotomenu:Help->AboutOracleApplications.Scrolldown,youwillfindthecurrentformnameinthelastsection.
2)gotomenu:Help->Diagnostics->CustomCode->Personalize[閱讀全文]
(2009-02-19 15:02:17)
Whensubmittherequestwithoutputformat‘Excel’,theresultisnotinExcelfile.
Solution:ConfigureinSystemProfile:LoginasSystemAdministrator,Profile->System,checkUser,putloginID,thensearch‘%Viewer’.Set‘Viewer:ApplicationforText’to‘Browser’;Set‘Viewer:Text’to“Browser’.
That'sit![閱讀全文]
Solution:ConfigureinSystemProfile:LoginasSystemAdministrator,Profile->System,checkUser,putloginID,thensearch‘%Viewer’.Set‘Viewer:ApplicationforText’to‘Browser’;Set‘Viewer:Text’to“Browser’.
That'sit![閱讀全文]
(2009-02-19 14:26:43)
1)BelowareerrormessageswhenfirsttimeopeningaformwithOracleForms.
FRM-18108:Failedtoloadthefolllowingobjects.
SourceModule:APPSTAND
SourceObjectLSTANDARD_PC_AND_VA
.........................................................
2)Reason:Couldn’tfindthenecessarysources.
3)Solutions:1)GototheUnixservertofindallsourcecodes.Theyarein…au11.5.0resourcedirectory.Thebelowexample,caedbr2...[閱讀全文]
FRM-18108:Failedtoloadthefolllowingobjects.
SourceModule:APPSTAND
SourceObjectLSTANDARD_PC_AND_VA
.........................................................
2)Reason:Couldn’tfindthenecessarysources.
3)Solutions:1)GototheUnixservertofindallsourcecodes.Theyarein…au11.5.0resourcedirectory.Thebelowexample,caedbr2...[閱讀全文]
(2009-02-19 14:22:02)
It'sin../au/11.5.0/USinsteadof../ap/11.5.0/US,../ar/11.5.0/US....[閱讀全文]
(2009-02-19 08:38:33)
1.Inmultiorgenvironment(likeuk+franceinonedb),eachMulti-OrgTablewillhaveacolumnnamedorg_id.Tableslikeinvoicesareorgsensitive,becauseUKhasnopurposetoseeandmodifyfrenchinvoices.HenceainvoicetableisacandidateforORG_IDcolumn.
Bydoingso,UKResponsibitieswillfilterjustUKInvoices.ThisispossiblebecauseinApps,Invoicescreenswilluseap_invoicesintheirqueryandnotAP_INVOICES_ALL.
2.VendorSites/Locationsa...[閱讀全文]
Bydoingso,UKResponsibitieswillfilterjustUKInvoices.ThisispossiblebecauseinApps,Invoicescreenswilluseap_invoicesintheirqueryandnotAP_INVOICES_ALL.
2.VendorSites/Locationsa...[閱讀全文]
(2009-02-18 08:33:00)
1)Tofindthedefaultorgidandorg_nameforcertainresponsibility:
selectnamefromHR_ALL_ORGANIZATION_UNITSwhereorganization_id=fnd_profile.value('ORG_ID')
2)tofindthedefaultreportinglevel: SELECTMEANINGFROMFND_LOOKUPSWHERELOOKUP_TYPE='XLA_MO_REPORTING_LEVEL'ANDLOOKUP_CODE=(SELECTDECODE(NVL(MULTI_ORG_FLAG,'N'),'N','1000','Y','3000')FROMFND_PRODUCT_GROUPS)
3)TofindthedefaultreportingContext: ...[閱讀全文]
selectnamefromHR_ALL_ORGANIZATION_UNITSwhereorganization_id=fnd_profile.value('ORG_ID')
2)tofindthedefaultreportinglevel: SELECTMEANINGFROMFND_LOOKUPSWHERELOOKUP_TYPE='XLA_MO_REPORTING_LEVEL'ANDLOOKUP_CODE=(SELECTDECODE(NVL(MULTI_ORG_FLAG,'N'),'N','1000','Y','3000')FROMFND_PRODUCT_GROUPS)
3)TofindthedefaultreportingContext: ...[閱讀全文]
