You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GL Allocation Rule – Dynamic Ratio Based Allocation

in General Ledger & Intercompany

Summary:

Hello Everyone,

I need guidance on configuring an Oracle Fusion GL Allocation Rule for the following requirement:

We need to allocate the balance from Cost Center 1601 to Cost Centers 1101, 1102, 1103, 1104, and 1105.

The allocation ratio should be calculated dynamically based on the actual balances of two accounts – Advance and Deposit – across these five cost centers.

For example, if the total relevant balance is 1,000 and the individual cost center balances are 100, 200, 300, 150, and 250, the allocation should be based on 10%, 20%, 30%, 15%, and 25% respectively.

Question: How can this be achieved using standard Oracle Fusion Allocation Rules, including the appropriate Source, Basis, Formula, and Offset configuration? Can the ratio be derived directly from actual account balances?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!