Troubleshooting
Problem
getting Oracle error 1405 OERRR ORA 1405
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)
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":"SS6PEW","label":"IBM Sterling Order Management"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Not Applicable","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Was this topic helpful?
Document Information
Modified date:
23 June 2025
UID
swg21539518