PRC: Transaction Import Receive Error: ORA-20003: import1_prog:ORA-01843: not a valid month"

(Doc ID 2395208.1)

Last updated on MAY 08, 2018

Applies to:

Oracle Time and Labor - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version , Projects Transaction Report

When attempting to run the concurrent request PAXTRTRX: PRC: Transaction Import,
the following error occurs.



ERROR
-----------------------
PAXTRTRX: PRC: Transaction Import Log:
+---------------------------------------------------------------------------+
Projects: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
PAXTRTRX: PRC: Transaction Import
+---------------------------------------------------------------------------+
Current system time is 29-APR-2018 13:01:27
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_TRX_SOURCE='Time Management'
------------
Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
American_America.US7ASCII
'.,'
BINARY
Enter Password:
REP-0004: Warning: Unable to open user preference file.
MSG-20003: ORA-20003: import1_prog:ORA-01843: not a valid month
ORA-06512: at "APPS.PA_TRX_IMPORT", line 10595
Report Builder: Release 10.1.2.3.0 - Production on Sun Apr 29 13:01:28 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Inside get_OTL_TM_origRef:
P_trx_source::Time Management
P_trx_ref::2018042947121231210051944
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
1891
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-APR-2018 13:01:30
+-----------------------------------


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

1.  Run the concurrent request PAXTRTRX: PRC: Transaction Import

2.  Receive error:

 

PRC: Transaction Import Log file error:
+---------------------------------------------------------------------------+
Projects: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
PAXTRTRX: PRC: Transaction Import
+---------------------------------------------------------------------------+
Current system time is 29-APR-2018 13:01:27
+---------------------------------------------------------------------------+
+-----------------------------
| Starting concurrent program execution...
+-----------------------------
Arguments
------------
P_TRX_SOURCE='Time Management'
------------
Current NLS_LANG, NLS_NUMERIC_CHARACTERS and NLS_SORT Environment Variables are :
American_America.US7ASCII
'.,'
BINARY
Enter Password:
REP-0004: Warning: Unable to open user preference file.
MSG-20003: ORA-20003: import1_prog:ORA-01843: not a valid month
ORA-06512: at "APPS.PA_TRX_IMPORT", line 10595
Report Builder: Release 10.1.2.3.0 - Production on Sun Apr 29 13:01:28 2018
Copyright (c) 1982, 2005, Oracle. All rights reserved.
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Inside get_OTL_TM_origRef:
P_trx_source::Time Management
P_trx_ref::2018042947121231210051944
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Output file size:
1891
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 29-APR-2018 13:01:30
+-----------------------------------

 

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