Dropship PO Receipt Fails:ORA-01400: cannot insert NULL into ("INV"."MTL_RESERVATIONS"."REQUIREMENT_DATE") (Doc ID 564405.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

When attempting to receive a drop ship po line, the following error occurs in the Inventory Debug:

ERROR
Create reservation returns : U
FND G_MISS_CHARFND_AS_UNEXPECTED_ERROR G_MISS_CHARN G_MISS_CHARPKG_NAME
G_MISS_CHARINV_Reservation_PVT G_MISS_CHARN G_MISS_CHARPROCEDURE_NAME
G_MISS_CHARCreate_Reservation G_MISS_CHARN G_MISS_CHARERROR_TEXT G_MISS_CHARORA-01400: cannot insert NULL into ("INV"."MTL_RESERVATIONS"."REQUIREMENT_DATE") G_MISS_CHAR
Reservation fails with unexpected error in dropshipreceive() : ORA-0000: normal, successful completion
Try receipt after setting sub/item non reservable
LEAVING OE_MSG_PUB.ADD_TEXT
ORA-01400: cannot insert NULL into ("INV"."MTL_RESERVATIONS"."REQUIREMENT_DATE") in Package
INV_Reservation_PVT Procedure Create_Reservation
UnExpected Error in Create Reservation...User-Defined Exception
Call to Create Reservation returned unexpected error ORA-0000: normal, successful completion
Exiting dropshipreceive with unexp. error => User-Defined Exception
[05-APR-08 08:49:49] INV_TRX_MGR: **Fails in OE_DROP_SHIPMENT :
[05-APR-08 08:49:49] INV_TRX_MGR: **Ex: Fails in OE_DROP_SHIPMENT
[05-APR-08 08:49:49] INV_TRX_MGR: BaseTransaction. Rollbacking all changes:
oracle.apps.inv.transaction.utilities.InvTrxException
[05-APR-08 08:49:49] INV_TRX_MGR: error expl :Fails in OE_DROP_SHIPMENT
[05-APR-08 08:49:49] INV_TRX_MGR: TrxUtil: stacked message - null
[05-APR-08 08:49:49] INV_TRX_MGR: error msg :null
[05-APR-08 08:49:49] INV_TRX_MGR: error msg2 :Fails in OE_DROP_SHIPMENT
[05-APR-08 08:49:49] INV_TRX_MGR: Mssg peeked :Fails in OE_DROP_SHIPMENT
[05-APR-08 08:49:49] INV_TRX_MGR: ** Error .. :updated MMTT. ERR code :Transaction processor error,msg:Fails in OE_DROP_SHIPMENTrcnt=1

Steps To Reproduce
1. PO responsibility
2. Receiving/Receipt
3. Query dropship PO
4. Receipt fails with the error in Inventory debug file

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.