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

(Doc ID 2280624.1)

Last updated on DECEMBER 20, 2017

Applies to:

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


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

PL/SQL procedure successfully completed.

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


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