My Oracle Support Banner

Unable to Process File with Record Date Format 'DD-MON-YYYY' in ORMB V2.7 (Doc ID 2519436.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Financial Services Revenue Management and Billing Cloud Service - Version NA and later
Information in this document applies to any platform.


We are not able to process a file with date format as 'DD-MON-YYYY' in ORMB V2.
Below is the file header, date record and footer which is getting processed:

STATEMENT DATA|10-JAN-2018 FR|ACID23457|FRBCBS100004|EA|01|PT|10|BIC|10-JAN-2018 01

The 'Display Profile ID' field on the 'File request type' is kept as blank.

When we try to create a new 'Display profile' for the date format 'DD-MOM-YYYY', below error message occurs:
"Date format pattern is entered incorrectly. Please check pattern code rules."

Note: The file which we are trying to process is having only date format and not the time format, whereas time format field on 'display profile' screen is a mandatory field.

Can you please look into this issue and provide a solution about how to process a file with date format as 'DD-MON-YYYY'? It was working fine in v2.6.x.x.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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