Search 800 + Posts

Feb 23, 2010

ORA-01400: cannot insert NULL into("INV"."MTL_RESERVATIONS"."REQUIREMENT_DATE")

User was getting ORA-01400: cannot insert NULL into
("INV"."MTL_RESERVATIONS"."REQUIREMENT_DATE") G_MISS_CHAR
Reservation fails with unexpected error in dropshipreceive
when she was trying to do a receipt against a Drop Ship PO. Everything look fine , but system was still thowing Error . On Investigation I found that REQUIREMENT_DATE is mandatory in MTL_RESERVATIONS table and it is populated from the Schedule_ship_date from the oe_order_llines_all table.
In this particular case Requisition and Purchase Order was created for the drop ship sales order , but the schedule_ship_date was NULL . SSD should be populated when Sales Order push the data to Purchasing for Requistion.

I populated the SSD and user was able to create Receipt.

No comments:

Post a Comment