My Oracle Support Banner

Apply Planning Updates (INPAPLAN) Process Inserts Wrong value in Ship to Customer (Doc ID 2726220.1)

Last updated on NOVEMBER 09, 2020

Applies to:

PeopleSoft Enterprise SCM Supply Planning - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

Apply Planning Updates (INPAPLAN) COBOL process inserts incorrect destination business unit description in ship to customer (PS_IN_DEMAND.SHIP_CUST_NAME1) field for interunit transfers.

It appears the SHIP_CUST_NAME1 field value for last MSR should have been blank whereas it contains penultimate destination BU’s description instead.
It seems that description extracted from LOCATION_TBL table is not emptied by setting it to blank in the processing loop.


Steps to Reproduce the Issue:
1)    Set the following setup
Supply Planning > Create Plan > Planning Instances
Supply Planning > Define Planning Attributes > Business Unit Groups
PeopleTools > Utilities > Administrator > TableSet IDs
PeopleTools > Utilities > Administrator > TableSet Control - Record Group tab
Set Control Value = SHARE, Default SetID = SHARE, FS_26 - Locations, SetID = SHARE
Set Control Value = 02177, Default SetID = SHARE, FS_26 - Locations, SetID = 02177
Set Control Value = US011, Default SetID = SHARE, FS_26 - Locations, SetID = 02177
Set Up Financials/Supply Chain > Common Definitions > Location > Location
SetID = SHARE, Location Code = US009
SetID = 02177, Location Code = US009

SELECT SETID, DESCR FROM PS_LOCATION_TBL WHERE LOCATION = 'US001';
Results : SetID = SHARE , Descr = USA - New York

SELECT SETID, DESCR FROM PS_LOCATION_TBL WHERE LOCATION = 'US009';
Results :
SetID = 02177 , Descr = USA - Los Angeles
SetID = SHARE , Descr = USA - Los Angeles

SELECT SETID, DESCR FROM PS_LOCATION_TBL WHERE LOCATION = 'US010';
Results
SetID = SHARE , Descr = USA - Phoenix
 
SELECT DESCR FROM PS_LOCATION_TBL WHERE LOCATION = 'US011';
Results
Descr = USA - San Francisco

2)    Set item 10014 on BU US001, US009 and US010 as ‘Use Ship To Locations’
Items > Define Items and Attributes > Define Business Unit Item - Planning tab, General
3)    Define transfer attributes from BU US001, US009 and US010 to BU US011 for item 10014
Items > Define Items and Attributes > Transfer Attributes
4)    Define transfer attributes defaults for BU US001, US009 and US010 from BU US011
5)    Increase quantity of item 10014 on BU US011 by 500
Inventory > Manage Inventory > Adjustments
6)    Refresh sourcing template for item 10014 on BU US001, US009 and US019
Supply Planning > Define Planning Attributes > Sourcing Templates > Define Sourcing Templates
7)    Make sure planning engine USBIKE is not loaded
Supply Planning > Create Plan > Planning Engines
8)    Load planning instance USBIKE
Supply Planning > Create Plan > Load Planning Instance
9)    Run material solver for planning instance USBIKE after making sure the planning engine is idle
Supply Planning > Create Plan > Planning Engines
10)    Go To Material Plan Detail and click on Search button with the following criteria
Supply Planning > Solve Plan > Material > Material Plan Detail
11)     Click on ‘Add Transfer’
Planned Due Date/Time = 05/12/18 00:00
12)     Set US011 as BU and US001 as destination BU and click on ‘Add’ button after making sure planning engine is loaded
13)     Set the following values and click on Apply button to save the planned transfer
14)     Repeat steps 9 to 12 for item 10014 on BU US009 and then BU US010
15)    Check that three planned transfers have been created in PL_PL_PLN_TRANSFER table:
SELECT * FROM PS_PL_PLN_TRANSFER WHERE PROBINST IN ('USBIKE’);
16)     Shut down planning engine and run Post updates PL_POST
17)     Check that three planned transfers have been created in DEM_CHG_INF_INV table for planning instance USBIKE:
SELECT * FROM PS_DEM_CHG_INF_INV WHERE PROBINST IN ('USBIKE')
18)     Start planning engine USBIKE and then approve all 3 planned transfers and save
19)     Run Apply Inventory updates INPAPLAN on BU US011and no destination unit
20)     Check the interunit transfers have been created in IN_DEMAND table and that SHIP_CUST_NAME1 field contains incorrect destination BU description for destination BU US010 is USA - Los Angeles.


Changes

 n/a

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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