Troubleshooting
Problem
getting Oracle error 1405 OERRR ORA 1405
Symptom
PART: Prints 6.0 SP1 DCS
COMPONENT: Not Applicable
OS: <None> -
<None>
DATABASE: <None> - <None>
WEB SERVER: <None> - <None>
WEB
BROWSER: <None> - <None>
Cause
Resolving The Problem
This means that the table involved has a null value in column.
1) Do a sql
trace if you do not know the name of the table and find out the name of the
table.
2) Do
select * from &Table where whse='&whse' and &field_name
is NULL
repeat this for all the fields which are not NOT NULL defined
and find out the field causing the error.
3)Set the field to ' ' (single
space)
[{"Product":{"code":"SS6QYM","label":"Sterling Selling and Fulfillment Suite"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Historical Number
PRI48646
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21539518