Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Demantra Solutions - EBS (MOSC)

Requirement: when the value of series 'Baseline Forecast' is less than 0.1 then update it to 0(Zero)

Sep 26, 2016 11:28AM edited Oct 15, 2016 5:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

We have a requirement that whenever the series "Baseline Forecast" is less than or equal to 0.1 then show it as Zero.

Note: baseline forecast is generated by batch engine.

we want the value updated in database as Zero, not just in worksheet view (That we can change in Display ###,##).

We want the value to be 0 in database, because based on this database value other series values are calculated.

I believe that doing modification in server expression will update the value to 0, but I am not sure regarding the modification.

Please help,

Regards,

Meraj

Tagged:

DEMANTRA_Worksheet

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month