My Oracle Support Banner

R11.5: PA: ADADMIN Maintain Multiligual Tables Fails on PANLINS.sql with ORA-1400 PA_PERIOD_MASKS_TL ORA-1858 (Doc ID 804723.1)

Last updated on MAY 11, 2019

Applies to:

Oracle Project Foundation - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Oracle Project Planning and Control - Version 11.5.10.2 to 11.5.10.2 [Release 11.5.10]
Information in this document applies to any platform.

Symptoms

When running Maintain Multiligual Tables using adadmin, the worker fails on PANLINS.sql with the following:

PL/SQL procedure successfully completed.

MESG
--------------------------------------------------------------------------------
LANGUAGE=AMERICAN
PACKAGE=PA_PERIOD_MASKS_PKG
SQLERRM=ORA-01400: cannot insert NULL into ("PA"."PA_PERIOD_MASKS_TL"."PERIOD_MASK_ID")

select to_date('ERROR')
*
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

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


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