Allocations
Discussion List
-
How can i allocate certain percentage of GL balances to range of cost centers using allocation rule?Hello All, I’m working on a business requirement where I need to allocate a specific percentage of GL balances from a source cost center to a range of target cost center…Ashish_Deokar 12 views 2 comments 0 points Most recent by Mark_Simpson General Ledger & Intercompany -
How to create allocation rule to nullify balance in one segmentSummary: Client has a requirement to nullify balance of natural account BC0300 of other segments to 000, at month end. For example, if they have an debit balance 100 on …
-
How to control General Ledger allocation rules access based on LedgerSummary: How to control General Ledger allocation rules access based on Ledger Content (please ensure you mask any confidential information): We have allocations rules w… -
Build job sets to group GL allocationsWe would like to check whether we can build job sets in which we can group GL allocations (e.g. per ledger) Reason for that is that nowadays we have a lot of allocations…Kamonwan Srasrisom 1 view 1 comment 1 point Most recent by Mark_Simpson General Ledger & Intercompany
-
Time Series Analysis using a View dimensionContent Over the past few months several posters have asked about calculating and reporting on time series values such as YTD, QTD, Trailing 12 months. The EPM Planning …Don Bean-Oracle 130 views 7 comments 3 points Most recent by NarayananS Profitability and Cost Management -
Average cost Calculation via Custom calculationSummary: Hi All, We need to calculate a rolling 6-month average cost per unit based on monthly data. For the current period (June), the calculation should consider Janua…Avtar 21 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Managing Filters for Source DimensionSummary: Is there a way to pick all zero level descendants of parent member I want to exclude from my entity dimension source. So If my top level entity is All Entities …KCJ04102003 2 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Rule Data Validation report running for all rules at onceHi team! We know it has Rule Data Validation report running for each rule to check the Source and Driver based for individual rule. Can we know if it can run for all rul…Gary Yip - D. 21 views 3 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
is there a way to find the absolute difference of 2 credit accounts ??Oracle Fusion GL Allocation rules creation through Calculation Manager: is there a way to get the absolute difference of 2 credit accounts in oracle fusion while creatin…
-
Allocation Rule Set generates Unbalanced Journal entriesSummary: We have 300 plus allocation rules which are bundled in to multiple 'Rule Sets'. Rules are working fine when run on individual level basis. When we run at 'Rule …Praveen T 397 views 15 comments 2 points Most recent by Sarang Prabtani-Oracle General Ledger & Intercompany -
Free Oracle University Advanced General Ledger Allocations TrainingSummary: Check out the free Oracle University Advanced General Ledger Allocations training to learn how to create formulaic templates for generating allocation journal e…Maria Centeno-Cloud ERP-Oracle 813 views 18 comments 23 points Most recent by Saeed Ahamed Financial Management Resource Center
-
EPCM Custom Calc: Conditional Allocation Based on Dimension MemberIn EPCM, is it possible to write a custom allocation calculation where: If the Function dimension member is "99," the rule does: Source * Driver If it’s any other member…P Avinash 20 views 1 comment 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
Request to purge transaction dataSummary:Request to cleanup transaction data Content (please ensure you mask any confidential information): The client has requested to purge the business data in the tes…
-
Does "unused" metadata have impactful performance implications?We are exploring breaking out our existing application and using multiple pods in our environment to help improve performance and run multiple models at the same time. E…Peter Joelson 11 views 4 comments 1 point Most recent by Peter Joelson Profitability and Cost Management
-
Allocation rule validation error Essbase Error(1300034)Summary: I'm getting a validation error on my allocation rule and I'm not sure why. POV = Allocation rule = Error = Content (please ensure you mask any confidential info…MichelleHaynes 243 views 3 comments 0 points Most recent by Nikhil_Jain10_07 General Ledger & Intercompany
-
EPCM Models - Manual execution Vs PipelineSummary: We are using Pipeline for automations inclusive of model calc executions. We have migrated certain rules from TEST to PROD. However, after migration the rules i…
-
Cells updated are negativeSummary: We are observing a stats report post allocation where number of cells updated are negative for many rules. In general, what are the reasons for this. Hi @Don Be…
-
Dynamic mdx calc of driver not working in allocation rule.Summary: Hello Experts - I have calculated a dynamic driver and the results are correct when compared to manual calc of same. However, when using the driver member in th…
-
Issue with Run time Prompt variable in General Ledger Allocation RulesSummary: We have an issue where the Run time Prompt (Accounting Period in this case) is showing up twice when we are running Generate Allocations process. Content (pleas…Bhanu Prakash Sharma 111 views 6 comments 0 points Most recent by Mountaire General Ledger & Intercompany -
PCM Video Update August 2025Here is a short video highlighting two significant new innovations inthe PCM Agent that are available in the August 2025 update. https://us.v-cdn.net/6034893/uploads/U5Q…Don Bean-Oracle 113 views 6 comments 4 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
How to use Parent Value in Target and Source section of Formula component in calculation managerWhile defining the allocation rule we have requirement to use parent value in Source and Target section of allocation rules. While Entering parent value in Source and ta…Basant Parihar 202 views 6 comments 0 points Most recent by Nikhil_Jain10_07 General Ledger & Intercompany
-
Fusion GL Calculation manager - Variable designer - Default valueSummary: I need help to default Accounting_Period value to be previous period as dynamic so that the ESS Job Generate Allocations can be scheduled instead of user runing…
-
Elapsed Time does not match with the time shown in the Calculation Statistics ReportSummary: Hi everyone, I am new to PCMCS and exploring the functionality in the sample application (BksML50). I was running a simple allocation rule with reference to the…Jacky_Chan_I4MUA 22 views 4 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Allocation formula is not generating allocation journalsSummary: Allocation formula is not generating allocation journals, we are getting below message in the log - Message data is :::::FUN_ALLOC_NO_LINES The allocation gener…
-
Model Documentation Report accessIs there a way that users can access the Model Documentation Report WITHOUT the ability to Edit Allocation Rules? So previously I had a thread where users had full acces…Peter Joelson 21 views 2 comments 0 points Most recent by NarayananS Profitability and Cost Management
-
Has anyone set Allocation rule in GL to create Standard Recurring Journals?Summary Unable to create variable for Accounting PeriodContent Hi, We are trying to use allocation rule to create Standard recurring journals and I'm unable to create va…Sathya Kannan 106 views 5 comments 1 point Most recent by Sudhakar Reddy N-Oracle General Ledger & Intercompany
-
migrating a rule in EPCM?Just to confirm — there's no way you can migrate a single or multiple rules between environments in EPCM, correct? I found the below posting about PCMCS, which recommend…Peter Joelson 33 views 3 comments 0 points Most recent by Peter Joelson Profitability and Cost Management
-
Allocation rules are creating duplicate data for Elimination of intercompany transactionsSummary: We need a solution for an issue related to an Allocation rules that we have, which is created to eliminate the IC balances. We have two ledgers, but the primary…Vamshi K G 11 views 1 comment 0 points Most recent by CA Nirmal Choudhary General Ledger & Intercompany