E-IB: How to manually cancel subscription contract stuck

(Doc ID 651383.1)

Last updated on JUNE 30, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.48 and later
Information in this document applies to any platform.
Enterprise, PeopleTools, Integration Broker, PT8.48 and above.

***Checked for relevance on 12-SEP-2012***


Goal

To correct subscription contracts stuck in TIMEOUT status.  This can also be used for messages in other status, even DONE but beware that the subscription handler will run the data for each resubmission... so care should be taken in pursuing this at your own risk.

 

ISSUE:

Subscription Contract stuck in TIMEOUT status. This is holding up other messages in the queue.  Customer cannot affect this message online due to other problems and as a workaround customer would like to cancel this message manually in the tables.  However, customer cannot find a pubid as seen in 8.47 and prior releases.

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