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

MOSC Banner

FDM FDMEE Jython Import Script Error - excel .csv tab delimited

edited Mar 11, 2019 2:32PM in Hyperion Financial Data Quality Management (FDM/FDMEE) (MOSC) 2 commentsAnswered ✓

Thanks in Advance for looking/sharing - your consideration is certainly appreciated.

Can anyone provide a suggestion as to how best fix this failure?

I need a simple script to look at the last character of the 2nd column (Account) and determine if it is an ' @ ' symbol.

If yes, then multiply the value in the 6th column by -100 and return the record with the calculation performed.

Otherwise, return the record without the calculation.

(( Ideally, any Negative Value in END-BAL (column 6) Less than 0 and Greater Than -1 would return a Positive Whole Number  e.g. -.17 would return 17 ))

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center