Requisition Import Is Completing In Error -- POCIRM-223: ORA-01400: Cannot Insert when Item_description is Blank

(Doc ID 2314056.1)

Last updated on OCTOBER 09, 2017

Applies to:

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

Symptoms

Requisition Import is completing in Error -- POCIRM-223: ORA-01400: cannot insert

ERROR

Cause: POCIRM encountered an internal error. Parameters: REQIMPORT,ORDER ENTRY,,LOCATION,,N,Y,

Action: Note both this error number and the actions you are trying to perform. Contac
POCIRM-223: ORA-01400: cannot insert NULL into ("PO"."PO_REQUISITION_LINES_ALL"."I

Requisition Import is completing in Error -- POCIRM-223: ORA-01400: cannot insert

Steps To Replicate
The issue can be reproduced at will with the following steps:
1. Run Requisition import for Order Entry Source
2. It completed in Error
 

Cause

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