R12: OIE : MasterCard Error Showing Invalid Date For Month Of Feb 2010-2-31 (Doc ID 1916167.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Internet Expenses - Version 12.1.3 and later
Information in this document applies to any platform.
APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program
Attribute ExpirationDate expects a date but 2017-9-31 is not a valid date.
DetailHandlerImpl.java

Symptoms

When attempting to load a data file that contains any Expiration Date for a month that contains less than 31 days the following error message appears:

APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program is failing to load transactions and errors with the following message:
Attribute ExpirationDate expects a date but 2017-9-31 is not a valid date.
Attribute ExpirationDate expects a date but 2018-2-31 is not a valid date.
Attribute ExpirationDate expects a date but 2018-2-31 is not a valid date.
Attribute ExpirationDate expects a date but 2016-9-31 is not a valid date.
Attribute ExpirationDate expects a date but 2016-4-31 is not a valid date.
...

ERROR
-----------------------
Attribute ExpirationDate expects a date but 2017-9-31 is not a valid date.
Attribute ExpirationDate expects a date but 2018-2-31 is not a valid date.
Attribute ExpirationDate expects a date but 2018-2-31 is not a valid date.
Attribute ExpirationDate expects a date but 2016-9-31 is not a valid date.
Attribute ExpirationDate expects a date but 2016-4-31 is not a valid date.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <patch 17483330:R12.OIE.B> "New Card Notifications should be sent on registering a new valid card in the application", bounce apache, and clear cach.
2. Submit APXMCCDF3 module: MasterCard CDF3 Transaction Loader and Validation Program
3. Error occurs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process credit card transactions.

Changes

  <Patch 17483330:R12.OIE.B> "New Card Notifications should be sent on registering a new valid card in the application" has been applied.

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