i-Store Delete credit card Issue

Problem Description

---------------------------------------------------

Oracle apps version:- 12.2.5

Steps to replicate :-

1) Add a new credit card, a new entry for this credit card is created.

2) Now delete the same credit card which was added in step 1, the row gets deleted and inactive date is set to SYSDATE.

3) Re-add the same credit card, 2 rows of the same card is displayed.

Below is the sequence of call from the JSP which loads the credit cards and display on the page:-

1) CCPayment.loadCreditCards(RequestCtx.getPartyId());

2) Below query gets executed

SELECT INSTRUMENT_ID,

party_id,

cust_account_id,

org_id,

CARD_HOLDER_NAME,

INSTR_ASSIGNMENT_ID,