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!

@return function error - I cant display the message when the business rule is attached to the form

User_CN0ZBMay 16 2014 — edited Nov 12 2014

Dears,

I have used @return function in a business Rule , when i run the business rule from Tools -> Business Rule it works properly , and the message of the @Ruturn Function is shown.

But when I attached the business rule to the form , it gives me the following error :

" An error occurred while running the specified calc script . ADF_FACES-60097: For more information, Please see the server's error log for an entry beginning with :ADF_FACES-60096: Server Exception during PPR,#26"

The following is the business rule that i am using :

SET FRMLBOTTOMUP ON;

Var _Ceilings;

Var _Budget;

FIX ( &BudYr )

FIX ( "Estimated" )

FIX ( "IC_Total")

FIX ( "E_$$$")

FIX ( Local )

FIX(D_$$$)

HSP_Inputvalue

(

_Ceilings =HSP_Inputvalue->"A_$$"->"D_$$"->"YearTotal"->"Total_Administratives"->"Total_Institutions"->"Total_G"->"$$$$$-Ceilings";

_Budget= HSP_Inputvalue ->"A_$$"->"YearTotal"->"Working_$$$$"->"Total_Administratives"->"Total_Institutions"->"Total_G";

IF (_Ceilings < _Budget )

@RETURN( "$$$$$$$$$$$$$$$$$$", ERROR);

ENDIF

)

ENDFIX

Thank you in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 10 2014

Added on May 16 2014

#business, #business-intelligence-applications, #error, #essbase, #form, #hyperion, #performance-management-applications, #planning, #planning-and-budgeting, #rules

12 comments

4,841 views