Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Making GL balances positive

JanGLiOct 20 2016 — edited Oct 21 2016

hi,

I am getting some negative gl balances when i fetch data from EBS. These accounts are of expense and liability balance type. According to my knowledge they will be moved as it is from EBS regardless of "absolute" option is selected or not. (-ve values will be -ve and +ve values will be +ve).

I am trying to create a script which will multiple column "AMOUNTX" of table "TDATASEG" with -1 if the "AMOUNTX" is less then 0.

I am getting the result what i want but the issue is my data workbench goes blank.

Screenshot:

pastedImage_3.png

I think this is because i have changed the "TDATASEG" table.

If this happens i won't be able to drill back to the GL accounts.

Is this the correct approach i am using?

Is this the correct column i am using; i think it is because i am getting the results i want.

Regards

Comments

USER1211

Why not just flip the sign on the specific account using out of the box Fdmee sign flip functionality via the mapping.

JanGLi

I could do that but there are thousands of accounts.

USER1211

Do you not have the list of the specific accounts? If you do you could create the explicit maps for those accounts and the issue should be solved..

Also if accounts within a certain range are to flipped you can design your sign flip by range.

Only You know your accounts so you could certainly do a more detailed review to see if you can setup a feasible solution with out of the box solutions.

let us know how you make out.

1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 18 2016
Added on Oct 20 2016
#business-intelligence-applications, #ebs, #fdmee, #financial-data-management, #performance-management-applications, #script
3 comments
471 views