Unsave Data Warning on Purchasing Attributes for Vendor/Supplier with future Effective Date (Doc ID 2049529.1)

Last updated on NOVEMBER 30, 2015

Applies to:

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

Symptoms

Reviewing Purchasing Attributes for Item Vendor with future effective date triggers Save warning.

The Item Vendor/Supplier information is added using the ExcelTOCI  IN_VND_ITM_XLS and the Effective date for Item vendor UOM is a future date.
After Item Loader loads data , PS_ITM_VNDR_UOM_PR.PRICE_CHANGE is blank.

When the Item Vendor UOM details are reviewed through on-line Purchasing Attributes page , following Save Warning is triggered when 'Return To Search'
is clicked

Do you want to save your changes? Click Yes to go back and save, or No to discard your changes.

Saving the page updates PS_ITM_VNDR_UOM_PR.PRICE_CHANGE = 'N'

Note: Same Save warning is also triggered  for Item Vendor UOM with future date added on-line.

Replication Steps:


ExcelToCI future effective dated Item Vendor UOM update

1.  Configured ExceltoCI for Template IN_VND_ITM_XLS.
2.  Input Item Vendor data for Item SHARE/10000 and Vendor SHARE/USA0000001 with effective date 09/1/2015
3.  Staged and submitted data successfully.
4.  Ran Item Loader.
     Navigation: Main Menu > SCM Integrations > Process Transactions > Items > Item Loader
5.  Item Vendor purchasing attributes loaded successfully.
6.  Query PS_ITM_VNDR_UOM_PR,   PRICE_CHANGE is blank
7.  Open Purchasing Attribute for Item SHARE/10000
8.  Tab to Item Vendor ,  click on Item Vendor UOM hyperlink for Vendor SHARE/USA000001
9.  After reviewing the details , click 'OK'
10.  Click Return to Search

 Following Save Warning displayed:

Do you want to save your changes? Click Yes to go back and save, or No to discard your changes.

11.  Click OK and click Save.
12.  Query PS_ITM_VNDR_UOM_PR,   PRICE_CHANGE = 'N'

On-line future effective dated Item Vendor UOM


1.  Open Purchasing Attribute for Item SHARE/10003
2.  Tab to Item Vendor ,  and add  Item Vendor  Vendor SHARE/USA000001 and Price Loc = 1
3.  Click on Item Vendor UOM hyperlink for Vendor SHARE/USA000001
4.  Change the Effective Date to 9/1/2015 (Future Date)
5.  Click 'OK'
6.  Click 'Save'
7.  Click 'Return to Search'
8.  Query PS_ITM_VNDR_UOM_PR,   PRICE_CHANGE is blank
9.  Open Purchasing Attribute for Item SHARE/10003
10. Tab to Item Vendor ,  click on Item Vendor UOM hyperlink for Vendor SHARE/USA000001
11.  After reviewing the details , click 'OK'
12.  Click Return to Search
13.  Following Save Warning displayed:

Do you want to save your changes? Click Yes to go back and save, or No to
discard your 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