My Oracle Support Banner

Create Scheduled Custom Process To Kick Off Groovy/Function (Doc ID 2523344.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


On : version, Opportunities

When attempting to create a function that triggered by a scheduled process, which in turn is supposed to update Opportunity status (DealStatus_c) based on conditions as shown in the groovy code
the following error occurs.

The process 762955 is showing status Error

The issue can be reproduced at will with the following steps:

1. The schedule process Schedule Custom Groovy Object functions - Error is invoked to run an object function.

2. The function defined is as follows:

def date_diff = 0
def vo1 = newView('OpportunityVO')
vo1.appendViewCriteria("MaximumStageStatus_c = 1000")
vo1 .executeQuery()
while(vo1.hasNext()) {
  def row =
  date_diff = today() - row.OpportunityStatusDate_c
  if(date_diff > 300) {

3. The object function above is created to update the status based on certain condition

4. The Scheduled process is showing the output 'Error' without any further details


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.