EEX 9.2: Conus Load Failing With Invalid Date Error For New File With New File Released on 10/01/2015 With Dates Into 2016 And Season End Date of 02/29 (Doc ID 2101753.1)

Last updated on APRIL 26, 2021

Applies to:

Symptoms

Not able to load CONUS data in Expenses effective date 10/15/2015

The new CONUS data file has season end date of 02/29 for some of the locations, these rows are failing with error message of invalid date. Subscription handler is taking year (2015) from the effective date 10/01/2015 and concatenate with season end date of 02/29 for leap year next year. So it is coming up with date of 02/29/2015 and saying a invalid date since there is no 02/29 in year 2015. However rate is for 02/29/2016 and which is a valid date since 2016 is leap year.

ERROR
-----------------------
CONUS_LOAD.CONUSLoad.OnExecute Name:OnNotify PCPC:1207 Statement:24

Attempt to call abstract method/property OnError of object class PS_PT:Integration:INotificationHandler. (180,845)


STEPS
-----------------------

1. Configure all the necessary setup in order to make use of the CONUS/OCONUS benchmark data upload functionality for Expense Location Amounts
  - Navigate to: Set Up Financials/Supply Chain > Product Related > Expenses > Location > Expense Location
  - Make sure to have US-based locations setup,
2. Have CONUS for US and Expense Locations, containing rows with effective date 10/01/2015 with dates going into 2016 (Download the file from http://www.defensetravel.dod.mil/site/perdiemFiles.cfm)
  - Navigate to: Enterprise Components > Integration Definitions > Inbound File Rule
  - Open the File Identifiers for CONUS_LOAD and OCONUS_LOAD, and set them as Active, as well as specify the proper folder navigation for their respective CONUS
3. Navigate to: Enterprise Components > Integration Definitions > Initiate Processes > Inbound File Publish
  - Create Run Control IDs, CONUS_LOAD and OCONUS_LOAD, run the process and note above error is displayed.

Changes

Cause

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