Forum Discussions

How to Consolidate ...
 
Notifications
Clear all

[Closed] How to Consolidate Balances between 2 Business Groups

6 Posts
2 Users
0 Likes
282 Views
Posts: 5
Topic starter
(@k-iqbal-ahmed)
Active Member
Joined: 6 months ago

Hi,

I have a scenario to implement as below:

1. There are 2 Business Groups (BG 1 & BG 2) and currently BG 1 is fully functional.
2. BG 2 yet to be defined and configured (adding new BG).
3. Both BG 1 & BG 2 will be in single instance.
4. Both BG 1 & BG 2 will use same COA but different currency
5. There are 6 Legal Entities. 4 LEs under BG 1. There will be 2 LEs under BG 2.
6. Have to consolidate balances of BG 1 & BG 2 and report
7. BG 1 has following Flexfield Qualifiers
      Balancing Segment
      Cost Center
      Natural Account
      Secondary Tracking segment

Kindly advise what is the procedure to configure this kind of setup in R12 (12.2.10)

Thanks in advance

5 Replies
Posts: 347
(@training-operations)
Reputable Member
Joined: 3 years ago

Hello,

We trust you're doing well!

Our team of experts is diligently working on resolving your query. Rest assured, we will get in touch with you as soon as we have a solution. We promise to keep you posted.

Thank you for your patience and kind regards,

Apps2fusion Team

Posts: 5
Topic starter
(@k-iqbal-ahmed)
Active Member
Joined: 6 months ago

Appreciate your positive response. Awaiting your solution at the earliest.

Thanks

Posts: 347
(@training-operations)
Reputable Member
Joined: 3 years ago

Configuring Oracle E-Business Suite (EBS) with multiple Business Groups (BG) and Consolidation involves several steps. Below is a high-level overview of the process. Keep in mind that detailed configurations may vary based on specific business requirements

  1. Define Business Groups:
    • Navigate to the "Define Business Groups" form.
    • Create BG 1 and BG 2.
  2. Define Accounting Flexfields:
    • Define your Accounting Flexfields based on your business needs.
    • For BG 1, ensure the flexfield structure includes Balancing Segment, Cost Center, Natural Account, and Secondary Tracking Segment.
  3. Define Currencies:
    • Define the currencies for BG 1 and BG 2.
    • Ensure that the ledger currency for BG 1 is set to the appropriate currency.
  4. Define Ledger:
    • Create a ledger for BG 1, specifying the COA and currency.
    • Repeat the process for BG 2.
  5. Define Legal Entities
  6. Assign Legal Entities to Ledgers:
    • Assign the relevant Legal Entities to the respective ledgers (BG 1 or BG 2).
  7. Define Accounting Options:
    • Set up accounting options for each Business Group.
  8. Consolidation Setup:
    • Navigate to the "Consolidation" responsibility.
    • Define consolidation sets for BG 1 and BG 2.
    • Specify the rules for consolidating data across Business Groups.
  9. Reporting:
    • Configure reporting tools to generate consolidated financial reports.
Posts: 5
Topic starter
(@k-iqbal-ahmed)
Active Member
Joined: 6 months ago

Many thanks. Will apply, test and revert. 

Regards

Page 1 / 2
Share: