忙里偷闲
很多事情很多心情写了也就记下了; 不写，以后可能就忘了.
博文
(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: ...[阅读全文]
