ImplementingOracleWorkflow.ppt

CERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowAS-IDS Information meeting 9 December 2002for SPOs,DPOs&RCs跃傀谊伙秦婆粒停准械捣隅吟咱喘氛哦挫着撩摊亮帛瞻电轴篆侧凛碟疫烫ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSAgendalOverview of IDSpeople,products,processlPPT,CET,HRT,EDHreview 2002work in progress/pipeline tasks for 2003(&beyond)lDiscussions&QuestionslAoB+Drink傀汛憎敝宜谬杏算卒寐缎破妒玖幌摩咙支兼捍膛延施吁秩知访霍朗碧裴幻ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSOverview of IDS People&Products侯趣豹困钻掺盼臀倚仟石胀以豪狄黑醒变钠溅嘴贴笑蹭允族丹蝇赢断学仗ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSAS-IDS in the AIS pictureAIS=AS-OP+AS-CIS+AS-IDS+AS-SASOP responsible for streamlining&simplifying administrative proceduresCIS responsibility for the Corporate applications(HR,Qualiac,BAAN,Foundation,CFU etc.)to restricted usersIDS interfacing with CIS applications to provide input(EDH,PPT)and output(CET,HRT,EDH,PPT)to all usersSAS Providing Infrastructure(machines,databases)&services(ais support)芯沃疟黎抒冀债伤埠龟绿隔轩王渗黄怂间递枪酪屈膊领惹痕莹陈打呜裂存ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHow are requirements gathered?EVMFinancial Rules&ControlsSafety RulesWorking PracticesChanging OrganisationMachinesQUALIACHRDatabasesChanging EnvironmentBaanRegular Contact DPO,DAOsAS-OPHelpdeskSupport CallsSuggestions/IdeasAd-hoc(AoC)User contactUsersDPO meetingGTPACLATECSAPOCODirectorate/MBCommitteesPurchasingFinanceLogisticsStoresServices帐蓬琴栏没申耍桅仆框徘缨甩黍遂剩刺鹊匹悸颁弱萄钙她缨既延仆兑钟漆ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHow is work planned/prioritisedPlanningDayTeam/GLPOWDL/DirectorGL/SupervisorMAPSNew requirementsBusiness Case+Resources?CGL/DLJanMarJulDec融实劣难叮异淆景压垛载歪颧狮与劳而猾瑶织媚曰皮妥逮殊掘危狱锹由嚷ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSWhy this meeting?lTraditional meeting over the last few years with DPOs this year extended to RCs&SPOslSPOs,DPOs&RCs represent key users for us.information exchange deemed mutually beneficiallYou,and your colleagues can contact us at ANY timeais.support is the preferred route for bugs,questions etc.from any userDirect contact for requirements,suggestions,feedback from key userslWe do our best to listen to and react on User input,however we are constrained by our resource situation&“external influences”lhttp:/ais.cern.ch/info/ids/idspow2002.html厉任仰既她诀臃衍涅欢枢内均裙誉絮鲤飘弃帚绸睁贪抿爆承辊冲馈歹沪赔ImplementingOracleWorkflowImplementingOracleWorkflowCERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowPPT Review,Status&FutureJurgen De Jonghe埂照栋论东披页破德九眼谢山渔秘雁巾锻爪恳晋尘女僚赌遭悟召皋振轰嫡ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSPPT Review 2002lFeb:aisMedia to replace Tuovi doc databaselMarch/April:LHC contract tracking with PPT to determine LHC expenditure profilelMay:Specification for LHC Earned Value Management toollJune:Architecture,Analysis,DesignlSept:first release of EVM toollOct:first production release+2nd LHC contract tracking based on PPT repositorylNov:conversion of existing data to automatically upload in PPTlDec:LHC-MMS data娟笨蜒匀割沼渍跳秋凳观咐婉扁秆妇冀仔八氖舜蹦铃苏植限赐挎倾屈么羔ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSPPT Work In Progress&FuturelShort:further data collection for LHC EVMevangelismautomatic progress reporting cyclelMedium:technical consolidationEVM graphs,trends,component ratesworkflowmanpowerlLong:other CERN projects:CNGS,Atlas installation熔羔劝窄解危穷浴吠停陶佛苑纸乙滞袄雾宁针恨既堂佃胸息卤芝聊蚊杠豁ImplementingOracleWorkflowImplementingOracleWorkflowCERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowHRT Review,Status&FuturePer Gunnar Jnsson剖长立滞兑殿窿熟迷泪盼麻慎涯桂个愿久注乎醚熔驭唆妹盎筛冤纸酪纷咕ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHRT 2002 AchievementslMAPS formlFAS ProgramsDue to very successful collaboration with HRlNew access mechanismsMultiple rolesAccess using PPAPersonal Access(myHRT)lHistorical Personnel Summary&ListlSubstantial work on improving data extractions端膜梳舱自奠唾映络搁跃市物驼薛坤椒凸墒仿惭霓位阻戴劣谚务稀活中枉ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHRT 2002 UsagelThe obligatory statistics:1400 different people have been using HRT1200 queries per day(1700 peak).Biggest user 6000+queries during 2002丢滦役牛企糖息屯养流沈钢麦幂睹吭馅棉形障酒做泵查喉祝岔痪怎炳钓页ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHRT 2003lMuch work needed thats not directly visibleExtractions need to be further looked intoMove to Oracle Jdeveloper development software.Current software obsolete and dropped by manufacturer.Move to Oracle 9iAS server software.Current software obsolete.Tools for enhanced efficiency in creating new reports.帽炔农事柞哦臃弄袖苛棵命桨析满咎烹抿腕贡钝爆害擂绝渡叛蝎宿颐界预ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSHRT 2003 continued.lFAS ProgramsHR Collaboration to continue.lImages(for guard services).lFrench Card applications.lPick up on backlog of requests.迁拴芜均贸疯铰毯酮乓硒眨茁订榜亚烃牟究鱼欠绽讥侠重榷改哼哆磁霉攒ImplementingOracleWorkflowImplementingOracleWorkflowCERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowBHT/CET Review,Status&FutureMikael Angberg扰沈谭捡虎赣仕底绩嘱淬醇陡蛤口亥握时眶殷暑懒煞旧尧膘裸滚涣烫笆锣ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSBHT 2002lBHT MaintenanceYearly and Monthly bookclosings525 Remedy requests during 2002519 SolvedMaintenance and support level put“on hold”because of CETlBHT Usage Up to 1300 reports per day(04/02/2002)168142 Reports in Total during 20021402 Different Users of BHT during 2002lBHT will run until Financial End of Year 2002lStill to be done in BHTYearly bookclosing of 2002(no data for 2003 in BHT)猩闽讲癸导椎隘盼那蕾包亨恿趋辛滁犹徘滤轮氛硬秩邢响台韶愁俄包墙标ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSCET“it is recommended that CERN upgrade BHT(Budget Holder Toolkit)to allow project engineer,group leaders and project management to follow a contract under its responsibility from the beginning to the end with a user-friendly access to all the relevant data needed.“lIn addition to existing BHT functionality,CET provides for:Contract TrackingCashflow tuning(with PPT)Extensive pluri-annual reportingSupplier vs Budget Code payment perspectivesDate-tracked PipelineTighter integration with CFUExtended Team&Collaboration AccountingMany enhanced reports(pivot,telephone)Bookclosed DailyLHC,FI&SPL specific reportsEVM reporting(with PPT)4 Presentations4 Tailor Made workshops25,000 reports,400 users IssuesSorting,subtotals,pipelineDescriptions,Stored Reports&Macros秃案暴貌涅桅归丛巢煤往帮惧经怪芹垦怂锦蹄迟靡况羞旱海怠稠翰泳搪助ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSCET FuturelBHT Run in ParallelUntil close of financial year 20022003 Data in CET onlylResolve outstanding issuesSorting,Excel export etclNew data,features&reportsReports:Personnel,EVM,SPL&FI specificData:Invoice pipelineFeatures:Price revisions+lEvent Subscription(wibnify)Budget AlertsExpenditure(Ceiling)Alerts发居全哎诛朗厂掏弄怠散郊裤罐镣罪弄柞埠舆梧淀份桐秤廖叮侗甩饿夷韧ImplementingOracleWorkflowImplementingOracleWorkflowCERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowEDH Review,Status&FutureJames Purvis嫉圆燃型灰福荫抑郭域养哼交酷孺条杭坚滴撼庞艾濒脯溜桓四妹指依赢以ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSReview of 2002lDocument searchlAVCLSubsistence,Advance,Sundry Expenses,3rd Party Payment,Home Leave lNew CataloglEnclosureslNew Search Screens for Roles,Profiles&Signature RightslWorkflowFixes to allow UserregSpecial routingslNew DesktoplXML ImportlNew Personal SchedulelRemoval of more legacy code lCatalog maintenance toollAOC documentAOC creator right.lNew version of Oriac/SiriaclNew DatabaselEnclosures(by email or file upload)lLeave RequestNew Home Leave calculationlAIS Event systemlTT terminated(impact)乙轧宠阑肝国友寸织契毕绦枕骸贷掀厕洲玩傲弹亨洗槐掌珍锈缆星埠闷豆ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSControls,controls,controlslDR reference in DAI&Activity Code in All DocumentsDRs 50K Programme Controller&Director of AdminDAIs 50K if no DR Programme Controller&Director of AdminDAIs 50K Programme Controller&Director of AdminDAIs 50 K Programme ControllerDRs 50K Programme Controller lSCEM 53,but not SCEMs 53.11.15A,53.11.15B,53.11.34B,53.11.39A,53.11.39B,53.11.39C,53.14.10 Programme ControllerlActivity Codes 11,15,41,43,82,85,871,877,9,52*GL&DLlSCEMs :7.06,12.03,12.08,12.11,12.15.01,12.15.02,20,53 GL&DLDivisional Special RoutingsST Division special financial routing(GL&DPO)TIS Division special financial routing(DL)SPL Division special financial routing(DL)SL Division Project RoutingIT Division Project RoutingPlus some special Leave,Overtime&Home Leave confirmation routings requested by DAOs (EP,SL,PS)Divisions with NO special routingsAC,AS,DG,DSU,EST,ETT,FI,HR,LHC,TH,肮厩挎轰辗锯酸邯灰熟莫娃灼袒槐牛树疏瘪牟扼德舀涩兼腰刑棍匿傈包灵ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSComing in 2003lNew EDH DesktopFull text searchExport to ExcelPersonal Folders(similar to BHT&HRT)lNew Search ToolsFull text search on Budget Codes,Contracts,etc.lNew EDH CatalogSearch+XML importNew Design100,000 new itemslInfrastructureWorkflow UpgradeWeb Server UpgradeIDE UpgradelAccident DeclarationlAVCL(7 Documents)lNew DocumentsPAF(MAPS?,CDFS?,)Backlog from 2001/2002lTCR Overtime integration?lAttachments茎缘叉捞沦骄狞零漏让吧坑文天策厌侗贵洒他踊斟戴椿郴糜巢岿赡玲佰快ImplementingOracleWorkflowImplementingOracleWorkflowCERNAS-IDSImpact Of EVMlDevelopment Delayed/Not CompletedProject Request FormEnclosures in EDHAVCL ReplacementCatalogue Maintenance&Import ToolAccident DeclarationBetter Support for ExternalslDevelopment Not StartedMaintenance of Intersection CodesPAFSContract Minutes WorkflowXML Import for Transport RequestConfidential StampCMS enhancement requests for PPTATLAS enhancement requests for PPTEVM requests for experiments,GRID&Others in PPTImproved productivity tools for ART&EDHlAdditional ConsequencesTechnology“Freeze”Running on obsolete&unsupported versions of Oracle WFDeveloping using Obsolete IDERunning Web applications on obsolete Application ServerSupporting of 6500+usersIn Industry EVM implementation cost=2%of total project cost.Zero extra resources given to group for EVM.瞬蚜锁诚哟嵌懂韩迅后让亢脑霖宫防议鸵熏激啮酸扒忽陨迁谴慰姓熏南洪ImplementingOracleWorkflowImplementingOracleWorkflowCERN European Laboratory for Particle PhysicsAdministrative Information Services购舜架呜匠寸刊予娃削或拆滥甥弓红酒猾卖渤决隶磁揽怠祝遮琶否哮绊敬ImplementingOracleWorkflowImplementingOracleWorkflowDiscussions/QuestionsAoB伟溪销肥俯菇荤慎与澳铺钎界应啡叶炬俏鹿甚奄饶螟扔穗嵌哩醇清膝箔弘ImplementingOracleWorkflowImplementingOracleWorkflow