Sunday, August 25, 2019

Financials Cloud for EPM folks - Value Sets

We all have to work with ERP applications in our EPM implementations one way or another, and I always thought its's beneficial to have some basic understanding and navigation skills in Financials Cloud, it helps when you're troubleshooting metadata issues or data reconciliation etc, so I'm going to start a light weight series on Financials Cloud to cover topics I find helpful when I'm working on a Planning, Profitability or Enterprise Reporting solution.

Before I begin I think it's worth mentioning that CoA structure in Financials is defined in two areas:

1. Value sets - Flat list of values for each segment and their respective properties
2. Hierarchies - Parent/child hierarchy representation for each segment.

In this post I will cover the Chart of Accounts Value Sets, how to navigate and check for specific segment value codes, I will be using a General Accounting Manager role for this. Here is the role name, code and description for reference.



First, we have to navigate to Setup and Maintenance and to do that we have three options.

1- From the landing page (this is the standard theme, you'll probably have a custom defined theme setup but it should be the same).



2- From the Navigator



3. From user settings and actions (click on the username in the top right corner)



Next thing we need to navigate to the setup page for Financials.



Click on Financial Reporting Structures functional area and then click on Manage Chart if Accounts Value Sets


This will take you to the setup page where you have your CoA segments defined, from this page select  General Ledger as your module and hit search to retrieve your CoA segments.




This is the CoA structure in this scenario. Account, Company, Cost Centre, LoB and Product segments.


All you have to do is select one of the segments, click Manage Values and search for your value to retrieve certain information like description or start/end dates (not relevant for EPM). Here you can see the Account segment values and their properties.





And that's it for today.

5 comments:

  1. With the new things we have all the tax planning solution Garland on time deliverance.

    ReplyDelete
  2. This is how my partner Wesley Virgin's adventure begins in this SHOCKING and controversial video.

    As a matter of fact, Wesley was in the military-and shortly after leaving-he discovered hidden, "mind control" secrets that the government and others used to get everything they want.

    These are the EXACT same tactics lots of celebrities (notably those who "come out of nothing") and the greatest business people used to become rich and successful.

    You probably know how you utilize only 10% of your brain.

    Really, that's because most of your BRAINPOWER is UNCONSCIOUS.

    Perhaps this conversation has even taken place IN YOUR own head... as it did in my good friend Wesley Virgin's head seven years back, while riding an unregistered, trash bucket of a car with a suspended driver's license and $3 in his pocket.

    "I'm very fed up with going through life check to check! Why can't I turn myself successful?"

    You took part in those thoughts, isn't it so?

    Your success story is waiting to be written. All you have to do is in YOURSELF.

    UNLOCK YOUR SECRET BRAINPOWER

    ReplyDelete
  3. I have read your article, it is very informative and helpful for me.I admire the valuable information you offer in your articles. Thanks for posting it.. Ottawa Payroll services

    ReplyDelete