PONNLINS.sql Fails With SQLERRM=ORA-01400: Cannot Insert NULL Into ("PON"."PON_CONTRACTS_TL"."ORG_ID (Doc ID 2280624.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Sourcing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The following occurs when running Maintain Multi-lingual tables in ADADMIN to enable Latin American Spanish. Please see output from the adworker log below.
------


Start time for file is: Fri Jun 23 2017 08:01:08

sqlplus -s APPS/***** @/u101/shared_mount/apps/apps_st/appl/pon/12.0.0/sql/PONNLINS.sql
Connected.

PL/SQL procedure successfully completed.


MESG
--------------------------------------------------------------------------------
Error in routine: pon_contracts_tl_pkg.add_language : SQLERRM=ORA-01400: cannot
insert NULL into ("PON"."PON_CONTRACTS_TL"."ORG_ID")


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

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