Business Unit Item Current Status Can Be Blank after Running the 'Change Item Status' SQR Report (INS4000) (Doc ID 2105108.1)

Last updated on FEBRUARY 25, 2016

Applies to:

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

Symptoms

The Item's Current Status (BU_ITEMS_INV.ITM_STATUS_CURRENT) field is blank on the 'Define Business Unit Item' page (navigation: Items, Define Items and Attributes, Define Business Unit Item) after following the steps similar to those listed here:

  1. Go to the 'Define Item' page, search for an Item, and change the Future Status Date to today’s Date and change the Future Status to 'Inactive'. Save.
  2. Click on 'Return to Search'.
  3. Search for the Item again.
  4. Change the Future Status to blank.
  5. Click on the 'Copy Item Status' hyperlink.
  6. Select the Inventory Business Unit to copy the Status to and click on OK.
  7. Click on 'Yes' to the message.
  8. Open a new page and check the Item on the 'Define Business Unit Item' page > the Future Status and Future Status Date remain unchanged.
  9. Return to 'Define Item' page and click on save > the Future Status Date is blanked out.
  10. Click on 'Return to Search'.
  11. Search for the Item again.
  12. Click on the 'Copy Item Status' hyperlink.
  13. Open a new page and check the Item on the 'Define Business Unit Item' page > the Future Status Date is now populated with today's date for the Inventory Business Unit and the Future Status is blank.
  14. Click on 'Return to Search' on the 'Define Business Unit Item' page.
  15. Run the 'Change Items Status' SQR report (INS4000) for the Inventory Business Unit.
  16. Go to the 'Define Business Unit Item' page and search for the Item > the Current Status Date is now today’s date but the Current Status is blank.

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