Assign Financial CUSTOM Categories to the Natural Accounts

Question

Hi all,

I’m working on Oracle ERP Analytics and trying to understand how to add new (custom) Financial Categories that can be assigned to Natural Account segment values.

I followed the standard navigation:

* Setup and Maintenance
* Financials → Financial Reporting Structures
* Manage Chart of Accounts Structure Instances
* Edit COA instance → Segment Instances
* Open the Value Set for the Natural Account
* Manage Values

From there, I can see the Financial Category column and assign values from a dropdown (e.g. Goodwill, Income Tax, Other Assets, etc.).

However:

* I cannot find where to create new Financial Categories
* I don’t see a related Value Set or Lookup exposed in Setup
* The categories look like seeded values

According to Oracle documentation:

“If you define custom categories, you need to define your own derived metrics…”

This suggests that custom Financial Categories should be possible, but it’s unclear where/how they are created.

Found this info in

https://docs.oracle.com/en/cloud/saas/enterprise-data-management-cloud/dmcaa/register_fc_financial_categories_100xbe093cd6.html

to use EDM to add Financial Castegories but the matter is that , how about a user without edm?, can be done on fusion or some other way?

JohnW-Oracle · Answer

Hello @User_0L517,

It looks like this question was posted twice. The earlier response was:

You can upload a predefined category or a custom category defined using the Financial Categories upload option described in the documentation here to upload categories:

https://docs.oracle.com/en/cloud/saas/analytics/26r1/fawag/upload-download-financial-categories.html

and for Financial Category Assignments

https://docs.oracle.com/en/cloud/saas/analytics/26r1/fawag/upload-download-financial-category-assignments.html#GUID-6B83696B-3353-4FBE-915C-CC6A567B105E

When possible, you should try to use the predefined categories. If the category is for customer-specific reporting only, create a custom category and assign natural accounts to it through Financial Category Assignments.

Hope that helps.

Regards,

John

User_0L517 · Answer

ok thanks but for direct fdi handling of custom financial categories what happens with prebuilt analyses and metrics in the GL subject areas are based on the standard financial categories provided by Fusion Applications. If custom categories are defined, corresponding derived metrics must be created to ensure accurate reporting.

There are missing blogs (404 error) blogs of this topic so if there is a new version could be helpful

What is the recommended approach to handle this ?

MandeepGupta · Answer

Hi,

Welcome to Oracle Analytics and AI Community.

This community focuses on Oracle Analytics and related products. Since your question pertains to Oracle Financials (Fusion SaaS), I recommend posting it in the Fusion SaaS sister community (CloudCustomerConnect) for better visibility and more relevant responses.

Subledger Accounting & Accounting Hub — Cloud Customer Connect

Thanks.