EXPECTED_DELIVERY_DATE and NEED_BY_DATE Becomes Null (In Table MTL_SUPPLY) After Cancelling The Split Internal Sales Order Line (Doc ID 2773482.1)

Last updated on SEPTEMBER 22, 2023

Applies to:

Symptoms

On : 12.2.5 version, Scheduling and Sourcing

ACTUAL BEHAVIOR
---------------
EXPECTED_DELIVERY_DATE and NEED_BY_DATE becomes Null after Cancelling the Split Internal Sales Order Line

EXPECTED BEHAVIOR
-----------------------
EXPECTED_DELIVERY_DATE and NEED_BY_DATE should remain as it was earlier after Cancelling the Split Internal Sales Order Line

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to Oracle Applications.
2. Go to Purchasing Super User Responsibility.
3. Navigate to MENUPATH > Requisitions
4. Open the Requisitions form and Create an Internal Requisition.
5. Approve the Requisition
6. Run Create Internal Order.
7. Switch to Order Management Super User Responsibility
8. Run the Order Import
9. Split the Sales Order Line of the Internal Sales Order created at step 8
10. Check the Date via following select statement. Dates are populated

select expected_delivery_date , quantity , need_by_date from apps.mtl_supply
where
req_header_id = &Requisition_Header_ID;

11. Now Cancel one of the Split Line.
12. Find that EXPECTED_DELIVERY_DATE and NEED_BY_DATE becomes Null.

Check the Date via following select statement. Dates are nullified

select expected_delivery_date , quantity , need_by_date from apps.mtl_supply
where
req_header_id = &Requisition_Header_ID;

Cause

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