Allocations
Discussion List
-
@Siblings function- Allocation returns all values including the specified memberSummary: Business has a requirement to use all intercompany account value except 0000 as Source, Offset and Target account. I have used the @sibling function to achieve …Ilona Jean P. 3 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Request for Guidance on Oracle Fusion Cloud Consolidation SetupSummary: Dear Oracle Support Team, I am reaching out to seek your guidance on configuring the consolidation process in Oracle Fusion Cloud. Specifically, I need advice o…Prakash Vattapalli 46 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Allocation Rule based on run time percentageSummary Recurring Formula rule based on run time entry of PTD percentageContent I am going through the allocation creation example explained in the "Recurring Journals i…Manish Sinha-190461 135 views 7 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany -
GL Allocation POV FunctionsSummary How to use functions in the POVContent Hi I have checked the documentation and white paper. However, I am still unclear regarding use of Functions in the POV. I …
-
How to add Parent value in Elimination rule, current design we used child cost center valuesWe need to add Parent Cost center value in Elimination rule in Allocation module where we already used child cost center hierarchy values in current process Could you pl…Veerapandu Ketha 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
how to create a recurring journal formula with allocation rulesSummary: Can anu one share a documentation or explain how to create a recurring journal formula with allocation rules Content (please ensure you mask any confidential in…Aviram Bar Shlomo-Oracle 36 views 2 comments 0 points Most recent by Aviram Bar Shlomo-Oracle General Ledger & Intercompany
-
How to populate the Intercompany Transaction Description generated through Intercompany AllocationsSummary: The Intercompany Batches are generated through the GL Intercompany Allocations. Need to automatically populate the Description field in the Transaction Header/T…
-
Us mexicoClient has manufacturing plant in Mexico but it is owned by US company . So I will have one US entity and US Business unit under US ledger .. but this Mexican plant resi… -
Creating a level0descendent variable for allocation rule is not populatingSummary: Creating a new allocation rule by copying an existing, I go to the Accounting Period POV and for the Subledger value, select Variable. In the box that opens, Da…Donna B 3 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany -
Can you see the allocation calculations within ERP-meaning the actual amounts being used?Summary: I see the log from the process, but is only shows the calculation rules. It doesn't show what amounts are actually being used by the allocation to generate the …
-
Suggest the best approach to transfer the balances from child to Parent companyWhile closing the child company provide the best approach to transfer the balances from child to Parent company Business is closing the Child company and they are expect…FerozKhan-Oracle 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Create a Formula for Allocation based on PercentageHi. I am trying to create a formula which will allocate Period Activity PTD of company 1101 to company 1201 and 1501 based on percentage: Source Account: 1101.1234.000 T…Ilona Jean P. 2 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Elimination in Consolidation LEDGERSummary: Elimination in Consolidation LEDGER Content (please ensure you mask any confidential information): We have 10 Ledgers and 1 Corporate Ledger in USD. Created 10 …Kumar 57 2 views 1 comment 0 points Most recent by Mary Ramirez-Oracle General Ledger & Intercompany -
In case of Allocations running in the system, will they update gl_balances in multiple steps?Summary: From the detail analysis we understood that the extract on GL balances and allocations are running at the same time, while allocations are processing along side…
-
User-Defined Exception (AP-810595) issue when validating Intercompany AP InvoiceSummary: I generated intercompany allocations and transferred it to AR and AP for invoicing. I was able to account the AR invoice, however I encountered User-Defined Exc…
-
Allocation by Percentage Across a Group of Dept and AccountsSummary: Trying to figure out how create an allocation by percentage from one company to another over a group of departments and accounts Content (please ensure you mask…Jacque Reeves 12 views 2 comments 0 points Most recent by Ilona Jean P. General Ledger & Intercompany
-
How can I distribute using the allocation functionality from one account to multiple accounts?Summary: As I can only find examples of this functionality for distribution from one to more cost centres, I require information on how to configure using accounts. Vers…TSNET_CasalloLucy 1 view 1 comment 0 points Most recent by SauravS-Oracle General Ledger & Intercompany -
Allocation using DFF of AFFSummary: Is there any possibility to create such allocation rule based on the DFF of AFF Value set? Content (please ensure you mask any confidential information): We hav…N&A Support Team 26 views 1 comment 0 points Most recent by Anisha singh-Oracle General Ledger & Intercompany
-
sql query to find link between Intercompany Accounting and GLI want to know the tables and link between intercompany accounting and general ledger. I want to pick intercompany data in query. -
How can we transfer half of the TB balance from one BSV to another BSV in the same ledger?Business has a requirement to transfer half of A BSV trial balance every month-end to B BSV (both A and B belonging to same ledger). We were trying to do allocation rule…Gayatri Sharma 13 views 1 comment 0 points Most recent by David Fleming General Ledger & Intercompany
-
How to generate AR/AP invoices from Intercompany AllocationsSummary: Can someone supply a use case and detailed steps to generate AR/AP invoices from Intercompany Allocations by running "Generate Intercompany Allocations". We hav…
-
How to create allocation rules from the general ledgerSummary: The following journals needs to be created. Add up the balances of the income accounts (4xxx) That balance should be multiplied by x%. The balance obtained in p…
-
Separate journal required for each formula line in an allocation ruleSummary: We have created an allocation rule with multiple formula lines and one offset. While generating the allocation, it is creating one huge journal. We want separat…Richa Arora-Oracle 11 views 2 comments 0 points Most recent by Kamal Ibrahim-Oracle General Ledger & Intercompany
-
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 108 views 4 comments 0 points Most recent by Ruth Batay-an General Ledger & Intercompany
-
No journal lines were generated for this allocation rule or rule setSummary: While running the intercompany allocation rules, the journal entries are not created. Could someone help me understand what is being missed? Content (please ens…Dhanachandran K 15 views 2 comments 0 points Most recent by venkatanarayana p General Ledger & Intercompany
-
Are Allocation/Recurring Journals the only way to action PrepaymentsAre Allocation/Recurring Journals the only way to action Prepayments Customer wants to allocate amounts monthly to expenses and I think that the only way in Fusion is vi…PhillipJ 3 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle General Ledger & Intercompany
-
Allocation Rule: Offset Account differs from Source AccountI am trying to create a rule where the Offsetting account is different from the source. SOURCE ACCOUNT: Natural Account: 202109; Event Edition: 2022 TARGET: Natural Acco…
-
Allocation Rules: member not level 0Summary: I am creating an allocation rule wherein "ALL Natural Account" is selected as member in POV. System is not accepting this saying member is not Level 0. How do I…Ilona Jean P. 44 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
Allocate Multiple Source Segments to multiple Target SegmentsSummary: Want to allocate an aggregated balance across several source dimensions with default Profit Center (0000). Target code combination would be based on Headcount b…
-
Allocation using slab rateSummary: Hi Team We have requirement to allocate fixed percentage, example 5% only if period Activity balance is between 1000 to 5000. Please suggest if there is way to …