AGIS: FUNPRDSTSB Manual Intercompany Transactions Sweep In AGIS Errors With ORA-01843 not a Valid Month When Date Format is not DD-MMM-YYY (Doc ID 1682828.1)

Last updated on MARCH 25, 2016

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Oracle Financials Common Modules - Version 12.1.3 and later
Information in this document applies to any platform.
FUNPRDSTSB module: Manual Intercompany Transactions Sweep

Symptoms

When attempting to run FUNPRDSTSB module: Manual Intercompany Transactions Sweep, the following error occurs in the log:

ERROR
-----------------------
ORACLE error 1843 in FDPSTP

Cause: FDPSTP failed due to ORA-01843: not a valid month
ORA-06512: at line 1

This issue is when Norwegian date format is set in Oracle Preferences, i.e. 31.12.2013
While if the user sets Date format as 31-DEC-2013, the issue is no longer faced.

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