How to Use Account Hierarchy Manager to Maintain Account Structure?

I found Account Hierarchy Manager feature as a friendly and more flexible way to maintain accounting flex field structure for both adding new child or parent values to hierarchy and changing hierarchy structure.

Hierarchy export functionality is also included in case you need to save for later reference or for offline review.

For those interested about this subject I create below video following next steps:

1. Open Account Hierarchy Manager (AHM) under GL responsibility
2. Select desired account structure and open natural account segment
3. Move child values from one parent to a different parent
4. Arrange your screen for a better view over values properties
5. Create a new account under an existing parent
6. Export hierarchy for selected parent
7. Drag and drop child between hierarchies
8. Just checking that changes are visible into standard screen

Account Hierarchy Manager setup overview

Oracle eBusiness Suite R12 standard documentation for The Account Hierarchy Manager

With the Account Hierarchy Manager you can graphically create, maintain, and review account structure hierarchies. You can define new parent and child segment values, as well as change parent/child dependencies. You can also create new rollup groups from the Account Hierarchy Manager and have your changes reflected automatically in both the Key Segment Values and Rollup Groups windows.

Attention: The General Ledger profile option, GL AHM: Allow Users to Modify Hierarchy must be set to Yes if you want to modify and save account hierarchies.
See: Setting General Ledger Profile Options, Oracle General Ledger User Guide

Attention: When you change parent/child relationships that affect existing summary accounts, run the Incremental Add/Delete Summary Templates program to update your summary account balances.
See: Maintaining Summary Accounts, Oracle General Ledger User Guide

Attention: You can only use the Account Hierarchy Manager for segments with value sets using Independent validation.

Attention: There are two applications that allow you to graphically create and modify account hierarchies and related information stored in General Ledger. The Account Hierarchy Manager is accessed through the General Ledger Navigator. Applications Desktop Integrator's Account Hierarchy Editor is a client server application accessed from your desktop.

See: The Account Hierarchy Editor, Applications Desktop Integrator User Guide

Prerequisites

• Define the profile option Gateway User ID. See: Oracle Applications User's Guide.
• Define the profile option Guest User Password. See: Oracle Applications System Administrator's Guide.
• Define the profile option GL AHM: FND Schema Name. See: Oracle General Ledger User Guide. 
• Define the profile option GL AHM: Database Host. See: Oracle General Ledger User Guide.
• Define the profile option GL AHM: Database Port. See: Oracle General Ledger User Guide.
• (Optional) Define the profile option GL AHM: Allow User to Modify Hierarchy. See: Oracle General Ledger User Guide.

If you liked this article feel free to share it with your fellows. 

For some other helpful videos check my YouTube Channel. 

To receive notifications for new articles subscribe to this blog.

Email Address