ssg

Home ContactUs February10th,2012

Bridgingthegapbetweenvisionandimplementation aboutus whatwedo clients partners joinourteam news blog

PostsTaggedPipeline

HowtoGetBRM PipelineWorking
April9th,2010byMarkPeterson2Comments

IrecentlyinstalledandconfiguredtheBRMpipelineratingusingBRM soptionalWirelessSuite.Ihada difficulttimegettingittoworkbecauseitrequiresinstallingmanyinterdependentcomponentsandmanymanual configurationsteps.Hopefullythisblogwillhelpyougetitworkingwithoutmuchdifficulty.Mostofthe difficultyhastodowithfiguringoutwhatstepsareneededandwhy.TheBRMdocumentationhasmostofthe informationyouneedbutitisnotinoneplaceanditsimplytellsyoutodothisorthat.Itdoesn tdoagoodjobat explainingwhatisneededtogetthepreconfiguredwirelesspipelinetowork.Italsodoesn texplainhowto createaccountsandCDRsthatworkwiththethesepreconfigureditems.Ilearnedoutalotfromgettingitto workthough.Sohere swhatIlearned. Pipelineratingisacompletelystandaloneratingengine.Thesestepstakeyouthroughtheprocessofconfiguring thepipelineandBRMsystemsoyoucancreateaccountsthatthepipelinecanworkprocessandthencreate,rate andloadCDRsintoBRM.Thepipelineneedstohaverateplans,zonesandotherfeaturesloadedintheIFW database.BRMneedsnewevent,service,deviceanditemclasstypesconfigured.ThepipelineusessomeBRM databaseconfigurationitemstoworkwhereasBRMneedssomeFMstohandlefunctionalityaroundtheCustomer Centerextensions.You llalsoneedtoinstalltheTelephoneandSIMCardAdministrator. Thebasicstepstogetittoworkarelistedhere.Moredetailsarebrokenoutinthesectionthatfollow. InstallCustomerCenterExtensions. InstallServersideComponents.

ConfiguringtheWirelessRegistryFile ConfiguretheIFWDatabasewithDefaultRatePlansandSettings. Runpin_setupScripts ConfigurePIN_REL LoadtheTelcoGSMEventMap MergeandLoadTelcoEventNotification CreatePortalProducts,Deal,PlanandaddtoPlanList LoadDeviceServiceMap LoadItemTypeMapping SettingupGSMAccountsandServices. ProcessCDRFile TestingandTroubleshootingPipelineRating

I nstallCustomerCenterExtensions Thefirstthingsyou llneedtodoisinstallapanelandit sassociateddialogboxesintoCustomerCenter.This panelisneededtocreateaccountswithtelephonyservices.Theseservicesrequirephonenumbers,SIMcardsand IMEInumbersinordertomaintain,rate,billandprovisiontheservice.BRMaddedthispanelsoCustomer ServiceReps(CSRs)canselecttelephonenumbers,SIMcardsandIMEInumberswhencreatingnewaccounts. YouwillalsoneedtoinstalladmintoolsusedforcreatingblocksoftelephonenumbersandSIMcards.Theinstall scriptsfortheseadmintoolsandtheCustomerCenterextensionsarelocatedonhttp://edelivery.oracle.com. Select OracleCommunicationsApplications inthedropdownandtheOSyou reworkingwithe.g.Microsoft Windows32bitplatform.Selectsearch. Selectthe BRMMediaPackforMicrosoftWindows(32bit)anddownloadOracleBRMclientsforWindows. AfteritdownloadsunzipthefileandinstallthesethreeclientcomponentsonyourPC. GSM_Mgr_CustCtrExt NumberAdminCtr SIMAdminCtr TheinstallscriptsassumeyouhaveCustomerCenteralreadyinstalledanditusuallyfindstheinstallation directorybyitself.Theinstallationoftheseclientsidecomponentsiseasy.Afteryouunzipthepackages,just executethesetup.exefileandfollowtheinstructions. I nstallServersideComponents SincethepipelineratingengineisnotpartofBRM,somesomenewopcodesareneededbyBRM.Although youhaveinstalledthepipelineratingengineontheserver,younotdoneyet.Thereareseveralmorecomponents youwillneed.Ifyouhaven tinstalledthepipelineratingengine,Ibloggedaboutitin,CommonBRMPipeline InstallationIssues. Ifyoudon thavetheinstallscriptsshownbelow,you llneedtogotoOracleedeliverysiteanddownloadthe optionalBRMcomponents.It sundertheOracleBRMMediaPack>OracleBRMExtensions. UnzipthefileandruntheseinstallscriptsasthePINuser.Theactualnamesmaybealittledifferentdepending upontheversionandplatformyou reusing. 7.4_WirelessSuite_linux_32_opt.bin 7.4_SIMMgr_linux_32_opt.bin 7.4_NumberMgr_linux_32_opt.bin 7.4_GPRS_Mgr_30_linux_32_opt.bin 7.4_GSM_Mgr_linux_32_opt.bin

ConfiguringtheWirelessRegistryFile WhenyouinstalltheWirelessSuitecomponent,itcomeswithapreconfiguredwirelesspipeline.Theregistryfor thispipelineislocatedinthetheIFW_HOME/confdirectoryandiscalledwireless.reg.Youwillneedtoeditthis filebyenteringtheconnectioninformationyouusedforsettinguptheIFWandPINdatabase.Itneedsthe databasealias,andusernameandpasswordsyouused.ThereisoneentryfortheIFWdatabaseandtwoentries forthePINdatabase.YouwillneedtoencryptthepasswordsusingAESencryption. NextyouwillneedtocreateanIFWsynchronizationqueue.Thewirelesspipelineregistry,wireless.reg,calls thesyncqueueIFW_SYNC_QUEUE.Itiscreatedbyrunningthepin_ifw_sync_oracle.plscripts.Icouldn tgetit toworktakingsomeofthedefaultvaluesasshowninthescriptusagesyntax. pin_ifw_sync_oracle.plcreate[lusername/password@databaseAlias][qqueue_name tqueue_table] Afterincludingthefollowingcommandlineoptions,Iwasabletogetittowork.Youwillneedtomodifythisfor yourparticularenvironment. perlpin_ifw_sync_oracle.plcreatelpin74/pin74@pindbr300s tablespacePIN74initrans5storage(initial 200knext200kmaxextentsunlimitedpctincrease0) ConfiguretheI FWDatabasewithDefaultRatePlansandSettings. TheBRMWirelessSuitecomeswithapreconfiguredsetofrateplans,discounts,impactcategories,etc.These settingsarestoredintheIFW_HOME/conf/pricingcenter/Oracledirectory. EdittheperlscriptcalledinsertWIRELESS_SAMPLE.plinthisdirectory.Changetheoracleconnection propertiestousetheIFWdatabasealiasandusernameandpasswordyouchose.Whenyourunthisscriptitwill executetheinsertstatementscontainedintheSQLscriptslocatedinthisdirectory.YouwillnoticethateachSQL scriptisnamedaftertheIFWtableitupdates.ThismakesitveryeasytoseewhatisbeingaddedtotheIFW database.Asyoucansee,therearealotoftablesaffectedbyrunningthisperlscript. ifw_alias_map.sql ifw_apn_group.sql ifw_calendar.sql ifw_daycode.sql ifw_discarding.sql ifw_discountbalimpact.sql ifw_discountdetail.sql ifw_discountmaster.sql ifw_discountmdl_ver.sql ifw_discountmodel.sql ifw_discountstep.sql ifw_discounttrigger.sql ifw_edrc_field.sql ifw_exchange_rate.sql ifw_holiday.sql ifw_icproduct_all.sql ifw_map_group.sql ifw_mostcalled.sql ifw_networkoper.sql ifw_pipeline.sql ifw_pricemodel_step.sql ifw_rateplan_cnf.sql ifw_rateplan_ver.sql ifw_ref_map.sql ifw_rsc_group.sql ifw_seqcheck.sql ifw_servicecode_map.sql ifw_service.sql ifw_specialdayrate.sql ifw_splittingtype_all.sql ifw_taxcode.sql ifw_taxgroup.sql ifw_timeinterval.sql ifw_timemodel_lnk.sql ifw_timezone.sql ifw_uom.sql ifw_apn_map.sql ifw_destinationdesc.sql ifw_discountcondition.sql ifw_discountmdl_cnf.sql ifw_discountrule.sql ifw_edrc_desc.sql ifw_glaccount.sql ifw_impact_category.sql ifw_networkmodel.sql ifw_pricemodel.sql ifw_rateplan.sql ifw_resource.sql ifw_serviceclass.sql ifw_specialday_lnk.sql ifw_standard_zone.sql ifw_tax.sql ifw_timemodel.sql ifw_usageclass_map.sql

ifw_usageclass.sql ifw_usc_group.sql

ifw_usagescenario_map.sql ifw_usagetype.sql ifw_zonemodel.sql

Torunthiscommand,besuretoredirecttheoutputtoafile.Itstreamsabunchofinformationtothestandard output.Itdoesn toutputtoalogfilesoyoumaywanttolookbackthisfiletobesureitranproperly. Runpin_setupScripts Asapinuser,goto$PIN_HOME/setup/scripts Runthepin_cmp_tcframework.plfile.Thisinstallscriptcreatesabunchofnewclasses(tables)inthePIN database.Expandthenodesbelowtoseewhattableswherecreated: ServiceObjects:

EventObjects
      

ConfigObjects:


Runtheperlpin_cmp_gsm.plscriptExpandthefollowingnodestoseewhattables(classes)arecreated. ServiceObjects


EventObjects:

   

ConfigObjects:
 

Active_sessionobjects:

Runthepin_cnf_tcframework.plscript.ThiswilladdthefollowingFMstotheCMpin.conffile.TheseFMs containopcodesusedbytheCustomerCenter. fm_prov fm_prov_pol fm_tcf fm_tcf_pol fm_trans_pol Runthepin_cmf_dm_prov_telco.plandpin_cnf_dm_prov_telco.pl ThiswillconfiguretheCMpin.conffileanddm_prov_telcopin.conffile.Youmayalsowanttoeditthestart_all andstop_allscriptsothatdm_prov_telcostartandstopswiththerestoftheCMandDMs. ConfigurePI N_REL Thereareseveraltrapsyoucanfallintotryingtogetthepin_relutilitytoworkforthefirsttime.Youwillneedto runsomesetup/scripts,modifytheuser$PATHandmakesureOraclesqlldrisinstalledontheserver.This sectionwillhelpyouavoidsomecommonproblems. First,thepin_relutilityrequiressomenewtablesinthedatabaseschematooperate.Gotothesetup/scripts directoryandrunthepin_cmf_rel.plandpin_cnf_rel.pl.Nextaddthe$PIN_HOME/apps/pin_reltothepinuser $PATH.AndfinallybesureOraclesqlldrisinstalledontheserver. Thepin_relutilityuseSQLLoader(sqlldr)toloadeventsintotheBRMdatabase.Toseeifitisinstalledonyour server,executingsqlldrfromthecommandlineasthepinuser.Ifitcan tbefoundchecktobesurethe $ORACLE_HOME/bindirectoryisinthepath.Ifsqlldrisn tinthebindirectory,theninstallit.It spartofthe

OracledatabaseinstallationsoyouwillbasicallyhavetoinstallOracleontheserver.Sinceyoudon tactually needaconfigureddatabaseontheserver,skippingthisstepduringinstallationwillsaveyousometime. Forperformancereasonsyoumaywanttorunonthedatabaseserver.WhenyourunCDRsthroughthepipeline, youcanmaptheoutputtoanetworkdriveorcopythefilestodatabaseserver.Forourtestingpurposesrunning itontheBRMserverissufficient.IfyouhavealargeamountsofEDRstoprocessinproductionandtoloadinto BRM,thenyoumayneedtomovethepin_relappovertothedatabaseserver. LoadtheTelcoGSM EventM ap ThePricingCenterneedstobeconfiguredtorecognizetheneweventandserviceobjectsloadedinpriorsteps. Fortunatelytheneweventmapiscreatedforyou.ThiseventmapcomesalreadymergedwithBRMbaseline eventmaps.Ifyou reworkingwithabaselineBRMinstallation,youjusthavetoloadthemintothedatabase. Changedirectorytosys/data/configdirectoryandrunthecommand: load_event_mapdvpin_event_map_telco_gsm Ifyouhavecustomeventsalreadyloaded,thenbesuretoeditthepin_event_map_telco_gsmfilebeforeyourun thiscommand.Thiscommandwilloverrightthechangesmadetothedefaulteventmap,ifyoudon t.Ifyou forget,justrerunthecommandwithcustomeventsaddedtothisfile. M ergeandLoadTelcoEventNotification TheTelcoprovisioningisintegratedthroughtheeventnotificationframework.Whennewproductsandservices arepurchasedforanaccount,theeventnotificationframeworkneedstofireofftheseopcodes.Theseopcodes willperformfunctionalityrequiredtoprovisioningthenewtelephonyservicesthroughBRMsprovisioning framework. PCM_OP_TELCO_SVC_LISTENER 4008 PCM_OP_TELCO_APPLY_PARAMETER 4009 PCM_OP_TELCO_PROPAGATE_STATUS 4010 PCM_OP_TELCO_PROV_CREATE_SVC_ORDER 4016 PCM_OP_TELCO_PROV_HANDLE_SVC_ORDER 4017 PCM_OP_TELCO_PROV_UPDATE_PROV_OBJECT 4019 Toenabletheprovisioningframework,changetofollowingdirectorytosys/data/configandexecute load_pin_notifypin_notify_telco CreatePortalProducts,Deal,PlanandaddtoPlanList Inthissectionyouwillcreateaproduct,dealandaplanthatcanbepurchasedagainstaccountsandrateCDRs throughthepipeline.Wewilluseoneoftherateplansinsertedinthepipelinedatabasewiththe insertWIRELESS_SAMPLE.plscriptdescribedabove.StartPricingCenterandconnecttothePINdatabase. Clickonthecreateproducticon,enteranameandselectinthedropdownlistApplies To:/service/telco/gsm/telephony. Acceptallthedefaultvaluesandwhenyougettheprompt, Doyouwanttoaddorchangeratesandfoldsforthis product? ,clickon Yes.NowaddanEventMapandlocate DelayedSessionGSMSession .Thisshouldgive youamenuofPipelineSingleRatePlans.ClickonSearch/Reload Thispopupwindowshouldlooklikethis:

Clickandthen Select theGSMSampleRatePlan.Applychanges.Nextcreateadealandaplanforthis product.AddthePlantothedefaultplanlist.Commitchangestothedatabase. LoadDeviceServiceM ap load_pin_device_permit_mappin_device_permit_map_sim_telco_gsm load_pin_device_permit_mappin_device_permit_map_num_telco_gsm LoadI temTypeM apping Theeventsratedbythepipelineenginerequiresan/itemobjecttoassociatethesechargestogetherforanaccount. ThedocumentationprovidesexamplesforassociatingchargefromNewYorkorCalifornia to/item/gsm/new_yorkoritem/gsm/california.Forsakeofsimplicitywewilljustassociateallpipelinerates eventsto/item/usage/gsm.Todothis,youwillneedtoedittwoxmlfilesinthe $PIN_HOME/sys/data/pricing/examplesdirectoryconfig_item_tags.xmlandconfig_item_types.xml.Addthe contentsfor<ItemTagElement>tothefollowingfilesasshownbelow: config_item_tags.xml <ItemTagElement> <ItemTag>gsm</ItemTag> <EventType>/event/delayed/session/telco/* </EventType> <ServiceType>/service/telco/gsm/* </ServiceType> </ItemTagElement> config_items_types.xml <ItemTypeElement> <ItemTag>gsm</ItemTag> <ItemDescription>GSMUsage</ItemDescription> <ItemTypeprecreate= truetype= cumulative >/item/usage/gsm</ItemType> </ItemTypeElement>

Toloadtheseconfigurationfilesusingthefollowingutilities: load_config_item_tagsdvconfig_item_tags.xml load_config_item_typesdvconfig_item_types.xml UsingDeveloperCenterextendthe/item/usageto/item/usage/gsm.TodothisstartDeveloperCenter,clickon theStorableClassEditorandclickonthe/item/usageclassintheclasswindow.ThenclickFile>New>Class andadd /gsmtothebaseclass.AndfinallyclickonFile>CommitClasstoDatabase Ifyougetapermissionerrormessagecommittingthesechanges,recallthattheDM_ORACLEpin.conffileneeds tobesettoenabledtochangestotheclassandfielddefinitions,seebelow: dmdd_write_enable_fields1 dmdd_write_enable_objects1 YouwillhavetorestarttheBRMtoloadthesechanges. SettingupGSM AccountsandServices. BeforeyoucancreateaccountsusingtheGSMplancreatedinPricingCenter,youwillneedtoloadupasetof testphonenumbersandSIMcardstouse.WhatSIMcardandphonenumberyouspecifywillmatterfortesting. Forinstance,thepipelinewillnotrateanyoutofnetworkcalls.SoalltheCDRsyoucreatetotestinthepipeline willhavetousephonenumbersassociatedwithaccountsandservicessetupinBRM.Butbeforeyoucandothat youwillneedtoestablishablockofavailablenumberstoselectfrom. IfoundthedocumentationverygoodforlearninghowtousetheNumberandSIMCardAdministrator.These applicationsareusedtosetupablockofnumbersandSIMcardsthatcanbeconsumedbyaccounttelephony servicesinBRM.TheNumberAdministratorwasstraightforwardandeasytouse.Thereareacouplethingsto note,however,whenusingtheNumberandSIMCardAdministrator. 1)LoadSIMCardtypesbeforerunningtheSIMCardAdministrator.Fromthe PIN_HOME/sys/msgs/simcardtypesdirectoryloadtheSIMcardtypesbyusingtheload_localized_stringutility fromthecommandline: load_localized_stringssim_card_types.en_US 2)UseknowngoodtestSIMcardsnumbers.TocreateablockofSIMcardsyoufirsthavetoordertheminthe SIMCardAdministrator.Aftertheyareorderedyouwillneedtofulfilltheorder.Tomakethiseasier,refertothe endofdocumentationforconfiguringtheSIMCardAdministrator.ItcontainsasetoftestSIMcardnumbersyou canusetotestwith.Ifyoudon tusethesenumbers,you llhavetofigureoutvalidfulfillmentdatausedto activatetheorder. NormallyyouwouldexportafileandsendthisfiletoasupplierofSIMcards.TheSIMcardmanufacturerwould returnanorderfulfillmentsoyoucanactivatethenumbersforBRMtoconsume.Fortestingpurposesyouwill exporttheorderandmodifytheorderwithtestdataprovidedinthedocumentation.Asdescribedinthe documentation,itinvolvesappendingsomeorderfulfillmentcodetotheendoftheexportedorderandthen loadingthembackintotheSIMCardAdministrator. 3)SetthestatustoNotSpecifiedwhensearchingforSIMcardsintheCustomerAdministrator.Whenyou searchforSIMcardsintheCustomerCenter,itsearchesthroughavailabledevices(/device/sim)forSIMcards withastatusofreleased.YoucaneitherconfiguretheSIMCardAdministratortoinclude New status,or changethestatusto NotSpecified .

4)CoordinatetestphonenumberswithzonemappingvaluesandCDRtestdata.Ifyouplantoleveragepre configuredzonemappingsandsampleCDRsthenyoumightconsidercreatingablockofphonenumbersto includethesenumbers.Ifyoudon tyou llhavetoeditthesampleCDRstoincludetheonesyoudiduseand determinehowthenumbersareratedandmappedinthezonemap.Forreference,Iincludedsomephone numbersusedinthesampleCDRs.TheseCDRsIfoundintheIFW_HOME/data/indirectoryinafilecalled test_cdr.orig.ThesecondandthirdfieldinthefilesarethesourceanddestinationnumbersoftheCDR.Again, bothsourceanddestinationnumbersneedtobeusedbyaccountsinBRMforthemtorate.Nooutofnetwork phonecallswillwork.
4% , . / 2 4% , . / 2 4% , . / 2 $! 4 . / 2 &! 8 . / 2 4% , . / 2 3 3 . / 2 4% , . / 2 4% , . / 2 4% , . / 2 4% , . / 2 ' 024 ' 02

Andthesewherepulledoutofthewireless.readmefile:
4% , 4% , 4% # , 4% , / #

OnceyouhaveablockofnumbersandSIMcardsconfigured,youcancreateaccounts.UsingCustomerCenter, createaccountstoincludephonenumbersyouplantousefortesting. ProcessCDRFile Startuppipelineusingthefollowingcommandin$IFW_HOME. ifwr/conf/wireless.reg CreateCDRfileandplaceinto/conf/data/in TestingandTroubleshootingPipelineRating TheerrormessagesprovidedbythePipelineRatingenginemakesissomewhateasylocateproblems.Themost helpfulmessagesarelocatedinthe$IFW_HOME/log/streamdirectory.Youwillfindtwosetsoflogsforeach inputfile,Stream_test_XXXX.edr.logandlog_test_XXXX.edr.log.IfyouhaveCDRsinthedata/indirectorythat don tmakeittothedata/out/gsm/* checkhereforerrors.ThemostcommonerrorsIfoundwhereproblemswith theITEM_TAGvalue(beingnull)andproblemswithoutofnetworkphonenumbers.Ifyou rehavingtrouble withITEM_TAGnumbers,reviewthesectiononItemTagMapping.Ifyouhaveerrormessageforoutof networkphonenumbers,rememberthatbothsourceanddestinationphonenumbersneedtobeconsumedby accounts(innetwork)inorderforthemtoberated. Tags:BRM CBRM EDR grammar mapping Mark OracleBRM Pipeline registry 2Comments

CommonBRM PipelineI nstallationI ssues

March24th,2010byMarkPeterson8Comments

TherearealotofmovingpartsassociatedwiththeBRMPipeline.Installingitcanbeverydifficult.Thisblog shouldremovesomeoftheobstaclesyoufaceininstallingandconfiguringBRMpipeline. BeforewegetintotheinstallationthereareafewimportantpointstoconsideraboutPricingCenter(PC).First, thepipelinehasit sownschemawhereitlocatesandstorespipelinepricinginformation.PCmakesadirect connectiontothisschemabypassingCMandDM_ORACLE.ThePCgetsthepipelineconnectionproperties fromanextensionof/configobjector/config/pricing_admin.Thisdatabaseobject, PRICING_ADMIN_CONFIG_INFO_T,iscreatedandpopulatedusingaBRM(PIN)setupscriptlocatedinthe $PIN_HOME/setup/scriptsdirectory.ThepipelineconnectionpasswordisencryptedusingAESencryption. DM_ORACLEneedstobeconfiguredproperlytoencryptanddecryptthispassword.Thisblogwilltakeyou throughthisandotherkeyinstallationstepsneededtorunthepipelineinBRM. Thebasicstepsarequitesimple.Howevereachstephasseveralenvironmentaltrapsyoucanfallintoifyouare notcareful.Iwilllistthestepsandthenbreakthemdownintomoredetailbelow. 1.Runthepipelineinstallationscripts 2.Executethepipelinedatabasesetupscripts 3.SetupDM_ORACLEforAESencryption 4.CreatetheIFWDatabaseConnectionobject/config/pricing_admin. 5.Addpricingcenterpermissions. RunPipelineI nstallationScripts TheBRMandPipelinecodecanbedownloadedfromthehttp://edelivery.oracle.com/.Youwillneedtofindand selectOracleCommunicationApplicationsandtheplatformyou reusing.Thedownloadyouneedislocatedin OracleCommunicationsBillingandRevenueManagementMediaPack. Afteryoudownloadthefile,unzipthefileintoastagingdirectoryandcreateausercalledIFW.Youmaywantto createauserlikeIFW74,ifyouhavedifferentversionsofthepipelineinstalledonyourserver. Dependingontheversionandplatformyoushouldseeainstallationfilecalledlikethis: 7.4_Pipeline_linux_64_opt.bin ExecutethisfileastheIFWuser.TheinstallationusesXwindowssoonyoumayneedtorunthefollowing commandastherootuserbeforeyou llseetheinstallationUI. xhost+ Likewise,besureyouhaveturnedonXwindowsforyouIFWusers.Thiscanbedonebysettingthefollowing environmentvariable exportDISPLAY=:1.0 SpecifythelocationoftheIFWinstallationdirectoryandallowtheinstallationtocomplete.Thisinstallationis justunpackingfilesintoyourinstallationdirectory.TosetuptheIFWuser,youcanexecuteoneofthese environmentscripts. source.me.csh

source.me.sh ThesefilesarelocatedintheIFWinstallationdirectory,$IFW_HOME.Irecommendmergingthecontentsof thisfilewithyourloginprofilescripts.Onlinuxthatmaybethe.bash_profilefilelocatedintheIFWdefaultuser homedirectory. ExecuteThePipelineDatabaseSetupScripts Thereare4IFWdatabasescriptsand5JSAdatabasesetupscriptsyouwillneedtorun.Thesearelocatedinthe $IFW_HOME/database/Oracle/Scriptsdirectoryandtheyarecalled: ifw_Tablespaces.sqlifw_Create.sqlifw_Roles.sqlifw_Synonyms.sql JSA_Tablespaces.sqlJSA_Create.sqlJSA_Roles.sqlJSA_Synonyms.sqlJSA_Prepare.sql ThreeimportanttablesneedtobepopulatedcorrectlyJSA_USER,JSA_MODULESandJSA_USERRIGHT. Runningthesetupscript,pricing_admin.plscriptasdescribebelow,candothisforyou,butitrequiresSYSDBA accesstodoso.ADBAcanusethescriptsintheAppendixtopopulatethemwithdata.Besuretoeditthemfirst withschemanamesyoupicked. SetupDM _OracleforAESencryption AsthepinusercreateanAESencryptionkeyusingthefollowingapplication: pin_crypt_appgenkey Thiswillcreateanoutputthatlookslikethis:

Gener at i on of Encr y pt ed AES key i s s ucc ess f ul Enc r y pt ed k ey i s >&aes| 0D5E11BFDD97D2769D9B0DBF

Copythelinesbetweenthe>and< andplacethemintothesys/oracle/pin.conffileasshown:

c r ypt aes| ${ PI N_HOM / l i b/ ${ LI BRARYPREFI X} pi n_cr y pt _aes 4dm LI BRARYEXTENSI ON} " &aes | 0D5E11BFD E} ${

DonotcopythekeyIusedhere.Substitutethekeyfortheoneyoucreatedwiththepin_crypt_app.Bouncethe CBRMusingstop_allandstart_allandmakesuretheDM_Oraclecomesupagain. CreatetheI FWDatabaseConnectionobject/config/pricing_admin Locatethepin.conffileinthe$PIN_HOME/setup/scriptsdirectory EditthefollowingentriestocontaintheproperIFWconnectioninformation

pi pi pi pi pi pi pi pi pel pel pel pel pel pel pel pel i i i i i i i i ne l ogi n_nam I FW e 74 ne l ogi n_pw I FW 74 ne por t 1521 ne db_t y pe or acl e ne db pi ndb ne adm n s y st em i ne adm n_pw m i anager ne db_al i as pi ndb

Runthepricingadmin_perlscriptusingthefollowingcommandline:
per l pr i c i ng_adm n. pl i ni t i

Thiswillusethevaluesinthepin.conffileandcreateandpopulatethePRICING_ADMIN_CONFIG_INFO_T tableinthePINDBschema.AllowthisperlscripttosettheAESencryptiondirectly.Ifyoutrytodothiswith directsqlupdates,thiswillcauseproblemswithDM_ORACLEwhenittriestoreadtheobject.Allow DM_ORACLEtoencryptthepassword.DM_ORACLEwilldecryptthepasswordbeforeitpassesittoclient applicationthroughtheCM. ThisperlscriptwillalsocreatetheJSAUSERandrolesintheJSAtablesandschema.Inorderforittodothis youmustgiveitasysdbaadminuserandpassword.Theperlscriptcreatestheuser,createssynonymsandgrants theuserpermissionstocreatetables,views,indexes,etc.Thismaynotbeacceptableinsomeorganizations.The appendixcontainsscriptsthatcanbeusedbyaDBAtodothisaccordingtocorporatespoliciesandprocedures. AddPricingCenterPermissions UsingCustomerCenterorPermissionCenteraddthefollowingread/writepermissionstotheroot.0.0.0.1user:
/ pr i ci ngc ent er / dat abas eac ces s / pr i ci ngc ent er / f i l esy s t em c es s ac / appcent er / pr i c i ngc ent er / l oadpr i c el i s t / acc ess / appcent er / pr ov i si oni ngt ags / appcent er / pc ent er

TesttheconfigurationbybringingupthePricingCenter.Verifythatyouhaveaccesstothepipelineconfiguration toolsinthepricingcenter. TroubleshootingPricingCenter Ifyoumaygettheerrormessage Unabletoconnecttothepipelinedatabase.Pleasecontactyour administrator .whenstartingupPricingCenter,checktobesureyoucanconnecttothePipelinedatabaseusing theconnectionpropertiesspecifiedintheconfig/pricing_adminobject.

Youmayalsogetthiserrormessageifyoucanlogintothepipelinedatabase,buttheusercannotaccessthe JSA_USER,JSA_MODULE,orJSA_USERRIGHTtables. AppendixA.SQLScriptsforJSA_USER

) * 3! 53% 2) $, % $% $! #4) 6% / ' ) . 532&) 234. ! % 2 53% ! 2) , 532, ! 34. ! % 532! 54( ) $

) * 3! 53% 2) $, % $% $! #4) 6% / ' ) . 532&) 234. ! % 2 53% ! 2) , 532, ! 34. ! % 532! 54( ) $

AppendixB.SQLScriptsforJSA_USERRI GHT
) ) ) ) ) ) ) ) ) ) ) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) * 3! 53% ' 22) ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#!. 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% ! ( 4 2) $ / $5, % $#! . ) . 3% 53% ) 24#! . 50$! 4% . $% % #! . 2% $#! . 02) . #! , 4% !

AppendixC.SQLScriptsforJSA_M ODULES
) ) ) ) ) ) ) ) ) ) ) ) ) )

* 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . % * 3! / $5, % / $5, % $ / $5, % ! % ! % 3#2) 04) / . % 429$! 4% . 429" 9 / $) &$! 4% ) . . $% . %

Tags:AES BRM CBRM IFW Integrate JSA_USER Mark Pipeline PricingCenter 8Comments

WelcomeClients,Partners,Friends
Weappreciateyourcomments,sopleaseleaveusyourthoughts.Commentspostedtothissitedonot necessarilyrepresenttheopinionsofSSG!

TagCloud
10gR2EnterpriseManagerSUNBPEL BEA Collaborate BusinessIntelligenceOracleBRMMetaLink 11g BusinessProcessDatabaseVirtualization

OOW OracleDatabaseOpenWorldApplicationIntegrationArchitectureOracleFusionMiddlewareBIBRM Fusion OracleOpen

WorldCBRMAIA Release12MarkSOA BPM EBusinessSuiteOracle

Search

Search Go!

RecentEntries
InformaticaWorld2010 AQuickRecap 18.11 OurFocusonDataManagementandDataIntegration OOW2010 20.09 SteveandDuke UnderstandingtheOracleBRMTableStructure10.09 InformaticaPowerCenter AQuickIntroduction 9.08 OracleAPEXandBIPublisher PremierSupportExtendedforFusionMiddleware10gR2(10.1.2) 29.04 Collaborate 10:BestPracticesforDWonOracle 22.04 Collaborate 10:OracleDataWarehouseupdates20.04

Archives
November2010

Actions
Register LogIn EntriesRSS CommentsRSS WordPress.org

2012SSG,Limited.Allrightsreserved. WebsiteDesignbyTheMODStudio