Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC)

MOSC Banner

Summarize amount of account and if negative or positive map to the concerning acount

edited Nov 16, 2018 11:39AM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 3 commentsAnswered

For some GL import accounts I would like to, first summarize the amounts and depending if the total result is positive or negative, map it to a specific HFM account, grouped by the Entity

The account is in field 3 and the Entity consists of field 1 and 5 and the amount is in field 7.

e.g.

Inport file:

V50|A|440259         |[None]|00490 |[None]|-9232737.390|-9232737.390|EUR

V50|A|440259         |[None]|00636 |[None]|798665.090|798665.090|EUR

V50|A|440259         |[None]|[None]|[None]|-110.210|128.760|USD

V50|A|440259         |[None]|[None]|00191 |-41375568.000|-41375568.000|EUR

V50|A|440259         |[None]|00463 |[None]|-15000000.000|-15000000.000|EUR

V50|A|440259         |[None]|[None]|[None]|83876146.680|83876146.680|EUR

V5000490 maps to entity 1

V5000636 maps to entity 2

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center