Supporting Three Level Hierarchy Through Accounts Receivable (AR) Relationship (Doc ID 2859081.1)

Last updated on AUGUST 10, 2023

Applies to:

Goal

The hierarchy is a 3 level of hierarchy between Grand Parent (Paying Entity) , Parent (Non Paying Entity) and Child (Non Paying Entity).

• Level-1 Grand Parent Account A1 is the top level paying account which will be the paying entity.
• Level-2 will comprise of Parent accounts which will have AR_BILLINFO and PARENT_BILLINFO rolling up to the Grand Parent account. These are non-paying child accounts.
• Level-3 will comprise of Child accounts which will be brought in by Parents. So the expectation is to have the AR_BILLINFO and PARENT_BILLINFO of this level-3 account point to resellers (B2-1 and B2-2 in the above example).

If a relation can be maintained in below mentioned manner:

1) AR relationship ship between Parent and Child.
2) AR relationship between Grand Parent and Parent .
3) Grand Parent is the only paying entity in this relation which is going to pay for Child and Parent (charges if Any).

The goal is to consolidate the Child Charges first at Parent level(from Billing prospective) and the consolidate all the Parent charges at Grand Parent level. Is this supported?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.