Home » Applications » Oracle Fusion Apps & E-Business Suite » Oracle Financial Analyezer
Oracle Financial Analyezer [message #454481] Wed, 05 May 2010 18:28
smilefortune
Messages: 1
Registered: May 2010
Junior Member
I'm trying to automate a formula in Oracle Financial Analyzer. Following is the code. My issue is next year I'd have to add another line at the bottom : else if GL_TIME1 eq 'YR2011' or nafill(inlist(FAGL4.ANCESTORS,'YR2011'),NO) then GLACTRES.

I would like to automate this, perhaps by using loops and system dates. Any suggestions?


if GL_TIME1 eq 'YR2005' or nafill(inlist(FAGL4.ANCESTORS,'YR2005'),NO) then GLACTRES
else if GL_TIME1 eq 'YR2006' or nafill(inlist(FAGL4.ANCESTORS,'YR2006'),NO) then GLACTRES
else if GL_TIME1 eq 'YR2007' or nafill(inlist(FAGL4.ANCESTORS,'YR2007'),NO) then GLACTRES
else if GL_TIME1 eq 'YR2008' or nafill(inlist(FAGL4.ANCESTORS,'YR2008'),NO) then GLACTRES
else if GL_TIME1 eq 'YR2009' or nafill(inlist(FAGL4.ANCESTORS,'YR2009'),NO) then GLACTRES
else if GL_TIME1 eq 'YR2010' or nafill(inlist(FAGL4.ANCESTORS,'YR2010'),NO) then GLACTRES
else GLACTUAL


[EDITED by LF: fixed [code] tags]

[Updated on: Thu, 06 May 2010 00:16]

Report message to a moderator

Previous Topic: EBS Application Data masking and Encryption.
Next Topic: Intercompany Account setup in Oracle R12
Goto Forum:
  


Current Time: Fri Mar 29 07:29:09 CDT 2024