My Oracle Support Banner

Monitoring - ESS Job On Promotional Discounting Request - (Doc ID 2367054.1)

Last updated on FEBRUARY 03, 2019

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

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
Goal
Solution
References


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