Mass Allocation - Oracle Apps Reference

Mass-Allocation in General Ledger can be used to allocate amounts across a group of Cost center, Departments, Divisions and Ledgers using a ... Skiptocontent Mass-AllocationinGeneralLedgercanbeusedtoallocateamountsacrossagroupofCostcenter,Departments,DivisionsandLedgersusingaFormula. Forexample,usingmassallocationrentexpensescanbeallocatedtodifferentdepartmentsonthebasisoftheareaoccupiedbythedepartment. Massallocationusesaformulaandaccountsegmenttypesforallocatingthebalances. Massallocationformulacanalsouseparentvalueswhereinbalancescanbeallocatedtotheallthechildvaluesbasedonthepercentagespecifiedforeachofthem. Formula A*B/C Where: ——– A=CostPool B=UsageFactor C=TotalUsage Mass-Allocationformulahasthreesegmenttypes:Looping,SummingandConstant. Looping(L): Loopingshouldbeassignedtoaparentsegmentvaluetoincludeeachchildvalueassignedtotheparentvalueintheformula. Summing(S):Summingshouldalsobeassignedtoaparentsegmentvalueonlytosumtheaccountbalancesofallthechildsegmentvaluesassignedtoaparent. Constant(C):Constanttypeisassignedtoachildsegmentvaluetousethedetailaccountbalancesassociatedwiththechildvalue. TestCase 1.NavigatetoGeneralLedgerResponsibility->Journals->Enter,CreateandPosttheJournal 2.NavigatetoGeneralLedgerResponsibility->Journals->Enter,CreateSTATJournalandPostit. Statisticaljournalsarecreatedtorecordnonfinancialinformation.StatisticaljournalswillbeenteredwithSTATcurrencyandthesestatisticaljournalentriesneednotbebalanced. 3.NavigatetoGeneralLedgerResponsibility->Journals->Define->Allocation ClickonformulasandentertheFormuladetails Lines Account Type LedgerCurrency CurrencyType EnteredCurrency AmountType A VisionOperations-01-210-0015-0000-000 C.C.C.C.C.C USD  Total PTD B VisionOperations-01-100-0015-0000-000 C.C.L.C.C.C USD  Statistical STAT PTD C VisionOperations-01-100-0015-0000-000 C.C.S.C.C.C USD  Statistical STAT PTD T VisionOperations-01-100-0015-0000-000 C.C.L.C.C.C PTD O VisionOperations-01-210-1110-0000-000 C.C.C.C.C.C PTD Sowhatwearedoingisweareallocating1000amounttoamount3departmentsbasedonthe%definedinSTATJournalwhichis50(forDepartment-109),30(forDepartment-110)and20(forDepartment-115). AllthesedepartmentsareaddedtoParentDepartment100andthatisusedinformula. SotheLogicis-> 1000(SegmentTypeisConstant,itsamountfromJournal)* 50or30or20(SegmentTypeisLoopingwhichwillpickoneafterotherfromSTATjournal)/ 100(50+30+20,thiscasesegmenttypeisSumming) Clickon“ValidateAll”buttonanditSubmits“ValidateMassAllocations”program. Clickon“ValidateAll”buttonanditsubmits“RunMassAllocations”program. EnterthedetailsandSubmit. GettheJournalnamefromprogramOutput 4.NavigatetoGeneralLedgerResponsibility->Journals->Enter,searchtheaboveJournalname 4thlineistheOffsetaccountwehadaddedtoformula. Tables GL_ALLOC_BATCHES GL_ALLOC_FORMULAS GL_ALLOC_FORMULA_LINES GL_ALLOC_HISTORY GL_AUTO_ALLOC_BATCHES Sharethis:TwitterFacebookLikethis:LikeLoading... Author: Govindbalram WorkinginOracleE-BusinessSuiteforpast9years. ViewAllPosts Postnavigation PreviousPostJournalTranslationNextPostGLConsolidation LeaveaReplyCancelreply Enteryourcommenthere... Fillinyourdetailsbeloworclickanicontologin: Email(required)(Addressnevermadepublic) Name(required) Website YouarecommentingusingyourWordPress.comaccount. ( Log Out /  Change ) YouarecommentingusingyourTwitteraccount. ( Log Out /  Change ) YouarecommentingusingyourFacebookaccount. ( Log Out /  Change ) Cancel Connectingto%s Notifymeofnewcommentsviaemail.Notifymeofnewpostsviaemail. Δ May2020 M T W T F S S  123 45678910 11121314151617 18192021222324 25262728293031 «Nov   Dec» Searchfor: Categories AccountPayables(7) AccountReceivables(1) AdvancedPricing(1) API(8) BackendQueries(12) CodeandAOLMigrationScripts(4) DataLoader(1) FunctionalAdministrator(1) GeneralLedger(16) InboundInterfaces(8) OAF(2) OrderManagement(3) OrderToCash(O2C)(1) ProcureToPay(P2P)(2) Purchasing(8) Scripts(1) ServiceContracts(2) Setups(1) ShellScript(2) SQLLoader(2) SubledgerAccounting(2) SystemAdmin(13) UserManagement(2) WebADI(3) Workflow(3) XMLPublisher(1) Archives July2021 (6) December2020 (2) May2020 (18) November2018 (4) October2018 (2) September2018 (1) August2018 (8) September2017 (1) May2014 (1) February2014 (2) December2013 (8) November2013 (1) October2013 (10) September2013 (1) July2013 (10) June2013 (14) May2013 (3) April2013 (4) March2013 (11) Meta Register Login Entriesfeed Commentsfeed WordPress.com BlogStats 512,207hits FollowBlogviaEmail Enteryouremailaddresstofollowthisblogandreceivenotificationsofnewpostsbyemail. Join99otherfollowers EmailAddress: Follow FollowMe LinkedIn Facebook Instagram Privacy&Cookies:Thissiteusescookies.Bycontinuingtousethiswebsite,youagreetotheiruse. Tofindoutmore,includinghowtocontrolcookies,seehere: CookiePolicy Follow Following OracleAppsReference Join99otherfollowers Signmeup AlreadyhaveaWordPress.comaccount?Loginnow. OracleAppsReference Customize Follow Following Signup Login Copyshortlink Reportthiscontent ViewpostinReader Managesubscriptions Collapsethisbar   LoadingComments...   WriteaComment... Email(Required) Name(Required) Website %dbloggerslikethis: