Allocations and Eliminations Oracle Fusion Cloud - Blog

Allocation rules are built upon dimensions. Examples are: ... The calculation manager provides an allocation wizard using templates. An allocation ... Skiptomaincontent DigitalEnterprise Oracle OracleOverview Cloud360Assessment OracleCloudImplementation CloudIntegrationsandPaaS EPMCloudService OracleAnalytics CloudManagedServices OracleCloudInfrastructureServices IndustrySolutions Hi-Tech LifeSciencesandHealthCare Salesforce SalesforceOverview SalesforceConsulting&AdvisoryServices SalesforceRevenueCloud SalesforceLightningMigration SalesforceMarketingCloud SalesCloudImplementations ServiceCloudImplementations SalesforceCommunityCloud IndustrySolutions Hi-Tech LifeSciencesandHealthCare Boomi BoomiPracticeOverview(Global) BoomiImplementationCostCalculator BoomiAPIManagement BoomiEDI BoomiOEM BoomiMasterDataManagement IndustrySolutions High–Tech Retail Manufacturing PrebuiltSolutionsandTemplates SAP SAPOverview SAPAdvisoryServices SAPMigrationServices SAPCoreServices SAPAutomation SAPManagedServices Netsuite NetsuiteOverview NetSuitePackageImplementations NetSuiteDataMigrationServices StrategicConsulting IndustrySolutions Hi-Tech LifeSciencesandHealthCare ServiceNow ServiceNowOverview ITServiceManagement ITOperationsManagement ITBusinessManagement HRServiceDelivery Security PlatformCustomApps Snowflake SnowflakeOverview DataWarehouseCenterofExcellence SnowflakeImplementation TraditionalDataWarehousetoSnowflakeMigration DataIntegration SnowflakeCalculator IndustrySolutions Hi-Tech Hi-TechOverview NetworkDevices Semicon EnterpriseSoftware SocialMedia LifeSciencesandHealthcare LifeSciencesandHealthcareOverview HealthCare LifeScience ManagedServices ManagedServices ManagedServicesOverview ApplicationManagementServices InfrastructureandDatabaseServices MonitoringandHelpdeskServices CloudManagedServices CloudInfrastructureServices CloudInfrastructureServicesOverview CloudAdoption CloudAdvisoryandAssessment CloudModernizationandMaintenance CloudSecurity ApplicationandITOutsourcing ApplicationandITOutsourcingOverview CloudApplicationSupport EnterpriseApplicationSupport DigitalConsulting TechnologyAdvisory TechnologyAdvisoryOverview Assessments MergersandAcquisitions ValueChainAssessment GlobalRoll-outs BusinessProcessRe-Engineering ITRoadmaps EnterpriseDataManagementStrategy ApplicationModernization ApplicationModernizationOverview CloudApplicationTransformation DevSecOpsArchitecturalTransformation MobileTransformation MicroservicesTransformation PortalsandContentManagement TechnologyUpgrades Analytics AnalyticsOverview Advisory&Consulting Implementation&MigrationServices StrategicServices ManagedServices Tableau QA&Testing QA&TestingOverview TestingasaService ManagedTestingasaService MobileDeviceTestingasaService IntegrationServices IntegrationServicesOverview AdvancedITConsulting MiddlewareImplementation Support&Maintenance APIEnabledIntegration EDI(ElectronicDataInterchange) Boomi Microsoft MicrosoftOverview AssessmentandConsultingServices MicrosoftCloud InfrastructureManagement ApplicationDevelopment Innovation IntelligentRPA IntelligentProcessAutomation Xenon XenonOverview XenonAccelerators ManualTestManagement AutomationTestManagement BusinessProcessFlowTesting-BPFT APITestManagement CI/CT/CD DefectTracking ReportsandDashboards AccessManagement Kanverse Kanverse.ai IntelligentDocumentProcessing InfatoODI2.0 InfatoODI2.0Overview InfatoODI2.0ROICalculator OracleCloudMigrator Propero™R12Upgrade JadeConnectIntegrationSolution Search Enteryourkeywords Apply EnterpriseDigitalTransformation EnterpriseDigitalTransformation Oracle OracleOverview Cloud360Assessment OracleCloudImplementation CloudIntegrationsandPaaS EPMCloudService OracleAnalytics CloudManagedServices OracleCloudInfrastructureServices IndustrySolutions Hi-Tech LifeSciencesandHealthCare Salesforce SalesforceOverview SalesforceConsulting&AdvisoryServices SalesforceLightningMigration SalesforceMarketingCloud SalesCloudImplementations Configure,Price,Quote(CPQ)andBilling ServiceCloudImplementations SalesforceCommunityCloud IndustrySolutions Hi-Tech LifeSciencesandHealthCare Boomi BoomiPracticeOverview(Global) BoomiImplementationCostCalculator BoomiAPIManagement BoomiEDI BoomiOEM BoomiMasterDataManagement IndustrySolutions High–Tech Retail Manufacturing PrebuiltSolutionsandTemplates SAP SAPOverview SAPAdvisoryServices SAPMigrationServices SAPCoreServices SAPAutomation SAPManagedServices Netsuite NetsuiteOverview NetSuitePackageImplementations NetSuiteDataMigrationServices StrategicConsulting IndustrySolutions Hi-Tech LifeSciencesandHealthCare ServiceNow ServiceNowOverview ITServiceManagement ITOperationsManagement ITBusinessManagement HRServiceDelivery Security PlatformCustomApps Snowflake SnowflakeOverview DataWarehouseCenterofExcellence SnowflakeImplementation TraditionalDataWarehousetoSnowflakeMigration DataIntegration SnowflakeCalculator IndustrySolutions IndustrySolutions Hi-Tech Hi-TechOverview NetworkDevices Semicon EnterpriseSoftware SocialMedia LifeSciencesandHealthcare LifeSciencesandHealthcareOverview HealthCare LifeScience ManagedServices ManagedServices ManagedServicesOverview ApplicationManagementServices InfrastructureandDatabaseServices MonitoringandHelpdeskServices CloudManagedServices CloudInfrastructureServicesOverview CloudAdoption CloudAdvisoryandAssessment CloudModernizationandMaintenance CloudSecurity ApplicationandITOutsourcingOverview CloudApplicationSupport EnterpriseApplicationSupport DigitalConsulting DigitalConsulting TechnologyAdvisory TechnologyAdvisoryOverview Assessments MergersandAcquisitions ValueChainAssessment GlobalRoll-outs BusinessProcessRe-Engineering ITRoadmaps EnterpriseDataManagementStrategy ApplicationModernization ApplicationModernizationOverview CloudApplicationTransformation DevSecOpsArchitecturalTransformation MobileTransformation MicroservicesTransformation PortalsandContentManagement TechnologyUpgrades Analytics AnalyticsOverview Advisory&Consulting Implementation&MigrationServices StrategicServices ManagedServices Tableau QA&Testing QA&TestingOverview TestingasaService ManagedTestingasaService MobileDeviceTestingasaService IntegrationServices IntegrationServicesOverview AdvancedITConsulting MiddlewareImplementation Support&Maintenance APIEnabledIntegration EDI(ElectronicDataInterchange) Boomi Microsoft MicrosoftOverview AssessmentandConsultingServices MicrosoftCloud InfrastructureManagement ApplicationDevelopment Innovation Innovation Xenon XenonOverview XenonAccelerators ManualTestManagement AutomationTestManagement BusinessProcessFlowTesting-BPFT APITestManagement CI/CT/CD DefectTracking ReportsandDashboards AccessManagement InfatoODI2.0 InfatoODI2.0Overview InfatoODI2.0ROICalculator Kanverse Kanverse.ai IntelligentDocumentProcessing IntelligentRPA IntelligentProcessAutomation OracleCloudMigrator Propero™R12Upgrade JadeConnectIntegrationSolution Insights Insights Perspectives Blog eBooks WhitePapers CaseStudies Datasheets Webinars PressRelease About About AboutUs LeadershipTeam Awards&Recognition GlobalAlliances ContactUs Events JadeGlobalFoundation Careers Careers Perspectives Blog ContactUs Covid-19 1-408-899-7233 [email protected] PressRelease JadeGlobalIsCertifiedGreatPlaceToWork® OnDemandWebinar PowerBIAnalyticstoAccelerateEnterpriseDecisionMaking Image AllocationsandEliminations:OracleFusionCloud DaisyDabandan June22,2021 “IseeallocationsinOracleFusionCloud,butitlooksVERYdifferentfromR12!” “Ididasearchinthetaskpane,typedEliminations,butnoresultsfound!” Ifyouhavebeenconfusedordonotknowwheretolookforanswers,thisbloghopestogiveyouaglimpseofhowallocationsandeliminationsarenowhandledinOracleFusionCloud. WithEBS,userswerelimitedtoallocationrulesinusingtheAllocationfunctionality.However,FusionCloudenhancesthesamefunctionality;improvesefficiencyandeliminatesextension/workaroundsrelatedtoAllocationsandEliminations.AstreamlinedAllocationandEliminationprocessaffordsbettertransparencyandmakesfinancialclosesmoother.Let’sseehow. Firstoff,hereisthehigh-levelcomparisonviewbetweenthetwoOracleproductversions. What’sthedifference? AllocationsandEliminationsinEBShavespecificallocationandeliminationtemplateswithinthegeneralledgerapplication,whichhandlesthesetwofunctionalitiesseparately.InOracleFusionCloud,it’stheOracleEPMtechnologyembeddedthroughouttheOraclecloudapplicationsused.Inaddition,atoolcalled“CalculationsManager”isleveragedusingOracleEssbase.ItprovidesanallocationtemplatethatisverydifferentfromOracleEBSandaformulatemplate,analternativemethodofdefiningallocationsoreliminations. Beforeweproceed,let’sreviewwhatmostOracleusersseeinOracleEBS. EBSMassAllocation EBSElimination FusionCloud-CalculationManagerFeatures Essbase/GeneralLedgerCube Real-Time–BalancesbecomeavailablewhenatransactionpostsinGeneralLedger Dimensions Allocationrulesarebuiltupondimensions.Examplesare: ChartofAccountssegments(company,department,account,intercompany,etc.) Ledger/Ledgersets Accountingperiod Scenario Amounttype Currency AllocationTemplate/Formula Thecalculationmanagerprovidesanallocationwizardusingtemplates.Anallocationrulecanhaveoneormorecomponents,whichcanbeeitherofthefollowing: AllocationsTemplateonly Formulaonly AllocationsandFormulaCombination Maintenance CalculationManagerprovidestheabilitytomaintainrulesusing: Variablecomponents Reusablecomponents Rulesets–groupssimilarallocationrulesintoaruleset Hierarchies UsesChartofAccount(COA)hierarchiestobuildrules/formula CanuseaseparateallocationhierarchyapartfromCOAhierarchiesusedforreporting Navigation TogettotheCalculationsManager,GotoGeneralAccountingandclickJournals. GotoCreateAllocationRules. ThelinkwillgototheEPMWorkspaceandwillshowtheGeneralLedgerBalanceCube. ExpandtogototheCOAStructure.Inthisexample,itisUSGAAP_USA. GotoRules,right-clickandselectNewtocreatearule. Enterthenameoftheallocationrule,selectthecorrectvaluesasrequired.Typically,theApplicationTypeandDatabaseshouldhavethevaluesasshownbelow. TheAllocationTemplate Now,let’sdiscussthedifferentsectionsoftheallocationtemplate.Forillustrationpurposes,onlythefirstallocationcomponentwillbediscussed. RuleDesigner Theruledesignerallowsyoutonavigatedifferentallocationblocksandmovearoundsectionswithinthetemplate.Italsoletsyouaddmultiplecomponentsforamorecomplexallocationrule.Thisexampleshowstwoallocationcomponents. PointofView ThefirststepaftertheBeginiconistheMainPointofView(POV).ThereisalsoaPOVsectionintheallocationcomponentitself.Forasimplerule,youcanusethemainPOVtoselectthevaluesyouwanttobefixed,meaningthereisnoneedtoenterthesamevaluesintheotherpartsoftheallocationtemplate.Forcomplexrules,youcanstilldothesame,butkeepinginmindthatfixedvalueswillapplytoallallocationcomponentsorblocks.Inthisexample,thereisavariablecomponentfortheaccountingperiod.Thismeansthatyoucanchoosetoselecttheperiodyouwanttorunfortheallocationruleatrun-time. Howtoselectdimensionvalues: Clickonthememberselectoriconlocatedontherightside.Fromthelist,selectMember.Whenthememberselectoropens,selectthedimensionvaluefromtheleftside,clickthearrowrightsymboltomovethedimensionvaluetotherightside.Finally,clickOKtoacceptthevalue. Source Inthissection,noticethattheotherdimensionsthathavethevaluespopulatedinthePOVarenolongershowingup.Instead,enterthedimensionvaluesfromwhichtheGLBalanceswillbeaggregatedandallocated(InEBS,thisisyour“A”line). AllocationRange Thisiswhereyoutellthesystemthedimensionyouwanttoallocate(orloopasinEBS).Inthisexample,theallocationrangeisthecostcentredimension.Inthebackground,thecalculationmanagerusesthevaluespopulatedhereaspartof“Target”and“Basis”. Target Noticethatthedimensionpopulatedintheallocationrange(i.e.,costcentre)isnotincludedhere.Instead,thissectionshouldcontainthetargetdimensionvaluestowhichtheGLbalancesfromtheSourcesectionwillbeallocated.InEBS,thisisthe“T”line. Offset Thevaluesherewillbeusedtocreatetheoppositesideoftheallocationjournal.Thisisthe“O”lineinEBS. Exclude Optionallyputexclusionsfromtheallocationrange,ifany. Basis Thissectioniswhereyouputthebasisofallocation.SincethereisnooutrightplaceforloopinginOracleFusionCloud,justlikeinEBS,theallocationrangeindicateswheretoloop.Hence,inthissection,theCalculationmanagerusestheallocationrangetodeterminetheratioforthebasis(Thisis“B”and“C”inEBS).Here,thebasisisheadcountpercostcentre.Noticethatyoudonotseethecostcentredimension. BasisOptionsandRounding Optionally,enterthebasisoptionsandroundingsections. TheFormulaTemplate Similartotheallocationtemplate,youcanalsopopulatethesamefieldswhencreatinganewformula. Youcanaccesstheformulatemplateintwoways: GLBalancesCube>COAStructure>db>Formula WhentheRuleDesignerisUp Youcandrag“Formula”fromtherulepallet.Youcanalsodothesameifyouwanttocreatearulewithacombinationofanallocationtemplateandaformula. Theformulatemplateusesthesamedesignerrule,includingthemainPOV.Theonlydifferenceisthattheformulatemplatehasadifferentbutsimplerformat. YouwillseethesamedesignerruleandmainPOV(thisistheonlyplaceavailableforPOV). Thisisathree-parttemplate:Source,TargetandOffset.Thisistypicallyusedforreclassification,eliminationsorsimple(i.e.%ofaspecificGLbalance)tocomplexallocationrules. TipsandTricks Buildyourhierarchies,accordingly,consideringreportingANDallocationneeds. Youcanhaveaseparatehierarchyforreportingandanotheroneforallocation. Onerulecanhaveoneormoreallocationcomponents/blocks. Donotusethesamesegmentvalueacrosssegments.ItcreatesEssbaseerrors. Essbasedoesnotrecognizeadebitoracredit,butyoucanuse‘*-1’tosettheoppositesideoftheallocationjournal. AbouttheAuthor DaisyDabandan,PrincipalSolutionArchitect,EnterpriseCloudApps-Oracle AddNewComment Yourname Email Comment Abouttextformats RestrictedHTML AllowedHTMLtags: