Monitoring - ESS Job On Promotional Discounting Request -

(Doc ID 2367054.1)

Last updated on FEBRUARY 28, 2018

Applies to:

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

Goal

On : 11.12.1.0.0 version, Sales, Sales Catalog

 Monitoring - ESS Job on Promotional Discounting Request -

Promotional Discounting Request(PDR) is a custom object created under sales container and we need to Run a ESS job to update the status to expired who's end date is less than current date.

Both End date and Status are custom fields, to achieve this we have created a object function as follows:
/*****************----------------*****************/
def vo = newView('PromotionalDiscoutingRequest_c')
def vc = newViewCriteria(vo)
def vcr = vc.createRow()

def vci1 = vcr.ensureCriteriaItem('EndDate_c')
vci1.setOperator('<=')
vci1.setValue(today())

def vci2 = vcr.ensureCriteriaItem('Status_c')
vci2.setOperator('=')
vci2.setValue('Draft')

vc.insertRow(vcr)
vo.appendViewCriteria(vc)
vo.setMaxFetchSize(20)
vo.executeQuery()


while(vo.hasNext())
{
  def rowCLR = vo.next()
  rowCLR.setAttribute('Status_c','Expired')
}

/*******************-------------------------***************************/

When ever we try running the ESS job the status of the job is showing as succeeded but the job is not updating the status value on the UI.

Container: Sales
Object Name: PromotionalDiscoutingRequest_c
Function Name: UpdatePDRStatusToExpired
Process ID: 86833

As the log is not getting generated we are not able to find exactly what the issue.
 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms