IBM Support

getting Oracle error 1405  OERRR ORA 1405

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>];

Document Information

Modified date:
16 June 2018

UID

swg21539518