Date Format Field In File Mapping Definition Is Incorrect/MMDDYY Becomes DDMMYY When Run
(Doc ID 2990149.1)
Last updated on JUNE 20, 2024
Applies to:
PeopleSoft Enterprise CS Student Financials - Version 9.2 and laterInformation in this document applies to any platform.
Symptoms
After setting up the File Parser to import data into a custom table the date is not following the field definition after import.
It is expected the date format will be as specified.
The issue can be reproduced at will with the following steps:
- Navigate to Set Up SACR > System Administration > Utilities > File Parser > File Mapping Definition
- On the file layout tab set the field = TRANSACTION_DATE as a date with format = MMDDYY with "/" as a separator
- Navigate to Set Up SACR > System Administration > Utilities > File Parser > Run File Parser
- Review the imported data
Cause
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
Symptoms |
Cause |
Solution |
References |