User was getting ORA-01400: cannot insert NULL into
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.
Post a Comment