PO Induction Data Error When PO Lines Have Allocations (Doc ID 2925288.1)

Last updated on FEBRUARY 02, 2023

Applies to:

Symptoms

Whenever a PO/Item has multiple allocations it seems the warehouse line that contains the stock being received at the Warehouse is duplicated. The business tested scenario is:
- Buying stock from a supplier to a warehouse, where part of the stock is pre-allocated to stores, and other part is to be stored at the warehouse.
- Later on the original allocation is cancelled and a new one is created.
- Downloading the PO template, the warehouse stock line is repeated multiple times, as many as the number of allocations.

This is incorrect and causes confusion. When reviewing the PO through the screen, the data seems OK, so this looks like an issue when generating the data on the induction template.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.) Create a PO.
2.) Create an allocation for the PO through xAlloc.
3.) Cancel the allocation (can be done by Worksheeting the PO, selecting to cancel the Allocation, and re-approving the PO).
4.) Create a new allocation through xAlloc.
5.) Download the PO through the induction template.
6.) Observe the duplicate warehouse lines.

*Note:
Step #3 in that list is irrelevant. When the issue was discovered it was one of the steps executed, but the issue still happens if step #3 is omitted. The issue is having 2 different allocations on the same PO using the same item and source warehouse. When the PO is downloaded into an excel template, the warehouse line will get repeated once for each different allocation.

Cause

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