Inconsistent Behavior for Single Use Credit Cards with Previously Authorized Transactions And Prepayments (Doc ID 2428847.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

On : 12.1.3 version, FC Core

Inconsistent Behavior for Single Use Cards with Previously Authorized Transactions used on 'AR_PREPAYMENTS_PUB.Create_Prepayment'

ERROR

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

Sometimes single-use cards are correctly processed and sometimes single use credit cards fail with

''INVALID_INSTRUMENT: Instrument does not exist".


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Created a credit card with single use flag 'Y' (iby_creditcards.single_use_flag)
2. Assign an instrument using this credit card.  Create a prepayment receipt using this credit card and verify it's successfully created
3. Update the credit card with single use flag 'N'. Create prepayment receipt using this credit card and it got created successfully.
4. Update the credit card with single use flag as 'Y' . Create a prepayment receipt for this credit card, sometimes it works fine and sometimes it wais with ''INVALID_INSTRUMENT: Instrument does not exist".

Cause

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