How to set up mass allocation in oracle r12

Step1:- Go to General Ledger ==> Journals ==> Define ==> Allocation. ... Step2:- Enter the Allocation Batch Name which will be create automate. skiptomain| skiptosidebar Aboutus FusionE-Books Workflows OAF Interfaces Scripts XML FusionTechnical FusionFinancial EBS Tuesday,3December2019 Howtosetupmassallocationinoracler12 Howtosetupmassallocationinoracler12 Inthispost,Wewillbediscussaboutthesetupofmassallocationinoracler12.GLmassallocationisoneofthegreatfeatureinoracle application,whenyouwanttocreatetheautomatejournalsbasedonthechart ofaccountsegmentsvaluesorwecansayfromgroupofcostcenters,Natural accounts,LocationsaspertheChartofaccountsegments.Wecanwritesome formula inthemassallocationsetups,whichtakestheinputfromourchartofaccountsbalancesandthen createtheautomateGLjournalsbasedonourGLmassallocationformulas.Herebelowiwilltrytoexplainthesetupofmassallocationinoracler12.  Exampleof setupmassallocationinoracler12 Ifwehave3bankaccountsandweareusingtheNatural Accountfrom50000001to50000003forthesebankaccountstotrackthebalance oftheseaccountsinoracleapplication. 50000000istheparentaccountforNaturalAccounts50000001 to50000003. Now,Ourbusinessrequirementiswewanttocalculatethe InterestforallthesebankaccountsNaturalaccount(50000001to50000003) monthlyandthenwantstocreatethejournaleachmonthindifferentBank InterestNaturalaccount(60000001)fortheinterestamountofalltheseall thesebankaccountsNaturalaccount(50000001to50000003). Conceptofmassallocationinoracleappsr12 NowtocreateanyMassallocationformulas,therearefew things,whicharequiteimportantandweneedtoprepareourformulaaccording tothat. Inmassallocationt,fourthingsarequiteimportantand theseare A,B,C,T&O. A:-AalwaysrepresenttheTotalValue/Amountonthat,we DOapplytheformula. ForExampleinour Case,ValuesinbankaccountsNaturalaccount(50000001to50000003)areourA. B:- Brepresentsthe ‘UsageFactor’.ThevalueunderB,alwaysmultiplewiththatvaluewhichdo comesaftersystemdrivetheformulawithA&T.ThefinalvaluefromA &TwillmultiplywiththeB. InB,Wehavetwooption,eitherwecanprovidetheconstant valueorwecangivethereferenceforsomeSTATjournalsandbasedontheSTAT journal,systemdotheformulaworking. Inourcase,WeknowtheInterestpercentageprovidedby bankeverymonthsowewilldirectlyputthecontactvalue.15Wedon’tneedto createsomestatjournalsandthendrivethevaluesfromthat. C:-Crepresentsthe‘TotalUsage’.Itmeansthisis somethingrelatedtoSummary.ForbothB&T,Wehavetwooption,either wecanprovidetheconstantvalueorwecangivethereferenceforsomeSTAT journalsandbasedontheSTATjournal,systemdotheformulaworking.Inour case,weknowthatweneedtocreatetheMonthlyjournalsforthebank interestsoforthisweneedtofindourthemonthlybalanceforthesebank accountsNaturalaccount(50000001to50000003)sotofindoutthemonthlybanks balanceweneedtodividetheFormulavariableAwith12.Soforthis,wewill puttheconstantvalue12underC. T:-it’snottheTAccountasweseeinLedger.Itisthe TargetAccountoftheJournallorthesearetheDebitAccountswhichshould holdtheallocatedexpense.SomyInterestamountforthesebankaccounts Naturalaccount(50000001to50000003)willbeallocatedtotheseaccounts mentionedunderTvariable. Inourcase,WewanttobooktheinterestinBankInterest Naturalaccount(60000000).SoweneedtogivethisAccountwithotherChartof Accountvalues. O:-Orepresentsthe‘Offsetaccount’.Thisaccountis sameastheaccountwegavein“A”.Thisisthecreditaccountforthecreating Journals. DetailStepstodothe setupformassallocationinoracler12 Step1:-GotoGeneralLedger==>Journals==>Define==>Allocation. Step2:-EntertheAllocationBatchNamewhichwillbecreateautomate.  ClickontheFormulasButtonasbelow. Step3:-Enterthenamewhichwewanttogivefortheallocation.EntertheCurrencyinwhichwewanttocreatetheAutomatejournalsfromthisallocationformula. Step4:- Thisisthebelowallocationformula,whichwehavetocreateasperourbusinessrequirement. AsiexplainedaboveaboutA,B,C,TandO. weneedtocreatetheformulaforeachvariableA,B,C TandO. Step5:-NowwearecreatingtheformulafortheVariable'A'.Clickonthe'A'variablelineandasisaidthebusinessrequirement(Wehave3bankaccountsandweareusingtheNaturalAccountfrom50000001to50000003forthesebankaccountstotrackthebalanceoftheseaccountsinoracleapplication. 50000000istheparentaccountforNaturalAccounts50000001to50000003) Asbelow,IamkeepingotherchartofaccountssegmentsasaC(Constant)butAccountsegmentiamkeeping'L' C:Constant– Thesegmentisconstantanddoesn’tneedanyLooporSum.Andthebalance shouldbepickedagainst“A”asaconstant L:Looping–Thesegmentneeds toloopfromfirstvaluetolastvalueasper ParentAccountHierarchy. S:Summing–Thesegmentneeds tosumthevalueinprovidedinSTATJV.  Generallytheaccountcodein“A”doesn’tnotneedanykindoflooping orsumming.SoeverysegmentshouldbegiventhevalueofC.Thevaluethis accounthasfortheparticularperiodshouldbepickedasaconstant.Keepthe currencyasEntered. Addcaption Step6:-ForVariable'B',wewillenterthemonthlyBankInterest '2.1'asaconstantvalue. Step7:-ForVariableC,WewillenterthenumberofMonthsintheyearandthatis'12' Step8:- ForVariable'T',WewillusethisbelowsettingsandBymistakeiusedAccountasa'L'butpleasekeepallthesethingsasa'C'. Step9:-ForVariable'O',Wewillusethisbelowsettings.Mostofthetimes,wekeep'O'variablesameas'A'variableasstep5. Addcaption Step10:- Asbelow,Allocationshowing'NotValidate'.Clickonthe'ValidateAll'buttontovalidatetheallocationformulaandifeverythingwillbeworkedthenallocationstatuswillbechangedto'Validated' Step11:-NowtoclickontheButton'Generate'tosubmittheAllocationprogramaspertheformula. Howtosetupmassallocationinoracler12 at 05:35 Labels: Howtosetupmassallocationinoracler12 1comments: Unknown said... Whatisparentaccount 24September2021at10:01 PostaComment NewerPost OlderPost Home ContactusforanyCollaboration,ProjectSupport&OnJobSupportWork Name Email * Message * KnowMoreAboutUs Products&Offerings LearnFusionFinancials'(OnlineBook) ClickToDownload OracleFusionSelfPacedTrainingsinDiscountedPrices Clicktoknowmore BuyOracleCloudInstanceAccess(ClicktoKnowMore) OracleFusion/EBSInterview'sQuestionAnswerSeries Top33OracleFusionOrderManagementInterviewQuestions TOP31OracleFusionSCMCloudInterviewQuestions TOP21OracleFusionHCMInterviewQuestions CompleteTaxSetupsinOracleFusion Top50oraclereportsinterviewquestions 33MostImportantOracleFusionfixedassetsinterviewquestions TOP33MostImportantOracleAppsTechnicalInterviewQuestions 25MostImportantOraclereceivableinterviewquestions 21MostImportantOracler12PayablesInterviewQuestions TOP20generalledgerinterviewquestionsinoracleappsr12 TOP23MostImportantOracleFusionInterviewQuestions TOP23MostImportantoafinterviewquestions OnlineOracleCourses(FreeofCost) CompleteTaxSetupsinOracleFusion LearnTaxImplementationinOracleFusion LearnP2PCycleinOracleFusion LearnOracleReportsXMLTutorial LearnOracleFusionCustomRolesTutorial LearnOracleFusionTechnicalOnline LearnOracleFusion/cloudFinancialsOnline LearnOracleCloudBPMOnline LearnCompleteOAFStepbyStepOnline LearnOracleWorkflowBuilderOnline OnlineFusionApplicationComposer/CustomizationBook OnlineFusionApplicationComposer/CustomizationBookClickToKnowMore OracleFusionTechnicalBook OracleFusionTechnicalBook OracleFusionWebServices(REST&SOAPAPI's)/IntegrationBook ContactMe [email protected] MostViewedPosts ReportBurstinginoraclefusion ARtoGLreconciliationinoracleappsr12 SettheoverrideemailaddressinOracleFusion HowtoCreatePOandReceivingInquiry(ViewOnly)RoleinOracleFusion HowtocreateanewOracleappsDatabasesourcetoDesigntheBIPreports HowtoaddhyperlinkintheemailbodyusingBurstinginOracleCloudBIPreports WhatisRapidImplementationinOracleCloud:RapidImplementationDataUploadProcessinOracleFusion DrillDownOTBIreportstoNavigateDirectlyintoOracleCloudPaymentPage HowtocreatevacationrulesinOraclecloud TOP30MostImportantOAFInterviewQuestions