Wrong Need By Date In Internal Requisition When Released From ASCP (Doc ID 1672281.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Symptoms

On :  12.1.3 version Advanced Supply Chain Planning

ACTUAL BEHAVIOR  
---------------
Wrong Need By Date in Internal Requisition when released from ASCP

We have an issue while releasing planned orders from HA1 to BA1 in ASCP.
From HA1-BA1: Need By date in the Internal Requisition in ERP is not correct.
We have calendar setup to indicate that goods from HA1 to BA1 always ships from HA1 on Wednesdays and BA1 receives on Fridays.
Implement Date: Need by + POST processing

If implementation date in ASCP side is not modified manually, then it's correct also in the Internal Requisition need by date.
But if we modify that date manually and release from ASCP then the Internal Requisition need by date is not correct.

This is occuring for all items we have tested.

Before the requisition import is running, need by date is written to the interface table.  In our R12 instance the need by date is already incorrect in the interface table.

In our 11i instance the same scenario is working correctly.

EXPECTED BEHAVIOR
-----------------------
Expect the R12 results to match 11i results.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1) 25-oct-2013 is implementation date in ASCP plan. For item post processing lead time is 2 days.
and Implement Date: Need by + POST processing
Our calendars are set that that HA1 organization ships on Wednesdays, but BA1 organization receives on Fridays.

so when need by date is calculated then:
1) based on item lead time IR need by date is 25-oct-2013 - 2 days (lead time) = 23-oct-2013
2) but since the calendar allows receiving only on Fridays, then IR need by date should be 18-oct-2013 - i.e. the closest Friday

But in case what we reported IR need by date is 11-Oct-2013, it's also Friday, but it's too early.

Cause

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