Auditor receives error "Receipt Package Received Date cannot be earlier than Report Submission Date..." when entering Original Receipts Package Received Date Issue (timezone related)

(Doc ID 2385819.1)

Last updated on APRIL 12, 2018

Applies to:

Oracle Internet Expenses - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Client has an issue with Auditing expenses when there is a change in timezone, Auditor is unable to enter the Original Receipts Package Received Date as system is not allowing to accept the System Date or Future date. Client tried exploring the Future Date Tolerance Setup and set it 1 and 2 but either did not help.

Issue: Client's Database Servers are located in United Kingdom which is in GMT time zone, Oracle Operations aere across the Globe and corporate head office is based in LA , USA

All the LA employees will be in PST time zone, by ~4 PM PST the GMT clock changes and goes into the next day.

The Scenario client has is:

1. Employee creates an iExpense after system date change (Server date is only changed) ~ after 4PM PST, the expense date/Report Submit date here will be the Server date i.e SYSDATE + 1
2. Employee Manager Approves the Expense on the same day
3. Auditor Receives the Expense & Receipts on the same day
4. When entering the Original Receipts Package Received Date with the System date system is not allowing and throwing a message
"Receipt Package Received Date cannot be earlier than Report Submission Date. Please change the Receipt Package Received Date.
If entering Sysdate +1 then getting this erorr "You Cannot enter a future date"



EXPECTED BEHAVIOR
-----------------------
auditor expects to be able to enter the 'Original Receipts Package Received Date' with no error


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Employee creates an i-expense after system date change(Server date is only changed) ~ after 4PM PST, the expense date/Report Submit date here will be the Server date i.e SYSDATE + 1
2. Employee Manager Approves the Expense on the same day
3. Auditor Receives the Expense & Receipts on the same day
4. When entering the Original Receipts Package Received Date with the System date system is not allowing and throwing a message
"Receipt Package Received Date cannot be earlier than Report Submission Date. Please change the Receipt Package Received Date.
If entering Sysdate +1 then getting this erorr "You Cannot enter a future date"




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