FCUBS - Unable To Get Any Record Where DR_CR_IND Flag As 'C' In SWACARDA Screen (Doc ID 3025143.1)

Last updated on MAY 31, 2024

Applies to:

Symptoms

FCUBS - Unable to fetch card records either debit or credit record SWACARDA screen.

In Summary screen SWSCARDA, after inputting the values and searched, system is fetching both credit and debit records.
And there is no indictor to distinguish between debit or credit cards.

Suppose if user tries to open any of the records, system is throwing error.


ERROR
-----------------------
ST-OTHR-001 - Unhandled Exception
ST-SAVE-024 - Failed to Query Data


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Request a Debit Card while creating Customer Account
2. In STDCRDMS, copy the record of debit card and create a new credit record
3. Fetch the records in SWSCARDA
4. Two records are resulted with no indicator
5. When user open any one record, system is throwing errors.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot open fetched record and close it.

Changes

SWPKS_SWDCARDA_MAIN has been customized to fetch only Debit records.

And also, the DDL of STZM_CARD_ACCOUNT is customized

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.