Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
ARCS-TM Data Management Supported date format is dd-MMM-yy ERROR — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ARCS-TM Data Management Supported date format is dd-MMM-yy ERROR

Received Response
18
Views
5
Comments
edited Jul 15, 2021 9:45PM in Account Reconciliation 5 comments

Summary

using CDM a source date of mm/dd/yyyy is failing to load with error of Supported date format is dd-MMM-yy.

Content

Using CDM a source date of mm/dd/yyyy is failing to load with error of Supported date format is dd-MMM-yy.

Is there a way in either ARCS or CDM to:

1. In ARCS, change the Attribute Date to be mm/dd/yyyy instead of dd-MMM-yy

OR

2. In CDM, to convert the date from mm/dd/yyyy to dd-MMM-yy.   I tried creating it s a GENERIC instead of ATRIBUTE and then assigning a MAP Member #SQL formula of:   TO_CHAR(TO_DATE(ATTR5, 'mm/dd/yyyy'),'dd-MON-yy') but that did not work either.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!