Transactions Imported With Incorrect Date Format (Doc ID 2274251.1)

Last updated on JUNE 06, 2017

Applies to:

Oracle Incentive Compensation - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Transaction data was imported through csv file. While the user saves excel file as csv the date format gets changed. The data format is in dd-mon-yy.
The transactions got imported without error but when the user wants to query in the 'maintain transactions screen' ,it is not showing up as the data can be queried in the screen only in dd-mon-yyyy format
Processed date if you see in commissions interface table , it is 3/1/0017 for 01-mar-2017

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

1. Collect the data in CSV file with date format as dd/mm/yy and save
2. Go to Compensation Manager / Analyst Responsibility
3. Tasks --> Import/Export
4. Click on New Import, select the csv file and Submit

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