My Oracle Support Banner

Transaction Register Program completes with Error ORA-01843: Not A Valid Month (Doc ID 2519390.1)

Last updated on JUNE 24, 2024

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
RXARINVR: RX-only: Transaction Register

Symptoms

On : 12.1.2 version, Reports Issues

Transaction register program completes with error
ERROR
-----------------------
ORA-01843: not a valid month


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Transaction register

Trace shows that following sql is throwing this error

SELECT NVL(MIN(PS.DUE_DATE), ARPT_SQL_FUNC_UTIL.GET_FIRST_DUE_DATE(1070 ,   NVL(CT.BILLING_DATE, sysdate )))
FROM AR_PAYMENT_SCHEDULES_ALL PS, RA_CUSTOMER_TRX_ALL CT
WHERE CT.CUSTOMER_TRX_ID=   PS.CUSTOMER_TRX_ID(+)
AND CT.CUSTOMER_TRX_ID = <nnnn>
GROUP BY CT.BILLING_DATE

 

Changes

 

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
Changes
Cause
Solution


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