Duplicate Rows into the PS_STAGED_COST_INV Table when Running the 'Load Staged Items' Process (INPSSTGE) for 2 Business Units and Processing InterUnit Transfer Receipts

(Doc ID 1504818.1)

Last updated on AUGUST 04, 2016

Applies to:

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

Symptoms

Running the 'Load Staged Items' process (INPSSTGE) (navigation: SCM Integrations, Process Transactions, Items, Item Loader) for 2 Business Units at the same time and processing InterUnit Transfer Receipts creates duplicate rows into the PS_STAGED_COST_INV table for the first Business Unit but using the Staging ID of the second Business Unit. This can leads to the process failing with the following error:

PTPSQLRT error in PeopleSoft Inventory background processing: INPSPROC IA075 - INSERT COST


Steps to replicate the issue:

  1. Create and deplete an InterUnit Transfer between Business Units US010 and US011.
  2. Create and deplete an InterUnit Transfer between Business Units US011 and US010.
  3. Receive both InterUnit Transfers.
  4. Run the INPSSTGE process for both Business Units US010 and US011.

    > Staging ID 1 is created in BU US010.
    > Staging ID 2 is created in BU US011.
    > One row is added into the PS_STAGED_COST_INV table for Business Unit US011.
    > Two rows are added into the PS_STAGED_COST_INV table for Business Unit US010, both for the right Receipt but one row has Staging ID 1 and the other Staging ID 2.

  5. Once the Receipt in Business Unit US010 is putaway, the row in the PS_STAGED_COST_INV table for Business Unit US010 and Staging ID 2 is not deleted.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms