11i: AR-ARGLTP: -1847 Ora-01847: Day Of Month Must Be Between 1 And Last Day Of Month (Doc ID 788119.1)

Last updated on JUNE 20, 2016

Applies to:

Oracle Receivables - Version 11.5.10.2 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 24-Jan-2014***
ARGLTP


Symptoms

-- Problem Statement:
In Receivables (Patch level AR.O) the AR GL Transfer process (ARGLTP) errors out with the following error
message:

AR-ARGLTP: -1847 ORA-01847: day of month must be between 1 and last day of month

This happens, when the program is started with parameters Start Date and Post through Date left
null. If these parameters are populated, the error does not occur.

The ARGLTP still transfers unposted items to GL, but the error prevents the Unposted Items report from being started.

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