Some Offers Stucked At Status 'Pending Validation' (Doc ID 848305.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Trade Management - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 06-Sep-2013***


Symptoms

-- Problem Statement:
On 11.5.10 :
Find some LUMPSUM offers are stuck at status Pending Validation

This occured in the past when these offers where set at hold status and then re-validated.

This looks no more reproducable now on customer instance.

How to re_actfiavte them ?


EXPECTED BEHAVIOR
Expect that status will go back from On-Hold to Active

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:

1.
Oracle Trade Management User > Trade Planning > Offers > create a Lumpsum offer :

BF Lumpsum Cisco

Start Date = 24-MAY-2009
End Date = 27-MAY-2009
Bill To customer = AC Networrk
Distribution Type = Amount
Activity = Coupon
Budget = BF Fixed Budget 2008-2009
Lumpsum Amount = 2000
> Update

Status = Draft

2.
Enter discount rules

Item Number = XXX with distribution value = 2000

Performance Dates : From 01-APR-2009 to 30-APR-2009

> Update button

> Request Approval :

Preview Approval
Please review the information here before confirming your approval submission request.


Name: BF Lumpsum Cisco
Status: Draft
Approval Type: Budget
Dates: 24-MAY-2009 To 27-MAY-2009
Requestor: FILLIATRE (Corporation), Mr. Benoit
Owner: FILLIATRE (Corporation), Mr. Benoit
Description:
Approval Rule: No Approval Required

Request Status



> Status is now active

3. Set status at On-Hold (in LOV) > Upadte

4. Set status back to active > Apply >  satus stays at Pendng validatin


NOTE : this is no more reproducible neither on customer instance neither internal instance where
it is not possible to pass from active to on-hold

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot set back offer status to Active (from On-Hold)

Cause

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