My Oracle Support Banner

Scheduled Custom Groovy Object Functions ESS Jobs Are getting Cancelled (Doc ID 2886861.1)

Last updated on AUGUST 27, 2022

Applies to:

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

Symptoms

When calling

Schedule ESS : Schedule Custom Groovy Object Function calling for a specific
With Job parameters

Process parameters:
PromotionEvents_C
nrsPriorityPromotionBatchNumber4

Job goes into retrying and errors eventually

We see these errors


Errors:
---
  access denied (""oracle.wsm.security.WSFunctionPermission"" ""http://xmlns.oracle.com/apps/crmCommon/extensibility/batchGroovy/invokeService/ExtnCustGroovyService#invokeRowFunctionAsync"" ""invoke"")
or
JBO-25184: Exception in expression "PromotionEvents_c" object function nrsPromotionApproved(java.lang.String,java.lang.String) :


Business impact:
------
KDP production is impacted as the promotions are not applied

High level functional flow
--
1. User creates or updates a Promotion in the UI
2. Upon saving, a new record is inserted into the PromotionEvents_c custom object. This record will have a specific Batch Number attribute (possible values are 0 -9)
3. We have Scheduled Custom Groovy that runs against the PromotionEvents_c custom object. It runs every 5 minutes. We have one process for each Batch Number. So for priority promotion events we have 10 different Scheduled groovy processes. We have another event type for RTM calculation and that also has its own 10 Scheduled Custom Groovy
4. The custom groovy finds all PromotionEvent_c records where Integration Status = "PENDING" and the BatchNumber is the one associated with the process. It then processes the event and ends up inserting data into other objects tied to the promotion (which objects depends on which type of event)

Cause

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
Symptoms
Cause
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.