PONNLINS.sql Fails With SQLERRM=ORA-01400: Cannot Insert NULL Into ("PON"."PON_CONTRACTS_TL"."ORG_ID
(Doc ID 2280624.1)
Last updated on APRIL 10, 2025
Applies to:
Oracle Sourcing - Version 12.1.3 and laterInformation 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
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 |