Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Allocation Amount (Operating Expenses - Revenue) in PCMCS Allocations — Cloud Customer Connect
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

Allocation Amount (Operating Expenses - Revenue) in PCMCS Allocations

Received Response
21
Views
8
Comments

Summary:

Content (required):

Hi All,

We have a need to reference the account (Which should be the result of Expenses – Revenue instead of Net Operating Income (Revenue - Expenses)) as the source in the allocation.

We created a parent account (Data Storage: we tried both Never Share/Stored options, Hierarchy Type: Dynamic, consolidation: addition)

·      Operating Expenses ( shared member and consolidation: addition)

·      Revenue( shared member and consolidation: subtraction) as children.

When we used this account in the source of the allocation, even though the offset account is different(level0 account) we are getting the error “Cannot Perform Allocation. Essbase Error(1300049): The argument [Offset] cannot contain dynamic members, for example [ ]”

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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