Terminate a Relation for a Person produces Error Class Row method GetRowset scroll RB_CREDIT_CARD is invalid (Doc ID 2031716.1)

Last updated on SEPTEMBER 08, 2015

Applies to:

PeopleSoft Enterprise CRM Sales - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Unable to terminate a relation for a person (either contact or site) due to the following error:

Error Message:

Class Row method GetRowset scroll RB_CREDIT_CARD is invalid. (2,270) RD_UTILITIES.CDMRowset.OnExecute Name:getRowsetObject PCPC:2315 Statement:58
Called from:RD_UTILITIES.CDMRowset.OnExecute Name:CDMRowset Statement:6
Called from:RB_CDM.INDIVIDUAL.Individual.OnExecute Name:cacheCreditCards Statement:1468
Called from:RB_CDM.INDIVIDUAL.Individual.OnExecute Name:isCreditCardChanged Statement:392
Called from:RB_CDM.INDIVIDUAL.Individual.OnExecute Name:isChanged Statement:417
Called from:RB_CDM.INDIVIDUAL.CONTACT.Contact.OnExecute Name:isChanged Statement:133

Steps to Reproduce:
1. Login to PeopleSoft CRM
2. Navigate to: Main Menu > Customer CRM > Search Person >
3. In the field Person ID, enter one for a person who have both:
a. relations (either contacts or Sites) AND
b. a record in the table PS_RB_CREDIT_CARD. (see SQL below for finding a person id):
  Select PERSON_ID from PS_RD_PERSON where BO_ID in (Select BO_ID FROM PS_RB_CREDIT_CARD)

4. Click the Search button
5. Click on the Relationships Tab and select one contact for editing (pencil button)
6. A modal window appear
7. Choose and set an end date
8. Click on the button Save
9. The error is shown

Expected Behaviour:
Using the Relationship Tab in a person page, would like to terminate a relation for a person successfully without this blocking error message.

Environment:
CRM 9.2
Tools Release 8.53.11

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