Fast formulas and use of brackets — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Fast formulas and use of brackets

Summary:

When writing if-then statements in fast formulas, is there any reason to use brackets for the condition?

Content (please ensure you mask any confidential information):

Looking at Oracle seeded fast formula code, there isn't really a consistent style used for brackets on if-then statements, even within the same formula. Examples:

IF prorate_start WAS DEFAULTED THEN
        prorate_start = l_card_comp_entry_start_date
IF (Additional_Pension_Type = 'CSSECS') THEN
(…
)
IF ENTRY_LEVEL = 'PA' then (
…)

Is there a rule, or is it just personal choice? I guess if you have a multi-line code block then you need to use Then (…), but other than that I don't see any restrictions. Having used other programming languages, the lack of a style guide feels quite noticeable.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!